Skip to main content

[en] Box

[en] Connection Type

[en] Alteryx Tool. The latest version is available from the Alteryx Community.

[en] Type of Support

[en] Read and Write

[en] Version

[en] Description

[en] v 2.5.2

  • [en] Compatible with Alteryx Designer and Server 2021.4.2 Patch 6, 2022.1 Patch 4 and later.

  • [en] Requires AMP engine.

  • [en] For Box Input, added an option include subfolders when utilizing wildcard search, downloading files locally, or when user opts to Process file as.

  • [en] Fixed performance issue when utilizing wildcard search in Box Input. (TPM-2027)

  • [en] Fixed issue where wildcard search was returning an error the first time workflow ran. (TPM-1847)

  • [en] Fixed issue where Box Output failed to write various number and date-time data types into YXDB files. (TDCE-96, TPM-1958)

  • [en] Fixed issue where workflow failed when Box Output was configured to use incoming field to dynamically name one or more output files. (TPM-1980)

  • [en] Fixed issue where the Box configuration panel showed intermittent error when left open for a long period of time. (TFLN-1210)

[en] Known Issue

  • [en] Box Output fails to write fixedDecimal data type into YXDB files. (TPM-2111)

[en] Alteryx Server requires the AllowAll value of the SDK Access Mode settings.

[en] v 2.5.1

  • [en] Compatible with Alteryx Designer and Server 2021.4.2 Patch 6, 2022.1 Patch 4 and later.

  • [en] Requires AMP engine.

  • [en] Fixed issue where the Configure File tab was resent when users pressed Enter in the File Path field. (TFLN-1209)

  • [en] Fixed issue where reading a XLSX file with Null values resulted in error. (TDCE-92)

  • [en] Fixed issue where a workflow run with the Box connectors using JWT authentication failed to run after a day, with the cryptography or Invalid access token error. (TPM-1802)

  • [en] Fixed issue where Box Output failed to append data when it contained quoted delimiter character. (TDCE-28)

  • [en] Fixed issue where Box Output either failed to write date and date-time data types, or changed the date to 70 years in the future. (TPM-1902)

[en] Known Issue

  • [en] Box Output fails to write various number and date-time data types into YXDB files (TDCE-96). Workaround is to output data into CSV or XLSX.

[en] v 2.5.0

  • [en] Compatible with Designer 2021.4.2 Patch 4, 2022.1 Patch 2 and later.

  • [en] Requires AMP engine.

  • [en] Added support for DCM.

    • [en] DCM is required for running this connector on Alteryx Server.

  • [en] Added option to overwrite only one sheet added.

  • [en] Changed the behavior of sheet and file name field to be excluded from the written data. Added option to keep the sheet and file name field.

  • [en] SSL/TLS validation is now performed against Windows Certificate Store.

  • [en] FIPS capable.

  • [en] Fixed issue with dynamic naming of files. (TPM-1688)

[en] Known Issue

  • [en] Alteryx Server requires the AllowAll value of the SDK Access Mode settings.

[en] v 2.4.0

  • [en] Compatible with Alteryx Designer 2021.4.2 and later.

  • [en] Append and Overwrite options now create a new version of the file rather than deleting the old file and creating a new one. This preserves the file’s version history and shared links.

  • [en] Removed the limit of 100 files downloaded from a single folder.

[en] v 2.3.0

  • [en] Authentication occurs using user's browser instead of embedded CEF in Designer to comply with modern security policies.

  • [en] Minor bugfixes.

[en] v 2.2.0

  • [en] Added an option to pass column information (column names and data types) to connected tool without the need to run the workflow.

  • [en] Added Dynamic Output

  • [en] Added an option to upload local files to Box using Box Output.

  • [en] Write Headers checkbox is now enabled by default.

  • [en] Minor bugfixes.

[en] v 2.1.1

  • [en] Fixed blank screen issue when authenticating in Designer 2021.3.2.54175. Note that you also need to update to Designer 21.3.3.63061 or later. A whitelisting header need to be added in your Box app after you update.

[en] v 1.0.0

  • [en] Supports OAuth (including SSO) and Access Token Authentication Methods

  • [en] Allows users to download the folders and files locally.

  • [en] Requires Alteryx Designer 2021.3 and Later

[en] Alteryx Tools Used to Connect

[en] Box Input Tool

box

[en] Link

[en] Box Output Tool

box

[en] Link

[en] Use the Box connector to run, schedule, and publish workflows from Designer, using files stored in your Box workspace. Supported file types are XLSX, CSV and YXDB.

小心

[en] Desktop Automation (Scheduler) is not supported by this connector.

[en] Data Connection Manager

[en] The Box tools version 2.5.0 and later support Data Connection Manager for an easier and a safer storage of your credentials. Create a connection to Box and easily reuse the stored credentials in workflows that include the Box tools. Alteryx Server requires stored credentials to successfully run the published workflows.

[en] Enable AMP Engine

[en] Make sure you have the AMP engine enabled for the workflows which contain the Box tools version 2.5.0 and later to leverage the full potential of Designer capabilities.

[en] Box App Registration

  1. [en] Log in to https://alteryx.app.box.com/developers/console using your Box credentials.

  2. [en] Select Create New App.

  3. [en] Select Custom App.

  4. [en] In Authentication Method, select User Authentication (OAuth 2.0). Enter App Name and select Create App.

  5. [en] On the Configuration tab in Application Scopes, select Write all file and folders stored in Box to provide permission to the app.

  6. [en] Select Save Changes.

  7. [en] To generate a new developer token, select Revoke and then select Generate Developer Token.

  8. [en] You can use Client ID and Client Secret from OAuth 2.0 Credentials for authentication.

[en] Custom Application Setup

[en] To avoid a Box CORS issue when using the app with OAuth authentication or Access Token and JWT, use a custom configuration:

  1. [en] Box app with OAuth authentication:

    1. [en] Add Redirect URI https://cef.alteryx.com/designer/oauthcallback to resolve the CEF window CORS issue.

      BoxOAuth
    2. [en] Enter file://* for Allowed Origins.

      BoxOAuthCORS
  2. [en] Box app with Access Token and JWT authentication:

    1. [en] Enter file://* for Allowed Origins.

      BoxTokensCORS