Today we are working with Version2 of Observepoint’s API. The database tables will be created from this model. Here’s the data model created for this project.
Observepoint is an Automated QA Regression Testing Tool. It is used to validate Web Analytics Tracking Tags. Users can create Web Journeys that replicate a user’s experience on a website. An ecommerce website for example would need to ensure that all tracking that is expected is in place when a visitor adds a product to their shopping cart. The user would create a Web Journey in Observepoint along with validation rules.
All posts in this ETL series:
Install PostgreSQL Database
Simple Data Model
Create Tables in PostgreSQL Database
Getting JSON API data with Python
Inserting JSON data into Postgres with Python