activities
latest
false
Workflow activities
- Overview
- App Events
- Flowchart Builder
- Callout
- Complex Scenarios
- Credentials
- UiPath Data Fabric
- Form
- Release notes
- Project compatibility
- Real Time Forms
- Updating form data
- Running forms using JavaScript
- Customizing Forms Using CSS
- Conditional components
- Adding multiple components on the same row in Columns
- Using the Data Table component
- Get File/Folder path
- Reading cell values from a Data Grid component
- Displaying PDF files
- Displaying images in forms
- Scrolling through Data Grids
- Using Dev Tools with forms
- Calculate form component values
- Managing dates in forms
- Opening hyperlinks inside forms
- Displaying a default tab in forms
- Displaying the full label of a component
- Searching long strings in drop-down lists
- Dynamically set form values
- About the pre 23.4 Form experience
- Project Compatibility
- Real Time Forms
- Dynamic Checkboxes
- Conditional Dropdowns
- Displaying a Default Tab
- Displaying Images
- Displaying PDF Files
- Displaying the Full Label
- Dynamic HTML Elements
- Managing Dates
- Searching Long Strings in Drop-downs
- Customizing Forms Using Local CSS Files
- Executing Do Block On Checkbox Change
- Customizing Columns Width
- Updating Form Data
- Resetting Collection Data
- Advanced Logic
- Executing Do Block on Dropdown Option Change
- Reading Cell Values From a Data Grid Component
- Conditional Components
- Scrolling Through Data Grid Components
- Using the Grid Component
- Dev Tools
- Calculated Value
- Dynamic Dropdowns
- Switching Tabs With Button Click
- Opening Hyperlinks Inside Form
- FTP
- IPC
- Automation Ops Pipelines
- Release notes
- About the Pipelines activity package
- Project compatibility
- Activate Solution Deployment
- Analyze
- Build
- Clone
- Delete Solution Package
- Deploy Solution
- Download Package
- Download Solution Package
- Download Solution Package Configuration
- Publish Package
- Publish Solution Package
- Re-sync Solution Project
- Run Existing Test Set
- Run Tests
- Stage
- Uninstall Solution
- Update Process
- Upload Solution Package
- Persistence
- Release notes
- Project compatibility
- Bulk Form Designer
- Start Job And Get Reference
- Wait For Job And Resume
- Add Queue Item And Get Reference
- Wait For Queue Item And Resume
- Wait For Form Task And Resume
- Resume After Delay
- Assign Tasks
- Create External Task
- Wait For External Task And Resume
- Complete Task
- Forward Task
- Get Form Tasks
- Get Task Data
- Get App Tasks
- Add Task Comment
- Update Task Labels
- Create App Task
- Wait For App Task And Resume
- Configure task timer
- Working with App tasks
- Building Your First Form Action
- Advanced Controls for Drop-downs
- Embedding Objects in Form Actions
- Allowing Users to Upload Files to the Storage Bucket
- Adding Advanced Logic Using Java Script
- Setting a Default Tab
- Removing the Delete button from Edit Grid using custom CSS
- Customizing Edit Grid templates
- Using buttons to trigger custom logic
- Using an External Form Layout
- Dynamically expanding form components at runtime
- Aligning the content of a form component from left to right using JSON attributes
- Sample Workflows
- System
- Release notes
- Project compatibility
- Supported character encoding
- RegEx Builder Wizard
- Add Data Column
- Add Data Row
- Add Log Fields
- Add or Subtract from Date
- Add Transaction Item
- Add Queue Item
- Append Item to Collection
- Append Item to List
- Append Line
- Beep
- Break / Exit Loop
- Browse for File
- Browse for Folder
- Build Collection
- Build Data Table
- Bulk Add Queue Items
- Change Case for Text
- Change Type
- Check False
- Check True
- Clear Data Table
- Collection to Data Table
- Comment
- Compress/Zip Files
- Copy File
- Copy Folder
- Combine text
- Comment Out / Disabled Activities
- Continue / Skip Current
- Create File
- Create Folder
- Create List
- Custom Input
- Delete
- Delete File
- Delete Folder
- Delete Storage File
- Delete Queue Items
- Disable Local Trigger
- Do While
- Download file from URL
- Download Storage File
- Enable Local Trigger
- Evaluate Business Rule
- Exists in Collection
- Extract/Unzip Files
- Extract Date and Time from Text
- Extract Text
- File Change Trigger
- File Exists
- Filter Collection
- Filter Data Table
- Folder Exists
- For Each
- For Each File in Folder
- File Change Trigger V3
- Find and Replace
- Find Matching Patterns
- For Each Folder in Folder
- For Each Row in Data Table
- Format Date as Text
- Format Value
- Generate Data Table From Text
- Get Asset
- Get Credential / Get Orchestrator Credential
- Get Current Job Info
- Get Environment Folder
- Get Environment Variable
- Get File Info
- Get Folder Info
- Get Jobs
- Get Processes
- Get Row Item
- Get Secret
- Get Transaction Item
- Get Username/Password
- Get Queue Items
- Global Variable Changed Trigger
- Input Dialog
- Invoke Code
- Invoke Com Method
- Invoke Power Shell
- Invoke Process
- Invoke VBScript
- Invoke Workflow File
- Is Text Matching
- Join Data Tables
- Kill Process
- Launch Workflow Interactive
- List Storage Files
- Log Message
- Lookup Data Table
- Manual Trigger
- Merge Collections
- Merge Data Table
- Message Box
- Modify Date
- Modify Text
- Move File
- Move Folder
- Multiple Assign
- New Item Added to Queue
- Notify Global Variable Changed
- Orchestrator HTTP Request
- Output Data Table
- Parallel
- Parallel for each
- Path Exists
- Postpone Transaction Item
- Process End Trigger
- Process Start Trigger
- Process Tracking Scope
- Raise Alert
- Read List Item
- Read Text File
- Read Storage Text
- Remove Data Column
- Remove Data Row
- Remove Duplicate Rows
- Remove From Collection
- Remove Log Fields
- Replace Matching Patterns
- Repeat Number of Times
- Repeat Trigger
- Rename File
- Rename Folder
- Report Status
- Reset Timer
- Resume Timer
- Retry Scope
- Return
- Run Local Triggers
- Run Agent
- Run Job
- Run Parallel Process
- Set Asset
- Send Email Notification
- Set Credential
- Set Environment Variable
- Set Secret
- Set Task Status
- Set Trace Status
- Set Transaction Progress
- Set Transaction Status
- Should Stop
- Split Text
- Sort Data Table
- Start Timer
- Start Job
- Stop Job
- Stop Local Triggers
- Stop Timer
- Text to Left/Right
- Text to Upper/Lowercase
- Time Trigger
- Trigger Scope
- Track Object
- Timeout Scope
- Update Row Item
- Update List Item
- Upload Storage File
- Wait for Download
- Wait Queue Item
- While
- Workflow Placeholder
- Write Storage Text
- Write Text File
- AddDataRow
- AddQueueItem
- AddTransactionItem
- AppendLine
- BulkAddQueueItems
- ClearDataTable
- CompressZipFiles
- CopyFile
- CreateFile
- CreateFolder
- DeleteFileOrFolder
- DeleteQueueItems
- DeleteStorageFile
- DownloadStorageFile
- ExtractUnzipFiles
- FilterDataTable
- GetAsset
- GetCredential
- GetJobs
- GetQueueItem
- GetQueueItems
- GetResourceForLocalPath
- GetRowItem
- GetTransactionItem
- InvokeProcess
- JoinDataTables
- ListStorageFiles
- LookUpDataTable
- MergeDataTable
- MoveFile
- OrchestratorHTTPRequest
- OutputDataTable
- PathExists
- PostponeTransactionItem
- ReadStorageText
- ReadTextFile
- RemoveDataColumn
- RemoveDuplicateRows
- Replace
- SetAsset
- SetCredential
- SetTransactionProgress
- SetTransactionStatus
- SortDataTable
- StartJob
- StopJob
- UpdateRowItem
- UploadStorageFile
- WaitQueueItem
- WriteStorageText
- WriteTextFile
- Testing
- Release notes
- About the Testing activity package
- Project compatibility
- Project Settings
- Add Test Data Queue Item
- Attach Document
- Bulk Add Test Data Queue Items
- Create Comparison Rule
- Compare PDF Documents
- Compare Text
- Delete Test Data Queue Items
- Generate Address
- Generate Given Name
- Generate Last Name
- Generate Random Date
- Generate Random Number
- Generate Random String
- Generate Random Value
- Get Test Data Queue Item
- Get Test Data Queue Items
- Verify Control Attribute
- Verify Expression
- Verify Expression With Operator
- Verify Range
- Address
- AddTestDataQueueItem
- AttachDocument
- BulkAddTestDataQueueItems
- DeleteTestDataQueueItems
- GetTestDataQueueItem
- GetTestDataQueueItems
- GivenName
- LastName
- RandomDate
- RandomNumber
- RandomString
- RandomValue
- VerifyAreEqual
- VerifyAreNotEqual
- VerifyContains
- VerifyExpression
- VerifyExpressionWithOperator
- VerifyIsGreater
- VerifyIsGreaterOrEqual
- VerifyIsLess
- VerifyIsLessOrEqual
- VerifyIsRegexMatch
- VerifyRange
- Workflow Foundation
Retrieves a list of records for the selected entity from UiPath Data Fabric, according to specified filters.
Description
Retrieves a list of records for the selected entity from UiPath Data Fabric, according to specified filters.
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 except RPA (neither Studio Desktop, nor 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.
- Entity - Select an entity to use with this activity. This dropdown menu includes your Data Fabric entities. Depending on the object chosen in this field, the activity is populated with property fields specific to that object. This field supports
TypeArgumentforImportedEntitiestype input.- If you Switch to object view, you must provide a single consolidated object with the value of every field in it.
- Query - Using the filter builder, add a query to filter entity records
The Filter Builder provides a set of operators that you can use to filter records based on the values of entity fields. The operators available for a field depend on its data type.
The following table describes each supported operator and the data types it applies to.
For the In and Not In operators, enter values as a comma-separated list. For example, to return only records where the text field productName in the Product entity is Computer or Laptop, enter Computer,Laptop.
| Operator | Description | Applicable data types |
|---|---|---|
| Equals (=) | Matches records where the field value is exactly equal to the specified value. | Text, Number, Yes/No, Date-Time, ChoiceSet |
| Not Equals (!=) | Matches records where the field value is not equal to the specified value. | Text, Number, Yes/No, Date-Time, ChoiceSet |
| Less Than (<) | Matches records where the field value is less than the specified value. For date fields, this returns records with an earlier date or time. | Number, Date-Time |
| Less Than Or Equal (<=) | Matches records where the field value is less than or equal to the specified value. | Number, Date-Time |
| Greater Than (>) | Matches records where the field value is greater than the specified value. For date fields, this returns records with a later date or time. | Number, Date-Time |
| Greater Than Or Equal (>=) | Matches records where the field value is greater than or equal to the specified value. | Number, Date-Time |
| Contains | Matches records where the field value contains the specified text as a substring. | Text |
| Not Contains | Matches records where the field value does not contain the specified text. | Text |
| Starts With | Matches records where the field value begins with the specified text. | Text |
| Ends With | Matches records where the field value ends with the specified text. | Text |
| In | Matches records where the field value is equal to any value in a specified list. | Text, Number, Date-Time, ChoiceSet |
| Not In | Matches records where the field value is not equal to any value in the specified list. | Text, Number, Date-Time, ChoiceSet |
| Is Null | Matches records where the field value is null. This operator does not require an input value. | Text, Number, Yes/No, Date-Time, ChoiceSet |
| Is Not Null | Matches records where the field contains a non-null value. This operator does not require an input value. | Text, Number, Yes/No, Date-Time, ChoiceSet |
| Is True | Matches records where a Yes/No field is True. This operator does not require an input value. | Yes/No |
| Is False | Matches records where a Yes/No field is False. This operator does not require an input value. | Yes/No |
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.
- Related Record depth - Specify the depth of related records in the response from the service. Range: 1-3. Default: 3.
Output
- Query Entity Records — Returns a list of records from the selected entity that match the provided filter. Each record includes all fields the caller has access to.