Alteryx Unable to edit Salesforce Tables

[EDutton]

Hello,

We are trying to add Account Team Members via Alteryx Salesforce Connector. The Alteryx service user in Salesforce has been given ‘Modify All’ access to the Accounts Object which is automatically inherited for the Account Team Object.

When trying to run a test Alteryx is stating "fields are not updateable members of target table: account access level, accountid, userid" which would naturally indicate that the Alteryx user does not have access to the fields etc, however, we know this is not the case as per the access provided. We have spoken to Salesforce who also confirm there is not issues with the permissions provided and that when they are trying to reproduce the issue with SOAP UI (which is also independent 3rd party) no error is seen and the Account Team Member was created successfully.

If we log into Salesforce directly as the Alteryx user, again, we are able to add/remove Account Team Members.

Salesforce have advised, in this scenario, the error is not observed at salesforce end and it is working fine with SOAP UI so we would suggest you to check with the 3rd party team on this.

Any advice or suggestions would be appreciated.

Thanks

[bharatandalam]

Hi @EDutton 

are you using salesforce input tool?

Thanks,

Bharat

[mceleavey]

Hi @EDutton ,

this suggests when you are connecting via Alteryx you are not using the Alteryx Service Account but are more likely using your local login username.

If you are attempting to connect via the Alteryx server ensure that the Alteryx Service on the server is set to use the appropriate service account.

If you are attempting to connect from your local designer, then you will need to grant Modify All access to your local Windows login.

Try this and let me know if this fixes the issue.

M.

[EDutton]

Hi @mceleavey,

I am using the Alteryx server account, which has numerous other jobs running with no issues. The problem appears to be with this specific Account Team Members table.

Thanks,
Ed