Ask Your Question

Salesforce origin, sub-queries in SOQL

asked 2018-06-10 10:19:42 -0600

peter_f gravatar image

updated 2018-06-10 10:21:17 -0600


Is there a way to handle sub-queries on relations? Like a customer with multiple cards, carts or any other 1:n relation.


SELECT Account.Id, (SELECT FirstName, LastName FROM Contacts) FROM Account WHERE Id > '${OFFSET}' ORDER BY Id

=> ERROR An exception occurred while running the pipeline, java.lang.NullPointerException

SELECT Id, (SELECT Id, Name FROM Cards__r) FROM Account WHERE Id > '${OFFSET}' AND Customer_ID__c = '000000009' ORDER BY Id

=> FORCE_04 - Record read failed: No type information for done. Specify component fields of compound fields, e.g. Location__Latitude__s or BillingStreet

Best Peter

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2018-06-10 20:24:45 -0600

metadaddy gravatar image

Currently, the Salesforce Origin doesn't support subqueries. Please create an issue at and we can look at adding them.

edit flag offensive delete link more


Hi Pat, Thank you for your response, I created an issue as suggested.

peter_f gravatar imagepeter_f ( 2018-06-11 03:10:45 -0600 )edit

Will be fixed in 3.4.0, tested with the nightly build and it works perfectly now, big thx Pat.

peter_f gravatar imagepeter_f ( 2018-06-15 02:59:15 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-06-10 10:19:42 -0600

Seen: 90 times

Last updated: Jun 10 '18