Manage and use datasets in scripts

The pm.datasets function provides access to datasets from a script or code mock. You can query datasets using SQL to retrieve data when your script or code mock runs. This enables your scripts and code mocks 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 code mocks.

pm.datasets

The pm.datasets function provides access to datasets from a script or code mock. 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
}