Rest API Device data logging

ChirpStack Application Server
#1

Hello Everyone.

I want to use the Rest API for logging my device measured data.
I use cURL and PHP for automatically logging the mesaured data to my MySQL database.

These data want to store my database:

  • Rssi value,
  • measure data(Temp, RH, BatteryLevel, Status,AirPressure),
  • fCnt:value
  • fPort: value

Which GET commands can I use to solve my problem?
Can anyone give a hint or example on how to solve my problems?

Thanks for helping.

#2

Anyone can help solve my problem?
@brocaar @sagarpatel

#3

Hi @bakok

You can use HTTP integration. it will store data on your MySQL database.
Please follow the documentation below documentation guide.

[HTTP - ChirpStack open-source LoRaWAN® Network Server] (HTTP - ChirpStack open-source LoRaWAN<sup>®</sup> Network Server)

#4

Dear @sagarpatel thanks for your advice.

Your advice is good.
The final solution is probably the PostgresQL separate database and PHP combination.

PostgreSQL

1 Like