https://community.qlik.com/t5/Talend-Studio/Parsing-a-JSON-response/m-p/2280898#M55601 <P>Hi Community!&nbsp; I'm trying to read Microsoft TFS data via APIs and I'm stuck...</P> <P>&nbsp;</P> <P>Using a tRestClient, I'm calling an API that returns this data (obviously I've cleansed it a bit) :<BR /><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot_1_10_19__12_50_PM.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M1te.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151817iB8B32E1793199D7E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M1te.png" alt="0683p000009M1te.png" /></span></SPAN></P> <P>The output I'm looking for is this:</P> <P>ID, Rev, AreaPath, TeamProject, ...Description, url</P> <P>20913, 2, name\\jack, Big Project, ...In Mobile only...,https:\\...</P> <P>&nbsp;</P> <P>Bottom line...I need to create a database table and load it with this data.&nbsp; The table should have a column for each "key" in this response from they key/value pairs</P> <P>Please help...I'm banging my head here!&nbsp;</P> <P>&nbsp;</P> <P>Brad&nbsp;&nbsp;</P> <P>&nbsp;</P> <P>UPDATE: I switched the tExtractJSONFields from Read By=JSON Path to Xpath and now it's working</P> Thu, 10 Jan 2019 17:58:27 GMT bradsheridan 2019-01-10T17:58:27Z https://community.qlik.com/t5/Talend-Studio/Parsing-a-JSON-response/m-p/2280898#M55601 <P>Hi Community!&nbsp; I'm trying to read Microsoft TFS data via APIs and I'm stuck...</P> <P>&nbsp;</P> <P>Using a tRestClient, I'm calling an API that returns this data (obviously I've cleansed it a bit) :<BR /><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot_1_10_19__12_50_PM.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M1te.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151817iB8B32E1793199D7E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M1te.png" alt="0683p000009M1te.png" /></span></SPAN></P> <P>The output I'm looking for is this:</P> <P>ID, Rev, AreaPath, TeamProject, ...Description, url</P> <P>20913, 2, name\\jack, Big Project, ...In Mobile only...,https:\\...</P> <P>&nbsp;</P> <P>Bottom line...I need to create a database table and load it with this data.&nbsp; The table should have a column for each "key" in this response from they key/value pairs</P> <P>Please help...I'm banging my head here!&nbsp;</P> <P>&nbsp;</P> <P>Brad&nbsp;&nbsp;</P> <P>&nbsp;</P> <P>UPDATE: I switched the tExtractJSONFields from Read By=JSON Path to Xpath and now it's working</P> Thu, 10 Jan 2019 17:58:27 GMT https://community.qlik.com/t5/Talend-Studio/Parsing-a-JSON-response/m-p/2280898#M55601 bradsheridan 2019-01-10T17:58:27Z https://community.qlik.com/t5/Talend-Studio/Parsing-a-JSON-response/m-p/2280899#M55602 <BLOCKQUOTE> <HR /> <A href="https://community.qlik.com/s/profile/00539000006EEg9AAG">@bradsheridan</A>&nbsp;wrote: <BR /> <P>&nbsp;</P> <P>&nbsp;&nbsp;</P> <P>Brad&nbsp;&nbsp;</P> <P>&nbsp;</P> <P>UPDATE: I switched the tExtractJSONFields from Read By=JSON Path to Xpath and now it's working</P> <HR /> </BLOCKQUOTE> <P>Hi Brad, congratulations!</P> <P>&nbsp;</P> <P>it works with both and JSONPath and XPath, depends on personal preferences</P> Tue, 15 Jan 2019 03:51:15 GMT https://community.qlik.com/t5/Talend-Studio/Parsing-a-JSON-response/m-p/2280899#M55602 vapukov 2019-01-15T03:51:15Z