CRM Integration: Database MSSQL: Call Journalling

[londonpapakura]

I use an insert statement for call journalling.

I see the statement is invoked with all necessary parameters:

2025/10/01 18:17:47.804|0025|Debg| [Integration.Crm.CallProcessingService] CRM: Triggering Call Journaling with values - CallType='Inbound' - PhoneNumber='0763xxx' - ContactName='31o 11040 RA xxx Bubikon /1068,' - AgentExtension='40' - AgentFirstName='' - AgentLastName='40' - AgentEmail='xx' - ContactRawData='11040|Contacts' - StartTime='10/01/2025 16:17:45' - EndTime='10/01/2025 16:17:47' - EstablishedTime='10/01/2025 16:17:45'
2025/10/01 18:17:47.804|0025|Debg| [Integration.Crm.Engine.ResultVariableScenarioProcessor] CRM: Processing scenario 'ReportCall'.

However, the Insert then fails, with for example the use of the ContactRawData parameter:

2025/10/01 18:17:47.804|0025|Debg| [Integration.Crm.Engine.ResultVariableScenarioProcessor] CRM: Executing SQL Query statement 'INSERT INTO A_Kontakt (AKT_ADR_ID, AKT_Typ, AKT_Start, AKT_Ende, AKT_PersonalNr, AKT_Ansprechpartner, AKT_Betreff) VALUES ('1068','0',@CallEstablishedTimeLocal,@CallEndTimeLocal,'1002',@ContactRawData,@Agent)'.


How can all this parameters be made accessible?

 

[Evolute IT]

You cannot use ContactRawData. It's EntityType and EntityId. You should read the documentation, the variables are listed.

 

[londonpapakura]

Thank you for your response.

Yes, I'm very sorry, I must have overlooked the link to the variables list:

Relevant documentation:
https://www.3cx.com/docs/sql-database-pbx-integration/
https://www.3cx.com/docs/crm-template-xml-description/#h.vcivldjsa1lz