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 01:21 AM
Hi @mayank.singh ,
Can you please change the Response entity type attribute of the snap to Text and try again?
Regards,
Marjan
12-16-2021 01:30 AM
Thanks for the reply!
I tried but no luck. The data preview is still empty.
12-16-2021 01:32 AM
Hi,
What is the value for Snap Execution attribute in the snap?
12-16-2021 01:33 AM
Validate and Execute.