Qlik Salesforce Connector - relationship queries

ricardoluz — Tue, 21 Dec 2021 20:46:08 GMT

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;

Re: Qlik Salesforce Connector - relationship queries

Vimarsh — Tue, 15 Sep 2020 15:10:39 GMT

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!

topic Re: Qlik Salesforce Connector - relationship queries in Connectivity & Data Prep

Qlik Salesforce Connector - relationship queries

Re: Qlik Salesforce Connector - relationship queries