tap-satismeter

This is a singer tap to query the Satismeter REST api. Exports the responses and response statistics.

Connecting tap-satismeter

Setup

You need your Satismeter Project ID and need to create an API key (also called Read key). This is described on the Satismeter docs for the Export responses api

---

tap-satismeter Replication

The tap will query the Satismeter REST api to obtain all of the user responses, and the per-month statistics for your project.

For responses, the number of rows replicated equals the number of responses. The datasource is append-only style, the tap will keep track of the last replicated response to only replicate new responses (and it will only request responses later than that moment from the Satismeter api).

For response statistics, the number of rows replicated equals the number of months. The tap will keep track of which month it has requested, and will continue from then on (it will always requery for the current month).

There are no rate limits enforced on the side of Satismeter api, but the tap has a rate limit of requests to Satismeter of 1 per 5 seconds, and each request has a 30 seconds timeout.

---

tap-satismeter Table Schemas

1. Responses

   • Table name: responses
   • Description: all of the user responses
   • Primary key column(s): id
   • Replicated fully or incrementally (uses a bookmark to maintain state): incrementally, based on the created field
   • Bookmark column(s): (if replicated incrementally) : created
   • Link to API endpoint documentation: Satismeter Export Responses API

2. Response statistics

   • Table name: response-statistics
   • Description: aggregated response statistics per month
   • Primary key column(s): id (which equals the value of the month)
   • Replicated fully or incrementally (uses a bookmark to maintain state): incrementally, based on the month field
   • Bookmark column(s): (if replicated incrementally) : month
   • Link to API endpoint documentation: Satismeter Response statistics API

3. Response statistics frequency

   • Table name: response-statistics__frequency
   • Description: Stitch-generated, flattened frequency count of amount of responses with a certain score (corresponding to the value in column '_sdc_level_0_id') in a certain month
   • Primary key column(s): autogenerated, combination of month & level
   • Replicated fully or incrementally (uses a bookmark to maintain state): same as in 2.
   • Bookmark column(s): (if replicated incrementally) : same as in 2.
   • Link to API endpoint documentation: same as in 2.

---

Instructions to run from source

Add the project id and api key for Satismeter in tap_satismeter/config.json.

Install the tap and its dependancies:

pip install -e .

cd tap_satismeter

Generate a catalog file which describes the included object stream schemas:

python __init__.py -c ../config.json --discover > catalog.json

Run the tap:

python __init__.py -c ../config.json --catalog catalog.json > output.json

---

Copyright © 2019 Stitch