Get dataset items
get-dataset-itemsRead-onlyIdempotent
Retrieve rows from an Actor run dataset. Filter fields, set limits, offset, and skip empty items to get the exact output data needed.
Instructions
Get items (rows) from a dataset — the output/results produced by an Actor run. Returns the rows themselves, not dataset metadata, counts, or a schema. When the user provides a datasetId and asks to retrieve results, output, data, or rows, call this tool directly. Default limit is 20. Use clean=true to skip empty items and hidden fields.
USAGE:
Use when you need to read data from a dataset (all items or only selected fields).
USAGE EXAMPLES:
user_input: Retrieve results from dataset abc123
user_input: Get only metadata.url and title from dataset username~my-dataset
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| desc | No | If true, results are returned in reverse order (newest to oldest). | |
| omit | No | Comma-separated list of fields to exclude from results. | |
| clean | No | If true, returns only non-empty items and skips hidden fields (starting with #). Shortcut for skipHidden=true and skipEmpty=true. | |
| limit | No | Maximum number of items to return. Default is 20. | |
| fields | No | Comma-separated list of fields to include in results. Fields in output are sorted as specified. Use dot notation for nested objects (e.g. "metadata.url"); the server auto-flattens parent prefixes. | |
| offset | No | Number of items to skip at the start. Default is 0. | |
| flatten | No | Comma-separated list of fields to flatten (e.g. flatten="metadata" turns {"metadata":{"url":"x"}} into {"metadata.url":"x"}). Normally derived automatically from dot-notation in `fields`; specify only as a diagnostic override. | |
| datasetId | Yes | Dataset ID or username~dataset-name. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| items | Yes | Dataset items | |
| limit | Yes | Limit used for pagination | |
| offset | Yes | Offset used for pagination | |
| summary | Yes | Summary of the result | |
| nextStep | Yes | One follow-up action with tool name | |
| datasetId | Yes | Dataset ID | |
| itemCount | Yes | Number of items returned | |
| totalItemCount | Yes | Total items in dataset | |
| apifyConsoleUrl | No | Personalized Apify Console link to the dataset; present only for Console sessions |