Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Salesforce output connector, can't run the update

arrancel
5 - Atom

I am new to Alterix. The issue I am having is (I think) quite straight forward. The test workflow I have created is simple. Reads from a .csv with two columns ID18__c and Do_not_use_RPI__c and then I would like to perform an update on the salesforce ffbc__Contract__c table of the Do_not_use_RPI__c  values with what I have in the csv for the given ID18__c.

 

However I am getting "Error: Salesforce Output (8): The following fields are not updateable members of the target table: ID18__c"

 

That makes perfectly sense BUT that is not the field I am intending to update, that is the field the connector (I thought) shall be using to identify the relevant ids in the table and update the Do_not_use_RPI__c  values (as the dataloader would do when updating)

 

If I rename the ID18__c to id then the error is "Error: Salesforce Output (8): The following fields are not members of the target table: id" that again makes sense but I don't find the way to specify which field is to be used to identify the records to be updated.

 

Thanks in advance

 

 

 

1 REPLY 1
arrancel
5 - Atom

I found what the issue was. The ID18__c had to be renamed yes, but it is case sensitive and I was renaming it as "id" where it had to be "Id". When changed it, updated the records (as expected)

Labels