Talend community forum / Store in Talend an ID sent from salesforce, for an ESBProviderRequest

prav_raj · 2012-05-23 07:37:15

Tags: [development, integration, Salesforce, store, webservice]

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.

pedro · 2012-05-23 07:48:12

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

prav_raj · 2012-05-23 08:10:03

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?

pedro · 2012-05-23 08:22:34

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.

Code:

"Id="+row1.ID

Regards,
Pedro

prav_raj · 2012-05-23 13:52:27

Hi Pedro,

Thanks. It worked.

Announcement

Unanswered posts

#1 2012-05-23 07:37:15

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

#2 2012-05-23 07:48:12

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

#3 2012-05-23 08:10:03

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

#4 2012-05-23 08:22:34

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

Code:

#5 2012-05-23 13:52:27

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

Board footer