I'm wondering if someone can help me here, I've recently integrated 3CX into Salesforce and am receiving the following errors when testing.
I should note that this is a relatively new instance of Salesforce with API enabled, so I have not created any custom contact fields.
Server returned a non successful status code - HTTPStatusCode=BadRequest - Reason=Bad Request - Content=[{"message":"\nContact(Id,FirstName,LastName,AssistantPhone,Fax,HomePhone,MobilePhone\n ^\nERROR at Row:1:Column:72\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"}]
Started scenario with empty id
Started Auth
Request text: https://login.salesforce.com/services/oauth2/token
Request form value grant_type set to password
Request form value client_id set to somethingsecure
Request form value client_secret set to somethingsecure
Request form value username set to [email protected]
Request form value password set to somethingsecure
Response text: {"access_token":"somethingsecure","instance_url":"https://mydomain.my.salesforce.com","id":"https://login.salesforce.com/id/somethingsecure","token_type":"Bearer","issued_at":"1564175125632","signature":"somethingsecure"}
Response finished
Variable Url set to https://mydomain.my.salesforce.com
Variable AccessToken set to somethingsecure
Finished Auth
Request text: https://mydomain.my.salesforce.com/services/data/v37.0/search/?q=FIND {5551234} IN PHONE FIELDS RETURNING Contact(Id,FirstName,LastName,AssistantPhone,Fax,HomePhone,MobilePhone,OtherPhone,Phone,Email,AccountId),Lead(Id,FirstName,LastName,Fax,MobilePhone,Phone,Email,Company),Account(Id,Name,Fax,Phone)
System.Exception: Server returned a non successful status code - HTTPStatusCode=BadRequest - Reason=Bad Request - Content=[{"message":"\nContact(Id,FirstName,LastName,AssistantPhone,Fax,HomePhone,MobilePhone\n ^\nERROR at Row:1:Column:72\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 CrmIntegration.ScenarioProcessorBase.ProcessRequest(ScenarioRequest request, IValueManager customManager, HttpClient client, 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)
TEST
I should note that this is a relatively new instance of Salesforce with API enabled, so I have not created any custom contact fields.
Server returned a non successful status code - HTTPStatusCode=BadRequest - Reason=Bad Request - Content=[{"message":"\nContact(Id,FirstName,LastName,AssistantPhone,Fax,HomePhone,MobilePhone\n ^\nERROR at Row:1:Column:72\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"}]
Started scenario with empty id
Started Auth
Request text: https://login.salesforce.com/services/oauth2/token
Request form value grant_type set to password
Request form value client_id set to somethingsecure
Request form value client_secret set to somethingsecure
Request form value username set to [email protected]
Request form value password set to somethingsecure
Response text: {"access_token":"somethingsecure","instance_url":"https://mydomain.my.salesforce.com","id":"https://login.salesforce.com/id/somethingsecure","token_type":"Bearer","issued_at":"1564175125632","signature":"somethingsecure"}
Response finished
Variable Url set to https://mydomain.my.salesforce.com
Variable AccessToken set to somethingsecure
Finished Auth
Request text: https://mydomain.my.salesforce.com/services/data/v37.0/search/?q=FIND {5551234} IN PHONE FIELDS RETURNING Contact(Id,FirstName,LastName,AssistantPhone,Fax,HomePhone,MobilePhone,OtherPhone,Phone,Email,AccountId),Lead(Id,FirstName,LastName,Fax,MobilePhone,Phone,Email,Company),Account(Id,Name,Fax,Phone)
System.Exception: Server returned a non successful status code - HTTPStatusCode=BadRequest - Reason=Bad Request - Content=[{"message":"\nContact(Id,FirstName,LastName,AssistantPhone,Fax,HomePhone,MobilePhone\n ^\nERROR at Row:1:Column:72\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 CrmIntegration.ScenarioProcessorBase.ProcessRequest(ScenarioRequest request, IValueManager customManager, HttpClient client, 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)
TEST
