JSON
format.JSON
input supports bulk creation, allowing multiple records to be added simultaneously in a single action.
Parameter | Description |
---|---|
Table | The name of the table. |
Record | Data of record, enter the field name and field value. |
Parameter | Description |
---|---|
Table | The name of the table. |
Create or Update Condition | Set the condition for deciding weather to create or update the selected record. |
Record Data Format | Entire Record |
Record | The value of the record you want to create or update |
Use Case Example: Ensuring Accurate Privileged User Access Tracking
Use Case Example: Tracking Failed Login Attempts for Users
Action | Behavior | Key Difference |
---|---|---|
Add Record | When you need to insert new data without checking for existing records | Adds records without checking for duplicates |
Create or Update Record | When you want to prevent duplicates or update existing records based on specific conditions | Checks for a matching record before adding; updates if found, adds if not |
Text
, Numbers
, Users
, Time
) as unique in the table. This ensures that each entry in a specific column is distinct, preventing duplicate values. For more details, visit this guide.Tip: When to Use Each Query Method
AccessLevel = "Administrator"
to audit privileged accounts.$gte
, $lte
, $contains_any
, or $like
.condition
. All records that match the condition will be returned.Parameter | Description |
---|---|
Query Method | By Condition- The query method to get records |
Table | The table you want to get records from. |
Fields | Table Fields. |
Condition | Condition that compares two table field values. |
Output Format | The format of the output the records are returned- Table, JSON or CSV . |
Limit (optional) | Limit the amount of records returned by the query. |
Offset (optional) | Choose the offset from the data to start querying the table from. |
Order By (optional) | Choose what field to order the results by. |
Sort (optional) | Sort the records by ascending or descending order. |
Include Query Metadata In Output (optional) | Check the box to include Query Metadata in the Output. |
All Pages (optional) | Check the box to return all data in the table(this setting invalidates the Limit and Offset fields.) |
Use Case Example: Get Table Records According to a Specified Condition.
ID
or by setting a condition to delete multiple records that meet certain criteria. This ensures precise control over data removal while preventing accidental deletions.
Record ID
.Parameter | Description |
---|---|
Table Name | The name of the table. |
Record ID | The record unique identifier. Can be obtained via the Select action. |
Parameter | Description |
---|---|
Table Name | The name of the table. |
Table Schema | The schema of the table in JSON format.For more information, see the Copy table schema. |
Skip if Exists | Skips table creation if a table with the same name already exists. |
Learn how to Copy a Table's Schema
Click Here to View the Whole Table Schema
Does Table Exist
Action before the Create Table step.Parameter | Description |
---|---|
Table Name | The name of the table. |
Search By | Search by name , display name or both. Default is display name . |
Use Case Example: Creating a Table Only If Table Name Doesn’t Already Exist
Parameter | Description |
---|---|
Table Name | The name of the table. |
Parameter | Description |
---|---|
Table Name | The name of the table. |