Nonflavored Prescription Medicine

npm

Share private packages across your team with npm Orgs, now with simplified billing via the aws marketplace!Learn more »

sigfox-iot-data

1.0.6 • Public • Published

sigfox-iot-data is a sigfox-gcloud and sigfox-aws adapter for writing Sigfox messages into SQL databases like MySQL and Postgres.

You may read and update Sigfox messages with other modules (such as sigfox-iot-ubidots) before passing to sigfox-iot-data for writing to the database. sigfox-iot-data works with most SQL databases supported by Knex.js like MySQL, Postgres, MSSQL, MariaDB and Oracle.

sigfox-iot-data was built with sigfox-aws / sigfox-gcloud, an open-source software framework for building a Sigfox server with AWS IoT / Google Cloud Functions. Check out sigfox-aws, sigfox-gcloud

sigfox-iot-data with MySQL:

sigfox-iot-data with Postgres:

Installation for AWS

See instructions at:

https://github.com/UnaBiz/sigfox-iot-data/blob/master/aws/index.js

Demo

  1. To send messages from a Sigfox device into your database, you may use this Arduino sketch:

    https://github.com/UnaBiz/unabiz-arduino/blob/master/examples/send-light-level/send-light-level.ino

    The sketch sends 3 field names and field values, packed into a Structured Message:

    ctr - message counter
    lig - light level, based on the Grove analog light sensor
    tmp - module temperature, based on the Sigfox module's embedded temperature sensor        
    
  2. Alternatively, you may test by sending a Sigfox message from your Sigfox device with the data field set to:

    920e82002731b01db0512201
    

    We may also use a URL testing tool like Postman to send a POST request to the sigfoxCallback URL.

    Set the Content-Type header to application/json. If you're using Postman, click Body -> Raw -> JSON (application/json) Set the body to:

    {
      "device":"1A2345",
      "data":"920e82002731b01db0512201",
      "time":"1476980426",
      "duplicate":"false",
      "snr":"18.86",
      "station":"0000",
      "avgSnr":"15.54",
      "lat":"1",
      "lng":"104",
      "rssi":"-123.00",
      "seqNumber":"1492",
      "ack":"false",
      "longPolling":"false"
    }

    where device is your Sigfox device ID.

    Here's the request in Postman:

  3. The response from the callback function should look like this:

    {
      "1A2345": {
        "noData": true
      }
    }
  4. The test message sent above will be decoded and written to your sensordata table as

    ctr (counter): 13
    lig (light level): 760
    tmp (temperature): 29        
    

    The other fields of the Sigfox message will be written as well.

install

npm i sigfox-iot-data

Downloadsweekly downloads

9

version

1.0.6

license

MIT

homepage

github.com

repository

Gitgithub

last publish

collaborators

  • avatar
Report a vulnerability