Updating smartsheet rows using integration services

Hi,
Am trying to update Smarsheet row using the Update row activity under the section of integration service, smartsheet activities. Could anyone tell me how to create an cell object of type “Sheets_rowsCells” which should be provided as input in the field “Cells” of the Update row activity.

Thanks,
Anju

Hi @anju_pj,

Welcome to uipdathe Forum.

Use Update row item activity.

https://docs.uipath.com/activities/docs/update-row-item

Thanks,

Hi @RajKumar_DC

Thanks for the response. Unfortunately this activity can be used in datatable. Am trying to update smarsheets. And we do have separate package and a set of activities to update smartsheet. And am trying to figure out the way to update smartsheet using that activities.

Thanks,
Anju

Hey Anju,

I am trying to do the same.
Were you able to find any solution to this?

Regards
Harshita

I too am struggling with the same thing.

My workaround for the moment is to extract the row Permalink and update the row through the UI, but I’d much rather do it through the API as god intended.

@Anil_G do you have any insight here?

I’ve been able to do this using SmartSheet integrations (using a Smartsheet Scope) but I would like to do it using the Integration Service.

The Update Row activity requires an input called “Cells” with a variable type called Sheets_rowsCells. It’s not at all clear how to create a variable of the required type.