Is there capability to ingest Excel or CSV file upload content into a Tulip Table via App?

Support, Troubleshooting, & Help
,
5

Hi @jboyle

The team likely steered away from this for the library, as it will require specific column mapping to be packed into the custom widget. However, it is very much possible. You will need to carefully map your csv column headers to tulip table ids, but the code below should be a great starting point. Hopefully you can just switch out the constant values at the top of the javascript and it works, but happy to hop on a call to troubleshoot. Date fields might require some manipulation, for example.

I would share the custom widget, but the file would break in later versions, so it is easier to just share code for posterity.

CSVUploadWidget.txt (4.4 KB)

Disclaimers and notes for the Tulip team:

  1. this is going to be pretty slow for large files, as the tulip api can only create one record at a time
  2. the create API does not have an option to allow overwriting, so if upserting is a requirement here then this script would need to be rewritten with a bunch of additional querying to check whether to POST or PATCH

Happy Tulip-ing!