topic Re: Print query from Salesforce component in Talend Studio

Print query from Salesforce component

Anonymous — Sat, 16 Nov 2024 05:42:52 GMT

Hi,

is there any way to print from system side the query done from the tsalesforceinput component?

Thanks

Iris

Re: Print query from Salesforce component

Anonymous — Wed, 29 May 2019 14:46:56 GMT

Hi,

Could you please share more details with some examples?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Print query from Salesforce component

Anonymous — Wed, 29 May 2019 17:08:34 GMT

Hi, from a tSalesforceinput component I need to print the query that is executed, as done for the tOracleInput with the 'tOracleInput_1_QUERY' variable. Thanks

Re: Print query from Salesforce component

Anonymous — Wed, 29 May 2019 18:30:44 GMT

Hi,

Right now, this Talend component do not have Query variable added to it. As an alternative, you can first create a query and add to a context variable. Then use this query variable both in SalesforceInput component and anywhere else.

This will be the most easy way to handle the current situation.

I would also recommend you to raise a JIRA ticket specifying this enhancement request for Salesforce component.

https://JIRA.talendforge.org

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Print query from Salesforce component

Anonymous — Thu, 06 Jun 2019 09:50:56 GMT

Hi, the problem is also that the string context variable is limited and cannot contain all the query I want to launch. Is there any workaround for this? Thanks

Re: Print query from Salesforce component

TRF — Thu, 06 Jun 2019 10:18:03 GMT

Use a global variable and don't forget SOQL query length is limited to 20,000 characters