Ragic icon

Ragic

Ragic: #1 No Code database builder

Ragic

AI-generated

Overview

This node integrates with Ragic, a no-code database builder, allowing users to perform various actions on Ragic forms and records. It supports reading multiple or single records, creating new records, updating existing records, retrieving files, and executing action buttons on records. This node is useful for automating database operations, managing records, and handling files within Ragic from an n8n workflow.

Use Case Examples

  1. Reading multiple records from a Ragic form with filters and limits.
  2. Creating a new record in a Ragic form using JSON or field mode input.
  3. Updating an existing record by specifying the record index and fields to update.
  4. Retrieving a file stored in a Ragic record, with optional user authentication for download security.

Properties

Name Meaning
Action Specifies the operation to perform on Ragic, such as reading data, creating or updating records, retrieving files, or executing action buttons.
Method Selects the input method for creating or updating records, either JSON mode or field mode.
Form The Ragic form to operate on, selectable from forms where the user is an admin.
Record Index The index of the record to read, update, or execute an action button on, found in the record URL.
Do Formula Whether to recalculate all formulas when creating or updating a record, disabling workflow scripts to avoid loops.
Run Link & Load Before Formula Whether to execute Link & Load fields before formula evaluation when creating or updating records.
JSON Body The JSON data to send when creating or updating records in JSON mode.
Entries Field entries for creating or updating records in field mode, including field name, content type (text or file), and value.
Subtable Entries Entries for subtable fields when creating or updating records in field mode, including subtable record node ID, field, content type, and value.
Show Subtables Whether to include subtable data in the response when reading data.
Ignore Masked Whether to show unmasked values for masked text fields when reading data.
Limit Maximum number of records to return when reading multiple records.
Filters Filter conditions to apply when reading multiple records, specifying field, operand, and value.
Other Parameters Additional parameters to include in the API request when reading data.
File Download With User Authentication Whether to use user authentication for file download, based on company settings.
Account Name Account name where the file is stored, used when not using user authentication for file download.
File Record Url Record URL where the file is uploaded, used when file download with user authentication is enabled.
File Name Name of the file to retrieve, as returned from a previous read data action.
Action Button The ID of the action button to execute on a record.

Output

Binary

Binary data of a retrieved file, named by the file's original name or 'downloadedFile'.

JSON

  • json - The JSON response from Ragic API for the requested action, including records data or action results.
  • binary - Binary file data when retrieving a file, keyed by the file name.
  • pairedItem
    • item - Index of the input item that corresponds to the output item, for data pairing in workflows.

Dependencies

  • Ragic API with API key authentication

Troubleshooting

  • Ensure the API key credential is correctly configured and has access to the specified Ragic forms.
  • Verify the form ID and record index are correct and accessible by the user.
  • When using field mode, ensure field names and subtable fields are valid and correctly specified.
  • For file retrieval, confirm the file name matches exactly as returned by the read data action.
  • If 'Do Formula' is enabled, be aware that workflow scripts on the sheet will not run to avoid infinite loops.
  • Large limits on reading data may cause timeouts; reduce the limit if requests fail or time out.

Links

Discussion