My company will start using the new project module of Teamleader Focus. Currently we use the V2Flat.ProjectsAll table from invantive to load the project data into power bi. How will this new project module affect the connection and the data we retrieve from Teamleader Focus through power bi?
Teamleader Projects V2 is totally separate from Teamleader Projects V1.
It is highly recommended to check beforehand that the Projects V2-tables contain the needed data. It is not uncommon that large parts of the Teamleader APIs do not support Projects V2 to the same extent as Projects V1 (not feature complete).
See also (Dutch):
We already use the V2Flat.ProjectsAll table, not the older V1 table. Is the new project module of teamleader in line with the V2Flat.ProjectsAll table. Or does it require a switch to the V2.Projects Table?
V2Flat and V2 refer to the API v2 of Teamleader Focus, which has no relationship in any way with Projects V2. The first one is an API specification, the latter a new module.
It is required to use the ProjectsV2 and similar named tables to access the Teamleader Focus Projects V2 data such as on
So if I understand correctly:
- We currently use the legacy projects module and will transfer to projects V2: Projects | Teamleader Developers
- This means that we would need to start using the ProjectsV2 (ProjectsV2: Teamleader Focus Projects) table from Invantive, instead of the V2Flat.ProjectsAll.
I would have some follow up questions then:
- Are IDs preserved across the old and new project modules?
- Are custom fields already available through the Invantive connection?
- Are there any known improvements in speed of data import through invantive with this new table?
Regarding your questions:
- The primary source for migration questions would be Teamleader itself, but according to our knowledge the modules are largely independent of each other in terms of data storage.
- Custom fields: to our knowledge, these are not yet available. Teamleader Support can inform you when they plan to have the new Projects V2 feature complete compared to Projects V1.
- Performance improvements: none known.
Thanks for your reply. One follow up question:
We checked with Teamleader Focus, and according to them the custom fields are retrievable through the v2/projects.list endpoint by using:
{"includes": "custom_fields" }
Can we expect from Invantive for this to be included in the V2.ProjectsV2 table or not?
The includes on the ProjectsV2 backing API has been found as documented on:
https://developer.focus.teamleader.eu/docs/api/nextgen-projects-list
We did not manage to find this addition on the Teamleader change log. An analyse will study whether this functionality is present, and if so, add it to the ProjectsV2 table to allow further reductions in number of API calls.
Apologies for the confusion.
It seems the table ProjectsV2 already contains the custom fields in the latest release. It is recommended to test the functionality using a Teamleader test set.
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.
Dit topic is 3 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.