Turn CSV and JSON files into data you can query in Postman. You build a dataset, shape it with SQL views and a join, then use it to drive a collection run and query it from a script.
- You'll build
- A queryable dataset with SQL views that drives a collection run and feeds a script.
- Time
- About 30 min · 3 parts · 8 steps · progress saves as you go
- How it works
- You do each step, then click Validate and LiftOff checks your work. 5 of the 8 steps can't be checked automatically, so you click Done for those.
- You'll need
- A free Postman account and API key (connect it below)
- A Postman Solo plan or higher
- A few setup steps, shown below before you start
Connect a Postman API key to check your work
You do each step in Postman, then LiftOff uses your key to look at your workspace and confirm it's done. Connect once and it works for every module. Your key is saved in this browser and is only used to check your work in Postman.
This module uses Postman features available on the Solo plan and above.
Compare plans →Before you start
You'll need a Postman plan that includes datasets (Solo, Team or Enterprise) and the Postman desktop app. Everything is tested against the free Postman Echo API, so there are no other accounts or keys to set up.
Gather the Data
Before anything can be queried, the data has to live somewhere Postman can reach. This part builds a dedicated workspace and your first dataset from two very different files, a CSV and a JSON export.
Ask the Data Questions
A view is a saved SQL query, and it's the heart of a dataset. Views use SQLite-compatible SQL for files and standard databases, and because the view stays fixed even if the files behind it change, everything built on top of it keeps working.
Put the Data to Work
Now the dataset stops being a table and starts doing jobs. First it drives a collection run, then your scripts query it directly.