Parsing a JSON response

Six Stars

Parsing a JSON response

Hi Community!  I'm trying to read Microsoft TFS data via APIs and I'm stuck...

 

Using a tRestClient, I'm calling an API that returns this data (obviously I've cleansed it a bit) :
Screenshot_1_10_19__12_50_PM.png

The output I'm looking for is this:

ID, Rev, AreaPath, TeamProject, ...Description, url

20913, 2, name\\jack, Big Project, ...In Mobile only...,https:\\...

 

Bottom line...I need to create a database table and load it with this data.  The table should have a column for each "key" in this response from they key/value pairs

Please help...I'm banging my head here! 

 

Brad  

 

UPDATE: I switched the tExtractJSONFields from Read By=JSON Path to Xpath and now it's working

Thirteen Stars

Re: Parsing a JSON response


@bradsheridan wrote:

 

  

Brad  

 

UPDATE: I switched the tExtractJSONFields from Read By=JSON Path to Xpath and now it's working


Hi Brad, congratulations!

 

it works with both and JSONPath and XPath, depends on personal preferences

-----------

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.