Store in Talend an ID sent from salesforce, for an ESBProviderRequest

One Star

Store in Talend an ID sent from salesforce, for an ESBProviderRequest

Hi All,
I'm a newbie to talend. I'm trying to integrate salesforce with Talend. My requirement is like, I need to call a web service in Talend from Salesforce, while calling that webservice I need to send an ID as a parameter, Talend has to store that ID and use it retrive details using the tSalesforceInput component.
I'm stuck as how to store the ID and use it for the tSalesforce input.
Can anyone give me suggestions as how it should be done?
Thanks.
One Star

Re: Store in Talend an ID sent from salesforce, for an ESBProviderRequest

Hi
Welcome to Talend Community.
According to your description, you can simply use the tSalesforceInput component which calls "https://www.salesforce.com/services/Soap/u/xx.0" salesforce webservice.
Select the Module you want and type ID into 'Query Condition'.
Regards,
Pedro
One Star

Re: Store in Talend an ID sent from salesforce, for an ESBProviderRequest

Hi Pedro,
Thanks for responding.
I have already tried the method you suggested, the trouble there is it like I have to hard code the ID i want in the query condition, I want to store the ID,Talend gets from salesforce and use it dynamically in the query condition, I might even require to query a list of IDs. any ideas on this?
One Star

Re: Store in Talend an ID sent from salesforce, for an ESBProviderRequest

Hi
Let's say there is a column called ID in input component(e.g tFileInputDelimited).
tFileInputDelimited-->main-->tFlowToIterat--Iterate->tSalesforceInput--main-->tLogRow
Modify 'Query Condition' as this.
"Id="+row1.ID

Regards,
Pedro
One Star

Re: Store in Talend an ID sent from salesforce, for an ESBProviderRequest

Hi Pedro,
Thanks. It worked.