Hi people!
I've connected Qlik Sense Enterprise to Salesforce using the native data connector (option SOAP). The connection works fine and I can export data using SOQL, but I can't export parameters from owners. For example, this query works:
SalesforceConnectorMaster:
SELECT Opportunity.Name,
Opportunity.CreatedBy.Name
FROM Opportunity
WHERE CreatedDate > 2023-05-26T00:00:00Z;
but this other doesn't work:
SalesforceConnectorMaster:
SELECT Opportunity.Name,
Opportunity.CreatedBy.Name,
Opportunity.Owner.Name
FROM Opportunity
WHERE CreatedDate > 2023-05-26T00:00:00Z;
This is the error message:
Connector reply error: Unable to get column information for the fields that are used in the query. Please make sure you have only one SELECT statement in a query editor. Description: Relationship queries with polymorphic key (keywords TYPEOF, Owner, Who and What) are not supported by the connector.
I can export all users and make a join in Qlik Sense, but it's inefficient. Many users doesn't have opportunities. Do you know if are there any option to export all in the same query?
Thanks!