Having Difficulty with Smartsheet API in Excel

Dave Atkinson

Dave Atkinson ✭

07/10/24 in API & Developers

I'm looking for examples of calling the Smartsheet API from Excel. I can't seem to get the syntax right.

0 ·

Answers

Joe Goetschel ✭✭✭✭✭✭

07/26/24

HI Dave, Can you give us some additional information? What is the use case? What are you trying to accomplish?

Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner
joe.goetschel@scscloud.com
Save My Contact
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
0 · Share on Facebook Share on Twitter

Categories

Trending in API & Developers

Newly Received 404 with Error Code 1006 on DELETE sheets/{sheetId}/rows API with ignoreRowsNotFound
Hey there, Was a recent breaking change pushed to the smartsheets API? Previously, when calling the DELETE Request to the rows endpoint, I would receive a 200 with a valid response. Now, when requesting a valid sheet, with a valid row, I am unable to get a 200 response and am only receiving 404 with error code 1006 in…
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…
What is the proper Content-Type string for an Excel (xlsx) file row attachment?
Hello, I have an Excel document (xlsx) that I want to upload to a row through the API. My code does successfully upload the file as a row attachment. However, when I download the file through Smartsheet and try to open it, I get an error "Excel cannot open the file 'file_name.xlsx' because the file format or file extension…