https://community.qlik.com/t5/Talend-Studio/tExtractJSONFields-dot-in-the-column-names/m-p/2338734#M106943 <P>In the Json query, this syntax should work:</P><P>"$[\'A.DEPTID\']"</P> Fri, 24 Mar 2023 16:12:49 GMT SCTalend1656344690 2023-03-24T16:12:49Z https://community.qlik.com/t5/Talend-Studio/tExtractJSONFields-dot-in-the-column-names/m-p/2338733#M106942 <P>Hello,</P><P>I'm using the tExtractJSONFields&nbsp;to extract fields from the API result.</P><P>Some of the API columns have dot in the column name. I'm getting NULLs for all the fields with dot in the name.</P><P>Is there any way to resolve it?</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000fILDBAA4.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154025i416DF7BE64C395B6/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000fILDBAA4.png" alt="0695b00000fILDBAA4.png" /></span> </P> Fri, 15 Nov 2024 21:57:33 GMT https://community.qlik.com/t5/Talend-Studio/tExtractJSONFields-dot-in-the-column-names/m-p/2338733#M106942 COW_WW 2024-11-15T21:57:33Z https://community.qlik.com/t5/Talend-Studio/tExtractJSONFields-dot-in-the-column-names/m-p/2338734#M106943 <P>In the Json query, this syntax should work:</P><P>"$[\'A.DEPTID\']"</P> Fri, 24 Mar 2023 16:12:49 GMT https://community.qlik.com/t5/Talend-Studio/tExtractJSONFields-dot-in-the-column-names/m-p/2338734#M106943 SCTalend1656344690 2023-03-24T16:12:49Z https://community.qlik.com/t5/Talend-Studio/tExtractJSONFields-dot-in-the-column-names/m-p/2338735#M106944 <P>It worked! Thank you</P> Fri, 24 Mar 2023 16:54:53 GMT https://community.qlik.com/t5/Talend-Studio/tExtractJSONFields-dot-in-the-column-names/m-p/2338735#M106944 COW_WW 2023-03-24T16:54:53Z