Smartsheet Update Rows Activites

[surranga (Suresh.R)]

Hi,

I am trying to update my smartsheet with the data extracted from SQL query . During execution I get an error

Activity ended with error:
Error Code: [202]
Message: Column ‘RowId’ does not belong to table .

Any thoughts on above error

Thanks In Advance
Suresh R

[pravin_calvin (pravin kumar)]

Hi @surranga

Check with the exact Column name that are same in both!

Regards

[Gokul001 (Gokul Balaji)]

Hi @surranga

@surranga

Column ‘RowId’ does not belong to table

Can you check the extracted value of the SQL query whether the value contains “RowId” column?

Regards
Gokul

[surranga (Suresh.R)]

Hi Gokul,

I don’t have a column name rowid extracted from the SQL query but I think in smart sheet it has default rowid in each sheet.

I am not sure how we can fix that error.

Thanks
Sureshbabu.R

[surranga (Suresh.R)]

I have same exact column name from the sql query to smartsheet. But it says rowid does not belong to table

[saitejaswini.anna (saitejaswini)]

Hello,

I am trying to update the rows in a smartsheet and I am receiving the below error
Activity ended with error:
Error Code: [202]
Message: “The attribute(s) row.rowNumber, row.createdAt, row.modifiedAt are not allowed for this operation.”

Can someone please help to resolve this issue

[pulapathiswathi (swathi)]

did you found solution

[kevin.scott]

The solution is to build a data table like this:

Then add a row to it using Add Data Row that contains the variables you want to pass:

Then in your Update Rows activity, pass the data table in the Row Data Field and leave the Rows field blank.