For opportunities to successfully sync to HubSpot from Salesforce, there are two fields that must be visible for the integration user to read on the opportunity object - Name and ID.
If the integration user cannot see all of these fields, you may see an error like:
“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' ] ]”
Note the bold - in this case, the integration user cannot see the field “Name” on the Opportunity object in Salesforce. If one or both of these fields are not visible to the integration user, follow these instructions:
For Professional Edition customers of Salesforce, drag-and-drop the following fields onto 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, and Close Date.
For Enterprise/Unlimited Edition users, make field-level visibility changes to the profile of the integration user.