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!
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.