This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
Hi All,
I am trying to pull expenses report from concur using azure data factory for submitted and not submitted report.
Can anybody help me to get exact API which should pull not submitted column should be as below same as for submitted report. What is would be the API for this.
currently I am using
Expense Type |
Employee |
Sent for Payment Date |
Report Name |
Transaction Date |
Payment Type |
Vendor |
City/Location |
Employee Org Unit 4 - Name |
Employee Org Unit 4 - Code |
Country (of Employee) |
Reimbursement Currency |
Transaction Currency |
Entry Expense Amount (reimbursement currency) |
Approved Amount (rpt) |
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
Hi @GIRITTH ,
I don't have much knowledge about this but just have basic understanding of API's.
Can you check below API:
https://developer.concur.com/api-explorer/v3-0/Reports.html
As per my understanding you can get reports with different different statuses using below API. I have highlighted code for Not submitted and submitted status.
Also, would suggesting using only 1 user for testing purpose, if it works then you can think of all users as I could see you have mentioned /api/v3.0/expense/entries?limit=100&user=ALL
possible that API needs exact user or employee id as per Concur to get report details. So, try with only 1 user and check if it works.
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
Thanks for the response.
I have used this(
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
Hi @GIRITTH ,
You can take any test profile from Concur where there are Not submitted and submitted expense reports. Take a help from someone who has Concur Admin access and can provide you this info or test profiles.
After that, you check how many reports are not submitted and how many are submitted in that employee's profile.
Use that Concur test profile employee ID (as per maintained in Concur employee profile) and then try to pass same employee ID in your API and try to get result.
While passing parameters, first check on which date those reports are created or submitted. Same date range or date you try to pass it in API.
Also, as highlighted in red color, can you try passing 1 employee ID instead of ALL. Just give it a try. I am not sure whether it will work or not as I don't have much knowledge of it.
/api/v3.0/expense/reports?limit=15&approvalStatusCode=A_NOTF&user=ALL&submitDateAfter=2024-01-01)