Access to the Reporting API

  • Updated

Welcome to the wonderful World of Skynamo Analytics!

Skynamo has a brand-new reporting API specifically designed to get your Skynamo data for the purpose of reporting.

How to get access?

The good things in life are never free, and the same goes for access to the Skynamo Reporting API.

Log a request for access with Skynamo Support (support@skynamo.com) or your Customer Success Member. They will be able to provide you with a quote.

Please note that while the Reporting API and connector are in Beta no costing will be incurred

The following information will be required:

  • Customer Name
  • Skynamo Instance Name
  • Email address of contact person who will be working with the API connection.
  • Specify whether or not you need the Power BI Custom Connector.

After the above has been done, approved, and paid you will be provided with credentials to access your Skynamo data through the reporting API (Client ID, Client Secret).

I have access, now what?

  • Reporting API

For more information on using the Reporting API and examples go to the Swagger documentation:

https://analytics-api.svc.za.skynamo.me/swagger/index.html

mceclip1.png

The provided credentials can be used in a CURL request (see below) to get an access token to Login by clicking on Authorize.

 

curl --request POST \
--url https://dev-9p75rrqx.eu.auth0.com/oauth/token \
--header 'content-type: application/json' \
--data '{"client_id":"<CLIENTID>","client_secret":"<CLIENTSECRET>","audience":"https://analytics.skynamo.com/","grant_type":"client_credentials"}'

 

The Data

The Skynamo Reporting API has four endpoints that returns data for 19 tables/entities, as shown in the below:

Entity

Notes

Users End Point – Returns User and User related entity data

Users

User details on Skynamo.

Travel Claims

The travel claims logged per user per day on Skynamo app.

User Time Segments

The ‘on clock’ and driving time captured on Skynamo app per user per day.

Tasks

The activity_id field will only be populated if the task (Scheduled Visit or Task) has been completed on Skynamo.

User Targets

The sales target per user per month that has been loaded on Skynamo.

Activities End Point – Returns Activity and Activity related entity data

Activities

The activities captured on Skynamo, example Visits, Forms, Orders, etc.

Credit Requests

The credit requests captured by a user for a customer on Skynamo.

Quotes

The quotes captured by a user for a customer on Skynamo.

Orders

The orders captured by a user for a customer on Skynamo.

Surveys

The surveys captured by a user at a customer on Skynamo.

Forms

The forms completed by a user on Skynamo. Form details, questions and answers are returned in the json_view field.

Customers End Point – Returns Customer and Customer related entity data

Customers

Customer details on Skynamo. Custom field data is returned in the json_view field.

Customer Users

The customer user assignments on Skynamo.

Invoices

The invoices that have been imported from a financial system/ERP into Skynamo.

Customer Targets

The sales target per customer per month that has been loaded on Skynamo.

Products End Point – Returns Product and Product related entity data

Products

Product details on Skynamo. Custom field data is returned in the json_view field.

 

The following images show the entity-relationship diagrams per Reporting API End Point for all the tables related to that endpoint. The relationships between End Points are also indicated. The main table of each endpoint has a pink border.

mceclip0.png

Users End Point ERD

mceclip1.png

Activities End Point ERD

mceclip2.png

Customers End Point

mceclip3.png

Products End Point

 

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.