Alteryx Designer Knowledge Base

The AWS Secret key field in Amazon S3 Download and Amazon S3 Upload tools are not displayed fully.

placeholder

Cannot save credentials in Azure Data Lake File (ADLS) connector v2.1.0. Error "Please provide an access token" after authentication.

Connector tools that use "Sign in via Internet Browser" do not work correctly with Designer or Server 2021.3.2. To use those tools, you must either authenticate with one of the options other than "Sign in via Internet Browser", down-rev to 2021.3.1, or upgrade to a version that includes a fix to TCPE-12 (Not available at the time this is being written.)

How to collect Wireshark traces to troubleshoot network-related issues.

Querying a Salesforce report using the Salesforce Input tool returns a maximum of 2000 records.

How to troubleshoot the error no attribute 'populate_token_attributes'

The following error appears when configuring your credentials in the Dynamics CRM Tools, Azure Data Lake Tools, OneDrive Tools, or the PowerBI Output tool:

Salesforce Output tool - red box appears with "Error trying to retrieve access token"

Troubleshooting error with Publish to Tableau Server tool: TypeError: Cannot read property ‘token’ of undefined

Steps on how to reinstall a Python-based .yxi tool.

Alteryx provides many built-in data connectors and there are additional ones available for download from the Gallery.

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.

Tab 1 - Basic \n URL : The URL for the resource you are trying to access must come from an upstream tool and is the only field required by Alteryx to configure the Download tool. Based on the API you are trying to pull information from (or send data to), other information will be required such as headers and/or a payload.

One of the greatest strengths of modern web APIs is their flexible, developer-friendly nature, which provides numerous options for both the provider and the user. However, this flexibility can make it more intimidating for business users to deal with the various data formats that these APIs provide. The purpose of this article is to familiarize you with the main data formats used by the vast majority of web APIs, and provide the basic knowledge that will allow you to confidently process the data they return into a typical tabular format.

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.

Before reviewing this section, we recommend watching our video on Standard Macros. In this section we will explain how to turn your working connector workflow into an Alteryx macro so it can be used as a tool within other workflows. The Interface tools will let you control which parameters and inputs can be entered into the connector macro. Interface tools take user inputs to update other tools inside the macro.

When connecting with the Sharepoint List Input Tool, you may see the following error:

Sharepoint Input Tool: Error encountered: There is an error in XML document

Latest versions of the Google Sheets and Google Analytics Connectors introduce ability to share a Connection Token across tools helping to stay under refresh token limit