Designer version: 2019.2.5.62427
SalesforceInput_4.1.0
I have a relationship query that is not being parsed. I am getting the raw JSON back as the result. Has anyone run into this issue? Is there a workaround or a fix in the works to address this?
Query not being parsed:
SELECT Username,
FederationIdentifier,
Contact.FirstName,
Contact.LastName,
CompanyName,
Contact.Account.Name,
Title,
Email,
Phone,
LastLoginDate,
Profile.Name,
ContactID
FROM User
WHERE Profile.Name = 'System Administrator'
AND IsActive = TRUE
Query being parsed:
SELECT Username,
FederationIdentifier,
Contact.FirstName,
Contact.LastName,
CompanyName,
Title,
Email,
Phone,
LastLoginDate,
Profile.Name,
ContactID
FROM User
WHERE Profile.Name = 'System Administrator'
AND IsActive = TRUE
The only difference is the first query contains "Contact.Account.Name"...
