cancel
Showing results for 
Search instead for 
Did you mean: 

REST GET: Not working for Smartsheet API

mayank_singh
New Contributor II

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.
image

image

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.

1 ACCEPTED SOLUTION

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.

image
image

View solution in original post

20 REPLIES 20

Tried, getting nothing.
If the same thing I do in Postman, I’m getting 1004 error.

Please make print screen of all the attributes of the REST Get snap.

Here:
image

I’ve tried all the snap properties, still not working.

If I try to validate & execute the snap with same data as you are saying (without authorization), I get the following error:

image

Please remove the snap and create it from scratch.

And also, can you make print screen of the Views tab, to see how you have set the values when error happens?