Error: 400 Bad Request - Salesforce Output tool

[clarab]

Issue

Salesforce Output tool used in a non-English Designer produces the following error:

Error - ToolId 1: ツール#93: Error trying to create the job. HTTP/1.1 400 Bad Request ... Data from server: xmlns="http://www.force.com/2009/06/asyncapi/dataload">
InvalidJob
Unable to parse Job

Environment

• Alteryx Designer - Non-English
• Salesforce Output tool
  • Version 1.3.0
  • Version 1.3.1

Cause

The cause is due to passing in a non-English operation value to Salesforce as selected in the "Output Operation" option in the Salesforce Output tool.

An example of a non-English (Japanese) output operation options in Salesforce Output tool:

Value passed to Salesforce:
 

<?xml version="1.0" encoding="UTF-8"?>
<jobInfo xmlns="http://www.force.com/2009/06/asyncapi/dataload">
<operation>更新</operation>
...
</jobInfo>

  

Solution

To address this, please update the "Gui.html" file to use English operation values so the "Output Operation" options will display in English instead.

1. Close Alteryx Designer.
2. Backup "Gui.html" in "...\Alteryx\Tools\SalesforceOutput_v1.3.0\" or"...\Alteryx\Tools\SalesforceOutput_v1.3.1\".
3. Modify the "Gui.html" file

FROM:

<label>XMSG("Output Operation")</label>
<alteryx-pluginwidget type="DropDown" id="dataItemOutputOptions" dataName="OutputOptions">
<alteryx-option>XMSG("Update")</alteryx-option>
<alteryx-option>XMSG("Insert")</alteryx-option>
<alteryx-option>XMSG("Delete")</alteryx-option>
</alteryx-pluginwidget>

TO:

<label>XMSG("Output Operation")</label>
<alteryx-pluginwidget type="DropDown" id="dataItemOutputOptions" dataName="OutputOptions">
<alteryx-option>Update</alteryx-option>
<alteryx-option>Insert</alteryx-option>
<alteryx-option>Delete</alteryx-option>
</alteryx-pluginwidget>

With the change, the "Output Operation" options will show "Update", "Insert" and "Delete" in English instead.

4. Open your workflow and re-select the output operation value in the Salesforce Output tool.