- Overview
- About the Integration Service Activities
- Configure Connection Wizard
- Using the WHERE property in LIST activities
- 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
Using the WHERE property in LIST activities
-
Add a Scope activity to your project and click on the Configure button. Your connection should be detected automatically. Click the Save button.
-
Add a List activity inside the Scope and click the Configure button.
-
Select the Object from the drop-down menu.
Each object displays different properties, but in most situations you will encounter some common ones, such as the Object name, the Where expression or Fields selection. Below you can find some of the generic properties you may find in List activities.
- Dir - Choose one of the available options for this field: ascending or descending.
- Id - The ID of the object.
- Fields - The fields to return on the response. Can be a single field or a comma-separated list of fields.
- Order_by - The manner in which the objects will be ordered.
- Page Token - Taken from the next page token of the previous page.
- PageSize - The number of resources to return in a given page.
- Where - The CEQL search expression, or customize the
where clause, without the
WHERE
keyword, in a typical SQL query. - Max Records - Encountered in List All Records activities. It defines the maximum number of records to return.
- Next Page Token - Encountered in List Records activities. It represents the token for the next page of records. Use this token to iterate through pages until an empty list is returned.
Where
property, or the CEQL search expression, provides a standard way to search across our connectors. It is a portion of a typical
activity that can include a number of properties.
Where
property specifies what to search and what objects to return in our result set. It is made up of a left hand side (LHS),
an operator and a right hand side (RHS). Scroll down to see a list of Valid CEQL Operators.
Where
property:
- AND -
TRUE
if all the conditions separated areTRUE
- OR -
TRUE
if any of the conditions separated areTRUE
- = - 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 aNULL
value is found - LIMIT - Limit the number of records to the specified number