https://community.qlik.com/t5/Talend-Studio/Extract-json-fields-from-an-rest-api-response/m-p/2338409#M106647 <P>Hi </P><P>You don't configure the Loop Jsonpath query parameter correctly. </P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000EZWF9AAP.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133820i45E074B1DE805929/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000EZWF9AAP.png" alt="0695b00000EZWF9AAP.png" /></span>We usually create a Json metadata and try to preview the data to check if we configure the settings correctly and it returns the data we want. </P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Wed, 21 Apr 2021 03:51:52 GMT Anonymous 2021-04-21T03:51:52Z https://community.qlik.com/t5/Talend-Studio/Extract-json-fields-from-an-rest-api-response/m-p/2338408#M106646 <P>Hello everybody,</P><P>I would like to retrieve a field from the result of an api request in json using tExtractJsonFields but I cannot get the right result.</P><P></P><P></P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000EYq6PAAT.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128417i518F25055214DDD7/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000EYq6PAAT.png" alt="0695b00000EYq6PAAT.png" /></span></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000EYq73AAD.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/139965iD1FA536160FA2CBA/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000EYq73AAD.png" alt="0695b00000EYq73AAD.png" /></span></P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000EYq6ZAAT.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138318iD1642EA00E8370D1/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000EYq6ZAAT.png" alt="0695b00000EYq6ZAAT.png" /></span></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000EYq6jAAD.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/141287iA27C8D4818C16F09/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000EYq6jAAD.png" alt="0695b00000EYq6jAAD.png" /></span></P><P></P><P></P><P>Any help please,</P><P>thank you in advance</P> Sat, 16 Nov 2024 00:14:50 GMT https://community.qlik.com/t5/Talend-Studio/Extract-json-fields-from-an-rest-api-response/m-p/2338408#M106646 oguedda 2024-11-16T00:14:50Z https://community.qlik.com/t5/Talend-Studio/Extract-json-fields-from-an-rest-api-response/m-p/2338409#M106647 <P>Hi </P><P>You don't configure the Loop Jsonpath query parameter correctly. </P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000EZWF9AAP.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133820i45E074B1DE805929/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000EZWF9AAP.png" alt="0695b00000EZWF9AAP.png" /></span>We usually create a Json metadata and try to preview the data to check if we configure the settings correctly and it returns the data we want. </P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Wed, 21 Apr 2021 03:51:52 GMT https://community.qlik.com/t5/Talend-Studio/Extract-json-fields-from-an-rest-api-response/m-p/2338409#M106647 Anonymous 2021-04-21T03:51:52Z https://community.qlik.com/t5/Talend-Studio/Extract-json-fields-from-an-rest-api-response/m-p/2338410#M106648 <P>HI,or you could use "$" in Jsonpath query and "token" in Json query if you want to extract other fields.</P><P>Send me Love and Kudos</P> Wed, 21 Apr 2021 08:13:15 GMT https://community.qlik.com/t5/Talend-Studio/Extract-json-fields-from-an-rest-api-response/m-p/2338410#M106648 gjeremy1617088143 2021-04-21T08:13:15Z