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
-
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).
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives