โ12-16-2021 01:12 AM
Hi,
Iโm trying to fetch data from a sheet using Smartsheets sheets API. Iโve generated the access token, and itโs working fine with Postman. Please see below itโs returning the data, but when I do the same using Rest Get, itโs not producing anything.
And also, with Smartsheets API, even if I pass the wrong sheetid its starts validating and does not throw any error. If itโs working in POSTMAN, it should work with REST Get also. Please let me know what Iโm missing.
Note: Iโve also tried using the Oauth2 method by creating an account for Smartsheets, and I was able to refresh the token as well, but with that approach, it is also not working.
Solved! Go to Solution.
โ12-16-2021 04:49 AM
I tried with the token that you have sent to me, and it is working perfectly, either for getting all the sheets or getting sheet by ID.
โ12-16-2021 04:01 AM
Hi @marjan.karafiloski, I created the new snap and didnโt provided the access token; I got the same 403 error. But after I added the access token, again its not returning anything.
โ12-16-2021 04:02 AM
Iโm using trail account of Smartsheet and created access token for testing purpose.
โ12-16-2021 04:31 AM
Let me know if I can share the API key with you. Anyway, itโs for my test account.
Later Iโll delete it.
โ12-16-2021 04:38 AM
If you can share it, it would be great. Iโll try to see if I can make it work.
Send it in private message.
โ12-16-2021 04:49 AM
I tried with the token that you have sent to me, and it is working perfectly, either for getting all the sheets or getting sheet by ID.