Need to filter fields from a Json Array in data flow in Azure Data factory
Hello ,
I am trying to filter some values from a json array ,
trued using filter function in dataflow but its not returning any value ,
I only need three fields from the below structure ,
Have tried using the expression as below ,
filter(directTerritory, toString(#item) == 'vendorNumber' || toString(#item) == 'vendorAccountName')
the structure of json data is as such below ,
"directTerritory": [
{
"vendorNumber": "str1234",
"vendorAccountName": "str1234",
"directTerritory": "st",
"directTerritoryDescription": "str1234",
"irishTerritory": "s"
},
{
"vendorNumber": "str1234",
"vendorAccountName": "str1234",
"directTerritory": "st",
"directTerritoryDescription": "str1234",
"irishTerritory": "s"
},
{
"vendorNumber": "str1234",
"vendorAccountName": "str1234",
"directTerritory": "st",
"directTerritoryDescription": "str1234",
"irishTerritory": "s"
}
]
can some one help me on this or any other way achieving the result