Does anyone have experience with Celigo to Smartsheet API Syntax?

HR_Valeo

I am using Celigo but have been stumped on proper syntax to update a row in Smartsheet from NetSuite. I am able to identify the Sheet ID, Row ID, Cell ID but have not been able to successfully update a row. Have tried to use different variations of: rows.id[2691881577385860].cells[17].value

with no luck.

Thanks in advance for any assistance or pointers.

Herman

Genevieve P.

Hi @HR_Valeo

If no other Smartsheet Community members respond with their Celigo experience, you may want to post in a developer community (such as Stack Overflow) or Celigo's community for more help.

Cheers,

Genevieve

daviddeuri

Hi Herman,

I’ve worked with Celigo and Smartsheet integration, and updating a row can be tricky with the syntax. For updating a row in Smartsheet using Celigo, the syntax generally involves specifying the row ID and updating the cell values as a JSON object.

In your case, try using this format:

jsonCopyEdit{  "id": 2691881577385860,  "cells": [    {      "columnId": 17,      "value": "Your New Value"    }  ]}

Make sure the columnId corresponds to the column you want to update, and the value is the new data you want to set. In Celigo, this should be added in the body of your PUT request for the Smartsheet API.

If this doesn’t work or you need more help with the NetSuite integration using Celigo, let me know. Good luck!

prime_nathaniel

@HR_Valeo

We do lots of netsuite integration work here at Prime, the way the SMAR api works is you need

sheet id - url from SMAR
row id - object from SMAR
column id - object from SMAR
column value - object from NS

So in order to do an update you need to GET all columns from smartsheet that you are interested in updating, you then MAP these column ids to your data via the names in NS. Now you have the appropriate JSON package to send to SMAR for update.