Page Comparison

...

1. Open the VQL Shell

   

2. Make sure you have the correct virtual database (VDB) selected in the top left corner of the VQL shell.
   

   

3. Follow the sections below based on the type of file you want to connect to.

Getting Box File ID

To get the ID of a Box file, navigate to the file in the Box web UI and copy the ID from the end of the URL.

...

CSV

1. Copy the VQL below into the shell

2. Replace {CONNECTION_NAME} with the desired name for the Box file connection

3. Replace {BOX_FILE_ID} with the ID of the file in Box (see step 3 in Step-by-Step).

4. Navigate to, and double click on the new connection, then click Create Base View.

...

1. Copy the VQL below into the shell

2. Replace {CONNECTION_NAME} with the desired name for the Box file connection

3. Replace {BOX_FILE_ID} with the ID of the file in Box (see step 3 in Step-by-Step).

4. Navigate to, and double click on the new connection, then click Create Base View.

5. Click OK in the Configure JSON View Dialog
   

   

6. In the next screen, for Tuple Root, put /JSONFile/JSONArray and click Create Base View.
   

   

...

1. Copy the VQL below into the shell

2. Replace {CONNECTION_NAME} with the desired name for the Box file connection

3. Replace {BOX_FILE_ID} with the ID of the file in Box (see step 3 in Step-by-Step).

4. Navigate to, and double click on the new connection, then click Create Base View.