Solved SalesforceV2 Issues

[Stevens2]

Hi All,

Bit stuck here, have managed to integrate Salesforce with 3CX, but when I search a number thats saved on the CRM, im getting the below.
I went into Asst phone in the object manager on Salesforce and have made the standard user visible, but no joy still


Started scenario with empty id
Started Auth
Request text: https://login.salesforce.com
Request form value grant_type set to refresh_token
Request form value refresh_token set to my token
Request form value client_id set to my key
Request form value client_secret set to my secret
Response text: ********
Response finished
Variable Url set to https:*****//.my.salesforce.com
Variable AccessToken set to my token
Finished Auth
Request text: https://*****.my.salesforce.com
System.Exception: Server returned a non successful status code - HTTPStatusCode=BadRequest - Reason=Bad Request - Content=[{"message":"\nFirstName,LastName,Title,Department,AssistantPhone,Fax,HomePhone,MobilePhone\n ^\nERROR at Row:1:Column:89\nNo such column 'AssistantPhone' on entity 'Contact'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.","errorCode":"INVALID_FIELD"}]
at Integration.Crm.Engine.ScenarioProcessorBase.ProcessRequest(Boolean authScenario, ScenarioRequest request, IValueManager customManager, HttpClient client, Boolean retry, CancellationToken token)
at Integration.Crm.Engine.ScenarioProcessorBase.ProcessScenario(ProtocolScenario scenario, IValueManager customManager, SqlQueryParameter[] sqlQueryParameter, CancellationToken token)
at Integration.Crm.Engine.ScenarioProcessorBase.Execute(ProtocolScenario scenario, SqlQueryParameter[] sqlQueryParameter, CancellationToken token)
at Integration.Crm.Engine.CrmProcessor.GetContactInfoFromCrm(List`1 result, IEnumerable`1 scenariosToProcess, IValueManager customManager, SqlQueryParameter[] sqlQueryParameters, Func`2 filterResultsFunctor, Boolean exactMatch, CancellationToken token)
at Integration.Crm.Engine.CrmProcessor.GetContactInfo(String contactNumber, InteractionTypes interactionType, CancellationToken token)

 

[edossantos_sipcaller]

This is the error:

No such column 'AssistantPhone' on entity 'Contact'.

You must make that field visible for the user running the integration. In some cases, when you fix this, the error is pretty much the same but with a different field (for example Fax). So you might be thinking that you fixed it, but the error is now something else. Just check carefully the error message if you make any changes.

 

[Stevens2]

Hi,

Thanks for getting back to me on this.
I have managed to get it working on contact lookup, now calls are being logged on salesforce, but under comments im seeing
Comments
[DateTime]: Answered outgoing call from [Agent] to [Number] [Name] ([Duration])[LineBreak][LineBreak]Transcription: [Transcription][LineBreak][LineBreak]Summary: [Summary][LineBreak][LineBreak]Recording: [RecordingUrl]

Shouldn't this get filled in?

 

[Stevens2]

I have managed to get it working now
This can be closed down.

Cheers