Parsing a JSON response

[bradsheridan]

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) :

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

[vapukov]

---

@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