EMDI gives the ability to download and set data by using http protocol. To make it possible, the communication/maintenance program must be running (tcpdevices.exe).

Reports called via http are easily made using SQL language and saved with the .sql suffix in the reports folder (e.g. C:\Program Files (x86)\SBZ systems\EMDI\reports).

Variables that you can include in the code

(used after the where command, only when we call a report)

:apo                                            Date from
:ews                                            Date to
:param1                                     General use
:param2                                    General use
:search                                      For search

Τα πεδία που αποστέλλουμε:

querysql                                    Here we write the file name of the report without the suffix .sql. Alternatively, we can put sql code directly.
key                                             Security code must be the same as the one set in the settings.
searchtext                                For search corresponding to :search
param1                                     General use corresponding to :param1
param2                                     General use corresponding to :param2
from                                          Date corresponding to :apo
to                                               Date corresponding to :ews

Result – Data download

When we call sql code, we take as a result simple utf8 encoding text in csv format and separator “|”. Also in the first row are all fields as in the database.

Examples

To call the “04.All customers” report via http:

To execute sql code directly through http:

We can also change data directly using the update command:

In this case we take the “ok” response when the code is successful.