Manage and use datasets in scripts

The pm.datasets function provides access to datasets from a script or local mock server. You can query datasets using SQL to retrieve data when your script or mock server runs. This enables your scripts and mock servers to return dynamic, data-driven responses instead of static values.

All methods are asynchronous and return Promises, so use await to access their results. Query results return rows as an async iterable, so use the for await...of loop to read the returned rows.

Learn more about using datasets in scripts and mock servers.

pm.datasets

The pm.datasets function provides access to datasets from a script or local mock server. You can load a dataset by its ID and then use methods to query the dataset or manage views.

pm.datasets(datasetId:String)

Loads a dataset and returns a handle you can use to interact with the dataset.

1
const ds = pm.datasets('menu-id');

dataset.executeView(viewId:String, params?:String[])

Runs a view that’s already defined in the dataset and returns the results. Query rows are returned as an async iterable, so use the for await...of loop to read the rows.

1
const ds = pm.datasets('menu-id');
2
3
const result = await ds.executeView(
4
  'view-id',
5
  ['pizza']
6
);
7
8
const allRows = [];
9
10
for await (const row of result.rows) {
11
  allRows.push(row);
12
}

dataset.executeQuery(sql:String, params?:String[])

Runs a custom SQL query against the dataset and returns the results. Query rows are returned as an async iterable, so use the for await...of loop to read the rows.

1
const ds = pm.datasets('menu-id');
2
3
const result = await ds.executeQuery(
4
  'SELECT * FROM menu WHERE category = ?',
5
  ['pizza']
6
);
7
8
const allRows = [];
9
10
for await (const row of result.rows) {
11
  allRows.push(row);
12
}