-
Generate list of current group memberships for a given user in Bridge
I would like to be able to make an API call in Bridge to generate a list of all groups/groupIDs that a user is a member of. To my knowledge, this can only be done for me as the "current user" at this time.
-
Does smartsheet have an endpoint for fetching the security controls from the admin centre
Hi @Lee Joramo @Genevieve P. Is there an end point/api or a sdk for fetching the the security controls from the Admin Centre page on the UI. If yes, does the access token need additional permissions. If No , Is there any other way to fetch these info. Or is it under development and when is it expected. Thanks, Narinder
-
How will the new email OTP login method impact Live Connector?
How will the new email OTP login method impact Live Connector’s 32-bit ODBC connection?
-
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…