Teamleader API custom fields

[forums]

Some suggestions.

Auto-complete Tickets

TicketMessages is slow, since it consumes 1 API call per ticket for which messages are retrieved.

As an alternative, you might want to study using Invantive UniversalSQL to retrieve the creator from the message for all new tickets (which is a small daily set) and then update the ticket accordingly to include that creator.

Custom Fields on Tickets

As far as known, the Tickets has yet the custom fields not retrieved in a performant way. When added by Teamleader, they will become available automatically as described in:

Huge performance improvement Teamleader Focus custom fields for Contacts, Companies and Deals

Go to Dutch version Performance Gains Teamleader Focus traditionally required one API call per row to retrieve the custom field values using a table function. For ease of use, views such as ContactsAll are available in the V1Flat and V2Flat schema that retrieve both base data as well as custom field values. However, the throughput is extremely slow, peaking at 200 rows per minute. Teamleader has considerably improved the performance of custom field value retrieval for the following V2 tables …

The custom field values can be retrieved at the cost of 1 API-call per ticket using V2Flat.TicketsAll.