API & Developers

Archives for April 2023

How do I get the Metadata from the Smartsheet?
Hello All, I am able to get the Row and Column from the smartsheet JSON response but in it there are no metadata. I used things like: params = {'include': 'objectValue,objectProperties,format,formula,columnType,options'} and passed it with the request. But I still do not get any metadata. Specifically, I am trying to get…
Sharepoint integration with Data Shuttle
We have the issue of connecting Sharepoint to Data Shuttle so we can offload data there. Once we choose Sharepoint, this window pops up Couldn't find the guidelines of how we can do that. Did anyone face the same issue ?
Mapping checkboxes
Hi! I am currently mapping a fillable PDF for document generation. When I map the checkbox field the checkbox is huge and not within the box. See pic below for example. How can I make this smaller and fit. Check should be next to Add MRM Thank you!
How can I connect project names to a project #?
I am looking for a better way besides individually making automations. That allows me to connect multiple project names using a drop-down list to a specific project number.
Python API Copy Sheet - Data not copying to new sheet
I am copying a sheet (source) to a new sheet (destination) using Smartsheet's SDK API. The copy of an empty sheet is the result. I tried the include parameter but it makes no difference. Does anyone know the correct syntax to use so when I copy a sheet the data within is copied to the destination sheet as well? Here's…
Smartsheets and Acumatica
Acumatica shows a list of templates that can be used with the product. We have created several and have issues finding out new templates after publishing them. I wonder if anyone has found a way to find missing templates.
Inbound Links
Hi, I have a sheet with a million instances of "Used in Formula on <unknown sheet>". Is it possible to delete the "unknown sheet" references using the API and Python code?
What is the maximum limit of batch size to insert, update, or delete the rows?
Hi, For https://smartsheet.redoc.ly/tag/rows API for "Add Rows", "Update Rows" and "Delete Rows", how many records can we insert, update and delete per call request? Is there any limitation in the number of rows or batch size? If so, what's the limit and what kind of error would we receive beyond the limit? I did not…
Does anyone have a Swagger file for the RM API?
Haven't been able to find a swagger file (JSON) for the RM API, wondering if anyone has either built one or got a Postman collection they can share? Many thanks Iain
Smartsheet bulk operation
Can anyone please explain the below result code significance and the scenario in which that could occur with an example?

Trending in API & Developers

QR Codes/Bar Codes
Dear Smartsheet Community. Is there a means within Smartsheet to allocate a unique QR/Bar Code to a specific line in a grid, such that if you subsequently scan the code (outside of Smartsheet), the specific line/data record can be accessed? For now, I am thinking of an image of the relevant code added in a cell as an…
Moving many rows to another sheet?
My task is to move 3500+ rows to an archive sheet every two weeks. I'm using the python SDK Sheets.move_rows() command but am running into a timeout error (4002) after just 250 rows (granted there are a lot of columns). Can anyone recommend a better method than telling python to loop through the list, moving 250 at a time?…
Bridge Search for a value - What are the modules to use?
I have a use case as follows: When a row changes or is added in the source sheet, I want to search for the row's column named "Key" against a column also named "Key" on a target sheet. If found I want to update a column named "History" in the target sheet that matches the source sheet's key. I also want to write the word…

API & Developers

Discussion List