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 Account.FirstName is not being pulled. Has anyone faced a similar issue ?
"SELECT Name,ID, Account.FirstName FROM Contact limit 10"
Did you set 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"?
Could you please give us some screenshots of your job?
