API & Developers

Archives for January 2023

How do I get all the rows in a Smartsheet by sending an API call using the requests package in pytho
I am trying to get just the rows (list of rows) in a smartsheet in a single API call by using the Python requests package instead of the smartsheet SDK. I tried to use /rows in my request like so: r = requests.get("https://api.smartsheet.com/2.0/sheets/{sheetID}/rows", headers=smartHeaders, params=payload) but…
Add Group Members via API
Has anyone had success adding Group Members via API (not being a system admin but having Group Management permissions)?
Dashboard - error pulling data
I have created a Dashboard. I am trying to pull the report data in as I have always done. I keep getting an error message. I re-created the reports and initially it will work. As soon as I hit "save" I start getting error messages. Help?
Reports - How to open in a new window
Hello Community! I have a Form that contains a "Reference" link, to show a list of projects. This list is a Report, but users have the issue that this report sometimes opens in the same window and hence, they lose everything they already typed in the Form. My question is: is there any parameter that I can include in the…
errorCode: 5636, "message": You have reached the cell limit of 500,000 cells for this sheet.
Hello Community, I am trying to automate dataflow from excel to Smartsheet using Python. The excel has 12000+ rows and 42 Columns. The Python script was able to transfer 11000+ rows successfully, but then throwing these errors: ERROR:smartsheet.smartsheet:{"response": {"statusCode": 400, "reason": "Bad Request", "content":…
How to embed power bi dashboard to smartsheet?
How to embed power bi dashboard to smartsheet?
What date format works for Power Automate to input a date in Smartsheet?
I am creating a Power Automate flow to input Form entries into a new row in Smartsheet. I am using Microsoft Forms and not Smartsheet's form because Power Automate will also perform other actions outside of smartsheet. One of my form fields is a date entry. I am trying to get Power Automate to enter this in a Date field in…
Dashboard Widget API
Hi All, Wanted to see if there was a way in the API to update the URL stored in the web content widget. From what I can tell I can modify the name and size/formatting properties of the widget, but am missing if I can write into the URL parameter.…
Slack Integration: How can I systematically retrieve the row from the slack notification
I have row update notifications going to Slack as notifications in a workflow. I am also able to listen to that Slack channel from my application. How can my application find out which rowId is being referred to - can the URL be interpreted somehow? Thanks, James.

Trending in API & Developers

Smartsheet API Documentation unexpectedly asking for login (23 Apr)
I'm unable to log into the smart sheet API Documentation. Till yesterday I was able to access the API documentation did not prompt for login. Kindly help me log in to SmartSheet Official API and SDK Documentation Log in with Redocly
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?…

API & Developers

Discussion List