As a financial marketplace and tool, Sighten

Info
This is slightly out of date. While the DAL still functions in the same manner, there are additional paths and metrics that can be requested. Make sure to work with your integration manager to ensure you implement the best flow for your needs.

EverBright offers what we call the Data Access Layer (DAL) to our API partners. Extensive data is collected

and

and calculated throughout the

lifecyle

lifecycle of a deal in

Sighten

EverBright, including information about the solar design, proposal, and financial information. 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

EverBright API endpoints. If

your Sighten subscription does not include access to Sighten's APIs

you require this information, please contact your

Sighten

EverBright account representative or

support@sighten.io to see how your needs may be met with the Data Access Layer

support@goeverbright.com.

What data is accessible

The base URL for the DAL is : https://engine.

sighten

goeverbright.

io

com/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

The credit qualification part of the DAL derives information related to credit pulls. Depending on the set up of the financier and integration, this may include product information and approval amounts among other data.

Product

The product option on the DAL returns information around the specific financing products for which your account has access.

Quote

Site

System

Code BlockSuccess Response { "

Common Paths / Options

Site

The site is the data object around which the entire EverBright platform is centered. It encompasses the homeowner contact, address, and utility information. This option on the DAL will return higher-level information related to each site.

Quote

The quote option returns information related to the quotes that have been created in your account. Pricing information, status, and dates of creation can be accessed for each individual quote.

Workflow

The workflow option is usually preferred anytime after a Contract has been signed. Using the Operations workflow to pull related information ensures it is the most up-to-date data available for this job.

Code Block
GET https://engine.goeverbright.com/api/data/

Code Block

language	json

Success Response

{
  "status_code": 200,
  "messages": {
    "warning": [],
    "info": [],
    "error": [],
    "critical": []
  },
  "data": {
    "options": [
      "credit_qualificationaddress",
      "productcontact",
      "quotelookup_table",
      "siteorganization",
      "system"
payment",
      "product",
   ]   },"product_result",
      "messagesproject":,
 {     "warning": []proposal",
      "qualification",
      "error": [],quote",
      "site",
      "info": []task",
      "usage_profile",
      "critical": []user",
      }"workflow",
      "statusworkflow_code": 200
}history"
    ]
  }
}

then each return

Limit

Page

Data Filtering

?date_updated_after=2017-01-20&date_updated_before=2017-01-22

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

Code Block
GET https://engine.goeverbright.com/api/data/workflow/

Code Block
GET https://engine.goeverbright.com/api/data/project/

Both examples above return the full list of possible metrics

A specific metric can be retrieved by appending it to the api/data/<data_object_option>/ endpoint as a query argument. Only the metrics specified will be returned in the response for each data object.

Field	Type	Description
`count`	`int`	The number of entries of data objects.
`has_next_page`	`bool`	Is there more data beyond the current page.
`pages`	`int`	The number of pages of data.
`data`	`array`	Array of data metric objects. Each object contains the values for the metrics specified in the URL retrieval.

Code Block
GET https://engine.

sighten

goeverbright.

io

com/api/data/

site

qualification/?metrics=site_

last_updated,site_idGET

id

Code Block

{
  "count": 90658,
  "has_next_page": true,
  "messages": {
    "info": [],
    "critical": [],
    "warning": [],
    "error": []
  },
  "status_code": 200,
  "pages": 4533,
  "data": [
    {
      "site_id": "f9f9df3b-132d-4d6f-b53a-4279e8f67ebf"
    },
    {
      "site_id": "c74f1784-f7b8-4b4b-19a7-c3ce2d2e14a5"
    },
    {
      "site_id": "c0a26dd5-7a1e-a4f5-aff8-bcca5b9ea46f"
    },
    {
      "site_id": "36a863d2-da0c-4b37-9901-5f6e61e5aaa0"
    },
    {
      "site_id": "5ba89921-946e-4b69-b25f-76764ae332dc"
    },
    {
      "site_id": "80beb076-be0c-4cc9-8369-d066cd76afa4"
    },
    {
      "site_id": "cb5bcf33-63b9-4268-a1c6-2b5511284faf"
    },
    {
      "site_id": "07501fb0-82c9-42bc-a6b3-cee538e85cdf"
    },
    {
      "site_id": "ab158a4f-a6f7-45d3-b53b-ad3da42fe165"
    },
    {
      "site_id": "82406937-ffd2-4d30-b7a9-d2eb0728398b"
    },
    {
      "site_id": "fe1a9e9e-c717-4213-90a3-918a5e8846c1"
    },
    {
      "site_id": "6495c911-b543-490b-a8fc-b4286cc5b0ba"
    },
    {
      "site_id": "c8b48b6e-d599-45a7-901c-487f19a20bc5"
    },
    {
      "site_id": "4e925c52-bf19-4042-beb6-ad9cb5b2a302"
    },
    {
      "site_id": "52324cd3-26e1-441b-b483-5d922398cfb4"
    },
    {
      "site_id": "601ecafb-08bb-458d-87a3-4bc8ec9daedc"
    },
    {
      "site_id": "834323d5-c88b-4dd2-b505-4e71b125f682"
    },
    {
      "site_id": "e4d5f57e-77a9-4c49-8449-d492887e1c63"
    },
    {
      "site_id": "9d9cbfda-da86-4157-b619-792fda47aec3"
    },
    {
      "site_id": "4fe662aa-936e-4713-905c-cb1f7bd141ce"
    }
  ]
}

Filtering

The Data Access Layer endpoints support filtering so users can retrieve the subset of data in which they are interested.

For example, from the quote section, the user can filter for only the quotes that have a SIGN status, meaning a contract has been signed. Additionally, the user can filter for jobs from a range of dates.

By default, the DAL will return 20 unique entries. If the user would like to see more or less entries at one time, the limit filter can be appended to the request. If there are multiple pages of entries, the user can also append the page filter to access a specific page of entries.

Example:

Code Block
GET https://engine.

sighten

goeverbright.io/api/data/

site

quote/?metrics=quote_status,site_id,site_last_updated

,site_id

&quote_status=SIGN&site_last_updated_after=2017-05-01&limit=3000

limit => how many entries to display in the response

GET

&page=3

Code Block
GET https://engine.

sighten

goeverbright.

io

com/api/data/

site

quote/?metrics=quote_status,site_id,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

&quote_status=SIGN&site_last_updated_after=2017-05-01

Code Block

{
  "count": 3226,
  "messages": {
    "error": [],
    "critical": [],
    "info": [],
    "warning": []
  },
  "status_code": 200,
  "data": [
    {
      "site_last_updated": "2017-05-08T16:47:31.088253+00:00",
      "site_id": "cc328ab2-aba3-4213-9b59-babfe6288a74",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-03T12:20:48.002937+00:00",
      "site_id": "111ee62b-8623-4298-bf40-882acd174302",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-04T14:35:31.227004+00:00",
      "site_id": "6f2c1d06-5eac-4327-af06-eaebd33b6a0c",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-05T21:36:22.929002+00:00",
      "site_id": "bcf73ec9-aceb-495e-b245-1ddff22144f4",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-10T23:39:45.927919+00:00",
      "site_id": "e3cb004c-5236-4637-ac87-82c8c4c4cedc",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-08T16:47:31.088253+00:00",
      "site_id": "cc328ab2-aba3-4213-9b59-babfe6288a74",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-08T16:47:31.088253+00:00",
      "site_id": "cc328ab2-aba3-4213-9b59-babfe6288a74",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-01T18:46:05.858952+00:00",
      "site_id": "bec53c6d-1457-4d17-b2b8-8cebfd38da86",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-01T18:46:05.858952+00:00",
      "site_id": "bec53c6d-1457-4d17-b2b8-8cebfd38da86",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-09T17:52:49.150111+00:00",
      "site_id": "80b1ef2a-1703-450b-9169-e8473d0c1fe5",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-05T18:35:28.825842+00:00",
      "site_id": "23140913-3fa1-44de-84f6-6af88157add8",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-10T17:43:15.466829+00:00",
      "site_id": "e19f87ea-93be-452a-b917-40aaff036e87",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-08T17:58:12.924447+00:00",
      "site_id": "68288d69-1aec-456b-a675-04a67e5be1ab",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-01T21:08:05.707306+00:00",
      "site_id": "831ee381-5cb4-47af-b6ce-0b546b73c5da",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-04T00:17:33.554579+00:00",
      "site_id": "77ac39bc-da99-4039-b9af-eb109546d355",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-03T20:34:29.664546+00:00",
      "site_id": "842c0e82-b01f-4ea7-b45c-a385df9deccc",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-03T17:51:14.296281+00:00",
      "site_id": "7a6f368c-5a3c-462c-aa9c-52f6bf0e5950",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-05T22:26:19.720932+00:00",
      "site_id": "c0fe104d-fec4-4bfd-9f21-916f15b835e2",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-04T11:36:23.781644+00:00",
      "site_id": "35296d05-3d4e-45b9-9df4-c8e81912da7c",
      "quote_status": "SIGN"
    },
    {
      "site_last_updated": "2017-05-04T18:42:39.780416+00:00",
      "site_id": "dc81e4c6-a6a6-4d84-97c9-40dfd17d8e23",
      "quote_status": "SIGN"
    }
  ],
  "has_next_page": true,
  "pages": 162
}

Versions Compared

Old Version 11

New Version Current

Key

Authentication and Credentials

What data is accessible

Metrics

Limit

Page

Data Filtering

Filtering

Example:

Related articles

Page Comparison

Versions Compared

Old Version 11

New Version Current

Key

Authentication and Credentials

What data is accessible

Metrics

Pagination

Limit

Page

Data Filtering

Filtering

Pagination

Example:

Related articles