The Infor Communities is globally accessed system by Infor and its customers, please do not post or upload any content that could be deemed as sensitive, confidential or subject to any data regulation requirements. If you are unsure whether or not the content contains sensitive, confidential or has any data regulation requirements, please seek the advice of your internal security, legal, and compliance experts.

Store JSON object in to external database

Hi,

 

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? 

 

Thanks