https://community.qlik.com/t5/Talend-Studio/tsalesforceinput-dynamic-schema-SOQL-join-query/m-p/2217731#M13206 <P>Hello,</P> <P>Did you set&nbsp;<SPAN><SPAN style="word-wrap: break-word;"><SPAN style="color: #000; word-wrap: break-word;"> tSalesforceInput component with one column of type "Dynamic"? Are you able to execute your job by using your query as "SELECT * FROM Contact limit 10"?</SPAN></SPAN></SPAN></P> <P><SPAN><SPAN style="word-wrap: break-word;"><SPAN style="color: #000; word-wrap: break-word;">Could you please give us some screenshots of your job?</SPAN></SPAN></SPAN></P> <P><SPAN><SPAN style="word-wrap: break-word;"><SPAN style="color: #000; word-wrap: break-word;">Best regards</SPAN></SPAN></SPAN></P> <P><SPAN><SPAN style="word-wrap: break-word;"><SPAN style="color: #000; word-wrap: break-word;">Sabrina</SPAN></SPAN></SPAN></P> Fri, 28 Sep 2018 09:20:45 GMT Anonymous 2018-09-28T09:20:45Z https://community.qlik.com/t5/Talend-Studio/tsalesforceinput-dynamic-schema-SOQL-join-query/m-p/2217730#M13205 <P>Hi All,&nbsp;</P><P>&nbsp;</P><P>The Below query executes fine with a fixed schema in tsalesforceinput component. We need to implement dynamic schema since the query changes time to time. When we switch to dynamic schema, the field&nbsp;<SPAN>Account.FirstName is not being pulled. Has anyone faced a similar issue ?</SPAN></P><P>&nbsp;</P><P>"SELECT Name,ID, Account.FirstName FROM Contact limit 10"</P> Sat, 16 Nov 2024 07:35:09 GMT https://community.qlik.com/t5/Talend-Studio/tsalesforceinput-dynamic-schema-SOQL-join-query/m-p/2217730#M13205 ravi999 2024-11-16T07:35:09Z https://community.qlik.com/t5/Talend-Studio/tsalesforceinput-dynamic-schema-SOQL-join-query/m-p/2217731#M13206 <P>Hello,</P> <P>Did you set&nbsp;<SPAN><SPAN style="word-wrap: break-word;"><SPAN style="color: #000; word-wrap: break-word;"> tSalesforceInput component with one column of type "Dynamic"? Are you able to execute your job by using your query as "SELECT * FROM Contact limit 10"?</SPAN></SPAN></SPAN></P> <P><SPAN><SPAN style="word-wrap: break-word;"><SPAN style="color: #000; word-wrap: break-word;">Could you please give us some screenshots of your job?</SPAN></SPAN></SPAN></P> <P><SPAN><SPAN style="word-wrap: break-word;"><SPAN style="color: #000; word-wrap: break-word;">Best regards</SPAN></SPAN></SPAN></P> <P><SPAN><SPAN style="word-wrap: break-word;"><SPAN style="color: #000; word-wrap: break-word;">Sabrina</SPAN></SPAN></SPAN></P> Fri, 28 Sep 2018 09:20:45 GMT https://community.qlik.com/t5/Talend-Studio/tsalesforceinput-dynamic-schema-SOQL-join-query/m-p/2217731#M13206 Anonymous 2018-09-28T09:20:45Z