Report data directly to SQL database

I would like also to ask if it’s possible to transfer the reports data directly to the SQL database or to generate the report files in the JSON format.

Thank you.

@denis_kaliberov

SQL
We cannot directly insert in the MySql db as there needs to be an interface for us to send the data. Do they have a way to insert the data after parsing the form? Perhaps it would work to set up the Data Mailbox and then you could write a custom tool to read and insert the data. Similar topic located here:Communication with webservices SQL

Json

The eWON allows you to create custom report files, and you could just create a template that is in JSON format with your tag data, and then use an EBD to send out this report. We have a HOWTO guide located here: HOW TO: Create advanced custom HTML reports

Additionally, you could manually build the format using the BASIC IDE in the eWON.

I’ve found that the Talk2M API requests can generate the JSON responses that could be used after to add the data to the SQL database.

Should we absolutely set up the Data Mail box to use the Talk2M API?

Thank you.

@denis_kaliberov

We have an M2web API, and DMweb API.
You can use the DMweb API to retrieve data in JSON format.

https://developer.ewon.biz/content/dmweb-api