Actions8
Overview
The node interacts with the Xano API to retrieve multiple rows from a specified table within a workspace. It is useful for scenarios where you need to fetch paginated data from a backend database managed in Xano, such as displaying records in a dashboard, processing batch data, or integrating Xano-stored data into other workflows.
For example, you might use this node to:
- Retrieve a list of users stored in a Xano table for further processing.
- Fetch product inventory data page by page to sync with another system.
- Query customer orders in batches for reporting purposes.
Properties
| Name | Meaning |
|---|---|
| Workspace Name or ID | Select or specify the workspace from which to fetch the table data. |
| Table Name or ID | Select or specify the table within the chosen workspace to get rows from. |
| Page | The page number of results to fetch (used for pagination). Default is 1. |
| Items per Page | Number of records to return per page. Controls the size of each page of results. Default is 10. |
Output
The node outputs JSON data containing the rows retrieved from the specified table and page. Each item in the output corresponds to a row in the table, represented as an object with key-value pairs matching the table's fields.
If the table contains binary data fields, those would be included in the output as binary attachments, but this node primarily focuses on JSON content representing table rows.
Dependencies
- Requires an API authentication token credential to connect to the Xano API.
- The node depends on the Xano service being accessible and the user having appropriate permissions to read data from the specified workspace and table.
- Pagination parameters must be correctly set to avoid fetching empty or incomplete data sets.
Troubleshooting
- Empty results: Verify that the workspace and table IDs are correct and that the table contains data.
- Authentication errors: Ensure the API key credential is valid and has sufficient permissions.
- Pagination issues: If no data appears on higher page numbers, confirm that the page number and items per page values correspond to existing data ranges.
- API rate limits: Excessive requests may lead to throttling; consider adding delays or reducing request frequency.
Links and References
- Xano API Documentation
- n8n Expressions Documentation (for dynamic property values)