Need help in understanding the Expense API V4 usage

[yvathumilli]

HI All,

I am currently exploring the Expense V4 API to retrieve all the details of a particular Expense report and present it to my end users in a different format. I logged in to our test tenant and was able to create client credentials, company token to be able to test these APIs. However I have 2 questions for which I was unable to find answers myself over the documentation and other sources:
1. I know that the depreceated V2 API used to give all the data relevant for an expense report in one go with just one API call. But now in V4 we need to call a bunch of endpoints just to gather information for one single expense report. I am currently working on a tool which has to query all the open expense reports and gather all its relevant information periodically. This now leads to too many API calls for each expense reports. Can anyone suggest a better/alternate approach if any ?
2. In the Expense V4 API I keep seeing endpoints for same information e.g., allocations, attendees... always in 2 flavors, one with specifying a user id and context type and another without that. However I am unable to get the latter one working. This is forcing me to always retrieve the User ID in order to call any of these Expense APIs. Can anyone give me a hint to what I am missing here and how I can make use of the APIs without the user id and context type? Does this require a special user with specific permissions to create the client id, secret, company token to make it work??

Sorry for the lengthy post. Highly appreciate any piece of relevant information. 

Thanks in advance.

[KevinD]

@yvathumilli hello there. If you are a site admin at your company, I would recommend you request to join the Admin Group here on the Community and post your question there. The reason being, the product forums here on Community are more trafficked by end users and not those who would deal with APIs. You are less likely to get a response to your question in this forum.

However, the Admin Group members are all site admins and those who are more likely to have worked with APIs. They are much more suited to get you a response.

[Mass]

Hi @yvathumilli 

We found the same issue from Expense v1 to Expense v4, way too many calls.

Also, Expense v4 doesn't hold the VAT breakdown we need which was available in v1.

We heard about FISAPI v4 which looked good but doesn't hold any mileage data!

We are now exploring a combination of Expense v4 to grab most of the data and then a call to FIS API v4 to retrieve the VAT data.

Thanks
Mass