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

Parents
  • Hi there,

    Why don't you use the standard BOD Sync.ItemMaster to send your XML file to the database ? I see that your incoming connection point is an application (M3). This application should send a BOD (and send in fact only BODs to ION because it's an Infor apps... standard or custom BOD).
Reply
  • Hi there,

    Why don't you use the standard BOD Sync.ItemMaster to send your XML file to the database ? I see that your incoming connection point is an application (M3). This application should send a BOD (and send in fact only BODs to ION because it's an Infor apps... standard or custom BOD).
Children