- Overview
- Act! 365
- ActiveCampaign
- Adobe Acrobat Sign
- Adobe PDF Services
- Amazon Bedrock
- Amazon Connect
- Amazon Polly
- Amazon SageMaker - Preview
- Amazon SES
- Amazon Transcribe
- Anthropic Claude
- Asana
- AWeber
- Azure AI Document Intelligence
- Azure Maps
- BambooHR
- Box
- Release notes
- About the Box activity package
- Project compatibility
- Add Shared Link to File
- Add Shared Link to Folder
- Search for Content
- Cancel Sign Request
- List Sign Requests
- Create Sign Request
- Resend Sign Request
- Copy File
- Delete File
- Download File
- Get File Info
- Get Folder Items
- Upload File
- Copy Folder
- Create Folder
- Delete Folder
- Delete Record
- Get Record
- Insert Record
- Replace Record
- List All Records
- Brevo
- Calendly
- Campaign Monitor
- Cisco Webex Teams
- Citrix ShareFile
- Clearbit
- Confluence Cloud
- Constant Contact
- Coupa
- Customer.io
- Datadog
- Deputy
- Discord - Preview
- DocuSign
- Drip
- Dropbox
- Dropbox Business
- Egnyte
- Epic FHIR R4 - Preview
- Eventbrite
- Exchangerates
- Expensify
- Facebook
- Freshservice
- Freshbooks
- Freshdesk
- GetResponse
- GitHub
- Google Maps
- Google Speech-to-Text - Preview
- Google Text-to-Speech
- Google Vertex
- Google Vision - Preview
- GoToWebinar
- Release Notes
- About the GoToWebinar activity package
- Project Compatibility
- Delete Webinar
- Get Webinar
- Get Webinar Meeting Times
- Get Webinar Registrant
- Get Webinar Start URL
- List Account Webinars
- List All In Session Webinars
- List All Webinar Attendees
- List All Webinar Registrants
- List All Webinars
- Quick Create Webinar
- Quick Update Webinar
- Search Recording Assets
- Delete Record
- Get Record
- Insert Record
- List All Records
- List Records
- API References
- Greenhouse
- Hootsuite
- HTTP Webhook
- Hubspot CRM
- HubSpot Marketing
- IBM WatsonX
- iContact
- Insightly CRM
- Intercom
- Jira
- Keap
- Klaviyo
- LinkedIn
- Mailchimp
- MailerLite
- Mailgun
- Marketo
- Microsoft Azure OpenAI
- Microsoft Dynamics CRM
- Microsoft Sentiment
- Microsoft Teams
- Release Notes
- About the Microsoft Teams activity package
- Project compatibility
- Create Channel
- Invite Member to Channel
- List All Channels
- Send Individual Chat Message
- Reply to Channel Message
- Send Channel Message
- Send Group Chat Message
- Get Channel by Name
- Get Individual Chat
- Get Team by Name
- Invite User to Team
- List All Channel Messages
- List All Chat Messages
- List All Team Members
- List All Records
- Insert Record
- Update Record
- Get Record
- Delete Record
- Microsoft Translator
- Microsoft Vision
- Miro
- Okta
- OpenAI
- Oracle Eloqua
- Oracle NetSuite
- Release Notes
- About the Oracle NetSuite activity package
- Project Compatibility
- Delete Record
- Get Record
- Insert Record
- List All Records
- Update Record
- Create Basic Company Customer
- Create Basic Company Vendor
- Create Basic Contact
- Create Basic Individual Customer
- Create Basic Individual Vendor
- Create Basic Support Case
- Update Basic Company Customer
- Update Basic Company Vendor
- Update Basic Contact
- Update Basic Individual Customer
- Update Basic Individual Vendor
- Update Basic Support Case
- Customer Created
- Customer Updated
- Record Created
- Record Updated
- Support Case Raised
- Support Case Updated
- Vendor Created
- Vendor Updated
- Paypal
- PDFMonkey
- Pinecone
- QuickBooks Online
- Quip
- Salesforce
- Salesforce Marketing Cloud
- Release Notes
- About the Salesforce Marketing Cloud activity package
- Project Compatibility
- Salesforce Marketing Cloud Scope
- Invoke Operation
- Delete Record
- Get Record
- Insert Record
- Update Record
- List Records
- List All Records
- Create Campaign
- Delete Campaign
- Get Campaign
- List All Campaigns
- Create Contact
- Delete Contact
- List All Contacts
- Update Contact
- Create Journey (Basic)
- Delete Journey
- Get Journey
- List All Journeys
- Update Journey
- Create List (Basic)
- Delete List
- Get List
- List All Lists
- Update List
- SAP Build Process Automation - Preview
- SAP Cloud for Customer
- SAP Concur
- SendGrid
- ServiceNow
- Release Notes
- About the ServiceNow activity package
- Project Compatibility
- Troubleshooting
- Create New Incident
- Create Incident Task
- List All Incidents
- Update Incident
- Add Attachment
- Download Attachment
- Get Incident Task
- Get Attachment
- List All Attachments
- List All Incident Tasks
- Update Incident Task
- When an Event Happens
- Delete Attachment
- Delete Record
- Get Record
- Insert Record
- List All Records
- Update Record
- Incident Created
- Incident Updated
- Incident Task Created
- Incident Task Updated
- Record Created
- Record Updated
- Shopify
- Slack - Preview
- About the Slack activity package
- Project Compatibility
- Create Channel
- Invite Users to Channel
- List All Channels
- Remove User from Channel
- Get File Info
- Send File to Channel
- Send Message to Channel
- Send Message to User
- Send Reply
- Send Button Response
- Add or Replace Users of User Group
- Create User Group
- Get User by Email
- List All User Groups
- List All Users
- Set Channel Topic
- Join Channel
- Archive Channel
- Create Group Direct Message
- Get Channel Info
- Button Clicked
- SmartRecruiters
- Smartsheet
- Release notes
- About the Smartsheet activity package
- Project compatibility
- Attach URL to Sheet
- Add Column
- Update Column
- Add Row
- Update Row
- Get Sheet
- List All Sheets
- Attach File to Comment
- Search Everything
- Update Sheet
- Create Sheet from Template
- Send Sheet Via Email
- List All Folders
- Download Attachment
- Attach File to Row
- Attach URL to Row
- Attach File to Sheet
- List All Workspaces
- List All Attachments
- Delete Row
- Download Sheet
- Search Sheets
- Insert Record
- Get Record
- List All Records
- Delete Record
- Snowflake
- Stripe
- Sugar Enterprise
- Sugar Professional
- Sugar Sell
- Sugar Serve
- TangoCard
- Todoist
- Trello
- Twilio
- UiPath GenAI Activities - Preview
- X (formerly Twitter)
- WooCommerce
- Workable
- Workday
- Youtube
- Zendesk
- Zoho Campaigns
- Zoho Desk
- Zoho Mail
- Zoom
- ZoomInfo
List All Records
-
Connection ID - The connection established in Integration Service. Access the drop-down menu to choose, add, or manage connections.
-
Select object - Select an object to use with this activity. Depending on the object chosen in this field, the activity is populated with property fields specific to that object.
Manage Properties
Use the Manage Properties wizard to configure or use any of the object's standard or custom fields. You can select fields to add them to the activity canvas. The added standard or custom fields are available in the Properties panel (in Studio Desktop) or under Show additional options (in Studio Web).
Additional options
Output
An output property is automatically generated based on the selected object.
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 |