what is a web api (aka brm web services)? · brm. asset management. inspection data. web site(s)...

What is a Web API (AKA BrM Web Services)?(Application Programming Interface)

TURNS THIS….

INTO INTERFACES LIKE THIS….

0101

0101

0101

Paul Evans – Project LeadJason Parent -- Developer

BrM Web ServicesWSDOT Bridge Data &

BrM Web ServicesWSDOT Data &

• Where is WSDOT in the BrM Implementation?• Our Data “Journey” and the Web API.• Web Services(API) Development Challenges Encountered

Inspection Data

WSDOT Inspection Data

Benefits

Actions

Element Deterioration Rates

Default Utility Tree

Not Complete

Complete

Utility Weight Profiles

Data Journey Interlude………….

BrMAsset Management

Inspection Data

SQL ETL

Data Flow Diagram

Iteration #3

One big SQL ScriptIteration #1

SQL ETL

SQL ELIteration #2 Staging Area

-”T”(Translate)

AM API

BrMAPI

TECH MANUAL

Why the API?

• Don’t have to make any changes to the BrM(Proprietary) database.

• Moving development(Apps/Reporting) to the Web.• It fits our current and future needs – Data CRUD.

• Plug in any interface we choose.• Provides Security, both front(token) and back end(SQL)

Data Transfer Web Page

Javascript Language/Libraries

API CHALLENGES TO OVERCOME

Chapter 2(Tech Manual) Installation 2-13

API CHALLENGES TO OVERCOME

Development EnvironmentWeb BrowserApplication Configuration

Data ConstraintsConnecting to our db

API CHALLENGES TO OVERCOME

Example Shadow Constraint --BrM -- 'yearrecon' must be of between 1800 and 2054."--Or NULL.WSDOT DB allows “0”.

BrMAsset Management

Inspection Data

Web Site(s)

SQL ETL

Reports

BrM API

Reports

Other Databases

Other Databases

“Final” System Diagram

Web Site

QUICK PROTOTYPE USING JAVASCRIPT AND BrM API

Questions?

England's 7-Circle Magic Roundabout