-
How to make a POST call using webhook
I have a use case where I want to trigger a UiPath Automation if any row gets added to a smartsheet. I went through the webhook documentation but in the create webhook function, we can pass just a URL for the "callbackurl" key. Since I have to make a POST call, I have a list of input paramters in the request body (plus the…
-
Updating Dropdown using Smartsheet API
Hello, I currently have a column with a dropdown list type and I'd like for it to be dynamic. I read some past discussions in the community, but I can't seem to find a clear solution when using the API. How can I use the API to automatically add to the dropdown when a new record is added? Or is there a way to use the API…
-
Creating and Formatting Sheet Summary Field with API using Python
I am updating a handful of sheet summaries using Python. My current code creates the sheet summary fields that I want with the correct formulas however I am unable to get the formatting to work properly. Below is a partial screenshot of the code: According to the API docs I should be able to set the formatting of the sheet…
-
I am not able to connect to smartsheet API from the java spring boot app with the VPN on.
I can connect to the smartsheet API from postman and also Off VPN. I tried to add a proxy setting to connect to the APIs to get it working with VPN and I am getting this error. Error Connecting to API com.smartsheet.api.SmartsheetException: com.fasterxml.jackson.core.JsonParseException: Unexpected character ('<' (code…
-
Creating a Group via API
I've searched the API Documentation, as well as github and I'm not seeing anything that allows someone to create a Smartsheet Group via the API - is that possible and I'm just not looking at the right thing? We are trying to set up automation with a multi-tier solution, and have others who are submitting project requests…
-
Use Smartsheet API to sync with external system
Hello I have a need to sync Smartsheet with an external system, the only way I can get the data out of the system is via a regularly updated report - however I have no way for the report to not include all data. Ideally the API would give me an option to specify the value of the primary column, and if there is an existing…
-
Creating price tickets
Would be grateful for any guidance please. I'm looking for a way of producing sheets of price labels including a barcode that would be generated from a smartsheet. I can get all the relevant data into one smartsheet however I have been struggling to come up with a way of creating a PDF that would contain the price label…
-
Script becomes unresponsive after deleting 10Krows.
I am attempting to delete rows from a Smartsheet that contains 16K rows. I'm using the smartsheet_client.Sheets.delete_rows(sheet_id, rows_in_chunks) method and have tried deleting in chunks of 20 and 200 rows at a time. However, the script becomes unresponsive/gets stuck after deleting 10K rows. I'm wondering if this…
-
Issue When importing an EXCEL file with API ? (switched indent !!)
Hi all, I have a question about what seems to be an issue in smartsheet API. I am surprised not to have found this bug in the forums because the Excel import in smartsheet must be very used? Here is the issue : When you import an Excel file containing indentation, with this script : https://smartsheet.redoc.ly/tag/import/…
-
How can I tell where the automation email fail is coming from?
My IT Dept. says Smartsheets is whitelisted. They show no record of any emails getting blocked. However, my automation is to send an email when a row is added from a form and now no emails are going out to anyone. I even tried Run Now and nothing is going out. Is it Smartsheets? Is it down? It worked two weeks ago when we…