Overview
This node integrates with the VanAnTravel API to manage records in a table within an application. It supports creating, retrieving, updating, and deleting records. The node is useful for automating data management tasks in applications that use the VanAnTravel platform, such as syncing data from other sources or managing records programmatically. For example, it can create new records with dynamic field mapping or raw JSON data, retrieve specific records by ID, update existing records, or delete records.
Use Case Examples
- Create a new record in a table by mapping fields dynamically from input data.
- Retrieve a specific record by its ID to use its data in subsequent workflow steps.
- Update a record with new values, either by mapping fields or sending raw JSON data.
- Delete a record by specifying its record ID.
Properties
| Name | Meaning |
|---|---|
| Tenant Access Token | The tenant access token for authentication (starts with t-). Required for API access. |
| App Token | The app token for the application (starts with app). Required to identify the app. |
| Table ID | The ID of the table (starts with tbl) where the record operations will be performed. |
| Kind Type Records | Determines how to handle the record data: either dynamically map fields from the table or send raw JSON data. |
| Field Mappings | Used when 'Kind Type Records' is set to dynamic mapping. Allows mapping of table fields to specific values with optional type overrides. |
| Fields | Used when 'Kind Type Records' is set to send raw data. JSON object representing the fields of the record to create or update. |
Output
JSON
code- Response status code from the API, typically 0 for success.msg- Response message from the API, e.g., 'success' or error message.dataitems
* ``
*record_id- The unique identifier of the record created or retrieved.
*fields- The fields and their values of the record.
*deleted- Boolean flag indicating if the record was deleted (only for delete operation).has_more- Indicates if there are more records available when retrieving multiple records.page_token- Token for pagination to fetch the next set of records.total- Total number of records returned in a getAll operation.
Dependencies
- Requires HTTP access to VanAnTravel API endpoints.
- Requires tenant access token and app token for authentication.
Troubleshooting
- Invalid JSON in 'Fields' parameter will cause an error; ensure JSON is well-formed.
- Missing or incorrect tenant access token or app token will result in authentication errors; verify credentials.
- Field names in mappings must match those in the table; use the auto-loaded options to avoid mismatches.
- API errors are caught and reported; enabling 'Continue On Fail' allows workflow to proceed despite errors.
Links
- VanAnTravel API Documentation - Official API documentation for managing tables and records.