API & Developers

Archives for June 2018

CORS in Ionic and third party api(Smartsheet)
I am trying to get data from smartsheet API. When I use postman and nodejs in separate server code, it works. But if I use the API inside the Ionic with HttpClient (@angular/http) it gives CORS issue with run in browser. Failed to load https://api.smartsheet.com/2.0/sheets/1235941564208899972: Response to preflight request…
Doc u Sign Intergration
On the Smartsheet Labs sign in page for Docusign- cannot seem to login. It keeps on saying Authentication failed- tried my email and the API username. I can log into Docusign no problem on their site.
Not all rows are fetching from my Python Script!
I have written a script to fetch all data from a Smartsheet. i am using Smartsheet's get_sheet('sheet_id') method to fetch my Smartsheet, which has 500 rows but i am only getting exactly 300 row objects, after 300 row objects an error like this being thrown "Too large to show contents. Max items to show 300". But the…
Adding rows to another sheet automatically
Each time I add one more row to one sheet (Sheet A), I want to trigger the addition of 7 rows to another sheet (Sheet B) . The data in the 7 rows will be driven off of 2 sheets (Sheet A and Sheet C). Sheet C is a static lookup table. Is this possible?
Product Key
I need my product Key for run powershell command. Where I can find them?
Pull attachment from Sheet
Is it possible to create a form that pulls attachments and sends back to the requester? e.g., I have a sheet completely filled with a column titled "Common Number Criteria", and an attachment that corresponds to each number in the column. If I created a form and send that link url to an outside user, can they type the…
Trying to delete a large number of rows trough API
Hi I am using the Node JS SDK to delete the content from a sheet. It works fine but for a lot of rows it fails (I have tested with a minimun of 1000). I get an error that says that the request is to large for the server. I understand whats happening, but I was wondering if there is another way to clear a sheet using the…

Trending in API & Developers

Smartsheet API Call
Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET request to make the API, call but I am not sure how to handle the response in Smartsheet. Many Thanks,
Do you know if you can add a custom code in values (pink rectangle) - Bridge Workflow?
Do you know if you can add a custom code in values (pink rectangle) in this Bridge workflow that is updating a SharePoint list any time changes are being made in the relevant Smartsheet Table? Basically this workflow is working as expected with one issue: for every empty cell, the workflow will update SharePoint with the…
Number values containing 'Apostrophe after being imported from Excel
Greetings All ! looking for some assistance regarding an integration issue I've picked up when importing data from Excel to Smartsheet's using MS FLow , i.e. Excel->MS Flow-> Smartsheet I am inserting an integer but the value on Smartsheet contains an apostrophe before the number which is not ideal as i am using these…

API & Developers

Discussion List