Does Smartsheet Form have any APIs?

Dave Jiang · 04/19/21

Hi,

I'm trying to automate the form submission process for my team, I saw form submission seems to be calling https://forms.smartsheet.com/api/submit, just wondering if we have any APIs open for this like the api.smartsheet.com ones?

Thanks

Cody Holmes · 04/19/21

Hi Dave,

Smartsheet does have a very robust and well-documented API, https://smartsheet-platform.github.io/api-docs/.

I am not 100% sure what your use case is, so forgive me if I'm not answering your question exactly. But if you are trying to automate form submissions, you should probably connect to a specific sheet via the API and use a PUT request to store the data into that sheet (since that is where the data is going on a form anyway).

Dave Jiang · 04/20/21

https://community.smartsheet.com/discussion/comment/287997#Comment_287997

Thanks Cody, I'll try "PUT" a new entry to the sheet! In my case upon the form submission there's a new unique ID created for the new entry in the sheet that the form is connected to, can this ID generation part also be covered by a "PUT" method to sheet?

Cody Holmes · 04/20/21

So I would probably just make another column in the sheet with an "Auto-Numbering/System" column type (see pic). You can set it up pretty easily. Once you make the "PUT" request, the ID will automatically get associated with the incoming form submission (the new row). There are other ways you could go about it, of course, but that's one method I would probably go about it. Hope that helps!

Dave Jiang · 04/22/21

Hi Cody,

Thanks the reply again!

The issue here is that I'm not the owner of the sheet, and I tried "post" a new row to the sheet and got an error "Cannot edit a locked column xxx", and this column is a mandatory field on the form, is there any way to get around this?

Does Smartsheet Form have any APIs?

Answers

Categories