-
How add column with Type Symbol and Limited to symbol only via API
Hi, I am struggling with an CALL api I need to add a column type Symbol with a validation = True If i put in my body options list, i got an error : Columns options are not allowed when symbol is specified If i remobed from my body options, i got an error: this type of column must have at least one option valu I'm a bit…
-
Calendar Notification/Alert
Hello, We are using this notification for an automated greeting for milestones. Other than custom message, we would like to include an image on our post. However when we are trying to include the column with the image, its not going through. The message is showing the file name of the image (see image below). Adding the…
-
Smartsheet API to create csv
Hi, I am trying to create csv file using smartsheet -python-sdk.. i am getting following error response.save_to_file() AttributeError: 'Error' object has no attribute 'save_to_file' on further debugging i found that save_to_file module does not exist. Is there any other way to export smartsheet to csv format via api call…
-
To make the Row ID (SmartSheet) reads its value from (Service Request #) column
After diving deeper in SmartSheet we notice that each row has an auto-generated ID to identify it, but to us what’s more important is our unique Id which is pre-created by our system (Service Request #), we have this unique number stored in specific column with unique value for each row in the sheet. So our question is…
-
How do I pull data using Reports API from 10000ft into Power BI
Hi, I am trying to import data from the 10000ft reports using the following API link, but I get the message 'Not Found'. https://api.10000ft.com/api/v1/reports/rows?view=time_fees_hours&time_frame=this_week&auth=<URL-ENCODED-TOKEN> Can anybody help? Thanks
-
How to insert a value for Contact List Column from c# using api
Hi all, I need to insert a value for a column, whose type is column list, from c# using api. I have even tried by defining the value and display value for this column from c#, but it does'nt get reflected on sheet. Thanks! Shoaib
-
How to set the value via Python APIs for simple CONTACT_LIST column ?
Hi, i have the column where the type is CONTACT_LIST (single value only, not multiple values) ... here is the code snippet: case_owner_email = "owner.name@company.com" new_row.cells.append({ 'column_id': project_metadata_column_map["Case Owner"], 'value': case_owner_email }) all my email addresses are correct, and all my…
-
How to set the value via Python APIs for simple CONTACT_LIST column ?
Hi, i have the column where the type is CONTACT_LIST (single value only, not multiple values) ... here is the code snippet: case_owner_email = "owner.name@company.com" new_row.cells.append({ 'column_id': project_metadata_column_map["Case Owner"], 'value': case_owner_email }) all my email addresses are correct, and all my…
-
copy_folder doesn't copy automation rules via rest api
currently I run a copy_folder by API then found that the automation rules of the sheet under the folder is not copied. I tried to create that automation rule by rest api, after copying the folder, but found that create_automation_rule is not available. Is there a good way to do this fully via rest?
-
How to make BULK request for: "create_cross_sheet_reference"
Hi, i need to create multiple cross sheet reference on the same sheet, and at the moment i'm doing one api call for each single reference ... is there a way to do this in a bulk request: only one api call for multiple references on the same sheet ? thx ljk
