...
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 REST API.
Details on Individual GET Endpoints
Following are 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.
Performance Dictionaries | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/ |
Examples:
performanceDictionaries | |
Regular Dictionaries | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/regularDictionaries |
Global Attribution Fields |
Curl
Grouping Rule Filters |
Sample response:
[
{
"instance": 257,
"profileName": "13F Report",
"reportType": "Advanced Reporting ",
"updateUser": "BASELINE ADMIN",
"updateDate": 1398830400000
}
]
...
Grouping Rule Range | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/groupingRuleFilter |
Entity Types | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/entityTypes |
Details on Individual GET Endpoints
Following are details on individual GET endpoints.
reportProfiles: A GET request to return a list of fieldsreport profiles.
This includes gives the profile names of all types of Regular fields, Advance fields, Special fields, and Performance fieldsPerformance Calculations, OLAP Reports and Advanced reports.
Resource path: /eagle/report/v1/ |
reportProfiles | |
Examples: | |
Web Browser |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/ |
Sample response: [ |
instance": |
257, |
profileName": " |
13F Report", |
reportType": " |
Advanced Reporting ", |
updateUser": " |
"updateSource": "REGFA
BASELINE ADMIN", |
1398830400000 |
fieldsByIndicatorfields: A GET request to return the a 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
This includes all types of Regular fields, Advance fields, Special fields, and Performance fields.
Resource path: /eagle/report/v1/ |
fields | |
Examples: | |
Web Browser |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/ |
Sample response: [ |
139, |
i Settlement Date", |
T", |
Date", |
entitiesfieldsByIndicator: A GET request to return a the list of report entitiesfields by field indicator.
This includes all types of entities like Portfolios, Performance composites, Reporting Composites, and Entity List etcFields 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 |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/fieldsByIndicator/ |
H” | |
Sample response: [ |
{ |
"id": |
143, |
"description": " |
i Book Value (lot)", |
"indicator": " |
H" |
, |
"id
"type": " |
Numeric", |
"updateSource": " |
REGFA", |
"updateDate": 1268884800000 |
entityByIdentities: A GET request to return an entity based on its ID. This is to filter a specific entity using an 8-digit Entity IDa list of report entities.
This includes all types of entities like Portfolios, Performance composites, Reporting Composites, and Entity List etc.
Resource path: /eagle/report/v1/ |
entities | |
Examples: | |
Web Browser |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/ |
Sample response: [ |
"id": |
" |
23980", |
"name": |
" |
JKAUMC9", |
"type": |
" |
COMP" |
}, |
For another Entity
[
{
{ |
" |
10120", |
"name": |
" |
ALLGIPS ", |
"type": |
" |
LIST" |
} |
entitiesByEntityNameLikeentityById: A GET request to return a list of entities that contain the specified value in the Entity name. This applies filters on the Entity name to query the list of Entities matching with the entity name filter.
...
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 |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/ |
Sample response: [ |
{ |
"id": |
" |
LTTEST02", |
"name": |
" |
LTTEST02", |
"type": |
" |
PORT" |
} |
|
"id": |
" |
JKAUMC1", |
"name": |
"JKAUMC1 Entity Name", |
"type": |
"ACOM" |
} |
entitiesByTypeentitiesByEntityNameLike: 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, and Custom index. This endpoint is used to filter the entities by entity typethat contain the specified value in the Entity name. This applies 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 |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/ |
JKA” | |
Sample response: [ |
JKOPTST2", |
COPYJKACOM23 |
", |
ACOM" |
{ |
JKACOM36", |
Copy |
of |
JKACOM3 |
", |
ACOM" |
POST Method of REST Endpoint
adhocReport is a feature supported to extract OLAP report output using both POST and GET method. This runs a PACE report service based on the request payload input parameters in JSON format.
Request Formats:
POST
...
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, and Custom index. 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/ |
Payload:
{"reportName": "string",
"entityId
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/entitiesByType/COMP” |
Sample response: [ |
JKTXC34", |
|
name": " |
JK DQM VOL CMP34", |
type": " |
COMP" |
{ |
JKTXC35", |
name": " |
JK |
DQM |
"benchmarkToPortfolio": true/false,
"constituentsAndBenchmarkToComposite": true/false,
"firstAlternateCurrency
VOL CMP35", |
COMP" |
"fetchPriorFXRates": "number",
"benchmarkOverride": {
"Comparison Index 4":"string",
"Comparison Index 5": "string",
"IsEntities": true/false
},
}
GET
} |
entityTypes: A GET request to return a list of default Eagle entity types and custom entity types. This includes all types of default entities like Portfolios, Performance composites, reporting Composites, Entity List, Custom index etc., and user defined custom entity types.
Resource path: /eagle/report/v1/entityTypes | |
Examples: | |
Web Browser | https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/ |
entityTypes | |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/entityTypes” |
Sample response: [ |
performanceDictionaries: A GET request to return a list of performance dictionaries, which are otherwise called as stored performance models.
Resource path: /eagle/report/v1/performanceDictionaries | |
Examples: | |
Web Browser | https://O171-q001-ww01.eagleinvsys.com/eagle/report/v1/performanceDictionaries |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/performanceDictionaries” |
Sample response: [ |
regularDictionaries: A GET request to return a list of regular dictionaries.
Resource path: /eagle/report/v1/regularDictionaries | |
Examples: | |
Web Browser | https://O171-q001-ww01.eagleinvsys.com/eagle/report/v1/regularDictionaries |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/regularDictionaries” |
Sample response: [ |
groupingRuleRange: A GET request to return a list of grouping rule Range fields which are used to construct dynamic grouping.
Resource path: /eagle/report/v1/groupingRuleRange | |
Examples: | |
Web Browser | https://O171-q001-ww01.eagleinvsys.com/eagle/report/v1/groupingRuleRange |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1groupingRuleRange” |
Sample response: [ {"aggregationID": 8178, "aggregationDescription": "AG Range GR Field", "fieldAttributeDescription": "eglDca-Cost", "fieldAttributeId": "6841" }] |
groupingRuleFilter: A GET request to return a list of grouping rule filter fields, which are used to construct dynamic grouping.
Resource path: /eagle/report/v1/groupingRuleFilter | |
Examples: | |
Web Browser | https://O171-q001-ww01.eagleinvsys.com/eagle/report/v1/groupingRuleFilter |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/groupingRuleFilter” |
Sample response: [ |
globalAttributionFields: A GET request to return a list of global attribution fields of types Brinson Fachler, Karnosky Singer and Eagle Fixed Income style.
Resource path: /eagle/report/v1/globalAttributionFields | |
Examples: | |
Web Browser | https://O171-q001-ww01.eagleinvsys.com/eagle/report/v1/globalAttributionFields |
Curl | curl -u user:password “https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/globalAttributionFields” |
Sample response: [ |
POST Method of REST Endpoint
adhocReport is a feature supported to extract OLAP report output using both POST and GET method. This runs a PACE report service based on the request payload input parameters in JSON format.
Request Formats:
POST
URL : https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/adhocReport |
Payload: { "groupModel": [{"simple": "fieldID"},{"range": "aggregationID"},{"perfModel": "dictionaryID"}], |
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 |
Below are details of the input parameter and its values in the POST request payload and GET Request URL String of the adhocReport endpoint to extract and OLAP report data.
Input Parameter | Description | |
reportName | Name of the Report. As the name indicates, report name should be provided in string format. | |
entityId | Single entity ID or multiple entity Description | |
reportName | Name of the Report. As the name indicates, report name should be provided in string format. | |
entityId | Single entity ID or multiple entity IDs 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 |
| |
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 |
| |
outputFormat |
| |
constituentsAndBenchmarkToComposite | Provide boolean value either true or false. This flag is applicable only for Composite Analysis report. | |
benchmartToPortfolio | Provide boolean value either true or false. This flag is applicable for OLAP reports such as Performance Analysis, Positions and Entity And Client. | |
firstAlternateCurrency | Provide 3 letter predefined Currency code. For example, USD / CAD | |
secondAlternateCurrrency | Provide 3 letter predefined Currency code. For example, USD/CAD | |
fetchPriorFXRates | Provide numeric value starting from 1 till 1000. | |
"benchmarkOverride": { "Comparison Index 5": "<Entity ID>", "IsEntities": true } |
| "benchmarkOverride": { "IsEntities": false } |
Info |
---|
Note Mandatory/Required parameters: reportName, beginDate, endDate, outputFormat Optional parameters: fields, entities. If not given or given as empty string will submit and generate report with all fields and entities mapped with that respective report profile |
.
Sample POST Request with Payload:
Request URL: https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/adhocReport
Payload:
...
| |
outputFormat |
|
constituentsAndBenchmarkToComposite | Provide boolean value either true or false. This flag is applicable only for Composite Analysis report. |
benchmartToPortfolio | Provide boolean value either true or false. This flag is applicable for OLAP reports such as Performance Analysis, Positions and Entity And Client. |
firstAlternateCurrency | Provide 3 letter predefined Currency code. For example, USD / CAD |
secondAlternateCurrrency | Provide 3 letter predefined Currency code. For example, USD/CAD |
fetchPriorFXRates | Provide numeric value starting from 1 till 1000. |
"benchmarkOverride": { "Comparison Index 5": "<Entity ID>", "IsEntities": true } |
|
"benchmarkOverride": { "IsEntities": false } |
|
Info |
---|
Note Mandatory/Required parameters: reportName, beginDate, endDate, outputFormat Optional parameters: fields, entities. If not given or given as empty string will submit and generate report with all fields and entities mapped with that respective report profile |
.
Sample POST Request with Payload:
Request URL: https://o171-q001-ww01.eagleinvsys.com/eagle/report/v1/adhocReport
Payload:
{
"reportName": "AG - GroupingRule Override GRModel1",
"entityId": "MTHREN8",
"beginDate": "20200504",
"endDate": "20200504",
"fields": "1087,1099,3277",
"outputFormat": "JSON, CSV"
"benchmarkToPortfolio": true,
"constituentsAndBenchmarkToComposite": false,
"firstAlternateCurrency": "GBP",
"secondAlternateCurrrency": "AUD",
"fetchPriorFXRates": "4",
"benchmarkOverride": {
"Comparison Index 4":"Primary Comparison Index",
"IsEntities": false
},
"groupingRuleOverride": {
"groupModel": [{"simple": "1061"},{"range": "8178"},{"perfModel": "178"}],
"calculationAndDisplay": {
"calculateAttributionAndDisplay": "1060",
"limitResultToLevelAbove": "LimitFetchDisplay",
"showBelowAttribution": "true",
"hideBenchmarkOnlySecurities": "true"
},
"dynamicPerformance": {
"portfolioLookThrough": true,
"adjustSecurityToMatchParent": true,
"applyFilterToBenchmark": true
},
"entityHierarchy":"BOTTOMUPBALANCED",
"globalAttributionOptions": "14533"
},
}
GET METHOD:
Sample Request URL:
...