Queue waiting time object in CRM integration

[Wise Cloud]

Hey Team,

I would like to modify the Microsoft Dynamics CRM template to include the queue waiting time in the data that is pushed. I would like to know if something like the objects [CallStartTimeUTC] or [CallEndTimeUTC] exists for the queue waiting time.

The ultimate goal is to integrate with Power BI, allowing the customer to run reports in Power BI that display the queue waiting time.

Thank you in advance!

 

[Evolute IT]

There's no variable for this.

 

[KyriacosS_3CX]

The data connectors will give you that info, it you can fit one in your workflow.

 

[OlegOLP]

there don't seem to be any standard methods. You can get 2 webhooks using third-party utilities. Next, subtract the times and get what you need.

{
"event": "ringing",
"callerid": "+381629759787",
"user": "801",
"usertype": "queue",
"did": "DID 38121203400",
"id": "250802081606_17-0",
"chid": "00000000-01dc-0381-705a-30e900000016",
"inbound_did": "520529",
"sip_displayname": "+381629759787",
"phonebook": "John Smith",
"call_id1": "[email protected];to-tag=775e8923;from-tag=as004cd620",
"call_id2": "i1kYyhxiRa73YjSRNAOL6w..;from-tag=207f2803;to-tag=6b5aee2e"
}

{ 
"event": "ringing", 
"callerid": "+381629759787", 
"user": "105", 
"usertype": "ext", 
"did": "DID 38121203400", 
"id": "250802081606_17-0", 
"chid": "00000000-01dc-0381-705a-30e900000016", 
"inbound_did": "520529",
"sip_displayname": "+381629759787", 
"phonebook": "John Smith", 
"call_id1": "[email protected];to-tag=775e8923;from-tag=as004cd620", 
"call_id2": "pHoNffqoO8qk70iVZInS9w..;from-tag=4f604b7a;to-tag=d57d226f" 
}

 

[Wise Cloud]

Hey Team,

Just an update: I was able to connect 3CX with Power BI using a Google BigQuery database, and it appears that the CDR data is flowing smoothly.

Thank you for all your inputs!