This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

REST GET: Not working for Smartsheet API

Go to solution
mayank_singh
New Contributor II

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

0 Kudos
Reply
1 ACCEPTED SOLUTION

Go to solution
marjan_karafilo
Contributor
In response to marjan_karafilo

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

image
image

View solution in original post

Reply
20 REPLIES 20

Go to solution
bojanvelevski
Valued Contributor
In response to mayank_singh

‎12-16-2021 04:49 AM

Hey @mayank.singh,

One thing I can think of is that you’re validating without holding the Shift button. This will clear the cache before validating.

Other weird thing that did happen to me is snap misbehaviour, so when I changed the Rest GET snap with a brand new, reconfigured Rest GET, it worked.

Try these and let us know what happened,

Regards

Reply