topic Re: tSalesforce_Input - Returning NULL values - I have amended schema in Talend Studio

tSalesforce_Input - Returning NULL values - I have amended schema

Anonymous — Wed, 20 Jul 2016 10:17:05 GMT

Hi,
I am attempting to use a manual SOQL query from a tSalesforce_Input component:
"select
Account.LLC_BI__lookupKey__c,
Account.ID
,(Select Contact.LLC_BI__Home_City__c
,Contact.Home_Country__c
,Contact.LLC_BI__Home_Address__c
,Contact.LLC_BI__Home_Zipcode__c from Account.Contacts)
from Account"
Which seems to run correctly - however, i get NULL results on all the columns from the 'Contact' module.
I have read a lot of information about amending the schema for the linked module (i.e. nameofcurrentmodule_nameoflinkedmodule_nameofcolumn) and so my schema looks like this:
LLC_BI__lookupKey__c
Id
Account_Contact_LLC_BI__Home_City__c
Account_Contact_Home_Country__c
Account_Contact_LLC_BI__Home_Address__c
Account_Contact_LLC_BI__Home_Zipcode__c

Can anyone help me understand why my fields from the contact module returns only NULL Values?

Many thanks!

Re: tSalesforce_Input - Returning NULL values - I have amended schema

Anonymous — Wed, 20 Jul 2016 13:07:56 GMT

I've also tried approaching this as a child -> parent query and still get the same result.

The new query:

"Select Contact.AccountId
,Contact.Account.LLC_BI__lookupKey__c
, Contact.LLC_BI__Home_City__c
,Contact.Home_Country__c
,Contact.LLC_BI__Home_Address__c
,Contact.LLC_BI__Home_Zipcode__c from Contact"

Schema:

AccountId
Contact_Account_LLC_BI__lookupKey__c
LLC_BI__Home_City__c
Home_Country__c
LLC_BI__Home_Address__c
LLC_BI__Home_Zipcode__c

I get the results from the Contact module, but NULLs from Account?

Please can anyone help me?

Re: tSalesforce_Input - Returning NULL values - I have amended schema

TRF — Thu, 21 Jul 2016 12:59:21 GMT

Hi,
There is some limitations when working with custom SOQL queries into TOS.
Maybe this post could help you .
Also, the schema fields and Salesforce fields mus have the same name or you'll get a NULL value (in fact schema's field with a name different of the Salesforce fields are not populated and remain null).
Hope this helps.

Re: tSalesforce_Input - Returning NULL values - I have amended schema

Anonymous — Thu, 21 Jul 2016 14:12:51 GMT

@TRF - Thank you - I am aware of the limitations particularly relating to the schema, but my queries aren't particularly complex, and I have followed the user guide on how to edit the schema with the module name and columns etc. but it still returns only NULL values.

Can anyone suggest where I have gone wrong?

Re: tSalesforce_Input - Returning NULL values - I have amended schema

TRF — Fri, 22 Jul 2016 13:13:58 GMT

@monkeyb33f - can you share the link to the user guide you mentioned in your last post?
Regards,
FT

Re: tSalesforce_Input - Returning NULL values - I have amended schema

Anonymous — Fri, 22 Jul 2016 13:54:12 GMT

@ TRF - Sure.

The link for the query i used was:
[font=Calibri, sans-serif] https://developer.salesforce.com/blogs/developer-relations/2013/05/basic-soql-relationship-queries.html[/font]

The link for the schema guide was:
https://jira.talendforge.org/browse/TDI-6612

Many thanks!

Re: tSalesforce_Input - Returning NULL values - I have amended schema

Anonymous — Tue, 26 Jul 2016 10:01:35 GMT

I think from finding some old forum posts, Talend just doesn't support Parent to Child relationships in SOQL.

I can get a child to parent working.

Pretty disappointing if this functionality isn't in place.