Use the Box Input to read data from your Box account to the Alteryx workflow and the Box Output to write data to your Box account. Supported file formats include: XLSX, CSV and YXDB.
Current version
-
Compatible with Alteryx Designer and Server 2021.4.2 Patch 6, 2022.1 Patch 4 and later.
-
Requires AMP engine.
-
Fixed issue where Box Output failed to write fixedDecimal data type into YXDB files. (TPM-2111)
-
Fixed issue where Box Output failed to overwrite certain large Excel files. (TPM-2169)
Previous versions
-
Compatible with Alteryx Designer and Server 2021.4.2 Patch 6, 2022.1 Patch 4 and later.
-
Requires AMP engine.
- DCM is required for running this connector on Alteryx Server.
-
Fixed issue where the Box connector intermittently showed an error message when left configured for a long period of time. (TDCE-177)
-
DCM authentication throws errors if it's not used right away. (TFLN-1371)
-
Compatible with Alteryx Designer and Server 2021.4.2 Patch 6, 2022.1 Patch 4 and later.
-
Requires AMP engine.
-
For Box Input, added an option include subfolders when utilizing wildcard search, downloading files locally, or when user opts to Process file as.
-
Fixed performance issue when utilizing wildcard search in Box Input. (TPM-2027)
-
Fixed issue where wildcard search was returning an error the first time workflow ran. (TPM-1847)
-
Fixed issue where Box Output failed to write various number and date-time data types into YXDB files. (TDCE-96, TPM-1958)
-
Fixed issue where workflow failed when Box Output was configured to use incoming field to dynamically name one or more output files. (TPM-1980)
-
Fixed issue where the Box configuration panel showed intermittent error when left open for a long period of time. (TFLN-1210)
Known Issue
-
Compatible with Alteryx Designer and Server 2021.4.2 Patch 6, 2022.1 Patch 4 and later.
-
Requires AMP engine.
-
Fixed issue where the Configure File tab was resent when users pressed Enter in the File Path field. (TFLN-1209)
-
Fixed issue where reading a XLSX file with Null values resulted in error. (TDCE-92)
-
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)
-
Fixed issue where Box Output failed to append data when it contained quoted delimiter character. (TDCE-28)
-
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)
Known Issue
-
Compatible with Alteryx Designer and Server 2021.4.2 Patch 4, 2022.1 Patch 2 and later.
-
Requires AMP engine.
-
Added support for DCM.
-
Added option to overwrite only one sheet added.
-
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.
-
SSL/TLS validation is now performed against Windows Certificate Store.
-
FIPS capable.
-
Fixed issue with dynamic naming of files. (TPM-1688)
-
Compatible with Alteryx Designer 2021.4.2 and later.
-
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.
-
Removed the limit of 100 files downloaded from a single folder.
- Added an option to pass column information (column names and data types) to connected tool without the need to run the workflow.
- Added Dynamic Output
- Added an option to upload local files to Box using Box Output.
- Write Headers checkbox is now enabled by default.
- Minor bugfixes.
- 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. For detail, see the Box Help page.
-
Compatible with Alteryx Designer 2021.3 and later.
-
Added support for OAuth (incl. SSO) and Access Token authentication methods.
-
Allows user to download the folders and files locally.
Known limitations
- Due to limited lifespan of refresh token, a workflow with this tool cannot be scheduled – this limitation will be addressed by adding JWT authentication method in the next version.
-
Public preview/beta of the tools. Do not schedule this tool or use it in production.
-
Read/write Excel dates as string to avoid data loss.
-
Fixed several errors in Excel reader.
- Added logic to clarify only .xlsx (not .xls) files.
-
Compatible with Designer 2019.2 and later.
-
Public preview/beta of the tools. Do not schedule this tool or use it in production.
-
Server is not supported.
-
English language support.
- When using ‘End User’ Authentication, your access will expire after one hour. You will need to Log Out and sign back in to re-authenticate. Use ‘Service-to-Service’ to avoid having to re-authenticate.
When sharing a workflow that uses a .yxi tool, the tool is not included and must be installed by the user.
