Read rows of a DataLens dataset
datalens_datasets_data_getRetrieve dataset rows for specified field columns, one page per call. Filter, sort, and paginate using guid-based column names from the dataset schema.
Instructions
Rows of a dataset: the columns asked for, one page per call.
Columns are named by the guid of a field, not by its title: read them with
datasets_get. For the next page give offset together with sort.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | The order of the rows: a field's guid and `asc` or `desc`. | |
| limit | No | The most rows to return; 100 when left out. | |
| offset | No | How many rows to skip; above zero it needs `sort`. | |
| params | No | Values for the dataset's parameters. | |
| columns | Yes | The guids of the fields to return (`dataset.result_schema[].guid`). | |
| filters | No | The rows to keep: a field's guid, an operation and its values. | |
| dataset_id | Yes | Dataset id. | |
| workbook_id | No | The workbook the dataset lies in. |