Actions18
Row → Get Many
AI-generatedOverview
This node operation retrieves multiple rows from a specified SeaTable table and view. It is useful for scenarios where you need to fetch bulk data from SeaTable for processing, reporting, or integration with other systems. For example, you might use it to get all customer records from a CRM table or to extract inventory data for analysis.
Use Case Examples
- Fetch all rows from the 'Orders' table to generate a sales report.
- Retrieve a limited number of rows from a 'Contacts' view for targeted marketing campaigns.
Properties
| Name | Meaning |
|---|---|
| Table Name | The name of the SeaTable table to access. You can select from a list or specify dynamically using an expression. |
| View Name | The name of the SeaTable view to access, which can be selected based on the chosen table or specified using an expression. |
| Return All | Determines whether to return all rows or limit the number of rows returned. |
| Limit | The maximum number of rows to return when 'Return All' is false. It ranges from 1 to 1000. |
| Simplify | Whether to return a simplified version of the response instead of the raw data. |
| Return Column Names | Whether to return the column keys (false) or the column names (true) in the output. |
Output
JSON
rows- Array of rows retrieved from the specified SeaTable table and view, each row containing data according to the selected columns and format.
Dependencies
- SeaTable API access with appropriate credentials
Troubleshooting
- Ensure the specified table and view names exist and are accessible with the provided credentials.
- If 'Return All' is false and no limit is set, the node may return fewer rows than expected; set a proper limit.
- If the node returns raw data when simplified data is expected, check the 'Simplify' property setting.
- Errors related to authentication usually indicate invalid or missing API credentials; verify and update them as needed.