Print this page

Salesforce Marketing Cloud Connector - AMPscript - CompanyOrAccount field is not accessible

Knowledge Article Number 000213145
Description
The Marketing Cloud AMPscript function RetrieveSalesforceObjects is unable to retrieve the CompanyOrAccount field in Salesforce.  The following message is displayed: "No such column 'CompanyOrAccount' on entity 'CampaignMember'." 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.
Resolution
Currently, Salesforce has the CompanyOrAccount field available to build reports, but it is not accessible via API. The Marketing Cloud AMPscript function uses an API call to retrieve the data and since the field is not accessible, it causes the AMPscript to fail.




promote demote