CRM Integration, 3CX won't lookup data with v16 SQL entries

[GabrielVE]

Hi everyone,

We had to reconfigure our SQL strings for v16 but apparently when a call comes in, and that the phone number is not yet known/added in the 3CX contacts, 3CX would not do a query using the SQL string setup in the CRM integration. Did a TEST using the Test button and here's the message that we got "CRM Integration is working OK but contact number does not exist. Check log for more info or try a different number."


Here's the SQL lookup statement that we're using "SELECT customer as firstname, contactlastname as lastname, mobile as phonemobile, businessphone as phonebusiness, homephone as phonehome, email1 as email, customername as companyname, telephone as phoneother FROM vw3CXConnection where mobile like '%[Number]%' or businessphone like '%[Number]%' or homephone like '%[Number]%' or telephone like '%[Number]%'"

Odd thing is that the results section of the TEST shows the customer details and phone number queried fine

Any help would be appreciated

Thanks

 

[edossantos]

You need to return the "contactid" field from your database, otherwise the record will be skipped. This is important to identify records and update them in 3CX when something changes, or create a new record if it's not already in 3CX contacts...