[resolved] Null results when using Salesforce Input

[Anonymous]

Hi,
I've just recently started using Talend, and my first goal was to be able to export some data from Salesforce.com and into a SQL server database. I'm not having any trouble when trying to input an entire module. However, when I try to use SOQL to only select certain fields, I get all NULL results (for string fields...for integers I get 0). The row count of what I'm getting matches up with the row counts that are in the table. However no data shows up. This happens when inserting into SQL Server and outputting to a delimited flat file. Here's an example of a query that I'm using:
select ID,
Broker_Agent__c
FROM MLS_Approval_Request__c
I did some searching online and found that there is a registered bug where if the ID field isn't the first field selected then NULL results are returned. But as you can see that's not the case here. Anyone else know of anything that could be causing this? For now I can get around dumping the entire table and then querying from within SQL Server, but I'd prefer to just return the results that I'm using and do a single export using SOQL.
Thanks,
Joe

[Anonymous]

Hi,

It seems that's this problem isn't resolved at all. I have it too...

The query is like this : "Select Id, CustomField__c FROM Account Where CustomField__c !=null"

The number of lines is correct, the query works perfectly with the application Force.com but with Talend, the field CustomField__c is always Null.

I've found on https://help.talend.com/reader/_YDfvfhmdBzbX9dWMenklg/Lv~Pqm4u2XWOeTfUjL1xMA that there are tSalesforceInput Limitations when "the field with the underscore character '_' in its name"

But what can I do have the values, then ?

[LGTLEON]

Hi!

I have same issue with these query, Fecha_de_Nacimiento_c field is always returning null.

"SELECT CaseNumber,

CreatedDate,

Origin,

Tipo_de_consulta__c,

Reason,

Submotivo_de_la_consulta__c,

Status,

ClosedDate,

Envio_masivo__c,

N_de_Afiliado__c,

Account.Fecha_de_Nacimiento__c,

OwnerId

FROM Case"

What am I doing wrong? I know the query is correct because I have tried directly against SalesForce with correct results.

Thanks in advance

[LGTLEON]

Hi! I have just resolved the mistake. It was an schema issue. I was mapping an incorrect column name from SalesForce. Attached the correct schema.