Forums | Back to Concur Developer Center

Get expense Itemization in bulk


#1

Hi,

I’m using the Expense API to get all expense reports for visualizing in Qlik Sense.

Is there a way of getting the itemizations without having to make one request per report ID.

Now I first fetch all reports using this
https://www.concursolutions.com/api/v3.0/expense/reports?user=ALL

(this is pretty fast)

Then I need to loop over the report IDs and fetch the itemizations for one report at a time with
https://www.concursolutions.com/api/expense/expensereport/v2.0/report/{reportId}

(This is very slow)

I found this (https://www.concursolutions.com/api/v3.0/expense/itemizations?limit=10&user=ALL), but its deprecated and I can’t get it to work so hopefully there is a better new solution for this?

Best
Robert


#2

Did you ever get this figured out, running into similar situation. @roberthj


#3

Hello - there is nothing available outside of doing the succession described above.

  • Get a List of reports that match desired search parameter(s)

  • One-by-one, make an API call for the Details of each unique report Id returned.