Integration to Zoho CRM

[francesco-vedica]

2021/04/01 08:47:09.247|16166|0018|Verb|CHR: Adding event: 2021-04-01 08:46:50.618|TargetAdded|000001788C2F41F8_113|a3b5165bda85/Target DN.3666858872/LineSet dn-name='' epname='Out'
>a3b5165bda85/Target DN.3666858872/LineSet dn-name='' epname='Out'
ep.dialing=3666858872
ep.originator.caller_num=
ep.originator.dial=3666858872
orig.dest=3666858872
orig.party.id=7b738b0c0587

2021/04/01 08:47:09.247|16166|0018|Verb|CHR: Adding event: 2021-04-01 08:46:50.619|RouteAdded|000001788C2F41F8_113|f936c60ad3d3/Route DN.10001/Line dn-name='' epname='3666858872@(Ln.10001@0459233260)'
>f936c60ad3d3/Route DN.10001/Line dn-name='' epname='3666858872@(Ln.10001@0459233260)'
ep.contact=sip:[email protected]:5061
ep.dialing=3666858872
ep.originator.caller_num=Vedica Cosmetics
ep.originator.dial=3666858872
ep.to=
target.party.id=a3b5165bda85
target.party.type=Target

2021/04/01 08:47:09.247|16166|0018|Verb|CHR: Adding event: 2021-04-01 08:46:50.619|RouteAdded|000001788C2F41F8_113|7bb9d97feb55/Route DN.10001/Line dn-name='' epname='3666858872@(Ln.10001@0459233260)'
>7bb9d97feb55/Route DN.10001/Line dn-name='' epname='3666858872@(Ln.10001@0459233260)'
ep.contact=sip:[email protected]:5061
ep.dialing=3666858872
ep.originator.caller_num=Vedica Cosmetics
ep.originator.dial=3666858872
ep.to=
target.party.id=a3b5165bda85
target.party.type=Target

2021/04/01 08:47:09.247|16166|0018|Verb|CHR: Adding event: 2021-04-01 08:46:50.619|RouteAdded|000001788C2F41F8_113|272ff8556a25/Route DN.10001/Line dn-name='' epname='3666858872@(Ln.10001@0459233260)'
>272ff8556a25/Route DN.10001/Line dn-name='' epname='3666858872@(Ln.10001@0459233260)'
ep.contact=sip:[email protected]:5061
ep.dialing=3666858872
ep.originator.caller_num=Vedica Cosmetics
ep.originator.dial=3666858872
ep.to=
target.party.id=a3b5165bda85
target.party.type=Target

2021/04/01 08:47:09.247|16166|0018|Verb|CHR: Adding event: 2021-04-01 08:46:50.619|RouteAdded|000001788C2F41F8_113|9deaf57bc55f/Route DN.10001/Line dn-name='' epname='3666858872@(Ln.10001@0459233260)'
>9deaf57bc55f/Route DN.10001/Line dn-name='' epname='3666858872@(Ln.10001@0459233260)'
ep.contact=sip:[email protected]:5061
ep.dialing=3666858872
ep.originator.caller_num=Vedica Cosmetics
ep.originator.dial=3666858872
ep.to=
target.party.id=a3b5165bda85
target.party.type=Target

2021/04/01 08:47:09.247|16166|0018|Verb|CHR: Adding event: 2021-04-01 08:46:50.624|RouteAdded|000001788C2F41F8_113|2a77fd032fad/Route DN.10000/Line dn-name='' epname='3666858872@(Ln.10000@0459233261)'
>2a77fd032fad/Route DN.10000/Line dn-name='' epname='3666858872@(Ln.10000@0459233261)'
ep.contact=sip:[email protected]
ep.dialing=3666858872
ep.originator.caller_num=Vedica
ep.originator.dial=3666858872
ep.to=
target.party.id=a3b5165bda85
target.party.type=Target

2021/04/01 08:47:09.247|16166|0018|Verb|CHR: Adding event: 2021-04-01 08:47:07.666|RouteConnected|000001788C2F41F8_113|f936c60ad3d3/Route DN.10001/Line dn-name='' epname='3666858872@(Ln.10001@0459233260)'
>f936c60ad3d3/Route DN.10001/Line dn-name='' epname='3666858872@(Ln.10001@0459233260)'
ep.contact=sip:[email protected]:5061
ep.dialing=3666858872
ep.disp_name=Francesco Facipieri
ep.originator.caller_num=Francesco - Vedica
ep.originator.dial=3666858872
ep.to=
orig.party.id=7b738b0c0587
target.party.id=a3b5165bda85
target.party.type=Target

2021/04/01 08:47:09.247|16166|0018|Verb|CHR: Adding event: 2021-04-01 08:47:08.712|PartyRemoved|000001788C2F41F8_113|f936c60ad3d3/None
>f936c60ad3d3/None

2021/04/01 08:47:09.247|16166|0018|Verb|CHR: Adding event: 2021-04-01 08:47:08.713|PartyRemoved|000001788C2F41F8_113|7b738b0c0587/None
>7b738b0c0587/None

2021/04/01 08:47:09.247|16166|0018|Verb|CHR: Adding event: 2021-04-01 08:47:09.246|Disconnected|000001788C2F41F8_113|Party.???
>Party.???
replaced_by.chid=

2021/04/01 08:47:09.248|16166|0018|Trac|CHR: Target has changed: Tgt a3b5165bda85{3666858872}[Ok/Unknown]
2021/04/01 08:47:09.248|16166|0018|Trac|CHR: Saving joined call:
2021/04/01 08:47:09.248|16166|0018|Trac|CHR: Executing SQL: INSERT into cl_calls (id,start_time,end_time,is_answered,ringing_dur,talking_dur)
VALUES (DEFAULT,'2021-04-01 06:46:50','2021-04-01 06:47:09',TRUE,'00:00:17.047967','00:00:01.046855')
RETURNING id
2021/04/01 08:47:09.249|16166|0046|Trac|CHR: * Participant 7b738b0c0587/Participant DN.10/Extension dn-name='Francesco Facipieri' epname='Ext.10'; answered at 4/1/2021 8:47:07 AM
2021/04/01 08:47:09.249|16166|0046|Trac|CHR: Executing SQL: INSERT into cl_party_info (id,dn_type,dn,caller_number,display_name,dn_class,firstlastname,did_number)
VALUES (DEFAULT,0,'10','Ext.10','Francesco Facipieri',0,'Francesco Facipieri','')
RETURNING id
2021/04/01 08:47:09.250|16166|0046|Trac|CHR: Executing SQL: INSERT into cl_participants (id,call_id,info_id,role,is_inbound,end_status,forward_reason,failure_reason,start_time,answer_time,end_time,billing_group)
VALUES (DEFAULT,320,900,1,TRUE,1,0,1,'2021-04-01 06:46:50','2021-04-01 06:47:07','2021-04-01 06:47:08','')
RETURNING id
2021/04/01 08:47:09.250|16166|0046|Trac|CHR: * Target a3b5165bda85/Target DN.3666858872/LineSet dn-name='3666858872' epname='3666858872'; originated by 7b738b0c0587
2021/04/01 08:47:09.250|16166|0046|Trac|CHR: Executing SQL: INSERT into cl_party_info (id,dn_type,dn,caller_number,display_name,dn_class,firstlastname,did_number)
VALUES (DEFAULT,13,'3666858872','3666858872','3666858872',0,'','')
RETURNING id
2021/04/01 08:47:09.250|16166|0046|Trac|CHR: Executing SQL: INSERT into cl_participants (id,call_id,info_id,role,is_inbound,end_status,forward_reason,failure_reason,start_time,end_time)
VALUES (DEFAULT,320,901,2,FALSE,0,0,1,'2021-04-01 06:46:50','2021-04-01 06:47:07')
RETURNING id
2021/04/01 08:47:09.251|16166|0046|Trac|CHR: * Participant f936c60ad3d3/Participant DN.10001/Line dn-name='3666858872' epname='3666858872'; answered at 4/1/2021 8:47:07 AM
2021/04/01 08:47:09.251|16166|0046|Trac|CHR: Executing SQL: INSERT into cl_party_info (id,dn_type,dn,caller_number,display_name,dn_class,firstlastname,did_number)
VALUES (DEFAULT,1,'10001','3666858872','3666858872',0,'','')
RETURNING id
2021/04/01 08:47:09.251|16166|0046|Trac|CHR: Executing SQL: INSERT into cl_participants (id,call_id,info_id,role,is_inbound,end_status,forward_reason,failure_reason,start_time,answer_time,end_time,billing_code,billing_ratename,billing_rate,billing_cost,billing_duration,billing_group)
VALUES (DEFAULT,320,902,1,FALSE,1,0,1,'2021-04-01 06:46:50','2021-04-01 06:47:07','2021-04-01 06:47:08','default','default','1','0.02','00:00:01.046855','')
RETURNING id
2021/04/01 08:47:09.252|16166|0046|Trac|CHR: Saving Pbx call 000001788C2F41F8_113
2021/04/01 08:47:09.252|16166|0046|Info|CHR: #1: Seg[1/#1] 7b738b0c0587(Ext.10)=>a3b5165bda85(3666858872) (08:46:50.618..08:47:07.666) Ringing Connected
2021/04/01 08:47:09.252|16166|0046|Trac|CHR: Executing SQL: INSERT into cl_segments (id,call_id,seq_order,seq_group,src_part_id,dst_part_id,start_time,end_time,type,action_id)
VALUES (DEFAULT,320,1,1,900,901,'2021-04-01 06:46:50','2021-04-01 06:47:07',1,1)
RETURNING id
2021/04/01 08:47:09.253|16166|0046|Info|CHR: #2: Seg[1/#2] 7b738b0c0587(Ext.10)=>f936c60ad3d3(3666858872) (08:47:07.666..08:47:08.712) Talking TerminatedByDst
2021/04/01 08:47:09.253|16166|0046|Trac|CHR: Executing SQL: INSERT into cl_segments (id,call_id,seq_order,seq_group,src_part_id,dst_part_id,start_time,end_time,type,action_id)
VALUES (DEFAULT,320,2,1,900,902,'2021-04-01 06:47:07','2021-04-01 06:47:08',2,6)
RETURNING id
2021/04/01 08:47:09.253|16166|0046|Trac|CHR: Executing SQL: INSERT into myphone_callhistory_v14 (idmpch14,call_id,calltype,dnowner,party_dn,party_dntype,party_name,party_callerid,start_time,established_time,end_time,end_status,end_status_hint)
VALUES (DEFAULT,320,3,'10','10001',128,'3666858872','3666858872','2021-04-01 06:46:50','2021-04-01 06:47:07','2021-04-01 06:47:08',0,0)
RETURNING idmpch14
2021/04/01 08:47:09.257|16166|0021|Info|CRM: about to report 1 calls at maxConcurrency 1
2021/04/01 08:47:09.257|16166|0021|Trac|Obtaining scenario entity order for entity 'Contacts'
2021/04/01 08:47:09.257|16166|0021|Trac|Obtained scenario entity order '1' for entity 'Contacts'
2021/04/01 08:47:09.257|16166|0021|Trac|Obtaining scenario entity order for entity 'Leads'
2021/04/01 08:47:09.257|16166|0021|Trac|Obtained scenario entity order '0' for entity 'Leads'
2021/04/01 08:47:09.257|16166|0021|Trac|Obtaining scenario entity order for entity 'Accounts'
2021/04/01 08:47:09.257|16166|0021|Trac|Obtained scenario entity order '2' for entity 'Accounts'
2021/04/01 08:47:09.257|16166|0021|Verb|Processing scenario 'Default'.
2021/04/01 08:47:09.257|16166|0021|Verb|Creating new HttpClient for Scenario authentication.
2021/04/01 08:47:09.257|16166|0021|Erro|Exception during number processing: System.ArgumentException: Only 'http' and 'https' schemes are allowed. (Parameter 'value')
at System.Net.Http.HttpRequestMessage.set_RequestUri(Uri value)
at CrmIntegration.ScenarioProcessorBase.ProcessRequest(ScenarioRequest request, IValueManager customManager, HttpClient client, CancellationToken token)
at CrmIntegration.ScenarioProcessorBase.ProcessScenario(ProtocolScenario scenario, IValueManager customManager, CancellationToken token)
at CrmIntegration.ScenarioProcessorBase.Execute(ProtocolScenario scenario, CancellationToken token)
at CrmIntegration.CrmProcessor.GetContactInfoFromCrm(String contactNumber, Boolean isInboundCall, String destinationEmail, Boolean createIfNotFound, CancellationToken token)
2021/04/01 08:47:09.258|16166|0021|Info|Call not reported because contact could not be found for number: 3666858872

 

[francesco-vedica]

I tried to write to zoho support and they replied the following:

Upon checking with our developer.
You would need to check with 3CX and ask for "Status Code" while making "Create Call" API request. If it is successful, As we will be sending the status code as. "201" or "202".
Along with the status. code, Please print the Exception Message and send that as well. (It will have errors like Mandatory not filled, Data type mismatch)

 

[edossantos]

The problem seems to be in the authorization. Are you selecting the normal account or the developer account when you press the Authorize button and you see the dialog from Zoho?

 

[francesco-vedica]

Thanks for the support, I have always selected the production account.
I haven't been able to solve the problem yet.

 

[edossantos]

Please do the authorization again from the 3CX Console > Settings > CRM Integration > Zoho > Authorize button. Ensure that you select your normal account, and NOT the developer account. Once you get a token back, click OK to save it in 3CX. Then make another test call and let me know if it works. In case it doesn't work, please:
- Enable verbose logs from the 3CX Console > Dashboard > Activity Log > Settings.
- Repeat the call to reproduce the issue.
- Generate the support information package and send it to me in a private message.

 

[francesco-vedica]

I did it all over again and now it seems to work. I don't know what's different from before, just to be safe I re-created the zoho extension fields to avoid problems with bees. Thank you so much for your assistance, I wish you good continuation.