https://community.qlik.com/t5/Talend-Studio/trestclient-input-with-txmlmap-sort-feature/m-p/2360952#M125420 <P>Hi, I am calling an api in talend job using trestclient and txmlmap to map the child elements. API has below json structure. I wanted to know how can I get the latest id(301) from an details element based on the modified subelement. I have loop on details element</P><P></P><P></P><P>[</P><P>&nbsp;&nbsp;{</P><P>&nbsp;&nbsp;&nbsp;&nbsp;"sales_id": 100,</P><P> "details": [</P><P> {</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"id": 300,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"modified": "2022-09-11"</P><P>},</P><P>{</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"id": 301,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"modified": "2022-09-12",</P><P>} ] }]</P> Fri, 15 Nov 2024 21:22:12 GMT BhavikaW 2024-11-15T21:22:12Z https://community.qlik.com/t5/Talend-Studio/trestclient-input-with-txmlmap-sort-feature/m-p/2360952#M125420 <P>Hi, I am calling an api in talend job using trestclient and txmlmap to map the child elements. API has below json structure. I wanted to know how can I get the latest id(301) from an details element based on the modified subelement. I have loop on details element</P><P></P><P></P><P>[</P><P>&nbsp;&nbsp;{</P><P>&nbsp;&nbsp;&nbsp;&nbsp;"sales_id": 100,</P><P> "details": [</P><P> {</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"id": 300,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"modified": "2022-09-11"</P><P>},</P><P>{</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"id": 301,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"modified": "2022-09-12",</P><P>} ] }]</P> Fri, 15 Nov 2024 21:22:12 GMT https://community.qlik.com/t5/Talend-Studio/trestclient-input-with-txmlmap-sort-feature/m-p/2360952#M125420 BhavikaW 2024-11-15T21:22:12Z