GitHub user Jimmy-MooreMediaLabs added a comment to the discussion: Pass list of emails to Salesforce Input to return SalesforceId
I found the solution to the issue with a little more trial and error. I've included screenshots of the two pipelines I created to do this. ## Parent Pipeline  CSV -> Pipeline Executor -> Sort both the original input fields and resulting fields -> Join fields using Inner Join The execution data dummy transform is purely optional ### Pipeline Executor  Since I was querying on email, I used the input field 'ToAddress' from my csv and defined it as a variable 'ToEmailVar' to be used in the sub pipeline. Note that the definition of the variable in the parent pipeline doesn't use the "${}" syntax. I struggled with that for a bit. ## Child/Sub Pipeline  Get variable -> Salesforce Input -> Copy rows to result Just like defining the variable in the parent pipeline, this transform doesn't use "${}" to get the variable. When running the query in the salesforce input you ***do*** use the "${}" as pictured here:  Last thing to note in the sub pipeline is to have the salesforce input transform output into a Copy Rows to Result transform. Without this transform, you won't get any data in your parent pipeline. GitHub link: https://github.com/apache/hop/discussions/5039#discussioncomment-12530479 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
