• V20: 3CX Re-engineered. Get V20 for increased security, better call management, a new admin console and Windows softphone. Learn More.

Salesforce Integration

Status
Not open for further replies.

xecunet

Joined
Dec 8, 2015
Messages
5
Reaction score
0
I'm getting this error when testing the Salesforce integration:

Server returned a non successful status code - HTTPStatusCode=BadRequest - Reason=Bad Request - Content=[{"message":"\nAccountId),Lead(Id,FirstName,LastName,Fax,MobilePhone,Phone,Email,Company)\n ^\nERROR at Row:1:Column:174\nNo such column 'Fax' on entity 'Lead'. 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"}]

Everything looks to be set up properly but, obviously, it isn't working. Any thoughts or ideas how to fix?
 
In this case, the query is failing because the standard field Fax on entity Lead is missing. You just need to edit the Salesforce configuration to make that field visible to the query, not necessarily visible in the layout. This way the query will succeed.
In order to do this change:
- Go to “Setup Home > Objects and Fields > Object Manager > Lead > Fields.”
- Click on the field that you want to make visible, for example “Fax”.
- Press the “View Field Accessibility” button on the upper right side of the screen.
- Click on the “Hidden” label on the right of “Standard User”.
- Under the “Field-Level Security” check the “Visible” option.

That should do the trick. Please after doing this change, test a new call and if it doesn't work, please check the log to see if there is another field hidden that you need to make visible.

Kind regards.
 
That did the trick. Thank you so much for your help!
 
Status
Not open for further replies.

Getting Started - Admin

Latest Posts

Forum statistics

Threads
141,407
Messages
747,504
Members
144,372
Latest member
Quantinium
Get 3CX - Absolutely Free!

Link up your team and customers Phone System Live Chat Video Conferencing

Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.

3CX
A 3CX Account with that email already exists. You will be redirected to the Customer Portal to sign in or reset your password if you've forgotten it.