โ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 02:22 AM
Tried, getting nothing.
If the same thing I do in Postman, Iโm getting 1004 error.
โ12-16-2021 02:28 AM
Please make print screen of all the attributes of the REST Get snap.
โ12-16-2021 02:34 AM
Here:
Iโve tried all the snap properties, still not working.
โ12-16-2021 02:41 AM
If I try to validate & execute the snap with same data as you are saying (without authorization), I get the following error:
Please remove the snap and create it from scratch.
โ12-16-2021 02:44 AM
And also, can you make print screen of the Views tab, to see how you have set the values when error happens?