Ask Your Question
1

Salesforce origin, sub-queries in SOQL

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

peter_f gravatar image

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

Hi,

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

e.g.:

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
0

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

metadaddy gravatar image

Currently, the Salesforce Origin doesn't support subqueries. Please create an issue at https://issues.streamsets.com/ and we can look at adding them.

edit flag offensive delete link more

Comments

Hi Pat, Thank you for your response, I created an issue as suggested. https://issues.streamsets.com/browse/SDC-9251

peter_f gravatar imagepeter_f ( 2018-06-11 03:10:45 -0500 )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 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 11 times

Last updated: Jun 10