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

  • 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).
  • In reply to Maxime R.:

    Hi,

    Yes, that's possible.
    But what i thought here , DataLake Flows are using m3_eventHub connector to sync table changes with datalake.
    So if i use the same approach and save the table records in external database that would be easy.

    Thanks