Seeking Advice on Bulk CSV Data Upload in Postman

Ask the Experts and Postman Tips
,
1

Hello everyone,

I would appreciate any tips on how to successfully upload data using a CSV file. Instead of the typical method shown in this

image
image366Ă—123 3.03 KB

where the request is iterated based on the amount of data,

I would like to upload all the data at once, resulting in an appearance like this.

image
image357Ă—251 8.84 KB

sample csv data:

image
image207Ă—102 1.86 KB

Thank you in advance for your help! I look forward to your suggestions and insights.

Ree

2

The Collection Runner will execute your collection once for each line in your CSV.

Therefore you can’t do what you want natively.

A couple of potential work arounds.

  1. Instead of using CSV files, use JSON as your data file.
  2. Have one header called “object” or “array” in your CSV and then take your required JSON and run it through a a JSON Minifier to compress the string and then use this string as the data. (Might not scale if you have hundreds of entries).
1 Like
3

thank you for this! will try this.