Create Dynamic Json on the go in expression functions inside mapping data flow (Azure Data Factory)

Question

I am trying to convert a csv file into json schema based collection. For json conversion, the only way I found was creating subcolumns for a column if you want hierarchy, Or you can use expressions like @(key1=value, @(key2=value2)) for json structures. What I want to do is Either pick key1 or key2 as parameters from dataflow/pipeline Or use it in a loop over an array such as map(array,@(#item=#item+2)). But It restricts me from doing that. However, I am able to traverse over values, But keys are something that needs to be only hardcoded. Please suggest a workaround if any.

Joseph Xu · Accepted Answer · 2020-08-04 01:36:36Z

1

In my opinion:

1: You can import the csv file into Azure SQL Database by using copy activity
2: Then you can work with JSON features in Azure SQL Database

edited Aug 4, 2020 at 1:36

answered Aug 3, 2020 at 3:07

Joseph Xu

6,1432 gold badges7 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create Dynamic Json on the go in expression functions inside mapping data flow (Azure Data Factory)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related