Connect to box and upload files

You can easily download and run the workflow within your KNIME installation. For optimal performance, we recommend using the latest version of the KNIME Analytics Platform.

Before running the workflow, install the new KNIME Box File Handling extension. Click the info icon in the top-right corner and then "Install Extensions". Search for the box one and follow the installation steps.

This workflow demonstrates how to upload a file from your local machine to the selected box folder in CSV, Excel and table formats.

To ensure easy accessibility, we stored the data in the workflow data area and used the CSV Reader node to load it.

To connect to box, we utilized OAuth2 authentication as the authorization flow.
As explained in the "Box Authenticator" node description, we must create a new app in box to use the OAuth grant type.
Go to the developer console at "your-company.app.box.com/developers/console"

Retrieve the Client ID and Secret for the app you created and place them in the "Credentials" node. You will pass them as a flow variable to the "Box Authenticator" node.

In the "Box Authenticator" node, choose "Authentication method" OAuth2, add the local URL you're using in the node as a redirect URL in your app, and click login and grant access.

Once connected, you can select your "root" folder for the workflow operations through the "Box Connector" node. This workflow showcases how to upload a CSV file from your local machine to box in different formats and create new folders.

Data:

These data are originally published in:

Gorman KB, Williams TD, Fraser WR (2014) Ecological Sexual Dimorphism and Environmental Variability within a Community of Antarctic Penguins (Genus Pygoscelis). PLoS ONE 9(3): e90081. doi:10.1371/journal.pone.0090081

External resources

• User Authentication (OAuth2.0) - box Docs
• Palmer Archipelago (Antarctica) penguin data - Kaggle