https://community.qlik.com/t5/Connectivity-Data-Prep/Load-Sub-Level-Hierarchies-of-local-JSON-using-Qlik-General-Web/m-p/1786117#M5803 <P>Dear all,</P><P>I've a Qlik Sense environment and i'm using Qlik General Web Connector to load JSON file from my local hard disk:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2021-02-25 12_09_29-Qlik Web Connectors _ Qlik General Web Connector.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49851iCA19E764FD483C8A/image-size/large?v=v2&amp;px=999" role="button" title="2021-02-25 12_09_29-Qlik Web Connectors _ Qlik General Web Connector.png" alt="2021-02-25 12_09_29-Qlik Web Connectors _ Qlik General Web Connector.png" /></span></P><P>The connector works correctly to load first level hierarchy of my json but what i have to do to load second level information (Highlighted in yellow)?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2021-02-25 12_07_40-C__Users_denardm2_Downloads_Sample Data.json - Notepad++ [Administrator].png" style="width: 374px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49849i8B2CD14F974C549D/image-size/large?v=v2&amp;px=999" role="button" title="2021-02-25 12_07_40-C__Users_denardm2_Downloads_Sample Data.json - Notepad++ [Administrator].png" alt="2021-02-25 12_07_40-C__Users_denardm2_Downloads_Sample Data.json - Notepad++ [Administrator].png" /></span></P><P>Attached you can find the sample data i'm using.</P><P>I've tried to use XPATH parameters with DATA/vehicles or ./vehicles without success.</P> Tue, 21 Dec 2021 20:47:14 GMT micheledenardi 2021-12-21T20:47:14Z https://community.qlik.com/t5/Connectivity-Data-Prep/Load-Sub-Level-Hierarchies-of-local-JSON-using-Qlik-General-Web/m-p/1786117#M5803 <P>Dear all,</P><P>I've a Qlik Sense environment and i'm using Qlik General Web Connector to load JSON file from my local hard disk:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2021-02-25 12_09_29-Qlik Web Connectors _ Qlik General Web Connector.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49851iCA19E764FD483C8A/image-size/large?v=v2&amp;px=999" role="button" title="2021-02-25 12_09_29-Qlik Web Connectors _ Qlik General Web Connector.png" alt="2021-02-25 12_09_29-Qlik Web Connectors _ Qlik General Web Connector.png" /></span></P><P>The connector works correctly to load first level hierarchy of my json but what i have to do to load second level information (Highlighted in yellow)?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2021-02-25 12_07_40-C__Users_denardm2_Downloads_Sample Data.json - Notepad++ [Administrator].png" style="width: 374px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49849i8B2CD14F974C549D/image-size/large?v=v2&amp;px=999" role="button" title="2021-02-25 12_07_40-C__Users_denardm2_Downloads_Sample Data.json - Notepad++ [Administrator].png" alt="2021-02-25 12_07_40-C__Users_denardm2_Downloads_Sample Data.json - Notepad++ [Administrator].png" /></span></P><P>Attached you can find the sample data i'm using.</P><P>I've tried to use XPATH parameters with DATA/vehicles or ./vehicles without success.</P> Tue, 21 Dec 2021 20:47:14 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Load-Sub-Level-Hierarchies-of-local-JSON-using-Qlik-General-Web/m-p/1786117#M5803 micheledenardi 2021-12-21T20:47:14Z