I'm new to Salesforce and was really hoping to make use of the camel-salesforce component to jump start an integration project.
Unfortunately, I've hit a wall and need to confirm whether the component should support unmarshalling results of query API call with a query containing a sub-select. For example: SELECT Id, ... (SELECT Id, Location_Type__c, ... FROM Account_Locations__r) FROM Account WHERE id = ... I elided most of the fields, but you get the idea. I was given this query by our Salesforce folks, and indeed it runs successfully via either the SOAP or ReST query APIs, but the DTO's generated by the camel-salesforce-maven-plugin provide access from e.g. QueryRecordsAccount to Account, but there's no Locations. I also tried to use the generated QueryRecordsAccount_Location__c DTO as the sObject parameter, and, while successful, all the requested fields just aren't part of the DTO's. Should the component be able to handle unmarshalling the results of such a query containing a sub-select? My alternative is to move on to using the SOAP API and the cxf components PAYLOAD data format and transform the XML query results directly to my target XML schema. Thanks in advance, Doug
