Hello, the Salesforce Connector tools continue to be finicky, especially when used on the Gallery, but can be made to work with some tricks and adjustments. I configured a workflow hosted on my company's Gallery that allows users to search for people within a company and optionally push those people straight into Salesforce as leads. Below are 2 steps I took to enable the Salesforce Connectors:
1. The first error you probably run into is a credential error, where you see one of the following errors:
Error: Salesforce Input (309): 'error': 'invalid_grant', 'error_description': 'authentication failure'
OR
Error: Salesforce Input (309): Traceback (most recent call last): File "main.py", line 71, in pi_initRuntimeError: Internal Error: DecryptPassword - buffer too small
I believe that the root of this problem is that when you enter credentials in the tools on your computer, they are encrypted, not within the workflow itself, but somewhere else within the local computer. Thus, when you upload the workflow to Gallery and try to run it, the workflow is run on your Alteryx server computer and it does not know how to decrypt the credentials.
To solve this, you just need to open the workflow on the remote desktop your Gallery is hosted on and enter your credentials into the Salesforce tools there. By saving the workflow on the same computer it will be run on when ran via the Gallery, you should get around these credential problems.
2. Additionally, I also ran into error handling problems within the Output connector. An example of one of these was when a user would accidentally attempt to push a lead to Salesforce that already existed. With the basic configuration of the Salesforce macro, this causes an error and stops the workflow. I made some adjustments within the macro to simply skip leads already in Salesforce and not throw an error; I did the same for several other errors. Below is the macro with these adjustments:
I hope this helps some of you!
