Skip to main content

Data Factory

New

Array from Object | Azure Data Factory

Vote (1) Share
Plinio Nunez's profile image

Plinio Nunez on 13 Jan 2025 12:43:08

Hello,


currently we can't, for example, join attributes of an object array as a collection -- which is sometimes useful in API calls and often necessary in cases where stored procedure activities return a reasonable json aray.



[

{"Name": "A", "Age":22},

{"Name": "B", "Age":22},

{"Name": "C", "Age":22},

{"Name": "D", "Age":22},

]


from there could we have a function in the expression editor that could extract the collection Name as a list from that json? somethinbg like : @extractList(object=JsonObject, property="Name") outputs ==> ["A", "B", "C", "D"]