My task is to import JSON file into SQL table using ADF.
What am I doing wrong while importing JSON to SQL table? I've attached JSON file and code from ADF. I'm using Copy activity in ADF pipeline.
It looks like only the first row gets imported. How can I tell ADF mapping to go to next set of data? Is it even possible to do so?
I've attached the files that may be helpful for you to figure out what the issue could be.
Any help on this would be much appreciated as I'm going nuts over this.
Thanks in advance.