Solved Show Information from Dynamics NAV Contacts Table (MSSQL)

[gregtomasger]

Hi, i want to display the contact information from a MSSQL Database when an existing contact calls with the known telephone number from the SQL Table.
We us MSSQL Server 2014 .

So i thought this should be easy and standard. But i dont get it to work.

1. Question: Is this possible? I have no CRM and i only want to display the information like company / name
2. If yes... how? i tried it a thousand times with this how to https://www.3cx.com/docs/sql-database-pbx-integration/

but when i test it i allways get this error:

Unknown expression: No_. Part: No_.
Started scenario with empty id
System.Exception: Unknown expression: No_. Part: No_.
at TcxLexicalParser.ValueManager.GetByPath(String[] path)
at TcxLexicalParser.LexEvaluator.ProcessInt(ConcatElement concatElement, IValueManager valueManager, Boolean isFunctionArgument)
at CrmIntegration.EscapedExpressionEvaluator.ParseExpression(String expression, Boolean asExpression, IValueManager customManager)
at CrmIntegration.ScenarioProcessorBase.ProcessSQLDatabaseQuery(ISQLClientFactory sqlClientFactory, ScenarioQuery query, IValueManager customManager, 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, String destinationEmail, Boolean createIfNotFound, CancellationToken token)

Because i have no CRM Tool i have both fields filled like adviced in an other post:
...you should set the prefix and suffix as follows:
Prefix: https://my.crm.example.com/
Suffix: /data


I aprecciate any help.
Best regards
Thomas

 

[gregtomasger]

My Mistake... [] not allowed. I used "" in the statement now it works.