Skip to main content

Update Rows

UiPath.Smartsheet.Activities.Rows.UpdateRows

Uses the Smartsheet Update Rows API to update a set of rows.

How it works​

The following steps are an example of how the activity works from design time (i.e., the activity dependencies and input/output properties) to run time.

  1. Complete the Setup steps.
  2. Add the Smartsheet Application Scope activity to your project.
  3. Add the Update Rows activity inside the Smartsheet Application Scope activity.
  4. Create and enter values for the Input properties.
  5. Create and enter values for Output properties.
  6. Create and enter an ResponseStatus variable for the Output property.

In the Body of the Activity​

  • Sheet Id - The Id of the sheet. Enter a Int64 or Int64 variable.
  • Rows - An array of Row objects to update. Enter a Row[] or Row[] variable. Either Rows or Row Data properties must be populated.
  • Row Data - A data table that contains row information to update. Enter a DataTable or DataTable variable. Either Rows or Row Data properties must be populated. The DataTable must contain these 3 columns:
    • RowID
    • ColumnID
    • ColumnValue
  • Rows Updated - The rows that were updated. Enter a Row[] variable.

Properties​

Common​

  • DisplayName - The display name of the activity. This field supports only Strings or String variables.

Misc​

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Output​

  • ResponseStatus - The status of the request (success/failure information). Enter a ResponseStatus variable.