Recent content by Aaron_A-COM

  1. CFD MySQL query syntax issue

    Hey Ernesto, This is what I've gathered so far from extensive searching and reading in other posts like: Matthew's comment about adding prefix digits and then his post here, where the 5 outbound CLI control methods are listed. Your own comment here for caller ID being controlled by the SIP...

  2. CFD MySQL query syntax issue

    Hey Ernesto, Thanks for breaking that down. I changed it to Scalar and reformatted and all good finally. I'm working through the way it presents the call outbound now. I can see from my capture and the logs that the call setup outbound gets dialled by Make Call@ when it is going out to the...

  3. CFD MySQL query syntax issue

    So... I'm guessing that the call flow log isn't meant to look like this when trying to dial. 2021/02/23 16:35:20.132|8280|0015|Trc|CallPair._7001_1.Callflow.71.[C:27420.2]-From script: Dialer - Dialer 0 - CallFlow.CFD.SequenceContainerComponent 'checkNumberAvailable_0' - Start executing...

  4. CFD MySQL query syntax issue

    Also, I'm really not sure what the purpose of the Condition Creation "checkNumberAvailable" is looking at the Condition needing to be met before reaching the Make Call. This is the condition in there by default: GREAT_THAN(LEN(TRIM("getNextNumber.ScalarResult")),0) Again, there isn't a...

  5. CFD MySQL query syntax issue

    Hey Ernesto, I ended up taking out the extra \'s and quotation marks that had been bookended on to the query which got it resolved. Next step is getting the Make Call element to work. I've changed the TRIM expression to TRIM("getNextNumber.QueryResult") from the ScalarResult that is in the demo...

  6. CFD MySQL query syntax issue

    Hey Ernesto, Screenshots attached. The query I'm entering in the SQL Statement field is: "SELECT t1.phone FROM acd_3cx_leads t1 WHERE (t1.`active` = 1 AND t1.`name` != "" AND t1.`closeTypeId` IS NULL AND t1.`assignedUserId` IS NULL AND t1.`rowVersion` IS NULL AND t1.`statusId` = 1) ORDER BY...

  7. CFD MySQL query syntax issue

    Hey Frederick, No, I didn't use the expression editor. I copied my query and pasted it in to the query string field. I'll see how I go working through it in there.

  8. CFD MySQL query syntax issue

    Hi Guys, I've got an issue with the syntax of my query that I'm stumped on as when used in something like HeidiSQL as an example It returns the data no worries. When used in the CFD app I get the following: 2021/02/17 18:49:44.867|8736|0028|Trc|CallPair._7001_1.Callflow.2.[C:1.2]-From script...

  9. CFD outbound dialler integrating with customer CRM via their API

    Hey Ernesto, Thanks for the response. The client is happy to work with a http request if that's the easiest way to accomplish it. They've been working with API and JSON output for other platform interactions already so they suggested that method. If we can accomplish it with http requests it...

  10. CFD outbound dialler integrating with customer CRM via their API

    Hi All, I'm wondering if there's any way to have the CFD application get the number to dial etc. supplied via an API from the client's CRM? We've looked at doing via the normal database lookup process but their dialling scenario is a little complex with multiple call back attempts at varying...
See more
3CX Logo Footer Copyright © Sitemap Privacy
Top Bottom