Get Request for Sheet works, get request for column doesn't?
Any idea why this would be happening
Use get request in Postman like so,
https://api.smartsheet.com/2.0/sheets/{InsertSheetId}
That works but any attempt to grab the columns doesn't like so,
https://api.smartsheet.com/2.0/sheets/{InsertSheetId}/columns.
Instead,
I get this message:
{
"errorCode": 1006,
"message": "Not Found",
"refId": "6liwku"
}
Answers
-
I'm assuming you have confirmed that the sheet ID is still correct? I have had no issues with that call in postman.
I do get that error when the sheet id is wrong.
-
Samuel,
Yes the sheet Id doesn't change at all. I can literally take the /columns off with no issue and send the same request with success.
-
That is very strange! I'm sorry I can't help you. Not sure why /columns doesn't work. However when you do the first call it does include the columns. Guessing that doesn't help you though.
Assuming you have "columns" and not column, right?
-
Sam,
100%
I suppose the first call does include the columns I had hoped there was just any easier way to read & extract this data.
Appreciate all your help.
-
Best of luck, maybe someone else will come along with the answer..
Maybe try the column call from a different program like a PowerShell rest API and see if you're still getting the same error. Doesn't make sense that its not working. Issues in Postman maybe?
