Import CSV/JSON file to Tulip Table

Show and Tell
1

Hi,

By using Bot API feature with Postman Runner, it is possible to import CSV/JSON file directly to a Tulip table.
To get explainations on Postman Runner , click on the following link
https://learning.postman.com/docs/postman/collection-runs/working-with-data-files/

Mathieu

8 Likes
2

So I assume you created the table with all of the necessary fields before using postman to POST the records using the Tulip /records endpoint to post each record from your CSV?

I am working on importing a csv file today.

Thanks!

3

hi austin,

yes exactly, you are well rigth. The table creation is an another action.
You could use TULIP API to create the table with the appropriate field but it is much more faster to do it manually.

If you need some help, do not hesitate.

Thanks

4

Did you have to use Postman variables inside your body to link the fields from the csv to the body of the POST request? Also did you write any tests in your postman request?

Thanks

5

Yes, exactly. This is just nominated variable (they are not linked to any environement or initialized at the beginning)
As on the following example,

image
image1340×715 31.2 KB

When you are using the Postman Runner tool, try the button preview just after upload your CSV or Json file.
You should have a match between your variables (inside your body) and the fields in your file.
As on the following example,

image
image1188×493 21.6 KB