To Fetch all concur expense reports that are pending for approval via API for complete organisation

[sanyam57685]

 It there a way we can fetch all the expense reports with their details that are pending for approvals across the organisation via API over which we can filter bases on different parameters. Currently in v4 it supports to fetch for a particular user not at company level that does not fits our use case. Any help will be useful to me

[PoojaKumatkar]

Hi @sanyam57685 ,

Technically it is not feasible to achieve this because:

• SAP Concur v4 APIs do not support fetching all pending approval reports at the organization level
• Approval data is scoped to individual users/approvers, not available centrally
• A possible workaround is to loop through each approver via API and combine results, but this is inefficient
• The recommended approach is to use Concur Extracts (Expense Report Extract) or Reporting tools (Cognos) for full organization visibility

In short: There is no single API endpoint to retrieve all pending approvals across the organization

If this answers your query, then please mark solution as accepted.

[sanyam57685]

The solution suggested can be used one time or whenver needed like a month or so but for our usecase we need to get the data on regular basis like every 3 hours or so. Any solution that is feasible please let me know

[cjmarimo]

Hello @sanyam57685 

• You could use v3.0 to retrieve all the reports: https://{{dataCenterURI}}/api/v3.0/expense/reports?user=ALL&approvalStatus=PENDING
• Then, within the JSON, filter by the desired field, for example “OrgUnit..”
• Then use v4.0 to retrieve the expense entries for each report.

https://community.sap.com/t5/enterprise-resource-planning-blog-posts-by-sap/web-services-for-concur-...

BR,

cj

[PoojaKumatkar]

Hi @cjmarimo ,

Thanks for sharing the SAP Community link. The post and API indicate that it is indeed possible to fetch all reports pending for approval using the API. Earlier, my understanding was that without specifying a particular user ID or approver ID, it wouldn’t be possible to retrieve other pending reports.

@sanyam57685 - If you plan to explore and try the suggested steps or process, could you please update us here in the community on the outcome and whether it worked? This will help clarify our understanding of this requirement.

Additionally, if you encounter any challenges during implementation, it would be helpful if you could briefly share how you resolved them. This can assist other community members facing similar requirements in troubleshooting their issues. 😌

[cjmarimo]

Hi @PoojaKumatkar 

You can add more parameters: approverLoginID, user, ...

SAP Concur Developer Center | Reports v3

BR,

cj