camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Doug Douglass <douglass.d...@gmail.com>
Subject camel-salesforce component unable to unmarshall nested query results
Date Tue, 13 Dec 2016 23:18:23 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message