Help Needed: Custom Field Mapping in Teamleader CRM Integration

How To
,
1

I’m working on a Teamleader CRM integration in Make.com and facing an issue with mapping custom fields. Here’s the situation:

  1. I’m trying to extract a specific custom field value from a Teamleader CRM item.
  2. The custom fields are presented as an array, and I can’t directly select specific custom field IDs.
  3. I’ve set up a Tools module with a Set Variable operation to extract the specific value of the corresponding field/ID
  4. I then want to output the value of the custom ID field to a Word node so I can populate a template with that value

I have tried if, select and map functions but cannot get it to work (one example down below).
image

Here is the array that I can use:
image

Looking forward to your ideas or feedback
Julian from Germany

2

Hi @Julian_K; first off, ' is not required for if statement because they don’t exist in the output array example.

If you are able to iterate the Custom fields, then you can filter on the ID and grab the value more easily.

Next, since the ID is buried in an array, that the value is outside of, I don’t think map will work. However, I’ve not tested such. Yet, have you had much luck with map’s documentation, especially the helper content at the end?

1 Like
3

Hi @Julian_K,

Custom fields in Teamleader’s API are always Array’s. You can access a value of a custom field based on the ID with the map() function as such:

copy-paste:
{{get(map(9.custom_fields; "value"; "definition.id"; "99e0db7b-d480-0194-a65c-d93b4ce67ca4"); 1)}}

This will look in the custom fields array and grab the value where the id is ‘99e0db7b-d480-0194-a65c-d93b4ce67ca4’. Because the map() function returns a new array, you use the get() function to get the value and return a string.

Also, if you were to update custom fields in Teamleader via a naked API call be aware of the following:

Collections are replaced entirely during updates, so all the wanted values should be provided when updating entities. >> Teamleader API Documentation

Cheers,
Henk
Official Make partner & Official Teamleader partner

5 Likes
4

Thank you very much, works flawlessly!

1 Like