-
Bridge - Error with POST call to API - Invalid Body
I'm trying to make a post call to an API using the "Call API" action within Bridge. Unfortunately, every time I try this action, it fails with an "Invalid Payload" response. I've tested the payload in Postman, and it seems to be working correctly. The API I'm using is a "POST" to a Slack Webhook. (It will automatically…
-
How to retrieve the only past 5 days created row using Smartsheet API
Hi All, I'm exploring the Smartsheet API. My use case to extract past 5days newly created records from my "ABC1231231" Sheet using Smartsheet API call. Kindly advise me which API method i need to use and how to use the Date query filter?
-
Checklist population with info from another sheet
Hi team! I'm hoping one of you wise Smartsheets gurus have some guidance. I am trying to build out a "checklist" that will populate with data from another form and for the life of me I cannot figure it out! For a little more context, I work in the Mortgage industry. The documentation needed for each loan can vary,…
-
Updating Column In Smartsheets Through Python API
Hello! I am trying to update a column in a specific smartsheet using the update_column method from the Python SDK. I keep getting the error: {"response": {"statusCode": 400, "reason": "Bad Request", "content": {"errorCode": 1032, "message": "The attribute(s) column.id are not allowed for this operation."} But, if I set the…
-
negative numbers formatted as text
I am using the JSON string below to add rows to a sheet via the API However if the value is negative, as in this case, the value is entered as a string rather than a number so -9987.5 becomes '9987.5 Positive values work just fine I believe something has changed recently as this didn't happen before. How can I specify that…
-
Merge all attachments of a sheet into one PDF?
Is there any way to automate merging all of the attachments of a sheet into one PDF? I was thinking of using zapier or Microsoft Flow but I haven't been able to figure out a good and simple way to. Ultimately I want the end users to be able to do so with only one trigger (after the sheet has all of the attachments.) Thanks…
-
Attach an existing Dynamic View to a sheet programmatically
I know there is no API for Dynamic Views yet, but I'm looking into building some automation for a client and wonder if there is a way to programmatically assign an existing Dynamic View to a new sheet. It doesn't look like when you copy a sheet and create a new one via API, the Dynamic View associated with that original…
-
I Cant seem to get my gif work on a smartsheet dashboard
I like the design of the smart sheet PMO dashboard setup(link below) and attempted to design a replica for my solution but have not been able to figure out the gif part. After converting my video to a GIF and ensuring that the size is below 30 MB I attach it to the dashboard but it doesn't animate. how can I go about this…
-
Report fetched through API is restricted to 450 rows only
Hello, Please note that I am using Smartsheet api to fetch a report that has around 500+ rows. Syntax - https://api.smartsheet.com/2.0/reports/<report id> This is only fetching 450 rows and I have no idea where the remaining rows went. Based on few posts through Google search, I tried pagination ways like - #1…
-
Sending form attachments to their own smartsheet or google drive folder
Hi everyone, We're currently trying to create a system that accepts form entries with attachments and stores those attachments in their own folder as soon as they are submitted. Preferrably, we would like this folder to update in real time and remove any attachments that are replaced when the same user uploads a different…