Hello @benny.wong ,
Thanks for the ask and using the Microsoft Q&A platform .
JSON is not a supported data type for MYSQL in ADF , please do check out the support data types here . For the second part of the ask you you please share the JSON ( please obfusticate the actual data ) ?
.
Thanks
Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members