ADF - how to remove the square bracket from json as a source.

Question

My source is json file and target is API. This extra square bracket is failing to post in the target API. Anything to be done in mapping which I am missing ? I have created items collection using dataflow.

Please help.

Answer 1

Hi @Anurag Yadav ,
Welcome to Microsoft Q&A platform and thanks for posting your question here.

You can try making use of substring() function or substringIndex() function to remove '[' and ']' from start and end.

For example:

Here I am trying to remove the leftmost and rightmost brackets from the following array of json: [{"items":[{"product_id":"123"}]}] by using substringIndex(substringIndex(Column_1, '[', -2),']',2)

Please refer to the below screenshot:

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  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
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators