- Overview
- Act! 365
- ActiveCampaign
- Adobe Acrobat Sign
- Adobe PDF Services
- Amazon Bedrock
- Amazon Connect
- Amazon Polly
- 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
- Freshbooks
- Freshdesk
- Freshservice
- GetResponse
- GitHub
- Google Maps
- Google Speech-to-Text
- 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
- iContact
- Insightly CRM
- Intercom
- Jira
- Release notes
- About the Jira activity package
- Project compatibility
- Create Issue
- Add Issue Attachment
- Download Issue Attachment
- Get Instance Details
- Add Comment
- Get Comments
- Get Issue
- Search Issues by JQL
- Update Issue
- Update Issue Assignee
- Find User by Email Address or Display Name
- Update Issue Status
- Delete Record
- Get Record
- Insert Record
- List All Records
- Replace Record
- Upsert Record
- Invoke Operation
- Delete Issue
- Event Trigger
- Keap
- Klaviyo
- LinkedIn
- Mailchimp
- Mailjet
- 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
- Create Online Teams Meeting
- 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
- Get Online Teams Meeting
- List All Recordings
- List All Transcripts
- Download Meeting Transcript/Recording
- List All Records
- Insert Record
- Update Record
- Get Record
- Delete Record
- Technical references
- 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
- PagerDuty
- Paypal
- PDFMonkey
- Pinecone
- Pipedrive
- QuickBooks Online
- Quip
- Salesforce
- Release Notes
- About the Salesforce activity package
- Project Compatibility
- Create Account
- Update Account
- Create Contact
- Update Contact
- Create Lead
- Update Lead
- Create Opportunity
- Upload File
- Download File
- Search Records
- Get Opportunity
- Get Lead
- Get Contact
- Get Account
- Add File to Record
- Create Bulk Upload Job
- Get Bulk Job Info
- Starts or Aborts Bulk Job
- Download SOQL Bulk Job Results
- Download Unprocessed Records of Bulk Upload
- Create Bulk Download Job Using SOQL
- Search Using String
- Get Object Fields
- Insert Record
- Get Record
- Delete Record
- Update Record
- List All Records
- Salesforce Marketing Cloud
- SAP BAPI - 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
- Release Notes
- About the Slack activity package
- Project compatibility
- Create Channel
- Invite Users to Channel
- Remove User from Channel
- Send File to Channel
- Send Message to Channel
- Send Message to User
- Send Reply
- Send Button Response
- Create User Group
- Get User
- List All User Groups
- List All Users
- Set Channel Topic
- Join Channel
- Archive Channel
- Create Group Direct Message
- Get Channel Info
- Button Clicked
- Troubleshooting
- 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
- IBM WatsonX
- WhatsApp Business
- WooCommerce
- Workable
- Workday
- Workday REST - Preview
- X (formerly Twitter)
- Xero
- Release notes
- About the Xero activity package
- Project compatibility
- Create Contact
- List All Contacts
- Add Attachment to Contact
- Get Balance Sheet Report
- Get BAS Report
- Get GST Report
- Get Bank Summary Report
- Get Aged Receivables by Contact Report
- Get Attachments of a Contact
- Get Budget Summary Report
- Get Profit and Loss Report
- Get Trial Balance Report
- Get Executive Summary Report
- Get Aged Payables by Contact Report
- List Reports
- Delete Record
- List All Records
- Get Record
- Insert Record
- Replace Record
- Youtube
- Zendesk
- Zoho Campaigns
- Zoho Desk
- Zoho Mail
- Zoom
- ZoomInfo
List All Records
UiPath.SapConcur.IntegrationService.Activities.ListAllRecords
- Connection - The connection established in Integration Service. Access the dropdown menu to choose, add, or manage connections. This
field supports strings or
String
variables. - Select object - Select an object from the dropdown menu and configure the listed properties. The supported objects for this activity are:
- Attendee types
- Expense entries
- Expense group configurations
- Reports - For more information on using the Reports object, see List All Records for the Reports Object.
The List All Records activity retrieves reports with configurable filters and a record limit that you define.
You can use the filter builder or the Where field to filter results retrieved directly from Concur.
The following fields are available options when using the filter builder:
Filter property | Usage |
---|---|
Approval status code | The status code for the Approval Status of the report. The values can include Concur Expense standard codes or custom codes.
You can pass any of the Concur Expense standard codes for this:
|
Approver login ID | The login ID for the report approver that is the current approver assigned to the report. |
Country code | Static enumerable values that defines the report country. Example: United States is US .
|
Created date | The report create date is either (before or equals), or (after or equals) entered date. |
Currency code | Static enumerable values that defines the report currency code. Example: United States is USD .
|
Last modified date | The latest modified date of the report. It is either <= (before or equal) or >= (after or equal) the entered date.
|
Paid date | The report paid date is either <= (before or equal) or >= (after or equal) the entered date.
|
Payment status code |
Static enumerable values that defines the status of the payment.
|
Processing payment date | The date that the report completed all approvals and was ready to be extracted for payment. It is either <= (before or equal) or >= (after or equals) the entered date.
|
Submitted date | The submit date of the report is either <= (before or equal) or >= (after or equals) the entered date.
|
User defined date | The user defined date is either <= (before or equal) or >= (after or equals) the entered date.
|
Advanced users who want to build their own queries can use the Where clause. This requires following the API documentation.
A_APPR
. To do this:
- See the parameter names from SAP Concur Developer Center | Reports v3.
- Copy the
approvalStatusCode
and the code,A_APPR
in this case. - In the List All Records activity, in the Where field, click the Plus button menu to select Set using an Expression, and enter:
"approvalStatusCode='
.A_APPR
'"
""
.
Using other additional parameters
Filter Property | Usage |
---|---|
Attendee type code | The report contains expense entries that have attendees of the specified type and can be fetched using combination of List all records and Attendee type object. |
Vendor name | The Vendor Description that is the vendor for at least one expense entry in the report. |
Entry transaction date after | The entry transaction date for at least one expense entry in the report is after this date. Accepted formats: yyyy-MM-dd or yyyy-MM-ddTHH:mm:ss.SSS .
|
Entry transaction date before | The entry transaction date for at least one expense entry in the report is before this date. Accepted formats: yyyy-MM-dd or yyyy-MM-ddTHH:mm:ss.SSS .
|
Expense group config ID | The unique identifier for the expense group configuration associated to the report’s expense group. Use the ID from the output of the List All Records with Expense group configurations. |
Expense type code | The expense type code that is the expense type for at least one expense entry in the report. Use ExpenseTypeCode from the output of List All Records with Expense group configurations. |
Has attendees | Determines if the report has at least one expense entry with an attendee. Boolean value. |
Has billable expenses | The IsBillable flag for at least one expense entry in the report. Boolean value.
|
Has images | Determines if the report has at least one expense entry with an entry image or if there is a report image for this report. Boolean value. |
Has vat | Determines if the report has at least one expense entry with VAT details. Boolean value. |
Is test user | The report owner is a test user using the report for testing purposes in a non-production environment. Boolean value. |
Payment type | The unique identifier for the payment type that is the payment type for at least one expense entry in the report. Use PaymentTypeID from the output of List All Records with Expense group configurations to obtain valid payment types. |
User | Provide the email address of the user who create or raised the report. If not provided, it will return the reports of the authenticated user.You must have Web Service Admin role to use this parameter for another user. |
Concur supports a maximum of 20 custom fields for its accounts.
To deduce the value coming from a custom field, the Display name and Value of custom fields are exposed as separate properties, so that you can understand what Custom 1 field represents in the Concur UI and what its value might be, if you want to use it further down in your automation.