Create a File - JSON adapter, similar to the File - XML adapter

Hello

so if I understand this post;  if I am reading data from a REST service that outputs JSON, I should be able to format this output into a delimited format?   I only ask, because we have shown that Tibco DV can convert JSON into tabular or comma separated, but it does a horrible job flattening the results into a coherent file; especially if the nesting (levels) is not consistent.  Does the workaround you describe below take a heavily nested JSON output, and convert into a delimited file with the correct column and rows?

Michelle Lacy

I've followed the instructions to the best of my ability, as well as enlisted a web developer but we've been unable to get this to work.

Hi Brian,

Until our File-based adapter can connect to JSON natively there is a fairly simply workaround you 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.

-Jeremy

Hi Brian, 

Thanks for submitting.  See TDV-I-4.  I think that has this covered.  

Thanks, 
Jason