The CData Excel Add-In for JSON is designed for streaming JSON only.

This streamed file content does not include all of the metadata associated with remotely stored JSON files, such as file and folder name.

If access to both the file metadata and the actual file content is needed, then the CData Excel Add-In for JSON must be used in tandem with the associated file system driver(s) for the service the JSON files are remotely stored in.

The following file system drivers are available:

• AmazonS3
• Box
• Dropbox
• FTP
• GoogleCloudStorage
• IBLCloudObjectStorage
• OneDrive
• SFTP

See the relevant CData file system driver's documentation for a configuration guide for connecting to stored JSON file metadata.