How to find old Row/Column IDs after 'Save as New'

diacristian

Hi,

After a 'Save as New', all Row and Column IDs are changed.

I would like to know if I could somehow get the old IDs (maybe they are stored somewhere)?

I need them because I want to compare data of the old file with the new one (considering that there are changes done in the new one), based on IDs, and if they are not the same than this is not possible.

Thanks

Genevieve P.

Hi @diacristian

The previous column IDs are only associated with their own sheet. This means that there isn't a way to retrieve the source column IDs from the duplicate created copy, you would need the previous Sheet ID to get these column IDs.

Cheers,

Genevieve

diacristian

Hi @Genevieve P.

Thanks for your answer. I have access to all IDs, I know how to retrieve them. This is not my question.

Asume I have both files, so I have all IDs (Sheet, Row, Column). Sheet1 is the original one, Sheet2 is duplicated. After duplication, user does some changes in Sheet2. I need to know what those changes are. If the Column/Row IDs would have been the same in Sheet1 & 2, this would have been a easy task. But it is not the case, so any ideas how API can help me in doing this?

Thanks,

Cristian

Genevieve P.

Hi @diacristian

The two sheets won't be linked in any way after the duplicate sheet has been created, so you would want to track the changes to Sheet 2 separately, perhaps using the 'modifiedAt' property?

Here's a conversation on StackOverflow that may help: Using Smartsheet API 2.0 how to get ONLY the 'modifiedAt' property of a specific sheet

Cheers,

Genevieve

diacristian

Thanks. Not helpful in my case.

This is a long shot ideea: if the assigning IDs algorithm would have an input of the old ones, maybe a reverse of it would help in returning the associated old ones by feeding it with the new IDs. :)