We are using the V2Flat.InvoiceLinesAll of Teamleader intensively. There are 2000 invoices in the largest Teamleader environment with in total 18000 invoice lines. Retrieval takes approximately 80 minutes with a lot of problems with Power BI Service trying over and over.
However, we only need the invoices not older between 13 and 24 months. This set is solely 1500 invoice lines.
A filter on invoice_date
is not always added correctly by Power BI, but is present already often due to Power BI query folding.
The V2 Teamleader Invoices
associated API invoices.list
used by the view InvoiceLinesAll
has - somewhat cumbersome - parameters for start and end date of the invoice, see:
https://developer.teamleader.eu/#/reference/invoicing/invoices/invoices.list
It would significantly improve performance when a larger than filter on invoice_date
would be forwarded to Teamleader APIs also.