topic Re: [resolved] Null results when using Salesforce Input in Talend Studio

[resolved] Null results when using Salesforce Input

Anonymous — Sat, 16 Nov 2024 13:43:54 GMT

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

Re: [resolved] Null results when using Salesforce Input

Anonymous — Fri, 16 Oct 2009 07:33:37 GMT

Hello Joe
Can you get the correct result with SOQL when you select other standard module like User? eg:
"select ID,Username, Lastname, firstname,Name from User"
Best regards

shong

Re: [resolved] Null results when using Salesforce Input

Anonymous — Fri, 16 Oct 2009 21:14:47 GMT

Hi Shong,
It works fine when I pull from a standard module. I ran the query that you provided me and everything came back as expected. Do you think it's a bug that custom modules won't allow you to use SOQL?
- Joe

Re: [resolved] Null results when using Salesforce Input

Anonymous — Mon, 19 Oct 2009 07:11:39 GMT

Hello Joe
If you are attempting to use a custom object, be sure to append the '__c' after the entity name. eg:
"select ID, name from myObj__c"
Note that here is double _
Best regards
shong

Re: [resolved] Null results when using Salesforce Input

Anonymous — Wed, 21 Oct 2009 18:46:40 GMT

I am using the double underscore. If you refer back to my first post you'll see that I have it in both the field I'm selecting and the table I'm selecting from.

Re: [resolved] Null results when using Salesforce Input

Anonymous — Thu, 22 Oct 2009 03:24:52 GMT

Hello guy
I get the same problem, all the custom fields are null, can you report a bug on our bugtracker?
Thanks for your support!!!
Best regards

shong

Re: [resolved] Null results when using Salesforce Input

Anonymous — Wed, 28 Oct 2009 09:47:22 GMT

Hello Jrugolo810
Just found that we should aslo add the '__c' on the column name on schema. Note that the filed name is case-sensitive.
Best regards

shong

Re: [resolved] Null results when using Salesforce Input

Anonymous — Mon, 20 Jun 2011 11:25:46 GMT

I've just recently started using Talend, As per my requirement I need to fetch the data of salesforce account object.
The query which I am using to fetch the account records ("Select Id from Account").
I have a table ("Customer") in sql server. I need to fetch records of Customer table and I want to use the Salesforce account Ids in the where clause of that query.
Can anyone tell me how can I do that.
Thanks,
Devendra

Re: [resolved] Null results when using Salesforce Input

Anonymous — Wed, 04 Jul 2012 13:56:45 GMT

Hi,
Did you ever find a solution to your problem? I'm sitting with exactly the same problem, but with the little twist that if if go with the string:
"SELECT Id, Unit_Price__c FROM Equipment_Data__c"
I get a correct value of the Unit_Price__c field.
But if I use the string:
"SELECT Id, Unit_Price__c, CreatedById, CreatedDate, Deal_Type__c, IsDeleted, Install_Date__c, Install_Sell_Out_Date__c, LastModifiedById, LastModifiedDate, Opportunity__c, Order_Date__c, Install_Outlook__c, Outlook_Install_Date__c, Product__c, Quantity__c, Total_Price__c, Transaction_type__c FROM Equipment_Data__c"
The field Unit_Price__c return a zero value.... (null).
What can be the problem?
Thanks.
Best regards,
Nicolai

Re: [resolved] Null results when using Salesforce Input

Anonymous — Fri, 04 Oct 2013 09:37:39 GMT

Hi,
has anyone had any luck with finding what is causing this problem? Or perhaps someone found a workaround? npaustian's workaround isn't working for me.
Thanks,
Ivan

Re: [resolved] Null results when using Salesforce Input

Anonymous — Sat, 04 Aug 2018 06:06:25 GMT

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 ?

Re: [resolved] Null results when using Salesforce Input

LGTLEON — Fri, 28 Jul 2023 05:36:03 GMT

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

Re: [resolved] Null results when using Salesforce Input

LGTLEON — Fri, 28 Jul 2023 06:06:50 GMT

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.