SmartSheet API creation of a crosssheet reference

I am getting strange error when creating a crosssheet references via API.

{ "errorCode" : 1002, "message" : "Your Access Token is invalid.", "refId" : "lj4bwkw3k720" }

I do not see why would it happen. I can get a reference with the same token and the response looks like this:

{"pageNumber":1,"pageSize":100,"totalPages":1,"totalCount":1,"data":[{"id":4576058512041860,"status":"OK","name":"SNAP SX Scorecard Roster Range 1","sourceSheetId":5996546819942276,"startColumnId":1425071219730308,"endColumnId":3226101330798468}]}

Then I want to replicate the reference in another sheet by calling this curl (I am using values that I got from list sheet references api call): C:\Program Files (x86)\cURL\bin\curl.exe https://api.smartsheet.com/2.0/sheets/{2767314723596164}/crosssheetreferences -H "Authorization: Bearer blablablablablablablablablablablabla" -H "Content-Type: application/json" -X POST -d '{ "name":"SNAP SX Scorecard Roster Range 1", "sourceSheetId":5996546819942276, "startColumnId":1425071219730308, "endColumnId":3226101330798468 }'

and I get the error { "errorCode" : 1002, "message" : "Your Access Token is invalid.", "refId" : "lj4bwkw3k720" }

Any tips on how to resolve it are greatly appreciated. Is there special access level needed to create cross sheet references programmatically ?

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi Pawel,

    I know you said that your token works for you with a different request, but could you try generating a new token and using this instead? As long as you have the correct permissions on the sheet in Smartsheet (for example, if you're the owner of the sheets), I'm not sure why you would receive this error.

    If you generate a new token and the same error occurs, please contact our Support team (see here).

  • Thank you for your response. I will try with new token, however it is not ideal as I have it embeded in number of places.