Adding element to a json object in ADF

Question

Adding element to a json object in ADF

Kothai Ramanathan 946 Microsoft Employee

I have a pipeline which has an object as a parameter. This object contains a json. Want to know if there are any ADF inbuilt function through which I can add another element to this json.

Initial json :
{
'fistname":"abc"
{
New json :
{
'fistname":"abc",
"lastname":"xyz"
}

Is there any add/addElement() function which can add another element to the existing json.

Thanks,
Kothai.

HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2020-12-11T01:48:26.593+00:00

Hello @Kothai Ramanathan ,

Thanks for the ask and using the forum .

While I explore more on this , can you please eloborate more on the use case here please ?

Thanks
Himanshu
Kothai Ramanathan 946 Reputation points Microsoft Employee

2020-12-11T03:59:35.583+00:00

@HimanshuSinha-msft : We are creating generic patterned pipelines which are driven through configuration based out of json contexts. In some cases, it is needed that based on certain criteria, there is a need to modify the json context. Hence the ask, thanks

Accepted answer

0 additional answers

Your answer

HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2020-12-11T01:48:26.593+00:00

Hello @Kothai Ramanathan ,

Thanks for the ask and using the forum .

While I explore more on this , can you please eloborate more on the use case here please ?

Thanks
Himanshu
Kothai Ramanathan 946 Reputation points Microsoft Employee

2020-12-11T03:59:35.583+00:00

@HimanshuSinha-msft : We are creating generic patterned pipelines which are driven through configuration based out of json contexts. In some cases, it is needed that based on certain criteria, there is a need to modify the json context. Hence the ask, thanks

Answer 1

HarithaMaddi-MSFT 10,146

Hi @Kothai Ramanathan ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

There is no function to add element to JSON string in ADF and this can be achieved by using Azure Functions or indirectly using ADF with array variables which supports append operation. JSON can be converted to Array and then element can be appended to it which later can be converted to string and JSON while loading. Below are snaps related to it.

Please let us know for further queries and we will be glad to assist.

---

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
Want a reminder to come back and check responses? Here is how to subscribe to a notification.

Kothai Ramanathan 946 Reputation points Microsoft Employee

2020-12-11T11:02:20.507+00:00

Thank you @HarithaMaddi-MSFT for the details. I have gone the Azure Function route and that seemed simpler. It would be good if ADF supports some built-in JSON functions, thanks.

Share via

Adding element to a json object in ADF

0 additional answers

Your answer