Opportunity not syncing between Salesforce and HubSpot

Last updated: October 16, 2018

Applies to:

Marketing Hub
Professional, Enterprise
Sales Hub
Professional, Enterprise

For opportunities to successfully sync to HubSpot from Salesforce, the Name and ID fields must be visible for the integration user to read on the opportunity object

If the integration user cannot see all of these fields, you may encounter an error:

com.hubspot.sfconnector.exceptions.SalesforceClientException: [InvalidFieldFault [ApiQueryFault [ApiFault exceptionCode='INVALID_FIELD' exceptionMessage=' StageName, Probability, CreatedDate, Type, Description, CampaignId, AccountId ^ ERROR at Row:1:Column:64 No such column 'Name' on entity 'Opportunity'. 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.' ] row='1' column='64' ] ]

In the error message above, the integration user cannot see the field Name on the opportunity object in Salesforce. If either the Name or ID fields are not visible to the integration user:

  • Salesforce Professional Edition: drag and drop the following fields on the opportunity page layout:
    • Opportunity Name
    • Opportunity Owner
    • Primary Campaign Source
    • Stage
    • Probability (%)
    • Created By
    • Type
    • Description
    • Expected Revenue
    • Account Name
    • Amount
    • Last Modified By
    • Close Date
  • Salesforce Enterprise/Unlimited Edition: make the Name and ID fields visible for the integration user. 

Was this article helpful?

If you still need help you can get answers from the , or to contact support.