Logo
For example "scheduled tasks"
Search
Info
Content
Category Navigation
  • 🔧  Pipes

  • Tadabase Functions

    Text Pipes

    Time Conversion

    Mask and Disguise

    Advanced Date Pipes

    Unit Conversion

    Mortgage Calculator Pipe

    Barcode Generator

    QR Code Generator

    Number Utility Pipe

    Search and Replace

    Tadabase Domain Utilities

    Base64 File Converter

    3rd Party Pipes

    Shopify

    Pipedrive Pipe

    Plaid Pipe

    Vehicle VIN Decoder

    OpenAI Pipe

    Freshdesk Pipe

    Toggl Track Pipe

    FedEx Pipe

    MySQL Pipe

    Letter Stream Pipe

    Microsoft OneDrive Pipe

    Klaviyo Pipe

    TaxJar Pipe

    QuickBooks Pipe

    Google Sheets Pipe

    Tadabase Rest API Pipes

    Vertical Lookup Pipe

    Connection Field Plucker Pipe

    Record Looper Pipe (Legacy)

    Generate CSV Pipe

Categories
🔧 Pipes
Tadabase Rest API Pipes
Record Looper Pipe (Le...

Record Looper Pipe (Legacy)

Tadabase Support is unavailable for this pipe. View the documentation below and see the video tutorial for guidance.

Example Use Case: If a customer add an item to their order, and sets the quantity to five (i.e., 5 headphones), you can generate 5 identical connected records in your order items table. 

Global Parameters

Once you have the Pipe installed, add your API credentials, which can be found in your app settings, into the Global Parameters tab. 

All API calls below must contain the authorization details in the global parameters. 

This pipe is configurable, and you will likely need to edit the Request to match your table structure. 

API Calls

This pipe contains a single API call:

  • Create Multiple Identical Records

 

Create Multiple Identical Records

Parameters

  • Number of Records* - Enter the number of records you would like to create. 
  • Table ID* - Enter the ID of the Table you would like create multiple records in. When you Trigger the Pipe from a Table Rule, Record Rule, etc., you can select the current Table ID as a parameter. See below for how to find the Table ID manually. 
Finding the Table ID:

To find the Table ID manually for testing purposes, navigate to the Table, and check the URL. The ID in the URL path between 'dataTables' and 'records' is your Table ID. In the example below, the Table ID of the Order Items table is eykNOvrDY3.

 

  • Field Slug 1* - Enter the Slug of the first Field you would like to set. (Ex: Order - "field_46")
Finding the Field Slug:

Navigate to the Table, open up the field and check the last part of the URL for the field Slug. See the image below. In the example below, the Field Slug of the Order field in the Order Items table is field_46.

Cool Tip: You can also get the Field Slug in a Table Rule/Action Rule/Record Rule by setting the Field Slug parameter to a Record Value of the field and then switching Record Value to Pipe Value.

  • Field Value 1* - Enter the desired value for the first Field you specified above. (In the example above, setting the Field Value 1 to the Order Record ID of "4MXQJdrZ6v" will set the Order ID connection field to "1001")

Note: When setting the value of a connection/join field, you must set it to the Record ID of the connected record. See here for instructions of how to find the Record ID.

  • Field Slug 2* - Enter the Slug of the second Field you would like to set. (Ex: Product ID - "field_47") See above for how to find the Field Slug.
  • Field Value 2* - Enter the desired value for the first Field you specified above. (In the example above, setting the Field Value 2 to the Product Record ID of "DVWQWRNZ49" will set the Product connection field to "1")

Note: When setting the value of a connection/join field, you must set it to the Record ID of the connected record. See here for instructions of how to find the Record ID.

  • Field Slug 3* - Enter the Slug of the third Field you would like to set. (Ex: Quantity - "field_49") See above for how to find the Field Slug.
  • Field Value 3* - Enter the desired value for the third Field you specified above. (In the example above, setting the Field Value 3 to "1" will set the Quantity field to 1)
 

Test Example:

In the example below, 3 records have been created in the Order Items table with the Order ID (connection field) set to 1001, the Product (connection field) set to "Airpods", and the Quantity (number field) set to 1. 

 

Record Rule Example: 

In the example below, each time an Order Item is created with a quantity greater than 1, it will Trigger the Create Multiple Identical Records API call and set the Order ID (field_46) to the connected order's Record ID, the Product (field_47) to the connected Product's Record ID, and the Quantity (field_49) to a custom value of 1. The Table ID is set to current record's (Table ID), and the Number of Records is set to the Quantity of the Item. After the pipe is triggered, the current record is soft deleted by setting all the record values to blank values and the Pipe Response field to a pipe value of "Message".

Note: Pipes are only be triggered if you Set the Record Value to be updated to a Pipe Value. 

 
Finding the Record ID:

There are 3 different ways to find the Record ID:

  • Via Pipe Parameter: In Record Rules/Table Rules/Action Rules, you can set a parameter to a Record Value of (Record ID). However, you cannot get the (Record ID) of a connected record, so this only works if you want to get the Record ID of the current record. 
  • Via Table Rule: Create a Record ID (Text) field in the Data Table, and create a Table Rule (each time a record is created) to update the Record ID (Text) field to the Record Value of (Record ID). 

  • Check the Record URL:  In the Data Builder section, navigate to the table where the record is located. Find the record you would like to get the ID for, and click the double arrows to edit the record. When you are on the Edit Record page, check the URL path. The ID after records is the Record ID. In the example below, the Airpods record in the products table has a Record ID of DVWQWRNZ49.

How did we do ?

Previous Article
Connection Field Plucker Pipe
Next Article
Generate CSV Pipe
Article Navigation
  • Global Parameters
  • API Calls
  • Create Multiple Identical Records
  • Parameters
  • Finding the Table ID:
  • Finding the Field Slug:
  • Test Example:
  • Record Rule Example:
  • Finding the Record ID:
  • Back to top
    Developer portal Tadabase Community
    API
    100% Operational
    Apps
    100% Operational
    Builder
    100% Operational
    Overall Status
    100% Operational