ADO.NET Provider for JSON

Build 20.0.7593

URI

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

データ型

string

デフォルト値

""

解説

Set the URI property to specify a path to a file or stream. This property is an alias to the DataSource property.

A comma-separated list of URIs is supported to include multiple files. See 高度な設定 for more advanced features available for parsing and merging multiple files.

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

Service providerURI formats
Local localPath/file.json

file://localPath/file.json

HTTP or HTTPS http://remoteStream

https://remoteStream

Amazon S3 s3://remotePath/file.json
Google Drive gdrive://remotePath/file.json
Box box://remotePath/file.json
FTP or FTPS ftp://server:port/remotePath/file.json

ftps://server:port/remotepath/file.json

SFTP sftp://server:port/remotePath/file.json
Sharepoint sp://https://server/remotePath/file.json

Example Connection Strings and Queries

Below are example connection strings to JSON files or streams.

Service providerURI formats Connection exampleQuery example (if folder1 contains file1.JSON or streamname1 is a JSON stream)
Local localPath

file://localPath/file.json

URI=C:\folder1/file.json SELECT * FROM file1
HTTP or HTTPS http://remoteStream

https://remoteStream

URI=http://www.host1.com/streamname1; SELECT * FROM streamedtable
Amazon S3 s3://bucket1/folder1/file.json URI=s3://bucket1/folder1/file.json; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO; SELECT * FROM file1
Google Drive gdrive://remotePath/file.json URI=gdrive://folder1/file.json;InitiateOAuth=GETANDREFRESH; SELECT * FROM file1
Box box://remotePath/file.json URI=box://folder1/file.json; InitiateOAuth=GETANDREFRESH; OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345;SELECT * FROM file1
FTP or FTPS ftp://server:port/remotePath/file.json

ftps://server:port/remotepath/file.json

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7593