Fetching data from DB to Boomi to Smartsheet
Hello,
I'm working on a project that should fetch details from a DB (MYSQL) via boomi (integration tool, that is currently designed to output queries or CSV), and then copies the data to a sheet or datatable.
How can I make this work?
Is there a script i can use to copy the CSV as attachment to a row? can i populate directly the Datatable via API? any ideas?
Answers
-
Hey Marco,
Chiming in since I had to do something similar for my organization. The smartsheet SDK documentation has a script that allows you to attach the CSV (or any file) onto the row via the link below. You'll need to install the SDK beforehand to do so for your programming language of choice.
https://smartsheet.redoc.ly/tag/attachments#operation/row-attachments-attachFile
You could also populate the CSV file directly onto the sheet via API using the SDK. Our organization decided to just use data shuttle but you could probably build the equivalent by customizing these three scripts below.
https://smartsheet.redoc.ly/tag/columns#operation/columns-addToSheet (Add columns onto sheet to match CSV file)
https://smartsheet.redoc.ly/tag/rows#operation/rows-addToSheet (Add rows onto sheet to match CSV file)
https://smartsheet.redoc.ly/tag/rows#operation/update-rows (Populate cell data from csv file once columns and number of rows match)
Sincerely,
Paul
