Versions Compared

Key

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

Table of Contents

Background and strategic fit

The purpose of this Integration is to pull over KPI Emission data to support our growing customer base to analyze the Emission data they are entering through the ProcessMAP solution.

...

  • KPIs classified as Energy will be pulled
  • ProcessMAP assumes anyone who is accessing the Outbound API has required authority to access the data this API contains
  • User accessing this endpoint through a valid Token & ConsumerId, provided by ProcessMAP, will have access to complete data
  • User would have to input single Location Code (e.g. Westlake) each time to consume that Location data
  • Data to be accessed with a limitation of 1 year duration at a time to avoid any performance issues
  • Data will be shown in Readable JSON format
  • Field Names in the Response would be Customer Field Naming
  • DATETIME, INT and FLOAT data will be shown as NULL when there is no data
  • The date that is being shown in response is in EST Date time format ONLY


AUTHENTICATION URL DETAILS [  Base URL with Auth EndPoint ] 

Please note that the above Auth Token expires after every 120 minutes.

Example:

Response

BASE URL + Endpoint FOR RESPECTIVE API CALLS

Endpoint : GET papi/v1/eca/emissiondata?locationCode={locationCode}&year={Year}

...

URI Parameters

  1. Location Code, Year and LastSyncedDate are to be passed as parameters
  2. Location Code and Year are required parameter but LastSyncedDate is optional
  3. When both Year and LastSyncedDate are provided, data returned will be any record created/updated since LastSyncedDate for the Year
NameDescriptionTypeAdditional information
LocationCode

Represents the unique code of location for which KPI Data should be returned

string

Required

Year

Represents the year for which the Emission data should be pulled

int

Required

LastSyncedDateRepresents the date when API was last calleddateOptional


Sample Parameters

...

View file
nameEmissionData.txt
height250

Field List

...

Emission Data Outbound Field List


SectionField NameDatabase Column Size

LocationNVARCHAR(200)
Program Details


Program IdINT

Program NameNVARCHAR(50)
KPI Details


KPI IDINT

KPI NameNVARCHAR(250)

Scope TypeNVARCHAR(100)

Activity TypeNVARCHAR(100)

Energy Source CatagoryNVARCHAR(100)

Energy SourceNVARCHAR(100)
Emission Detail


PeriodNVARCHAR(50)

EmissionNVARCHAR(50)

Emission DataDECIMAL(32,10)

Emission UOMNVARCHAR(50)

Emission TypeNVARCHAR(20)

Created ByNVARCHAR(200)

Created DateNVARCHAR(30)

Updated ByNVARCHAR(200)

Updated DateNVARCHAR(30)


Errors/Validation Messages

...