topic Re: [resolved] cannot use manual SOQL query in tSalesforceInput in Talend Studio

[resolved] cannot use manual SOQL query in tSalesforceInput

Anonymous — Sat, 16 Nov 2024 11:34:29 GMT

Hi,
I am using Talend Open Studio for Data Integration.
I would like to retrieve the columns from Salesforce tables based on manual SOQL queries.
Although I write the query, when I press View Schema I still see all the columns in the respective table.
Is this option not suported by TOS?
The reason I need to write manual queries is to take also the currency converted value in Salesforce.
Thanks

Re: [resolved] cannot use manual SOQL query in tSalesforceInput

Anonymous — Thu, 24 Jul 2014 03:36:11 GMT

Hi,
We support for SOQL query in tSalesforceInput. Please see jira issue:https://jira.talendforge.org/browse/TDI-6612.
What's your manual SOQL queries?
Best regards
Sabrina

Re: [resolved] cannot use manual SOQL query in tSalesforceInput

Anonymous — Mon, 28 Jul 2014 12:40:09 GMT

Hi Sabrina,
Thanks for taking over my issue. A lot of your answears were very useful in my "Talend journey".
I am using TOS 5.3.1 on windows.
In my querry I want to get also the converted EUR value but I do not think it has to do with the querry (It is the same no matter of the querry. )
For ex in tPostgresqlInput after inserting a manual query I have the "Guess Schema " button. But in tSalesforceInput no.
I insert the simplest query: "select Name from Account" and when go to "Edit Schema " or check in the tmap, I find all the fields in the Account module.
Please find attached the settings that I have.
Thanks.

Re: [resolved] cannot use manual SOQL query in tSalesforceInput

Anonymous — Wed, 06 Aug 2014 09:46:37 GMT

Does anyone know what the problem is or what I am doing wrong?
Thanks

Re: [resolved] cannot use manual SOQL query in tSalesforceInput

Anonymous — Wed, 06 Aug 2014 13:14:33 GMT

Does anyone know what the problem is or what I am doing wrong?
Thanks

The Salesforce objects and fields come from closed lists defined win the components definition files.
The component does not support guess schema.
I believe your only option is to manually change the schema
You could look at defining schemas within the repository which may help you

Re: [resolved] cannot use manual SOQL query in tSalesforceInput

Anonymous — Fri, 08 Aug 2014 18:19:50 GMT

I have manually changed the schema and it worked.
Thanks a lot for your suggestion!