Dear Eric,
I'm really not fan of grabbing the data directly in the database instead of via the API, but if the data are not present and I nedd to expose them to my customers, I have no other way.
We are actually doing a list of all what is missing with the current API. We can share it with you if you are interested.
Best regards
Artionet.Group - Digital Transformation, eGovernment Solutions