Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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!