We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Error: The Following Fields Are Not Updatable Members of the Target Table

londonhanson
Alteryx
Alteryx
Created

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
    • All versions
  • 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 

  1. 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.
  2. Salesforce permissions needed include Modify All access and API enabled.
  3. 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