The Time Entries option in the Business Intelligence API, export the data in a not so easy to use format.
The Time Entries report shows this data differently
The BI API output is the raw data format, and the Time Entries report output is a transformation of the data to better viewing. Can i request that the BI API output match that of the report?
David,
Thanks for your idea, this is something we will consider going forward. The first screenshot is obviously how the table has been designed in the database. For the time entries report we simply pivot the data. Your change would thus mean the BI API would not simply be access to the underlying tables, but to pivoted views of this.
I'm not sure if you know but you are able to access report data using the standard API, information available here:
https://support.ppolive.com/hc/en-us/articles/209874893-PPO-Integration-API-Fact-Sheet
