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
I need to download all my expenses every day for internal reporting and forecasting.
With the following url I can make an API call and get all the data:
/api/v3.0/expense/entries?limit=70&user=ALL
I don't want to download thousands of records every day. So, how can I make an incremental download for all the data created after the last download?
it should be something like this: /api/v3.0/expense/entries?limit=70&user=ALL&filter=lastmodifieddate[gt]2023-11-20
Thanks in advance.
Solved! Go to Solution.
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
Since I can download all the reports and I can use this filter for future downloads. I can use this approach to get the list of new reports and download the items for each of them. Thank you very much for your help.
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
@jmontoya did you ever get this figured out? If not, let me know. I have someone I can ask about APIs.
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
No, not yet. There has to be a way to filter the data. I don't see any other way to do an incremental download if I can't add some kind of filtering. Your help is appreciated.
Thanks
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
SAP Concur Developer Center | Reports v3
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
I am able to get all the report's entries with the following URL:
/api/v3.0/expense/entries?reportID=xxxxxxxxxx&limit=100&user=ALL
Thanks
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
Since I can download all the reports and I can use this filter for future downloads. I can use this approach to get the list of new reports and download the items for each of them. Thank you very much for your help.
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
Exactly what I am doing. I find this API very unintuitive to use. Feels like I have to run 5 calls just to get all of the information needed for one invoice.
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 , I tried the same only full load can work.
If we need to get the entries data , allocation , itemizations its not possible. as in reports api we cannot go for filter. in entries we cannot filter on any specific date. and getting the complete data from the api everyday is not possible. So i am not sure what sort of solution you are refering. can you explain.