Versions Compared

Old Version 9

changes.mady.by.user Judy Ho (Unlicensed)

Saved on

compared with

New Version 10

changes.mady.by.user Judy Ho (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

As a financial marketplace and tool, Sighten offers what we call the Data Access Layer (DAL) to our API partners. Extensive data is collected and and calculated throughout the lifecyle of a deal in Sighten. The DAL allows our partners to always retrieve the most relevant and pertinent data effectively and quickly.

Authentication and Credentials

Authentication and access for the data access layer are the same as those used for other Sighten API endpoints. If your Sighten subscription does not include access to Sighten's APIs, please contact your Sighten account representative or support@sighten.io to see how your needs may be met with the Data Access Layer. 


What data is accessible

The base URL for the DAL is : https://engine.sighten.io/api/data/

Retrieving from the base endpoint reveals what options and information are available through the DAL. . Each of the options represent a different starting point for how associated information, "metrics," are derived.


Code Block
GET https://engine.sighten.io/api/data/


Credit Qualification

This part of the data access layer 


Credit

Product

Quote

Site

System




Code Block
Success Response


{
  "data": {
    "options": [
      "credit_qualification",
      "product",
      "quote",
      "site",
      "system"
    ]
  },
  "messages": {
    "warning": [],
    "error": [],
    "info": [],
    "critical": []
  },
  "status_code": 200
}


Each of these data structures then each return a set of data (or "metrics") related to that data structure.

Pagination

Limit

Page

Data Filtering





Finding sites and when they were last updated:

In order to find when a site was last updated, we can call the api/data/quote/ endpoint to return the last updated dates along with the quote ids and site ids. 

GET https://engine.sighten.io/api/data/site/?metrics=site_last_updated,site_id

GET https://engine.sighten.io/api/data/site/?metrics=site_last_updated,site_id&limit=3000

limit => how many entries to display in the response

GET https://engine.sighten.io/api/data/site/?metrics=site_last_updated,site_id&limit=3000&page=3

Response:

Fields of interest:

pages => number of pages of entries

count  => number of total entries

has_next_page => there are more entries on the next page


{

  • messages:

  • {

    • info: [ ],

    • warning: [ ],

    • error: [ ],

    • critical: [ ]

  • },

  • pages: 1095,

  • data:

  • [

    • {

      • site_last_updated: "2016-01-21T22:53:50.889244+00:00",

      • site_id: "353da0c0-67ab-44a2-913b-2ca1ffc8137a"

    • },

    • {

      • site_last_updated: "2016-01-21T22:53:50.889244+00:00",

      • site_id: "353da0c0-67ab-44a2-913b-2ca1ffc8137a"

    • },

    • {

      • site_last_updated: "2016-01-21T22:53:50.889244+00:00",

      • site_id: "353da0c0-67ab-44a2-913b-2ca1ffc8137a"

    • },

    • {

      • site_last_updated: "2016-01-21T22:53:50.889244+00:00",

      • site_id: "353da0c0-67ab-44a2-913b-2ca1ffc8137a"

    • },

    • {

      • site_last_updated: "2016-01-21T22:53:50.889244+00:00",

      • site_id: "353da0c0-67ab-44a2-913b-2ca1ffc8137a"

    • },

    • {

      • site_last_updated: "2016-02-03T15:45:54.782968+00:00",

      • site_id: "ec9d7a8a-4f24-4c15-92dc-294c67fde3e1"

    • },

    • {

      • site_last_updated: "2016-02-05T17:18:15.580026+00:00",

      • site_id: "610d3705-a808-4f1e-ae53-6009ea4bf8c6"

    • },

    • {

      • site_last_updated: "2016-02-05T17:18:15.580026+00:00",

      • site_id: "610d3705-a808-4f1e-ae53-6009ea4bf8c6"

    • },

    • {

      • site_last_updated: "2016-02-05T17:18:15.580026+00:00",

      • site_id: "610d3705-a808-4f1e-ae53-6009ea4bf8c6"

    • },

    • {

      • site_last_updated: "2016-02-05T19:03:15.641856+00:00",

      • site_id: "f463f568-7129-4504-8c31-6352a5ccd23f"

    • },

    • {

      • site_last_updated: "2016-02-05T19:03:15.641856+00:00",

      • site_id: "f463f568-7129-4504-8c31-6352a5ccd23f"

    • },

    • {

      • site_last_updated: "2016-02-05T19:03:15.641856+00:00",

      • site_id: "f463f568-7129-4504-8c31-6352a5ccd23f"

    • },

    • {

      • site_last_updated: "2016-02-05T19:03:15.641856+00:00",

      • site_id: "f463f568-7129-4504-8c31-6352a5ccd23f"

    • },

    • {

      • site_last_updated: "2016-02-05T19:03:15.872990+00:00",

      • site_id: "671df10c-3330-474d-ad00-4d5ad4b98668"

    • },

    • {

      • site_last_updated: "2016-02-05T19:03:15.872990+00:00",

      • site_id: "671df10c-3330-474d-ad00-4d5ad4b98668"

    • },

    • {

      • site_last_updated: "2016-02-05T19:03:15.872990+00:00",

      • site_id: "671df10c-3330-474d-ad00-4d5ad4b98668"

    • },

    • {

      • site_last_updated: "2016-02-05T19:03:16.534995+00:00",

      • site_id: "5bc86965-582a-48fe-9062-58914d1f8fda"

    • },

    • {

      • site_last_updated: "2016-02-05T19:03:16.534995+00:00",

      • site_id: "5bc86965-582a-48fe-9062-58914d1f8fda"

    • },

    • {

      • site_last_updated: "2016-02-05T19:03:16.534995+00:00",

      • site_id: "5bc86965-582a-48fe-9062-58914d1f8fda"

    • },

    • {

      • site_last_updated: "2016-02-05T19:03:16.534995+00:00",

      • site_id: "5bc86965-582a-48fe-9062-58914d1f8fda"

    • }

  • ],

  • count: 21897,

  • has_next_page: true,

  • status_code: 200

}

Metrics are retrieved from data access layer through reporting