I am using Kommo and I just need to get email from this structure.
I have checked all the topics but I was not manage to figure it out.
Can anyone help me on that?
Many thanks.
Hi @Gokhan
created a sample json structure:
you can use the following to get the email:
output:
If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel
Unfortunately it does not work. I need to filter out the Email from the collections. But this does not work.
The JSON Structure is as follows.
[
{
“object”: [
{
“field_id”: 2345512,
“field_name”: “Database Name”,
“field_code”: null,
“field_type”: “text”,
“values”: [
{
“value”: “Gokhan Ucar_Test”
}
]
},
{
“field_id”: 2345514,
“field_name”: “Country”,
“field_code”: null,
“field_type”: “text”,
“values”: [
{
“value”: “Turkey”
}
]
},
{
“field_id”: 2252722,
“field_name”: “Email”,
“field_code”: “EMAIL”,
“field_type”: “multitext”,
“values”: [
{
“value”: “gokhanuc@gmail.com”,
“enum_id”: 1602250,
“enum_code”: “PRIV”
}
]
},
{
“field_id”: 2252720,
“field_name”: “Phone”,
“field_code”: “PHONE”,
“field_type”: “multitext”,
“values”: [
{
“value”: “+905337209541”,
“enum_id”: 1602244,
“enum_code”: “HOME”
}
]
}
]
}
]
Hi @Gokhan
we have tried with the structure provided
work flow:
iterator:
text aggregator:
Output:
To get all the values as an array you can use array aggregator instead of text aggregator