# Query Multiple Entity Records

> Sends a request to the Data Fabric API to query records from a primary entity, with optional expansion to a secondary entity via a field-level filter.

## Description

Sends a request to the Data Fabric API to query records from a primary entity, with optional expansion to a secondary entity via a field-level filter.

This activity is equivalent to the activity of the same name in the Data Service classic activities package.

## Project compatibility

Windows | Cross-platform

## Supported workflows

All workflows in Studio Desktop and Studio Web.

## Properties

* **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.