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.
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:
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.
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.
Use case from Brian Anderson: