Offset parameter in api

Hi brocaar. what is the significance of offset parameter in https://{Server_address}/api/nodes/{DEVEui}/frames?limit=1000000&offset=10.

We have configured another MYSQL database where we are storing the frames that is received through the same API and we have to loop through all the frames repeatedly everytime. Is there any way of only receiving updated frames. Also we wont be aware of how many new frames have been received in a specific time.

The offset is used for pagination. E.g. when you have 20 frames:

  • limit=10 & offset=0: Frame 1 - 10
  • limit=10 & offset=10: Frame 11 - 20

We have configured another MYSQL database where we are storing the frames that is received through the same API and we have to loop through all the frames repeatedly everytime. Is there any way of only receiving updated frames. Also we wont be aware of how many new frames have been received in a specific time.

Please note that the frames endpoint is only for debugging. For receiving / sending data, see: https://docs.loraserver.io/lora-app-server/integrate/data/. You could create a MQTT handler for storing the data into MySQL.

How would we configure MQTT in java application??..We have one java app and from there we are calling LORA server REST api. to get the JSONdata into our application and storing it into the MYSQL database. We are not aware with MQTT handler configuration in java application… Is this the correct way to get real time data from lora-app-server

How you implement a MQTT handler I leave as an exercise for you :wink: Please note that soon (I’m planning to release this today or tomorrow) you will be able to configure per application HTTP endpoints for uplink data / join notifications etc…

I would be really grateful if that would be possible. Oh and about the MQTT hanler the Game is on. :wink:

Hey, were you able to make the release??. I achieved the MQTT handler configuration using eclipse PAHO for iot.