TDV Adapter for REST

Build 22.0.8462

URI

The Uniform Resource Identifier (URI) for the XML/JSON resource location.

Data Type

string

Default Value

""

Remarks

Set the URI property to specify a path to a file or stream.

NOTE: this connection property requires that you set ConnectionType, which provide the

See Fine-Tuning Data Access for more advanced features available for parsing and merging multiple files.

Below are examples of the URI formats for the available data sources:

Service provider URI formats
Local Single File Path One table

localPath/file.json

file://localPath/file.json

Directory Path (one table per file)

localPath

file://localPath

HTTP or HTTPS http://remoteStream

https://remoteStream

Amazon S3 Single File Path One table

s3://remotePath/file.json

Directory Path (one table per file)

s3://remotePath

Azure Blob Storage Single File Path One table

azureblob://mycontainer/myblob//file.json

Directory Path (one table per file)

azureblob://mycontainer/myblob/

OneDrive Single File Path One table

onedrive://remotePath/file.json

Directory Path (one table per file)

onedrive://remotePath

Google Cloud Storage Single File Path One table

gs://bucket/remotePath/file.json

Directory Path (one table per file)

gs://bucket/remotePath

Google Drive Single File Path One table

gdrive://remotePath/file.json

Directory Path (one table per file)

gdrive://remotePath

Box Single File Path One table

box://remotePath/file.json

Directory Path (one table per file)

box://remotePath

FTP or FTPS Single File Path One table

ftp://server:port/remotePath/file.json

Directory Path (one table per file)

ftp://server:port/remotePath

SFTP Single File Path One table

sftp://server:port/remotePath/file.json

Directory Path (one table per file)

sftp://server:port/remotePath

Sharepoint Single File Path One table

sp://https://server/remotePath/file.json

Directory Path (one table per file)

sp://https://server/remotePath

Example Connection Strings and Queries

Below are example connection strings to XML/JSON files or streams.

Service provider URI formats Connection example
Local Single File Path One table

localPath

file://localPath/file.json

Directory Path (one table per file)

localPath

file://localPath

URI=C:\folder1/file.json
Amazon S3 Single File Path One table

s3://bucket1/folder1/file.json

Directory Path (one table per file)

s3://bucket1/folder1

URI=s3://bucket1/folder1/file.json; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO;
Azure Blob Storage Single File Path One table

azureblob://mycontainer/myblob//file.json

Directory Path (one table per file)

azureblob://mycontainer/myblob/

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

URI=azureblob://mycontainer/myblob/; AzureStorageAccount=myAccount; InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth;

OneDrive Single File Path One table

onedrive://remotePath/file.json

Directory Path (one table per file)

onedrive://remotePath

URI=onedrive://folder1/file.json;InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth;

URI=onedrive://SharedWithMe/folder1/file.json;InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth;

Google Cloud Storage Single File Path One table

gs://bucket/remotePath/file.json

Directory Path (one table per file)

gs://bucket/remotePath

URI=gs://bucket/folder1/file.json; InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; ProjectId=test;
Google Drive Single File Path One table

gdrive://remotePath/file.json

Directory Path (one table per file)

gdrive://remotePath

URI=gdrive://folder1/file.json;InitiateOAuth=GETANDREFRESH;
Box Single File Path One table

box://remotePath/file.json

Directory Path (one table per file)

box://remotePath

URI=box://folder1/file.json; InitiateOAuth=GETANDREFRESH; OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345;
FTP or FTPS Single File Path One table

ftp://server:port/remotePath/file.json

Directory Path (one table per file)

ftp://server:port/remotePath

URI=ftps://localhost:990/folder1/file.json; User=user1; Password=password1;
SFTP sftp://server:port/remotePath URI=sftp://127.0.0.1:22/remotePath/file.json; User=user1; Password=password1;
Sharepoint sp://https://server/remotePath URI=sp://https://domain.sharepoint.com/Documents/file.json; User=user1; Password=password1;

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462