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

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.