Overview

Connecting Denodo to Box is a two step process. The first step involves creating an app that will give Denodo access to Box via OAuth and that people can share files with. The second step involves creating a connection to a Box file in Denodo using the credentials of the app.

Creating a Box App

This outlines how to create a Box App for Denodo. Since an app has already been created for Denodo, this guide is just for reference.

1. Go to the Box developer console: https://tufts.app.box.com/developers

2. Click Create a New App
   

   

3. Select Custom App
   

   

4. Select Server Authentication and give the app the name Denodo
   

   

5. Request authorization of the app in Box and create a TechConnect ticket requesting authorization of the Box app.
   

   

6. Once authorized, note down the email address/Service Account ID of the app, accessible from the General Settings tab. Use this email address to grant the app access to files.
   

   

7. Give the app access to files/folders by sharing them with the email address above
   

   

Connecting Denodo to Box

In Denodo, you can query files in Box by creating connections to individual files. In general, you will need to create one connection and one base view for each file you want to query.

1. Create a new Data Source file connection (Delimited file, JSON, XML, Excel)
   

   

2. Select ‘HTTP Client’ as the Data Route
   

   

3. Fill in the Base URL using this format, https://api.box.com/2.0/files/{FILE_ID}/content, replacing {FILE_ID} with the ID of the file in box.
   https://developer.box.com/reference/get-files-id-content/
   

   

   

4. Under the Authentication section, fill in the fields as follows. The Token endpoint URL is https://api.box.com/oauth2/token. You’ll need to click on Extra parameters of the refresh token requests and fill in the additional parameters that Box requires (screenshot , as outlined in the linked documentation below
   https://developer.box.com/guides/authentication/client-credentials/

   

   
   

   

   
   

   

   
   

   

5. Fill out the bottom section to match your file configuration. The screenshot below shows a common configuration for a CSV
   

   

6. Test the connection, confirm it works, then click Save.

7. Click Create Base View to create a base view for the file.