Export data owners with Salesforce connector

pepAA — Wed, 31 May 2023 10:33:56 GMT

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!

topic Export data owners with Salesforce connector in Connectivity & Data Prep

Export data owners with Salesforce connector