Get Request for Sheet works, get request for column doesn't?

DougSmartsheetDev

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"

}

Samuel Mueller

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.

DougSmartsheetDev

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.

Samuel Mueller

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?

DougSmartsheetDev

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.

Samuel Mueller

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?