URI
The Uniform Resource Identifier (URI) for the CSV 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.
- If specifying a directory path, it is generally recommended to end the URI with a trailing path separator character, as an example 'folder1/' instead of 'folder1'.
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 provider | URI formats | |
| Local | Single File Path One table
localPath/file.csv file://localPath/file.csv 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.csv Directory Path (one table per file) s3://remotePath | |
| Azure Blob Storage | Single File Path One table
azureblob://mycontainer/myblob//file.csv Directory Path (one table per file) azureblob://mycontainer/myblob/ | |
| OneDrive | Single File Path One table
onedrive://remotePath/file.csv Directory Path (one table per file) onedrive://remotePath | |
| Google Cloud Storage | Single File Path One table
gs://bucket/remotePath/file.csv Directory Path (one table per file) gs://bucket/remotePath | |
| Google Drive | Single File Path One table
gdrive://remotePath/file.csv Directory Path (one table per file) gdrive://remotePath | |
| Box | Single File Path One table
box://remotePath/file.csv Directory Path (one table per file) box://remotePath | |
| FTP or FTPS | Single File Path One table
ftp://server:port/remotePath/file.csv Directory Path (one table per file) ftp://server:port/remotePath | |
| SFTP | Single File Path One table
sftp://server:port/remotePath/file.csv Directory Path (one table per file) sftp://server:port/remotePath | |
| SharePoint SOAP | Single File Path One table
sp://library/folder/file.csv Directory Path (one table per file) sp://library/folder/ Use the Sharepoint URL as the remote path. Not the display name. | |
| SharePoint GRAPH | Single File Path One table
spgraph://library/folder/file.csv Directory Path (one table per file) spgraph://library/folder/ Use the Sharepoint URL as the remote path. Not the display name. | |
| SharePoint REST V1 | Single File Path One table
sprestv1://library/folder/file.csv Directory Path (one table per file) sprestv1://library/folder/ Use the Sharepoint URL as the remote path. Not the display name. |
Example Connection Strings and Queries
Below are example connection strings to CSV files or streams.
| Service provider | URI formats | Connection example |
| Local | Single File Path One table
localPath file://localPath/file.csv Directory Path (one table per file) localPath file://localPath | URI=C:\folder1/file.csv |
| Amazon S3 | Single File Path One table
s3://bucket1/folder1/file.csv Directory Path (one table per file) s3://bucket1/folder1 | URI=s3://bucket1/folder1/file.csv; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO; |
| Azure Blob Storage | Single File Path One table
azureblob://mycontainer/myblob//file.csv 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.csv Directory Path (one table per file) onedrive://remotePath | URI=onedrive://folder1/file.csv;InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth;
URI=onedrive://SharedWithMe/folder1/file.csv;InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; |
| Google Cloud Storage | Single File Path One table
gs://bucket/remotePath/file.csv Directory Path (one table per file) gs://bucket/remotePath | URI=gs://bucket/folder1/file.csv; InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; ProjectId=test; |
| Google Drive | Single File Path One table
gdrive://remotePath/file.csv Directory Path (one table per file) gdrive://remotePath | URI=gdrive://folder1/file.csv;InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; |
| Box | Single File Path One table
box://remotePath/file.csv Directory Path (one table per file) box://remotePath | URI=box://folder1/file.csv; InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345; |
| FTP or FTPS | Single File Path One table
ftp://server:port/remotePath/file.csv Directory Path (one table per file) ftp://server:port/remotePath | URI=ftps://localhost:990/folder1/file.csv; User=user1; Password=password1; |
| SFTP | sftp://server:port/remotePath | URI=sftp://127.0.0.1:22/remotePath/file.csv; User=user1; Password=password1; |
| SharePoint SOAP | Single File Path One table
sp://library/folder/file.csv Directory Path (one table per file) sp://library/folder/ Use the Sharepoint URL as the remote path. Not the display name. | URI=sp://Shared Documents/folder1/file.csv; User=user1; Password=password1; StorageBaseURL=https://subdomain.sharepoint.com; |
| SharePoint GRAPH | Single File Path One table
spgraph://library/folder/file.csv Directory Path (one table per file) spgraph://library/folder/ Use the Sharepoint URL as the remote path. Not the display name. | URI=spgraph://Shared Documents/folder1/file.csv; InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; StorageBaseURL=https://subdomain.sharepoint.com; |
| SharePoint REST V1 | Single File Path One table
sprestv1://library/folder/file.csv Directory Path (one table per file) sprestv1://library/folder/ Use the Sharepoint URL as the remote path. Not the display name. | URI=sprestv1://Shared Documents/folder1/file.csv; AuthScheme=NTLM; User=user1; Password=password1; StorageBaseURL=http://sharepointserver/sites/mysite; |