https://community.qlik.com/t5/Talend-Studio/Salesforce-Lookup-Trouble/m-p/2305410#M77065 <P>I'm new to Talend and having some trouble. I'm pulling data from an AS400 and pushing it to a Salesforce custom object (currently a test file). That part is working fine, but I'm trying to add a lookup that will pull the Salesforce ID for the related account to the custom object. Can this be done in a single job or do I need to add a subjob?</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0693p00000AH7dzAAD.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132954iD2B40EB42F452E56/image-size/large?v=v2&amp;px=999" role="button" title="0693p00000AH7dzAAD.png" alt="0693p00000AH7dzAAD.png" /></span></P> Sat, 16 Nov 2024 01:08:54 GMT MGowan 2024-11-16T01:08:54Z https://community.qlik.com/t5/Talend-Studio/Salesforce-Lookup-Trouble/m-p/2305410#M77065 <P>I'm new to Talend and having some trouble. I'm pulling data from an AS400 and pushing it to a Salesforce custom object (currently a test file). That part is working fine, but I'm trying to add a lookup that will pull the Salesforce ID for the related account to the custom object. Can this be done in a single job or do I need to add a subjob?</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0693p00000AH7dzAAD.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132954iD2B40EB42F452E56/image-size/large?v=v2&amp;px=999" role="button" title="0693p00000AH7dzAAD.png" alt="0693p00000AH7dzAAD.png" /></span></P> Sat, 16 Nov 2024 01:08:54 GMT https://community.qlik.com/t5/Talend-Studio/Salesforce-Lookup-Trouble/m-p/2305410#M77065 MGowan 2024-11-16T01:08:54Z https://community.qlik.com/t5/Talend-Studio/Salesforce-Lookup-Trouble/m-p/2305411#M77066 <P>Yes, you can query the account information including the account ID from salesforce and do a lookup. From your screenshot, I see tSalesforceInput returns 0 rows, do you add any conditions in the query? If so, can you show us the query condition?</P> Tue, 10 Nov 2020 02:36:55 GMT https://community.qlik.com/t5/Talend-Studio/Salesforce-Lookup-Trouble/m-p/2305411#M77066 Anonymous 2020-11-10T02:36:55Z https://community.qlik.com/t5/Talend-Studio/Salesforce-Lookup-Trouble/m-p/2305412#M77067 <P>I was able to get it working. I simplified the job, removed the custom query on the lookup, and it started working.</P><P><span class="lia-inline-image-display-wrapper" image-alt="0693p00000AHQ90AAH.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151821i85F18D45D2AE3CBA/image-size/large?v=v2&amp;px=999" role="button" title="0693p00000AHQ90AAH.png" alt="0693p00000AHQ90AAH.png" /></span></P> Wed, 11 Nov 2020 14:23:13 GMT https://community.qlik.com/t5/Talend-Studio/Salesforce-Lookup-Trouble/m-p/2305412#M77067 MGowan 2020-11-11T14:23:13Z