Skip to Content
0
Dec 27, 2022 at 08:46 AM

How to use "dynamic content" as a filter in SAP CDC connector in Azure Data factory

406 Views Last edit Jan 03, 2023 at 08:04 AM 2 rev

I'm trying to use SAP CDC linked service in my ADF pipeline to import some data. And also there is an option to filter out some data on source side using "Selection" part of copy activity source configuration. This part gives possibility to select from drop-down list column and logical operators to use for filtering value. Also there is an option to replace it with entire expression as a dynamic content, but when I try add there any logical expression it fails with error:

The value of property 'selection' is in unexpected type 'List`1'.

So the question is - what is the syntax of that expression that can be used as a filter on SAP side?