Actions6
Record → Create Records
AI-generatedOverview
This node allows you to create new records in a specified table within the Teable platform, which is a database service with a spreadsheet-like interface. It is useful when you want to programmatically add data entries to your tables, for example, importing user information, logging events, or adding transactional data.
Typical use cases include:
- Automating data entry into a Teable table from other systems.
- Bulk creating multiple records at once by providing an array of record objects.
- Integrating form submissions or API data feeds directly into a Teable database.
Properties
| Name | Meaning |
|---|---|
| Table ID | The unique identifier of the target table where records will be created. Found in the table URL or API docs. |
| Records | One or more records to create. Each record consists of fields defined as a JSON object, e.g., {"Name": "John Doe", "Age": 30}. Multiple records can be added in one operation. |
| Additional Options | Optional settings affecting how fields are interpreted and processed: - Field Key Type: Choose how field keys are identified in the input JSON (by field name, field ID, or database field name). - Typecast: Whether to automatically convert field values to their appropriate types (e.g., strings to numbers). |
Output
The node outputs the response from the Teable API after attempting to create the records. The output JSON typically contains details about the newly created records, such as their assigned IDs and stored field values.
If binary data were involved (not indicated here), it would represent file attachments or similar content related to the records, but this node focuses on JSON record creation only.
Dependencies
- Requires an API key credential for authenticating with the Teable API.
- Needs the base URL of the Teable instance configured in credentials.
- The node sends HTTP requests to the Teable API endpoint to perform record creation.
Troubleshooting
- Invalid Table ID: If the provided Table ID is incorrect or does not exist, the API will return an error. Verify the Table ID from the Teable UI or API documentation.
- Malformed JSON in Fields: The "Fields" property expects valid JSON. Errors in JSON syntax will cause failures. Use proper JSON formatting.
- Field Key Type Mismatch: Ensure that the selected Field Key Type matches the keys used in your JSON fields. For example, if using field names, keys must correspond exactly to those names.
- Authentication Errors: Missing or invalid API credentials will prevent the node from connecting. Confirm that the API key and base URL are correctly set.
- Typecasting Issues: Enabling typecast may cause unexpected conversions; disable it if you encounter data type problems.
Links and References
- Teable API Documentation (hypothetical link)
- n8n Documentation on Creating Records (for general guidance on custom nodes)
This summary is based solely on static analysis of the provided source code and property definitions.