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

Questions
, , ,
1

Connecting from Power Bi 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:

image
image1570×290 45.5 KB

Teamleader.V2Flat.CompaniesAll:

image
image1163×339 35 KB

2

In de volgende release 24.0.307 zullen de volgende tabellen toegevoegd zijn voor Teamleader Focus om dit probleem op te lossen:

  • view ContactAddresses,
  • view CompanyAddresses,
  • tabelfunctie ContactAddressesByContactId,
  • tabelfunctie CompanyAddressesByContactId.

Zie voor beschikbaar ook Releasefrequentie Invantive Cloud.

3

This question was automatically closed after at least 1 week 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.

4

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