JSON

Connecting to JSON Data Sources

Below is an overview of the authentication properties corresponding to each data source:

Service provider

URI formats

InitiateOAuth

OAuthClientId

OAuthClientSecret

OAuthAccessToken

OAuthAccessTokenSecret

User

Password

AuthScheme

AzureAccount

AzureAccessKey

AWSAccessKey

AWSSecretKey

AWSRegion

Local

localPath file://localPath

HTTP or HTTPS

http://remoteStream https://remoteStream

OPTIONAL

OPTIONAL

OPTIONAL

Amazon S3

s3://remotePath

REQUIRED (your AccessKey)

REQUIRED (your SecretKey)

OPTIONAL

Azure Blob Storage

azureblob://mycontainer/myblob/

REQUIRED

REQUIRED (your AccessKey)

Google Drive

gdrive://remotePath

OPTIONAL

OPTIONAL

OPTIONAL

OPTIONAL

OPTIONAL

Box

box://remotePath

OPTIONAL

REQUIRED

REQUIRED

OPTIONAL

OPTIONAL

Dropbox

dropbox://remotePath

OPTIONAL

REQUIRED

REQUIRED

OPTIONAL

OPTIONAL

SharePoint Online

sp://remotePath

REQUIRED

REQUIRED

FTP or FTPS

ftp://server:port/remotePath ftps://server:port/remotepath

REQUIRED

REQUIRED

Wasabi

wasabi://bucket1/remotePath;

Connecting to Local Files

Set the URI to a JSON file.

Below is an example connection string:

URI=C:\folder1\file.json;

Connecting to HTTP JSON Streams

Set the URI to the HTTP or HTTPS URL of the JSON resource you want to access as a table. Set AuthScheme to use the following authentication types. The provider also supports OAuth authentication;

• HTTP

  To use HTTP Basic or Digest, set the User and Password. Set CustomHeaders if you need access to the request headers. Set CustomUrlParams to modify the URL query string.

• Windows (NTLM)

  Set the Windows User and Password to connect and set AuthScheme to "NTLM".

• Kerberos and Kerberos Delegation

  To authenticate with Kerberos, set the User and Password and set AuthScheme to NEGOTIATE. To use Kerberos Delegation, set AuthScheme to KERBEROSDELEGATION.

For example:

URI=http://www.host1.com/streamname1;AuthScheme=BASIC;User=admin;Password=admin

Connecting to Amazon S3

Set the URI to a JSON document in a bucket. Additionally, set the following properties to authenticate:

• AWSAccessKey: Set this to an Amazon Web Services Access Key (a username).

• AWSSecretKey: Set this to an Amazon Web Services Secret Key.

For example:

URI=s3://bucket1/folder1/file.json; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO;

Optionally, specify AWSRegion.

Connecting to Wasabi

Set the URI to the bucket and folder. Additionally, set the following properties to authenticate:

• AWSAccessKey: Set this to an Wasabi Access Key (a username)

• AWSSecretKey: Set this to an Wasabi Secret Key.

For example:

URI=wasabi://bucket1/folder1/file.json; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO;

Optionally, specify AWSRegion in addition.

Connect to Azure Blob Storage

Set the URI to the name of your container and the name of the blob. Additionally, set the following properties to authenticate:

• AzureAccount: Set this to the account associated with the Azure blob.

• AzureAccessKey: Set the to the access key associated with the Azure blob.

For example:

URI=azureblob://mycontainer/myblob; AzureAccount=myAccount; AzureAccessKey=myKey;

Connecting to Google Drive

Set the URI to the path to a JSON file. To authenticate to Google APIs, use the OAuth authentication standard. You can connect with a user account or a service account. In the user account flow, you do not need to set any connection properties for your user credentials, as shown in the connection string below:

URI=gdrive://folder1/file.json;InitiateOAuth=GETANDREFRESH;

Connecting to Box

Set the URI to the path to a JSON file. To authenticate to Box, use the OAuth authentication standard. You can authenticate with a user account or a service account. In the user account flow, you do not need to set any connection properties for your user credentials, as shown in the connection string below:

URI=box://folder1/file.json; InitiateOAuth=GETANDREFRESH;

Connecting to Dropbox

Set the URI to the path to a JSON file. To authenticate to Dropbox, use the OAuth authentication standard. You can authenticate with a user account or a service account. In the user account flow, you do not need to set any connection properties for your user credentials, as shown in the connection string below:

URI=dropbox://folder1/file.json; InitiateOAuth=GETANDREFRESH; OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345;

Connecting to SharePoint Online

Set the URI to a document library containing JSON files. To authenticate, set User and Password and SharepointUrl.

URI=sp://Documents/folder1/file.json; User=user1; Password=password1; SharepointUrl=https://subdomain.sharepoint.com;

Connecting to FTP

Set the URI to the address of the server followed by the path to a JSON file. To authenticate, set User and Password.

URI=ftps://localhost:990/folder1/file.json; User=user1; Password=password1;

Securing JSON Connections

By default, the provider attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store. To specify another certificate, see the SSLServerCert property for the available formats to do so.