Sep 27 2023 11:47 PM
Hi,
I am pushing data from SQL to an API rest sink with a copy activity. This is working fine. Now we added a column with multiple values. We need to format that column to a list. When I format this in SQL ADF creates an string output like this:
"custom.type" : "[\"type1\",\"type2\"]".
While I actually want this:
"custom.type" : ["Type1","Type2"]
I already changed the datatype to Array in the code representation in ADF but that does not seems to change. I know there are more option in dataflow for using complex JSON structures. But it would be silly and expensive to start a whole cluster for just this action.
Hope someone has a solution for this.
Thanks in advanced.
Ronald