topic Re: Salesforce Connector - Existing Field Not Found in Alteryx Designer Desktop Discussions

Salesforce Connector - Existing Field Not Found

dcoelho-nhld — Tue, 09 Jul 2019 13:38:50 GMT

I'm trying to use the Salesforce output connector to insert new Customer records and keep receiving this error message.

However, this field DOES exist, as shown below:

It also doesn't appear on the Input connector, which is another issue as I need this field to join my data.

I need this field for what I'm attempting to do. Any suggestions on how to get the connectors to recognize the existing field? I've tried deleting the connectors and re-adding them and also restarting Alteryx Designer, with no luck.

Re: Salesforce Connector - Existing Field Not Found

kelsey_kincaid — Tue, 09 Jul 2019 14:33:09 GMT

@dcoelho-nhld Does the Salesforce security profile of the user credentials you are using have read/write access to the field in question?

Re: Salesforce Connector - Existing Field Not Found

dcoelho-nhld — Tue, 09 Jul 2019 16:07:32 GMT

The user I'm using is a System Administrator. I'm not sure how to check field specific permissions though. I don't see anything saying that this field isn't able to be read/written to.

Re: Salesforce Connector - Existing Field Not Found

kelsey_kincaid — Tue, 09 Jul 2019 17:20:39 GMT

@dcoelho-nhld Try going to Salesforce Setup --> Users --> Profiles --> System Administrator --> Object Settings --> Customer

From there you should see a full list of 'Field Permissions'. Hopefully as System Administrator you have access to all of the fields, but since you still have to manually add permissions to the System Admin profile it's possible something was missed. You'll want to verify that you have read and edit access on the ActID__c field.

Re: Salesforce Connector - Existing Field Not Found

dcoelho-nhld — Wed, 10 Jul 2019 19:17:14 GMT

Thanks for the instructions, I was able to find that page and I do have both read and edit access to that field. However, I changed the permission for "Standard User" instead of "System Administrator" and now the field is working correctly for both the input and output connectors. Thank you very much for your help!