tSalesforce_Input - Returning NULL values - I have amended schema
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?
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.
@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.
