[resolved] cannot use manual SOQL query in tSalesforceInput

One Star

[resolved] cannot use manual SOQL query in tSalesforceInput

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

Accepted Solutions
Five Stars

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

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

All Replies
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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.
One Star

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

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

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

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
One Star

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

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