Larkbase icon

Larkbase

Truy vấn dữ liệu từ Larkbase API - Larksuite Base
Join our community

Actions3

Overview

This node interacts with the Larkbase API to manage records in a specified table. It supports creating multiple records, updating multiple records, and searching records within a table. The node is useful for automating data management tasks such as bulk data entry, batch updates, and querying records based on specific criteria. For example, it can be used to create a batch of product entries, update their prices, or search for records matching certain filters.

Use Case Examples

  1. Creating multiple product records in a table by providing JSON data for each record's fields.
  2. Updating existing records by specifying record IDs and new field values in JSON format.
  3. Searching records with complex filters and pagination parameters to retrieve specific data sets.

Properties

Name Meaning
Base ID / App Token Identifier for the base or application token used to authenticate API requests.
Access Token Token used for API authentication to authorize requests.
Table ID Identifier of the table where records will be created, updated, or searched.
Records JSON JSON-formatted data representing one or multiple records to create or update. For creation, it includes fields; for updates, it includes record IDs and fields.
Kích thước Chunk Maximum number of records to process in a single API call, up to 500.
Debug Level Level of debug information returned, ranging from basic to detailed including request/response data.

Output

JSON

  • records - Array of records created or updated, including their details.
  • status - Status of the operation, e.g., 'success'.
  • recordCount - Number of records processed successfully.
  • skippedRecords - Number of records skipped during update (if applicable).
  • items - Array of records returned from a search operation.
  • total - Total number of records matching the search criteria.
  • has_more - Boolean indicating if more records are available beyond the current page.
  • page_token - Token for fetching the next page of search results.
  • debug - Debug information based on the selected debug level.

Dependencies

  • Larkbase API with authentication via Base ID/App Token and Access Token.

Troubleshooting

  • Ensure Base ID/App Token and Access Token are provided and correctly formatted; missing or invalid tokens will cause errors.
  • Validate JSON syntax for the 'Records JSON' input; malformed JSON will result in parsing errors.
  • Chunk size must not exceed 500; larger values may cause API errors.
  • Warnings are logged if tokens do not follow expected prefixes (e.g., 'YXL' in App Token or missing 't-'/'u-' in Access Token).
  • Common error messages include JSON syntax errors and API call failures; review error details and correct inputs accordingly.

Links

Discussion