Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Created by Guest
Created on Jan 18, 2018

Add a file adapter to connect to JSON files directly

Extend the flat file support of the server to connect directly to JSON files to read in data.
  • Attach files
  • Guest
    May 21, 2018

    Until our File-based adapter can connect to JSON natively there is a fairly simply workaround users can implement in the meantime:

    You can use the Jetty HTTP server instance that comes with DV as the lightweight web server to host your JSON files. It's recommended that you create a symlink to an external folder and place the symlink in this directory:

    <TDV Install>apps/server/webapps/home

    Then you can access the files using a REST data source adapter (Instead of the File-based adapter) with the URL:

    http://localhost:9400/<name of your symlink folder>/

    And then create individual GET operations in the REST adapter for each file you need to access.

  • Guest
    May 10, 2018

    Use case from Brian Anderson:

    We get numerous data files that are constructed with JSON. We need to import these files, transform them then either output them as database views, or export them as csv files.