...
Copy and paste this VQL into the VQL shell and replace {CONNECTION_NAME} with the desired name for the Box file connection and replace {BOX_FILE_ID} with the ID of the file in Box (see step 3 in Step-by-Step). Make sure you have the correct database selected in the top left corner of the VQL shell.
After running the below VQL, navigate to, and double click on the new connection, then click Create Base View.
| Code Block | ||
|---|---|---|
| ||
CREATE OR REPLACE FOLDER '/01-base_layer' ;
CREATE OR REPLACE FOLDER '/01-base_layer/01-connections' ;
CREATE OR REPLACE FOLDER '/01-base_layer/01-connections/Box' ;
DROP DATASOURCE DF IF EXISTS {CONNECTION_NAME} CASCADE;
CREATE DATASOURCE DF {CONNECTION_NAME}
FOLDER = '/01-base_layer/01-connections/box'
ROUTE HTTP 'http.CommonsHttpClientConnection,120000' GET 'https://api.box.com/2.0/files/{BOX_FILE_ID}/content'
CHECKCERTIFICATES
AUTHENTICATION OAUTH20 (
ACCESSTOKEN = 'QdwTWOBaEREKeA5X30NqMRRwjEGY094b5uJp8q/eD38cycmYXTvY43eg8BvtHHm/X8tbbR9GDexgux5dm9STG8VFbDxhgKJMNoEl4jabdPodBkn5vcwrA9kcaDUxgwZh' ENCRYPTED
REQUESTSIGNINGMETHOD = HEADER
AUTHENTICATION_GRANT = CLIENT_CREDENTIALS_GRANT
TOKENENDPOINTURL = 'https://api.box.com/oauth2/token'
EXTRA_PARAMETERS_OF_REFRESH_TOKEN_REQUEST (
'box_subject_type' = 'enterprise',
'box_subject_id' = '192935'
)
CLIENTIDENTIFIER = '0jngdws659fyhpkb80f8fbt26q7olovd'
CLIENTSECRET = '4fMN87hoo/bjczYeTKGDn+d4kxRCxmjLiy5MQcuYpFlNiT1WMX1BP/m7Ggj5LeUROHpwKOC3872PkcfQLuOK40zjLG5MQ07G7Jro0gK+PG4QpUidG6TmsK86WHylZbf/ZvRGBc0pGr9SzpAccK2MiEsXenWuY5Uju6HPPYRF7IA=' ENCRYPTED
ACCESSTOKENEXPIRESIN = 4155
)
PROXY OFF
COLUMNDELIMITER = ','
ENDOFLINEDELIMITER = '\n'
HEADER = TRUE; |
...