I am working with a third party software solution that consumes Salesforce API data via WDSL. I can run queries on any of the tables to return the result object - this works fine.
I need to get data from Account AND a custom table called Marketing_attributes. Their relationship is well defined and works well as a child-parent or parent-child query. However, the results I get back are nested, e.g. The marketing fields are nested within a column of the Accounts object that is returned.
The software that I'm working with cannot handle the nested object.it just sees one extra colum "Marketing Attributes" and not it's child elements.
I have tried various ways of querying the data with brackets, with dot notation, with dot notation transversing up or down etc. But whatever I do, it still returns a nested result.
Is there a way I can flatten the results? The Salesforce example:
SELECT Id, FirstName__c, Mother_of_Child__r.FirstName__c FROM Daughter__c WHERE Mother_of_Child__r.LastName__c LIKE 'C%'
Returns nested results - and this is basically how my query is setup today.
Any ideas? MAny thanks