This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email firstname.lastname@example.org for assistance.
How To: Use Salesforce Output tool without a Salesforce Security Token
Some organizations set up their Salesforce users to not use a Security Token. This is done by setting an acceptable range of IP addresses instead in Salesforce Admin. This article will walk you through how to modify the Salesforce Output tool so that it may be used without a Salesforce Security Token.
Without the work-around users are able to sign in on the GUI of the tool without a token successfully:
However when running the workflow they will receive errorParse at char(0): Type mismatch in operator +.(Expression #3)
Alteryx Designer, Server
All Versions affected
Salesforce Output Tool
Salesforce account set up to not use a Security Token. This is usually managed by the SFDC Admin. This can be checked in the Administer Section --> Security Controls --> Network Access section.
1. To implement work-around, start with the workflow that is receiving the error shown above.
2. Right-click on Salesforce Output tool and click "Open Macro".
3. In the macro, navigate to the "get access token" container and click on the Formula tool.
4. In the "query_body" formula, remove "[security token]" from the formula.
5. Formula should now look like this:
6. Save the macro. This will now modify the tool permanently in the tools folder and can be used without a Security Token in any workflow.
7. Users will now be able to run this workflow, and any other workflows on this machine with this tool successfully.
The Salesforce Input tools (both the Deprecated version and Python-based 4.x versions) do not encounter an issue running locally without a Salesforce Security Token.
If you encounter any issues or have questions on the above, please contact Alteryx Support.