As per the above image M3_eventhub will return the MITMAS table record in JSON format.
I'm trying to store this record in external table by calling the stored procedure.
Following are the issues currently i'm facing at.
1. How to convert JSON in to XML with in document flow (because database connector only supports XML type)
2. Is there are any way i can store JSON file as it is in external table?
In reply to Maxime R.: