Teamleader Empty items_price_per_unit field in V1Flat.SubscriptionItemsAll

I am connecting from Power BI to Invantive Bridge Cloud via OData4. I am syncing multiple tables including V1Flat.SubscriptionItemsAll (there isn’t a V2 table that contains line items (nor custom fields)) but the field items_price_per_unit is “null” for all rows despite subscriptions having data in what this field should be.

Power BI query editor:

Teamleader screenshot:

Where’s the bug? Is there a plan to make a V2 table? With custom fields and line items?

It has been a few months since this post. Any updates?

Starting release 23.0.75, the V2-tables include subscription grouped lines, subscription lines and subscription custom fields.

This release is scheduled for availability on Invantive Cloud in the course of this week.

It is recommended to switch to the V2-tables.

1 like

This question was automatically closed after at least 2 weeks of inactivity after a possible solution was provided. The last answer given has been marked as a solution.

Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.

Dit topic is 7 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.