Need to filter fields from a Json Array in data flow in Azure Data factory

Philip, Binil 1 Reputation point
2021-07-25T15:24:03.913+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.