SSIS package to read Smartsheet data to export the data into SQL database

dsp9

dsp9 ✭

04/19/19 edited 12/09/19 in API & Developers

I need to bring data from Smart sheet data into sql server using ssis. can anyone suggest the steps.

Tags:

0 ·

Comments

Andrée Starå ✭✭✭✭✭✭

04/19/19

Hi,

Maybe you can find an answer here: https://stackoverflow.com/questions/tagged/smartsheet-api

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on Facebook Share on Twitter

Categories

Trending in API & Developers

How to obtain sheet "created by" in Bridge for a child workflow
How can I use Bridge API Call OR Get Sheet OR another element to obtain the "Created By" metadata for use in a workflow? I see createdBy in the sheets summary in the SDK: sheetSummary - fields But I don't see it in the output of past runs of either the API Call or the Get Sheet element in Bridge. I see createdDate but not…
How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…
URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!