community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
How to register and create Dynamics CRM Application on Azure
View full article
Looking for more premium connector and tool content to better equip your Alteryx platform for success? Check out what our partners have been up to!
View full article
Issue   When using the Salesforce Input tool, the following error is seen at run-time:   400: Bad Request     This may only occur on some tables It fails almost immediately after the workflow starts running. It may also been seen on the Salesforce Credentials screen along with the error: invalid_grant: authentication failure     Environment   Alteryx Designer Version 2018.3+ Salesforce Input tool Version 4.0 or 4.1   Diagnosis   Confirm where you are seeing the error. If it is on the Salesforce Credentials configuration page when you click Connect, and you see "invalid_grant", please see Solution B.   Otherwise, validate the query to get a more verbose error log.   1. Use the Query Builder option (this is the default option) and select the Table and Output Fields you want to read in. 2. Change to the Custom Query option and click the Validate button:   3. If you receive the error: "OPERATION_TOO_LARGE: exceeded 100000 distinct ids", see Solution A.     Solution A   The data you are attempting to pull is too large to be returned in one call based on the Salesforce API limits used by the Salesforce Input Tool. Limit the number of results returned by modifying the WHERE Clause (SOQL) in the tool's configuration:     Please see the Additional Resources section below for a guide on SOQL (Salesforce Object Query Language). Here are some suggestions:   Try limiting date fields by relative dates : CreatedDate = THIS_YEAR Try limiting a string field to a certain value: Name='SFDC Computing' You can also combine conditions with logical operators like AND & OR: Name='SFDC Computing' AND NumberOfEmployees>25 For more advanced comparisons, you can perform fuzzy matches by using the LIKE operator.  For example, you can retrieve all accounts whose names start with SFDC by using this condition:  WHERE Name LIKE 'SFDC%' - The % wildcard character matches any or no character. The _ character in contrast can be used to match just one character.     Solution B   The credentials are incorrect. Please confirm your Username, Password, and Token are correct.     Additional Resources   Salesforce Knowledge Base - Write SOQL Queries Salesforce Knowledge Base - Reset Your Security Token
View full article
The partnership between Alteryx and Tableau is becoming stronger and stronger, and the seamless effortless integration has been made easier through the Publish to Tableau Server Tool. This article demonstrates the use of the Publish to Tableau Server tool, available on the Alteryx Analytics Gallery.
View full article
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: <?xml version="1.0" encoding="UTF-8"?><error xmlns="http://www.force.com/2009/06/asyncapi/dataload"> <exceptionCode>InvalidJob</exceptionCode> <exceptionMessage>Unable to parse Job</exceptionMessage> </error>   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.   Steps: Close the Designer. Backup "Gui.html" in "...\Alteryx\Tools\SalesforceOutput_v1.3.0\"  or  "...\Alteryx\Tools\SalesforceOutput_v1.3.1\". 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.     
View full article
Sharepoint Input Tool: The IDCRL response header from server is not valid   When connecting with the Sharepoint List Input Tool, you may see the following error:   The IDCRL response header from server 'SERVERNAME' is not valid. The response header value is 'NTLM'.   Environment   Product - Alteryx Designer Sharepoint List Input Tool   Cause   This typically occurs when Sharepoint Online credentials are used when the server is expecting your Windows credentials (DOMAIN\username).   Solution   Select the appropriate SharePoint version (e.g., 2013 or 2016) Enter your User Name and Password using Windows Credentials Note: Be sure to specify your Domain (e.g. AYX\jsmith NOT jsmith)   Additional Resources   SharePoint List Input Tool 
View full article
Issue   When reading in data with a Sharepoint Input tool, the below error appears:   Error encountered: There is an error in XML document (<ROW>, <COL>).   Environment   Product - Alteryx Product - Sharepoint Input Tool   Cause   The SOAP API response from Sharepoint that Alteryx uses to pull data contains illegal characters per the XML v1.0 standard.   Solution   In a browser, while logged in to your Sharepoint, download the XML at the list items API endpoint. The API endpoint is defined in the Sharepoint documentation. In a text editor like Notepad++, show all characters, and find the illegal character at the <Row, Col> referenced in the error message. You will need to update your Sharepoint data to remove this character.   Additional Resources   Sharepoint SOAP API documentation How to deal with invalid characters in SOAP responses from ASP.NET web services
View full article
Issue    When using a Python-based connector (e.g. Salesforce Input, Azure Data Lake File Input), an error message referring to CERTIFICATE_VERIFY_FAILED appears.   Error establishing connection: HTTP error: SSLError(MaxRetryError("HTTPSConnectionPool(host='test.salesforce.com', port=443): Max retries exceeded with url: /path/file (Caused by SSLError(SSLError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:749)'),))",),)     Environment   Product - Designer Product - Python-based connectors   Cause   The root certificate of the host you are trying to connect to is not in the Python-based tool's keystore, so a trusted connection cannot be made.   Solution   In a browser, go to the host specified in the error message (e.g. "test.salesforce.com") Click the lock icon next to the URL in the browser, then click Certificate  On the Certification Path tab, click the Root Certificate, then click View Certificate Then, click Details, then Copy to File Proceed through the Wizard, choosing Base-64 encoded format.  Open the exported certificate and copy it's contents. Append the contents from the exported cert to the cacert.pem file located in the tool's certifi folder: Example for Admin installs: C:\ProgramData\Alteryx\Tools\SalesforceInput_v4.0.0\Lib\site-packages\certifi\cacert.pem Example for Non-Admin installs: C:\Users\{USERNAME}\AppData\Roaming\Alteryx\Tools\big_query_input_v1.0.3\Lib\site-packages\certifi\cacert.pem   Additional Resources   certifi - PyPi
View full article
Use the Google BigQuery Input tool to query a table from Google BigQuery and read it into  Designer ...
View full article
OneDrive is a file hosting and synchronization service operated by Microsoft. You can connect to a OneDrive instance in Alteryx with the OneDrive Input tool and the OneDrive Output tool.
View full article
The improvements in our salesforce connectors have been astronomical over the last year and now it is easier than ever to navigate the UI configuration screen and connect to your Salesforce Data!
View full article
Issue - Unable to connect to Salesforce Output tool   When connecting to the Salesforce Output tool, the following error is observed and an empty red box appears:   Error: Salesforce Output (8): Tool #92: Error trying to retrieve access token. HTTP/1.1 302 Found... Data from server:<html><head><meta http-equiv="Content-Type" content="text/html;charset=utf-8"/><title>Error 405 Only POST allowed</title></head><body><h2>HTTP ERROR 405</h2><p>Problem accessing /services/Soap/u/34.0. Reason:<pre>Only POST allowed</pre></p><hr /><br/><!-- Body events --><script type="text/javascript">function bodyOnLoad()if(window.PreferenceBits)window.PreferenceBits.prototype.csrfToken="null";;function bodyOnBeforeUnload()function bodyOnFocus()function bodyOnUnload()</script> </body></html><!--............................................................................................................................................................................................................................................................................................................................................................................................................-->       Environment   Alteryx Designer Version 10.5+ Salesforce Output Tool   Cause   Salesforce Lightning URLs are not supported. Lightning URLs take the following format:  https://mycompany.lightning.force.com   Solution   Use a non-lightning URL. This can be provided by your Salesforce administrator and as looks as follows: https://na7.salesforce.com/     Additional Resources   Salesforce Tools The 'How to Guide' to the Salesforce Connector
View full article
So we’re now downloading all the network-shared documents we want thanks to instructions   posted on our Knowledge Base, and we’re on our way to mastering FTP in Alteryx. But what if we want to take it a step further? A lot of our users rely on FTP as a drop zone for datasets that are generated periodically (e.g. weekly, monthly, or quarterly datasets). We should then be able to schedule a workflow to coincide with those updates, automatically select the most recent dataset, crank out all the sweet data blending and analytics we have in our scheduled workflow, and proceed with the rest of our lives, right? Right. We can do just that, and with a little work up front, you can automate your FTP download and analysis to run while you’re enjoying the finer things in life. Here’s how in v10.1:
View full article
In a  previous article , we've shown you how you can upload to FTP using the  Download  tool. With the release of Alteryx 10.5, the Download tool now supports uploading to  SFTP . With this addition, we'll take the opportunity to show you some more examples of uploading data to SFTP/FTP and show you how seamless it can be.
View full article
  Ever wish you had an easy way to read in data to Alteryx Designer from your Quickbooks Online account? Well, now there's a tool for that.   This article will describe how to make an API call to QuickBooks Online through the QuickBooks Input Tool attached to this article. 
View full article
If the API that you are working with requires you to sign or authenticate your requests, it may utilize an implementation of OAuth 2.0 or another authentication method to show that you have the access needed to consume the web service. There are some key words that you can look for in the API documentation that you are using that will help you quickly choose the appropriate grant flow to use in Alteryx.
View full article
Now you are ready to take your workflow one step further and add some error checking. If something is wrong with your request or something goes wrong on the server, an API will usually return an error message. It is useful to capture this information and clearly display it to the user of the connector. The Message tool will come in handy here. It will help you to troubleshoot the error and actually stop the workflow from processing if you would like.
View full article
  Salesforce Tools                                                Connecting to Salesforce   In order to use the Salesforce Input or Output tools in Alteryx, you must first connect to Salesforce using your Salesforce credentials:        1.  Make sure you have the correct Salesforce URL; it will look something like  https://[instance].salesforce.com .         2.  Your Salesforce username      3.  Your Salesforce password      4.  A Security token that you can recover from your Salesforce administrator or using the steps below (if you have the sufficient privileges from your Salesforce admin):     In Salesforce.com, click on the picture icon in the top right-hand corner and click on my Settings:         Click on Personal > Reset My Security Token:       This will send out an automated email with your security token. Voila!  You should be ready to connect!     Configuring the tool       Environment - Choose the environment that you wish to utilize for the data pull. We will automatically find the host name based on your email address. User Name - Salesforce username (often an Email address). Password - Password associated with Salesforce account. Security Token - If necessary, you can send a new token to your email by logging in to Salesforce, going to “My Settings”, and selecting “Reset My Token” under the                                        “Personal” tab.   Once you click the ‘connect’ button, Salesforce will authorize your credentials, and you will be able to begin using the tool to query Salesforce data.     Salesforce Input Tool (Querying Salesforce)   Query Builder:   The Query Builder has four fields that allow you to select the data you would like to pull from Salesforce simply, without having to write full SOQL (Salesforce Object Query Language) statements:   Table: Select the table you would like to pull fields from. *The list only includes ‘Queryable’ tables as defined by the flag ‘Queryable’ set to true or false returned by the API call.   Fields (optional): Select the fields in the table you need data from. If no fields are selected, all fields will be pulled.   Record Limit (optional): Place a MAX on the number of records you will pull.   WHERE Clause (optional): Using a SOQL statement, specify the conditions that you require for the data you pull. *You do not need to include ‘WHERE’ in the statement. Ex. AccountID = ‘2543456’   It is best practice to limit the records you bring in with the Fields, Record Limit, and WHERE clause arguments in the Salesforce Tool instead of bringing in all of the salesforce data, and then filtering down the data with tools in Alteryx.   Custom Query:   If you prefer Querying Salesforce using SOQL, you can use the Customer Query to write out SOQL statements. For full SOQL Syntax, see this link. If you began using the Query Builder, and decided to change to the custom query, the pre-existing query will already exist in the Query Builder in full SOQL syntax:       Below the SOQL Query text box is a check box for “Attempt to Parse JSON Response.” With this box checked (the box is checked by default), Alteryx will attempt to parse the response returned from the API call for quick viewing in the results window.  If the box is left unchecked, the API response will be returned in one field titled “JSON.” You can parse this response using the JSON Parse tool in Alteryx.   Next to the “Attempt to Parse JSON Response” check box is a “Validate” button. Clicking this button prior to running the workflow will submit the query to Salesforce to determine if it valid. It will also check to see if the response from the API will be able to be parsed automatically, which should prompt you to leave the “Attempt to Parse JSON Response” check box selected.     Existing Report:   This option will allow you to pull any pre-built reports and their data that already exist in Salesforce. Simply select the report you which to read in and run the workflow.   _____________________________________________________________________________________   Salesforce Output Tool (Writing to Salesforce)   Connecting to the Salesforce Output is identical to the Salesforce input tool. URL, User Name, Password, and Security Token are all required credentials to connect to the API. There are only two options that need to be selected in the Salesforce Output tool. Both are required.   Table: Select a table to write to from the list of tables available   Output Operation: Select the operation for how you will write the data to the table. The three available options are Update, Insert, and Delete.   ** If you want to overwrite values in Salesforce with null values, use “#N/A” instead of “null.” You can accomplish this with a replace function in the Formula tool.   Basic Troubleshooting steps:   Error: “Unable to reach SOAP API (Check URL)”     -Check to see if your username needs to have the domain attached (eg. JonDoe@alteryx.com).   -If you’ve ensured that the URL is correct, this may be a proxy issue. Alteryx should pick up the proxy settings, but you may need to enable them manually by going to Options->User Settings->Edit User Settings->Advanced. There is an article on the community that walks through this.    -The tool requires that your Salesforce account is API enabled. You may have to work with your Salesforce administrator for granting your account API User Permissions.   _____________________________________________________________________________________   Error: “The following fields are not updateable members of the target table: (table)”   This error is telling you that your Salesforce administrator has locked the fields from being updated, and you will have to work with them determine what can be updated. ____________________________________________________________________________________   Error: “INVALID_LOGIN: Invalid username, password, security token; or user locked out.”   After you have confirmed that your credentials are correct, and you are not locked out of Salesforce, check to see if your company uses SSO (single-sign-on) for Salesforce. You can check this by seeing if Salesforce requires a password directly when you log in a browser. This authentication is not supported by the connector, and will not work. You must use credentials that log you in directly into Salesforce for the tool to work.    *See the “Common Issues” section of this Community article by @JordanB for more common issues and troubleshooting steps.   Other:   Salesforce has a maximum length for SOQL statements, which is set at 20,000 characters by default. There is also a maximum length of 4,000 characters for the WHERE clause.  Other SOAP API call limits can be found here.   As the API accepts data in batches which have limits, the output tool contains logic to take care of the batching. Please see this link for more details.
View full article
When using the Salesforce Input tool, you can limit the data to a certain timeframe. Alteryx has the ability to use SOQL date queries so that you pull data for a certain time frame instead of pulling ALL of your data and then having to filter out what you are interested in. Pulling all of your data can take some time depending on the size of your table and this is a quick way to get around a potentially slow data pull.   Once you have entered your Salesforce credentials, go ahead and pick your table (1). From the table you have selected choose your fields (2). At least one has to be some kind of field with dates and/or date times recorded. And finally, you can enter in a SOQL query that will execute on your date field (3).   The date query that you enter could be something as simple as a specific date, for example, ‘DateField  = 2016-03-31’ or ‘DateField  > 2016-03-31’. Or you could use some of the SOQL date literal query options. For example ‘DateField  = YESTERDAY’ or ‘DateField  = LAST_QUARTER’         Here is a full listing of your date query options when using SOQL to query on dates in the salesforce input tool - Date Formats and Date Literals. If you need help in getting your salesforce login credentials please see our Obtaining Credentials for the Salesforce Connectors article.   If you run into any issues with the Salesforce input tool, please feel free to reach out to our Client Support team through the Case Portal. 
View full article
Issue   The following error appears when configuring your credentials in the Dynamics CRM Tools, Azure Data Lake Tools, OneDrive Tools, or the PowerBI Output tool:   The reply url specified in the request does not match the reply urls configured for the application       Environment   Alteryx Designer 2018.2+ Connectors Dynamics CRM Tools Azure Data Lake Tools OneDrive Tools PowerBI Output tool Windows Operating System   Cause   The redirect URI specified in the Azure application for the respective connector has not been set or has been configured with the wrong URL.   Solution   Set the Redirect URI in your Azure application to https://login.live.com/oauth20_desktop.srf If you do not have permissions to do this, please contact your Azure administrator If you do have permissions, follow the instructions from Microsoft's documentation: Add redirect URI(s) to your application   Additional Resources   Azure App Service error: AADSTS50011: The reply address does not match the reply addresses configured for the application
View full article