get_select_list
Execute a SELECT or SSELECT query to retrieve a list of record IDs from a U2 database for further processing without fetching full records.
Instructions
Execute a SELECT statement and return the list of record IDs.
This is useful for getting a list of matching records for further processing, without retrieving the full record data.
Args: query: SELECT or SSELECT statement Example: 'SELECT CUSTOMERS WITH STATE = "CA"' max_ids: Maximum IDs to return (optional, defaults to U2_MAX_RECORDS)
Returns: Dictionary containing query, list of record IDs, count, and whether results were truncated.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ||
| max_ids | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||