I use the Exact Online database through your cloud.
The thing is, I’m missing some Project HourTypes. If I use another connector I get more hourtypes (also the ones which have a end date in the past).
Is there another table for these hourtypes? Or can I do something else to get that data as well?
The table HourTypes is based on the hour types-API of Exact Online. The additional columns such as start date and cost price are available through the Items-table by filtering on the value of the column IsTime. The value of IsTime should match 1.
Recommended item-tables for reporting purposes are in decreasing order of recommendation:
ItemsIncrementalItemsBulkExactOnlineREST..ItemsExactOnlineXML..ItemsYou are my hero sir
You are welcome!