Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Qlik Salesforce Connector - relationship queries

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;

Relationship.PNG

 

Labels (3)
0 Replies