Qlik Salesforce Connector - relationship queries

[ricardoluz]

After upgrading the embedded Salesforce connector to version 15.3, the connector is no longer working with fields from multiple tables (relationship queries).

The documentation example results only null values for relationship tables.

//The LOAD Statements below will only work with SOAP (non-Bulk mode) of the Salesforce connection.
SalesforceConnectorMaster:
SELECT	 Name,
		(SELECT Name FROM Contacts), 
		(SELECT CaseNumber FROM Cases)
FROM Account
WHERE CreatedDate > 2019-11-26T00:00:00Z;


Account.Contacts:
LOAD Account.Contacts.Name,  
	PK_Account.Contacts AS Account.ContactsKey , 
	FK_AccountContacts AS AccountKey 
RESIDENT SalesforceConnectorMaster WHERE NOT IsNull([FK_AccountContacts]);

Account.Cases:
LOAD	Account.Cases.CaseNumber,  
	PK_Account.Cases AS Account.CasesKey , 
	FK_AccountCases AS AccountKey 
RESIDENT SalesforceConnectorMaster WHERE NOT IsNull([FK_AccountCases]);

Account:
LOAD Account.Name,  
	PK_Account AS AccountKey  
RESIDENT SalesforceConnectorMaster  WHERE NOT IsNull([PK_Account]);

DROP Table SalesforceConnectorMaster;

[Vimarsh]

Hi Ricardoluz,

Were you able to solve this issue? I am facing a similar problem where contact object's data is not getting loaded.
Appreciate any help!

Thanks!