Cmdlets for JSON

Build 22.0.8479

URI Parameter (Connect-JSON Cmdlet)

JSON リソースロケーションのUniform Resource Identifier (URI)。

Syntax

Connect-JSON -URI string

Data Type

cstr

Default Value

""

Remarks

URI プロパティを設定して、ファイルまたはストリームへのパスを指定します。

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

複数ファイルのパースおよびマージに使用できる、より高度な機能については、データアクセスのファインチューニング を参照してください。

以下は、使用可能なデータソースのURI 形式の例です。

サービスプロバイダURI 形式
Local Single File Path One table

localPath/file.json

file://localPath/file.json

Directory Path (One aggregated table from all files)

localPath

file://localPath

HTTP またはHTTPS http://remoteStream

https://remoteStream

Amazon S3 Single File Path One table

s3://remotePath/file.json

Directory Path (One aggregated table from all files)

s3://remotePath

Azure Blob Storage Single File Path One table

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

Directory Path (One aggregated table from all files)

azureblob://mycontainer/myblob/

OneDrive Single File Path One table

onedrive://remotePath/file.json

Directory Path (One aggregated table from all files)

onedrive://remotePath

Google Cloud Storage Single File Path One table

gs://bucket/remotePath/file.json

Directory Path (One aggregated table from all files)

gs://bucket/remotePath

Google Drive Single File Path One table

gdrive://remotePath/file.json

Directory Path (One aggregated table from all files)

gdrive://remotePath

Box Single File Path One table

box://remotePath/file.json

Directory Path (One aggregated table from all files)

box://remotePath

FTP またはFTPS Single File Path One table

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

Directory Path (One aggregated table from all files)

ftp://server:port/remotePath

SFTP Single File Path One table

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

Directory Path (One aggregated table from all files)

sftp://server:port/remotePath

Sharepoint Single File Path One table

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

Directory Path (One aggregated table from all files)

sp://https://server/remotePath

接続文字列とクエリの例

以下は、JSON ファイルまたはストリームへの接続文字列の例です。

サービスプロバイダ URI 形式 Connection example
Local Single File Path One table

localPath

file://localPath/file.json

Directory Path (One aggregated table from all files)

localPath

file://localPath

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

s3://bucket1/folder1/file.json

Directory Path (One aggregated table from all files)

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 aggregated table from all files)

azureblob://mycontainer/myblob/

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

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

OneDrive Single File Path One table

onedrive://remotePath/file.json

Directory Path (One aggregated table from all files)

onedrive://remotePath

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

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

Google Cloud Storage Single File Path One table

gs://bucket/remotePath/file.json

Directory Path (One aggregated table from all files)

gs://bucket/remotePath

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

gdrive://remotePath/file.json

Directory Path (One aggregated table from all files)

gdrive://remotePath

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

box://remotePath/file.json

Directory Path (One aggregated table from all files)

box://remotePath

URI=box://folder1/file.json; 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 aggregated table from all files)

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.8479