Account
| API | Description |
|---|---|
| POST api/Account/Login |
Login, Example: "LoginViewModel": {"Username": "username", "Password": "password","StrataDB":"strataDB"} |
| POST api/Account/GetAccessibleDatabaseList |
LoginFirstStep, Example: "LoginViewModel": {"Username": "username", "Password": "password"} |
Strata
| API | Description |
|---|---|
| GET api/Strata/GetAllCountries |
Get All Countries |
| GET api/Strata/GetDataFeedInfo?DataFeedID={DataFeedID} |
Look Up Datafeed Settings |
| GET api/Strata/GetSingleReading?DataFeedID={DataFeedID}&StartDate={StartDate}&EndDate={EndDate} |
Get Single Reading for a certain period by DataFeedID, Example: api/Strata/GetSingleReading?DataFeedID=1992&StartDate=2018-01-01&EndDate=2018-03-15 |
| GET api/Strata/GetDataTrend?DataFeedID={DataFeedID}&StartDate={StartDate}&EndDate={EndDate}&AggregationLevel={AggregationLevel}&AggregationType={AggregationType} |
Get Data Trend for a certain period by DataFeedID, Example: api/Strata/GetDataTrend?DataFeedID=1992&StartDate=2018-01-01&EndDate=2018-03-15. AggregationLevel is in seconds, defaulted to daily (86400) you could use 604800 for weekly data. If you want to have monthly data set AggregationType to 2 regardless of aggregationLevel this will always return monthly frequency. |
| GET api/Strata/GetEPRDataForCluster?ClusterID={ClusterID} |
Get EPR Data based on ClusterID, Example: api/Strata/GetEPRDataForCluster?ClusterID=1 |
| GET api/Strata/GetClusterLeagueTable?DataFeedID={DataFeedID}&StartDate={StartDate}&EndDate={EndDate} |
Get Cluster Leauge Table for a certain period by Data Feed ID, Example: api/Strata/GetClusterLeagueTable?DataFeedID=104178&StartDate=2017-01-01&EndDate=2018-01-01 |
| GET api/Strata/GetTreeData?DataFeedID[0]={DataFeedID[0]}&DataFeedID[1]={DataFeedID[1]}&StartDate={StartDate}&EndDate={EndDate} |
Get Tree data based on DataFeed ID, Example api/Strata/GetTreeData?StartDate=2012-01-01&EndDate=2018-01-01&DataFeedIDs=104333&DataFeedIDs=104334&DataFeedIDs=104335&DataFeedIDs=104336&DataFeedIDs=104366 |
| GET api/Strata/GetClusters |
Get All Clusteres |
| GET api/Strata/GETStandardReportForSite?SiteID={SiteID} |
Get Standard Report based on Site ID, Example api/Strata/GETStandardReportForSite?SiteID=2444 |
| POST api/Strata/GetDataFeeds |
Search Data Feeds by Filters, DataFeedSpec Parameter is optional if not passed it gets all the data feeds if any spec passed it will filter the result accordingly. Example: api/Strata/GetDataFeeds?SearchUtilityID=10 |
| POST api/Strata/SearchStructure |
Search Structures, Structure Spec parameter is optional if not passed it returns all Structures, if any of spec passed it will filter the result accordingly. Example: api/Strata/SearchStructure?StructureType=2 |
| POST api/Strata/InsertDataFeedReading |
Insert Reading into certian datafeed, in Request Format below you could see the acceptable format, if you send a duplicate reading it will get overwritten only if the dataFeedID and the exact date and time has been passed you could ignore "OverrideReading" and "IsOverride" just send "Reading" and "ReadingDate" Example: "DataReadingList": [ { "ReadingDate": "2020-03-25 15:45:40", "Reading": 5500.522 }, |
| POST api/Strata/InsertDataFeedsReading |
Insert Reading into multiple datafeed, in Request Format below you could see the acceptable format. if you send a duplicate reading it will get overwritten only if the dataFeedID and the exact date and time has been passed you could also ignore "OverrideReading" and "IsOverride" and just send "Reading" and "ReadingDate" for each datafeedID : |
| GET api/Strata/MeterReadingForm/GetMeterReadingFormDataFeeds?MeterReadingFormID={MeterReadingFormID}&entryDate={entryDate} |
Get MeterReadingForm DataFeeds Returns a list of datafeeds that are attached to a meter form |
| GET api/Strata/MeterReadingForm/GetListOfMeterReadingForms?searchString={searchString} |
Get ListOfMeterReading Forms Returns a list of Meter reading forms |
| GET api/Strata/OEE/OEEExport?StartDate={StartDate}&EndDate={EndDate}&SiteID={SiteID}&ProductionAreaID={ProductionAreaID}&ProductionLineID={ProductionLineID} |
OEEExport Returns a list of OEE data |
| GET api/Strata/OEE/OEEExportFile?StartDate={StartDate}&EndDate={EndDate}&SiteID={SiteID}&ProductionAreaID={ProductionAreaID}&ProductionLineID={ProductionLineID} |
OEEExport Returns a list of OEE data from the Excel Exporter |
| GET api/Strata/OEE/OEEEWOExportFile?StartDate={StartDate}&EndDate={EndDate}&SiteID={SiteID}&ProductionAreaID={ProductionAreaID}&ProductionLineID={ProductionLineID} |
OEEExport Returns a list of OEE EWO data from the Excel Exporter |
| POST api/Strata/Asset/GetSteamTrapsBySpec |
Get Steam traps by spec, SteamTrapSpec Parameter is optional if not passed it will default to last 7 days |
| POST api/Strata/Asset/GetAssetsBySpec |
Get Assets by spec, AssetSpec Parameter is optional |