MS Excel
Edinn API functions can be tested or used using Microsoft Excel. I this document we will see an example.
From MS Excel, in the top menu Data, select From Web:
Type, into the URL, what is indicated in the edinn API for Big Data, for example: (IMPORTANT! Change the url according to your server IP ad PORT)
http://localhost:8080/bigdata?company=1111111111&session=42M1z6hOENuqkuuro4CJVHv6UAtsih4X9TUA5TKT1SN13LkYLdv7AdpYxZqc&process=1CON&datefrom=20201001060000&dateto=20201101060000
And click on Ok:
When the response appears, select data, put the mouse pointer on the right side, click right mouse button and choose "Add as a new query":
When the records appear, click "To Table" on the top left corner:
Then, click Ok without changing anything:
Click on the button which is on the top of the column, and click Ok on the following window:
When data appears, click on Close & Load on the top left corner:
And data will be already in our excel sheet.
For more information about the meaning of this data, please check the Big Data call from the edinn API.