Store JSON object in to external database

unknown

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

Find more posts tagged with

General Discussions

Accepted answers

All comments

Maxime Richard

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).

unknown

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

Copyright © 2025 Infor. All rights reserved.