Back to Community feed

Use list of results of a Lookup activity in a 'WHERE field IN list' condition in Azure Data Factory

as the title states, in an Azure Data Factory pipeline I am trying to use the results of a Lookup activity in a WHERE condition of a query against Salesforce. To be more detailed, the Lookup activity has the option 'Select only first row' NOT selected and it looks as follow: SELECT id FROM staging_table Then I am trying to pass the output to a Copy Data activity that runs a query against Salesforce using the output of the Lookup in a condition that looks like WHERE Id IN @output, however any kind of syntax I try for the activity output results in some errors, I only managed to get it working for the first result of the array. Thank you for any help you may provide!

How to implement marketing automation?

ActiveCampaign is a marketing and sales automation platform that helps growing businesses meaningfully connect and engage with their customers. Its SaaS platform enables businesses to create optimized customer experiences by automating many behind the scenes processes and communicating with their customers across channels with personalized messages.



Pipedrive is a Flexible, highly focused on driving the sales, and easy-to-use CRM software built by salespeople and marketing professionals with a single goal – to simplify your sales process and assist salespeople in clinching the deals. Using Pipedrive CRM you can focus on the right people at the right time and convert those people into deals.
6 answers, 0 articles