CRM Template I can't get data from a list

[dperuzzo]

Hello !

I created an integration model for my own CRM.
I am not able to get data from a list for PhoneBusiness

How can I set this?

 

[Evolute IT]

Hello !

I created an integration model for my own CRM.
I am not able to get data from a list for PhoneBusiness

How can I set this?

View attachment 17483
View attachment 17485

Result.ListFone[0]

You need to specify the index. You cannot match a variable to an array of numbers.

 

[dperuzzo]

I tried that. It also didn't work.

 

[dperuzzo]

someone ?

 

[edossantos]

The only way is filtering the record. If you can change the web server response, then this is an example of how you should generate the response:

"phones": [
{
"number": "79692284200",
"type": "work"
},
{
"number": "89692284201",
"type": "mobile"
}
]

As you can see, each item in the array specifies the phone type. Then you can use the filters as follows in the XML template when defining the variables:

<Variable Name="PhoneBusiness" Path="customers.phones.number">
<Filter>
<Rule Type="Equals" Ethalon="work">customers.phones.type</Rule>
</Filter>
</Variable>
<Variable Name="PhoneMobile" Path="customers.phones.number">
<Filter>
<Rule Type="Equals" Ethalon="mobile">customers.phones.type</Rule>
</Filter>
</Variable>

 

[dperuzzo]

I have no way to change the CRM response.
Is there any other way to obtain this information?

 

[edossantos]

What you can do is defining an Output with the number being searched, this way the returned record will be considered a match. For example:
<Output Type="PhoneBusiness" Value="[Number]"/>

However, please note that if the contact has other phones, they will not be added to the 3CX Contact when more than 1 phone is returned in the array.