"Row Moved" not in Cell History when called by the API?

Samuel Mueller · 09/14/22

"When I call "List Cell History" with the API the "Row was moved from another sheet" does not show up. Am I doing something wrong? Why can't I get this cell history?

Julio S. · 09/29/22

Hi @Samuel Mueller,

Thanks for your patience waiting for an answer about this. In further internal review we've received confirmation that, at the moment, no "row was moved" action is expected when using the API to get the Cell History. Please let our Product team know about your feedback by filling in this form, here. Thank you!

Julio

Genevieve P. · 09/28/22

Hi @Samuel Mueller

My apologies for the delay; I've been able to replicate what you're describing (this action is not in the API response for the Cell History, even when it appears in the UI). I'm checking with our teams to see if this is currently expected behaviour or not and I'll follow up once I have more information.

Cheers,

Genevieve

Julio S. · 09/29/22

Hi @Samuel Mueller,

Thanks for your patience waiting for an answer about this. In further internal review we've received confirmation that, at the moment, no "row was moved" action is expected when using the API to get the Cell History. Please let our Product team know about your feedback by filling in this form, here. Thank you!

Julio

Samuel Mueller · 10/04/22

Thank @Julio S. and @Genevieve P. for your follow up answers, I appreciate the help.

dsmitts.jay · 08/14/23

@Samuel Mueller I am trying to access the Cell History in Bridge. How did you go about doing this?

Thanks,

Dustin

Genevieve P. · 08/14/23

Hey @dsmitts.jay

You can use an HTTP module to call the Smartsheet API and get the Cell History.

Here's the information about the HTTP Call Utility Function
Here's the information in the Smartsheet API documentation about getting Cell History

Cheers,

Genevieve

Samuel Mueller · 08/14/23

@Genevieve P. Thanks for answering this for me 😊

@dsmitts.jay If you need an example beyond the information Genevieve sent along, let me know and I can share one with you.

dsmitts.jay · 08/14/23

@Samuel Mueller Yes that would be great.

Samuel Mueller · 08/14/23

@dsmitts.jay So there are 3 things you need in order to get the cell history.

Sheet ID
Row ID of the cell
Column ID of the cell

You can get these by doing a get sheet method in bridge, and you find the sheet ID in the sheet- file -> Properties

I'm not sure how much you know about Bridge, but here is an example of how to get dynamic fields out of the workflow.

clicking copy will add something like {{states.startstate.smartsheet.get_sheet.sheet.columns.1.id}} to your clipboard that you can plug into your HTTP call url. Or once you get the IDs you want, you can either hardcode them, or use the dynamic data reference. Below are both examples of the URL to use for the HTTP Call (hardcode, or dynamic):

Dynamic: https://api.smartsheet.com/2.0/sheets/{{states.startstate.smartsheet.get_sheet.sheet.id}}/rows/{{states.startstate.smartsheet.get_sheet.sheet.rows.0.id}}/columns/{{states.startstate.smartsheet.get_sheet.sheet.columns.1.id}}/history?include=columnType
Hardcode: https://api.smartsheet.com/2.0/sheets/46416037844228/rows/55620051428356/columns/29125725133060/history?include=columnType

In the simplest case you can have a workflow that's similar to this. You can ignore the retrieve data you wouldn't necessarily need that

Get Sheet allows you to retrieve your column and row ids

Then the HTTP call looks like this

the URL is one of the urls from my bullet points above. You would replace the Authorization Value with your API Token. and this is what the result would be:

Now depending on what you are actually trying to achieve, you will likely need a more complicated workflow and the use of Child Workflows or JavaScript to loop through the data.

dsmitts.jay · 08/14/23

I am somewhat familiar with Bridge and have been using it for things like populating dropdown options.

I am trying to retrieve the cell history for only rows that have changed. That sounds like a challenge seeing that I need the RowID to do the HTTP call in the first place. Unless there is a workflow I could build to pull only changed rows first?

Dustin

Samuel Mueller · 08/14/23

@dsmitts.jay You would need to use a trigger. However it's harder to know which columns were changed in a dynamic sense. So you would probably need to look at specific columns. Here is an example of a trigger.

Then your trigger will look something like this, and for rowid you can use that dynamic field so everytime a row is changed, it will return that row, and column you choose in your url. The Get Data Reference will return something like this: {{runtime.event.id}} and your URL in your HTTP call will be: https://api.smartsheet.com/2.0/sheets/{{states.startstate.smartsheet.get_sheet.sheet.id}}/rows/{{runtime.event.id}}/columns/{{states.startstate.smartsheet.get_sheet.sheet.columns.1.id}}/history?include=columnType

Then every time a row is changed, you will get the changes in that updated row, and the column you designated.

dsmitts.jay · 08/14/23

@Samuel Mueller ok thanks, I'll try and make sense if this, and see what I can make happen.

dsmitts.jay · 08/14/23

@Samuel Mueller can you further explain this "and for rowid you can use that dynamic field so everytime a row is changed, it will return that row, and column you choose in your url."

Thanks,

Dustin

Samuel Mueller · 08/14/23

@dsmitts.jay in the trigger section of my last screenshot, you see where it says ID under event, the "Data Reference" value from that id is {{runtime.event.id}}. if you place that text into the HTTP Call URL, it will be the row id that was changed in your sheet which caused the "trigger". It would return whatever row id that was changed and triggered the workflow.