Integration Service Activities

Last updated Feb 19, 2026

Search Records

Project compatibility

Windows | Cross-platform

Overview

Description	API Method	API Path
Search one or more records of a standard or custom Salesforce object (for example, Lead or Opportunity) using filter criteria.	GET	/searchRecords

Input

Parameter	Description	Data Type
Select object	API name of the Salesforce object to search (standard or custom). Depending on the object chosen in this field, the activity is populated with property fields specific to that object.	string
Where	Add a filter using the Filter builder or type an SOQL WHERE expression. For example, `LastModifiedDate >= '2014-10-12'`	string
Fields	Comma-separated list of fields to return in the response	string
Include deleted	Indicates whether deleted records should be included in the search results	boolean
Nulls last	Indicates whether records with null values should be sorted last	boolean
Order by	Comma-separated list of fields to sort the results by	string
Max records	Maximum number of records to return in a single response	int32
Return total count	Indicates whether the total number of matching records should be returned	integer

Output

Parameter	Description	Data Type
Response	Search results containing the matching Salesforce records and metadata	Object

Note:

In API workflows, a single response object is returned as the output. Any required fields can be extracted directly from this object.
In RPA workflows, some output parameters may differ, but the necessary values can still be retrieved from the response object even if they are not explicitly exposed.

Using the query

The CEQL (“Where” filter) provides a standard way to search across all the connectors. Many API providers support some form of searching in their APIs but each one approaches searching differently. Rather than having you research how to query each resource at a provider, we've normalized your search experience. It translates your queries to the API provider's search syntax. You compose queries with available query connectors field selection. Each connector allows different components of the query, but in most situations you can use some common parts.

Query Reference

Query Component	Syntax	Example	Description
CEQL query the "where" expression	`1<field><operator><value> <AND/OR> 2<field><operator><value> 3...`	Department!='Procurement' AND Name='John'	The expression or expressions specifying what to search and what objects to return in our result set. Refer Valid CEQL Operators section below. This is made up of a left hand side (LHS), an operator and a right hand side (RHS).

Valid CEQL Operators

Operator	Descriptions
AND	TRUE if all the conditions separated by AND is TRUE
OR	TRUE if any of the conditions separated by OR is TRUE
=	Equal to
!=	Not equal to
<	Less than
>	Greater than
<=	Less than or equal to
>=	Greater than or equal to
LIKE	TRUE if the operand matches a pattern
IN	TRUE if the operand is equal to one of a list of expressions
IS NULL	TRUE if a NULL value is found
LIMIT	Limit the number of records to the specified number

Examples

Operator	Example
Equal Operator (=)	`Name='Edge Communications'`
AND Operator	`Name=’Account Name’ AND Industry=’Electronics’`
OR and Greater Than (>) Operators	`LastModifiedDate>'2018-01-15T00:00:00.000Z' AND (Name='Account Name' OR Industry='Apparel')`
LIKE Operator	`Name LIKE 'Acc%'`
Greater Than or Equal To (>=) Operator	`AnnualRevenue >= 100000`

On this page

Project compatibility
Overview
Input
Output
Using the query

Was this page helpful?

PREVIOUSDownload File

NEXTSearch Using SOQL

Support and Services

Get The Help You Need

UiPath Academy

Learning RPA - Automation Courses

UiPath Forum

UiPath Community Forum

Trust and Security

Cookies Policy