-
HTTP 403 Error while copying large attachments from Smartsheet to Azure Blob after 1 minute
Around 4-5 years back we developed a job to take backup of attachments from smartsheet and store it in Azure Blob Storage. We are copying the attachment from Smartsheet to Azure directly using the temporary URL that we receive from Smartsheet GetAttachment API call. We are copying attachments up to a size of 2GB and this…
-
Export Smartsheet as CSV using API - "media type not supported"
I'm able to export a smartsheet document as JSON with the API, however, our endpoint doesn't support nested data. So I'd like to get it either as flattened JSON or CSV. Sample #4 here shows the CSV option: // Sample 4: Get sheet as CSV curl https://api.smartsheet.com/2.0/sheets/{sheetId} \ -H "Authorization: Bearer…
-
Reasons for error code 1008 in webhook subscription request
Hi, Zapier Integrations team here. We are experiencing users reporting being unable to set up a webhook subscription to Smartsheet when a POST request is made to https://api.smartsheet.com/2.0/webhooks Response received { "errorCode": 1008, "message": "Unable to parse request. The following error occurred: Field 'name'…
-
API for RM and smartsheet project plan linking
Are they any APIs that can be used to link an RM project to an existing smartsheet project plan? Also, is there an API that can be used to navigate between a smartsheet project plan and an RM project?
-
API creates rows but strips out all cell values
I am attempting to write data into Smartsheet using the API, but every POST request that adds a row results in all cell values being removed. The API call returns SUCCESS, a new row is created, and the row number increments correctly, but every cell in the row is blank. This happens consistently with all sheets, even with…
-
Need the hyperlink column to be included in the Smartsheet API response.
Need Smartsheet technical expert suggestion or approach to retrieve hyperlink from Smartsheet API The recommended approach to retrieve hyperlink data structure from columns via the API Any specific column type configurations or API parameters that might be required Best practices for handling hyperlink data in API…
-
Pull FROM Reference Link
Dear Community, i have a question, is there anyway to pull the Form link automatic into a sheet or call it by API? Of course i understand that is i have multiple Forms in One Sheet i have multiple adress Like Sheet 1 Adress 78654654 Form A — 4788 Form B — 47654 Is there any logic in the adress so we can match it and pull?
-
Smartsheet API: List Users Missing Fields & 502 Error with planId Param on Business Plan
Hi all, We have an account on the Business Plan and are using the List Users API to retrieve user details. However, when we make the API call, only a few fields are returned, matching what's documented in the API docs. Additionally, when we try to use the planId query parameter, the API returns a 502 error with the…
-
Is there a way to populate a dropdown list from another sheet?
I have a list of employees that change frequently in Sheet 1. I have a dropdown for employee in Sheet 2. Is there any way to populate the dropdown in Sheet 2 with the list from Sheet 1? Example: Sheet 2 has a column named Employee. Sheet 1 has a column setup as a dropdown called Tech. I want to take all of the names from…
-
How to Implement Dynamic Dropdown among Two Sheets
A department wanted a way to take a unique list from a project column in one sheet and use that distinct listing as a dropdown for another sheet, which updated every hour. I currently run the below script from Python Anywhere on an hourly basis, and I have shared this script so that anyone else can use it as a template for…