Content Comparison

CREATE OR REPLACE DATASOURCE CUSTOM ${CONNECTION_NAME}
    FOLDER = '/01-base_layer/01-connections/Box'
    CLASSNAME='com.denodo.vdb.contrib.wrapper.xls.ExcelWrapper'
    DESCRIPTION='';

CREATE OR REPLACE WRAPPER CUSTOM ${CONNECTION_NAME}
    FOLDER = '/01-base_layer/01-connections/Box'
    DATASOURCENAME=${CONNECTION_NAME}
    PARAMETERS (
      'Type of file' = 'Excel 2007 or later (*.xlsx)',
      'File location' = ROUTE HTTP 'http.CommonsHttpClientConnection,120000' GET 'https://api.box.com/2.0/files/1493246708852${BOX_FILE_ID}/content'
        AUTHENTICATION OAUTH20 ( 
          ACCESSTOKEN = 'blah'
          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 = ${CI_GET_FROM_DSE}
          CLIENTSECRET = ${CS_GET_FROM_DSE}
        )
        PROXY OFF,
      'Worksheet' = '${SHEET_NAME}',
      'Extract data from all sheets' = false,
      'Extract sheet name as a new column' = false,
      'Has headers' = true,
      'Stream tuples' = true
    );