Teamleader Empty primary_address_* fields in Teamleader.V2Flat.CompaniesAll but not Teamleader.V2.Companies

Connecting from PowerBi via ODATA 4 to Invantive Cloud Bridge to obtain Teamleader data.

The fields in table Teamleader.V2Flat.CompaniesAll related to the primary_address_* are empty (“null”) despite the information being present in Teamleader and most of them in Teamleader.V2.Companies.

Where is the bug?

Fields concerned:

  • primary_address_country → Missing in Teamleader.V2Flat.CompaniesAll only
  • primary_address_city → Missing in Teamleader.V2Flat.CompaniesAll only
  • primary_address_postal_code → Missing in Teamleader.V2Flat.CompaniesAll only
  • primary_address_line1 → Missing in both

Teamleader.V2.Companies:

Teamleader.V2Flat.CompaniesAll:

Thanks in advance
Ed