Error: “The following fields are not updatable members of the target table: [Field_Name]”
Environment Details
Error is received when performing an update to a record with the Salesforce Output Tool. The column is locked for editing by your Salesforce Administrator or is the incorrect primary key to reference for updating the record.
The following fields are not updatable members of the target table: [Field_Name]
- Alteryx Designer
- Salesforce Output Tool
- Salesforce
Cause
This error indicates that the field provided in the error could not be used as a primary key to update the record the Salesforce Output Tool is pushing, or that the record is locked for editing by a Salesforce Administrator.
Resolution
Solution
- Please consult with the Salesforce Admin to identify the proper primary key and ensure the table can be edited by you, including proper write permissions.
- Salesforce permissions needed include Modify All access and API enabled.
- Another consideration is that you may have a service account used on the Alteryx Server to run schedules jobs, which will need these permissions as well.
Additional Resources
