Salesforce Input Tool
Use the Salesforce Input tool to query your tables from Salesforce.com and read them into Designer.
Gallery tool
This tool is not automatically installed with Designer. To use this tool, download it from the Alteryx Analytics Gallery.
Your Salesforce account must be API Enabled to use this tool. Ask your Salesforce administrator to set your Salesforce account to API Enabled.
Configure the tool
Salesforce Credentials
For more information, visit Salesforce Documentation.
- Username: Enter your Salesforce user name (e.g., your email address).
- Password: Enter your Salesforce password.
- Security Token: Enter your Salesforce Security Token.
- Connect: Click to connect and display the Configuration window.
Query Type
To query your tables from Salesforce.com and read them into Designer, select a query type:
Query Builder
Use Query Builder to browse for and select a Salesforce table, output fields, and other parameters.
- Table: Select a table to read into Designer. Type in the search box to filter for a table or browse for a table by using the arrows. The list includes any queryable table. If queryable is set to false, the table will not display.
- Output Fields: Select the fields you want to retrieve from the table. You can search for a field or select all fields.
- Record Limit: Optional. Enter the number of rows to return or leave blank to return all rows.
- WHERE Clause (SOQL): Optional. Type a Salesforce Object Query Language (SOQL) query. Defaults to IsDeleted=False which returns only current records. To return deleted records, use IsDeleted=True. If this field is left blank, Designer returns all records.
Custom Query
Custom Query displays your Query Builder query. Use Custom Query to specify a table and parameters as a Salesforce Object Query Language (SOQL) query.
- SOQL Query: SOQL Query displays your Query Builder query.You can type a new SOQL statement or edit the Query Builder query.
- Validate: Click to validate the query via the Salesforce API. Designer displays the message from the Salesforce API.
- Attempt to Parse JSON Response: Select to parse the query response and display the parsed output in the Results window. Only table data is parsed. If not selected, the response is output as a single JSON field, which you can parse with the JSON Parse tool.
Existing Report
Select a preconfigured report from your most recently viewed Salesforce reports. Only the last viewed 200 reports display.