VanAnTravel Connector

VanAnTravel advanced connector with dynamic field loading and smart filtering
Join our community

Actions5

Overview

This node interacts with the VanAnTravel Connector API to perform operations on records within a specified table. Specifically, the 'Get Many' operation retrieves multiple records from a table with support for advanced filtering, sorting, and pagination. It is useful for scenarios where users need to fetch bulk data from a table with complex filter conditions, such as retrieving all records matching certain criteria or sorting records by specific fields.

Use Case Examples

  1. Fetch all records from a table where the status field equals 'active' and sort them by creation date in descending order.
  2. Retrieve up to 100 records from a table with a filter that the 'priority' field is greater than 5 and return only specific fields like 'name' and 'email'.
  3. Use a custom filter expression to get records where a date field is within the current month.

Properties

Name Meaning
Tenant Access Token The tenant access token for authentication (starts with t-)
App Token The app token for the application (starts with app)
Table ID The ID of the table (starts with tbl)
Return All Whether to return all results or only up to the limit
Limit Max number of results to return when Return All is false
Advanced Filters Multiple field filters with AND/OR logic to filter records
Custom Filter Expression Advanced: Write custom filter expression (overrides advanced filters)
Additional Options Additional options for Get Many operation including sorting, field selection, text field formatting, automatic fields inclusion, formula reference display, and user ID type

Output

JSON

  • code - Response status code (0 indicates success)
  • msg - Response message (e.g., 'success')
  • data
    • items - Array of record objects, each containing record_id and fields
    • has_more - Boolean indicating if more records are available for pagination
    • page_token - Token for fetching the next page of results (if any)
    • total - Total number of records returned

Dependencies

  • Requires HTTP requests to VanAnTravel API endpoints with tenant access token and app token for authentication.

Troubleshooting

  • Ensure that the tenant access token and app token are correctly provided and valid; authentication errors will occur otherwise.
  • Invalid JSON in filter values or custom filter expressions may cause API errors; verify syntax carefully.
  • If 'Return All' is true and there are many records, the operation may take longer due to pagination.
  • API rate limits or network issues may cause request failures; handle errors and consider retry logic.

Links

Discussion