I’m working on a Teamleader CRM integration in Make.com and facing an issue with mapping custom fields. Here’s the situation:
- I’m trying to extract a specific custom field value from a Teamleader CRM item.
- The custom fields are presented as an array, and I can’t directly select specific custom field IDs.
- I’ve set up a Tools module with a Set Variable operation to extract the specific value of the corresponding field/ID
- 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).
Here is the array that I can use:
Looking forward to your ideas or feedback
Julian from Germany
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
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
4 Likes
Thank you very much, works flawlessly!
1 Like