Workflow activities

• UiPath Data Fabric connection - Select the Data Fabric connection you established in Integration Service. Access the dropdown menu to select, add, or manage connections.
• Primary entity - Specify the main entity from which records are retrieved.
• Secondary entity - Specify the related entity to join with the primary entity.
• Join type - Define the type of join performed between the primary and secondary entities.
  • Inner Join - Select to return only records where matching values exist in both entities.
  • Left Join - Select to return all records from the primary entity and matching records from the secondary entity. If no match exists, secondary fields return null.
• Primary entity join field - Specify the field from the primary entity used to establish the join relationship.
• Secondary entity join field - Specify the field from the secondary entity used to establish the join relationship.
• Filter conditions - Define filtering criteria for records from the primary and/or secondary entity.

Options​

• Skip - Specify the number of records to skip from the start.
• Top - Specify number of records to return at most. The property supports values from 1 to 1000. The default value is 100.
• Sort ascending - Specify whether to sort in ascending (true) or descending (false) order.
• Sort by field - Specify the field used to sort the returned records.

Output​

• Query Multiple Entity Records — Returns a list of records produced by joining the two selected entities and applying the provided filter. Each record contains all fields the caller has access to across both entities.