Pin History Raw Data Timestamp

Blynk Servers Local Blynk Server
1

I have a problem with raw data csv timestamp format via REST API pin history.
The issue is seconds and milliseconds are missing from utc time.
e.g.: I’m getting 1524480420000 milliseconds elapsed since 1970. Jan. 01.
and this format does not contain the second and millisecond parts of timestamp

Does anybody can help me, how to configure my local Blynk server to get the valid timestamp?

2

Please use reporting widget instead, this API will be dropped soon - http://docs.blynk.cc/#widgets-other-reports-widget

3

Hi Dmitriy,

I’m developing an MVC Asp.NET application to display info from my ESP8266
in custom format. (even available outside of the app)
So, if REST API will dropped, I decided to use Npgsql library to access Blynk’s postgre database.
I have tried it, and works as I expected.
(I hope Postgre will not dropped :slight_smile: )

Regards,
miciry89

4

Ah… I see. We changed some things in reporting so we want to drop old API that is not used anymore. Maybe some day we will introduce new api for that as flexible as current reports widget.

1 Like
5

Yes. It is not - Introduction - Blynk Documentation

You probably want to use raw storage for your case - https://github.com/blynkkk/blynk-server#enabling-raw-data-storage

6

Hi Dimitriy,

REST API has a function to get the hardware connection state (isHardwareConnected)

Is there any way to get this info from PostgreSQL?
which table is storing this?

Many thanks,
miciry89

7

This info is not stored in the Postgres as this is session state (realtime) info. (there is another widget for that is on its’ way :slight_smile: )

8

Many thanks again

9

You mean the HTTP REST api will be dropped in total , or just the “commands” involved in pin history data

10

I believe he was talking about “export .CSV” with SuperChart

11

I hope so!