...
- GET method of REST Endpoints
- POST method of REST Endpoints
Base Path: https:// <hostname>//eagle/report/v1/<supported feature>
REST Endpoint output defaults to JSON Format. In addition, the Endpoints are in camel casing and case sensitive.
...
GET method of OLAP RESTful web service is used to read/request the data from the Eagle data warehouse. Below are the list of GET Endpoints supported by OLAP RESTAPI.
Features | BASE URL’s |
Report Profiles | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/reportProfiles |
Fields | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/fields |
Fields By Indicator | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/fieldsByIndicator/{FieldIndicator} |
Entities | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/entities |
Entity By Id | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/entity/ {EntityID} |
Entity By Name | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/entitiesByEntityNameLike/{Entitynamelike} |
Entity By Type | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/entitiesByType/{EntityType} |
Details on individual GET Endpoints
reportProfiles: A GET request to return a list of report profiles.
This gives the profile names of all types of Performance Calculations, OLAP Reports and Advance reports.
Resource path: /eagle/report/v1/reportProfiles | |
Examples: | |
Web Browser | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/reportProfiles |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/reportProfiles” |
Sample response: [ |
fields: A GET request to return a list of fields.
This includes all types of like Regular fields, Advance fields, Special fields, Performance fields etc.
Resource path: /eagle/report/v1/fields | |
Examples: | |
Web Browser | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/fields |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/fields” |
Sample response: [ |
fieldsByIndicator: A GET request to return the list of report fields by field indicator.
Fields of all types are assigned with an indicator respective to the database it belongs to and those are fetched with a filter mentioned in this endpoint.
Resource path: /eagle/report/v1/fieldsByIndicator/{fieldIndicator} | |
Examples: | |
Web Browser | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/fieldsByIndicator/H |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/fieldsByIndicator/H” |
Sample response: [ |
entities: A GET request to return a list of report entities.
This includes all types of entities like Portfolios, Performance composites, Reporting Composites, Entity List etc.
Resource path: /eagle/report/v1/entities | |
Examples: | |
Web Browser | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/entities |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/entities” |
Sample response: [ |
entityById: A GET request to return an entity based on its Id.
This is to filter a specific entity using an 8-digit entity id.
Resource path: /eagle/report/v1/entity/{entity id} | |
Examples: | |
Web Browser | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/entity/LTTEST02 |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/entity/LTTEST02” |
Sample response: [ |
entitiesByEntityNameLike: A GET request to return a list of entities that contain the specified value in the Entity name. This is to apply filters on the Entity name to query the list of Entities matching with the entity name filter.
Resource path: /eagle/report/v1/entitiesByEntityNameLike/{entity name} | |
Examples: | |
Web Browser |
ww01.eagleinvsys.com/eagle/report/v1/entitiesByEntityNameLike/JKA | |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/entitiesByEntityNameLike/JKA” |
Sample response: [ |
entitiesByType: A GET request to return a list of entities by entity type.
This includes all types of entities like Portfolios, Performance composites, Reporting Composites, Entity List, Custom index etc. This endpoint is used to filter the entities by entity type.
Resource path: /eagle/report/v1/entitiesByType/{entity type} | |
Examples: | |
Web Browser | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/entitiesByType/COMP |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/entitiesByType/COMP” |
Sample response: [ |
POST method of REST Endpoint
‘adhocReport’ is a feature supported to extract OLAP report output using both POST and GET method. This will run a PACE report service based on request payload input parameters in JSON format.
Request Formats:
POST
URL : https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/adhocReport |
Payload: { |
GET
URL: https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/adhocReport? reportName=******&entityId=****,****&beginDate= YYYYMMDD &endDate= YYYYMMDD &fields= 7377,7373,11429,11779,11780&outputFormat=JSON JSON/ JSON2/ CSV/ TSV/ XLS/ ERX |
Details of input parameter and its values in POST request payload and GET Request URL String of ‘adhocReport’ endpoint to extract and OLAP report data.
Input Parameter | Description |
reportName | Name of the Report. As name indicates, report name should be provided in string format. |
entityId | Single entity Id or multiple entity Id’s with comma (,) or tilde (~) as separator should be provided in string format. |
beginDate | Beginning date of the report should be provided in this particular format (YYYYMMDD). |
endDate | End Date of the report should be provided in this particular format (YYYYMMDD). |
fields | § Single field Id or multiple field Id’s with comma (,) or tilde (~) as separator should be provided in string format. § Fields related to entity or security characteristic should be given along with calculation or other performance fields. |
outputFormat | § Provide any one output format from the list JSON, JSON2, CSV, TSV, XLS, ERX to receive response in that particular format. § Any format apart from these given options will get you response in JSON2 format (default). |
Note:
Mandatory/Required parameters: reportName, beginDate, endDate, outputFormat
...