Lake icon

Lake

Read, update, write and delete data from Lake
Join our community

Actions5

Overview

The "Get Many" operation of the "Row" resource in this node allows users to retrieve multiple rows from a specified table within a project (or base) in Lake. It supports fetching all rows or limiting the number of returned rows, applying sorting rules, filtering by formulas, and selecting specific fields or views. Additionally, it can download attachments associated with the rows if requested.

This operation is beneficial when you want to bulk fetch data records for processing, reporting, or integration purposes. For example, you might use it to:

  • Retrieve all customer records from a CRM table.
  • Fetch a limited set of recent orders sorted by date.
  • Filter rows based on certain criteria using formulas.
  • Download attached files linked to the rows for further processing.

Properties

Name Meaning
Authentication Choose the authentication method: "API Token" or "User Token".
API Version Select the API version to use: "Before v0.90.0", "v0.90.0 Onwards", or "v0.200.0 Onwards".
Workspace Name or ID (Only for API version 3) Select or specify the workspace where the base/project resides.
Base Name or ID (Only for API version 3) Select or specify the base (project) to operate on.
Project ID (For API versions 1 and 2) Specify the project ID or select from the list.
Project Name or ID (For API version 2) Select or specify the project to operate on.
Table Name or ID Select or specify the table from which to retrieve rows.
Return All Whether to return all matching rows or limit the results. If false, the number of rows returned is controlled by the "Limit" property.
Limit Maximum number of rows to return when "Return All" is false. Minimum value is 1.
Download Attachments Whether to download attachment fields defined in "Download Fields".
Download Fields Comma-separated list of attachment field names to download. Case sensitive. Required if "Download Attachments" is true.
Options Additional options including:
- View ID: Select fields of the returned rows.
- Fields: List of specific fields to return.
- Sort: Sorting rules specifying field and direction (ASC/DESC).
- Filter By Formula: A formula string to filter rows.

Output

The output is an array of JSON objects representing the retrieved rows from the specified table. Each object corresponds to one row and contains key-value pairs where keys are column names and values are the respective cell data.

If "Download Attachments" is enabled, the node also downloads the binary content of the specified attachment fields and includes them as binary data in the output items, allowing further processing or saving of these files.

Dependencies

  • Requires connection to the Lake API service.
  • Requires valid authentication via either an API token or user token.
  • The node dynamically loads available workspaces, bases/projects, and tables via API calls to assist user selection.
  • No additional external dependencies beyond the configured API credentials.

Troubleshooting

  • Empty Results: Ensure the correct project/base, table, and filters are selected. Verify that the table contains data.
  • Authentication Errors: Confirm that the provided API token or user token is valid and has sufficient permissions.
  • Invalid Field Names: When specifying fields or download fields, ensure names exactly match those in the table schema (case sensitive).
  • Attachment Download Failures: Check that the specified attachment fields exist and contain downloadable content.
  • API Version Mismatch: Selecting an incorrect API version may cause unexpected errors; verify compatibility with your Lake instance.
  • Rate Limits or Network Issues: Temporary network problems or API rate limits may cause failures; retry or check API usage policies.

Common error messages typically indicate missing or invalid parameters, permission issues, or non-existent rows/tables. Using the "Continue On Fail" option can help handle partial failures gracefully.

Links and References

Discussion