[resolved] cannot use manual SOQL query in tSalesforceInput

Five Stars

[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.
Five Stars

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.
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
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
Five Stars

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

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download