Search

Insert Bulk data into inline Jiffy table

Articles

Use this function to insert multiple rows into the inline table of Jiffy Table.

Syntax

Insert Bulk data into a inline Jiffy table (Jiffy_table_name, Column_name, Values, UUID)

Parameters

Input Parameter Name Description
Jiffy_table_name Data Table Variable
Column_name Column Names
Values Values to be inserted in to the table (Table Type Variable )
UUID UUID of the row in the parent table

  • The Inline Table name is given as ParentTable.InlineTable
  • The Jiffy table name and Columns names provided must match with the names in the Dataset and are case sensitive.
  • Both data and column names must be comma-separated.

Returns

Return value Description
UUID Returns UUID of each row of the inserted data as a table type variable(SingleColTable)

The table type variable of UUID returned must be assigned to a SingleColsTable variable

Sample

Insert Bulk data into a inline Jiffy table (Customer.FamilyDetails, Name, Relationship, ParentDetails, 5fba170c58e0a754f2a19050)

  • Inserts ‘ParentDetails’ into the ‘Name’ and ‘Relationship’ Columns in the ‘Customer.FamilyDetails’ inline table for the record having the UUID(5fba170c58e0a754f2a19050) in the parent table and returns UUID of the rows inserted in Inline Table

To view all the Table functions, click here.

Did you find what you were looking for?