For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
5 0 0 2

Legal Entity OrgId for Fund

We are trying to get Legal Entity OrgId for some funds having their Isin has input. The request works fine for usual equity but always returns null for fund.

Is there a way to either get the Legal Entity OrgId or the Issuer OrgId ?

I am happy to have another data type to retrieve The Issuer OrgId field which is not part of Legal Entity Detail Extraction Request

Following is the json request (produced in java)

{

"ExtractionRequest":{

"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.LegalEntityDetailExtractionRequest",

"Condition":{

"DeltaDays":-1

},

"ContentFieldNames":[

"IssuerOrgId"

],

"IdentifierList":{

"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.EntityIdentifierListWithValidationOptions",

"EntityIdentifiers":[

{

"Identifier":"IE00B6X2JP23",

"IdentifierType":"Isin",

"UserDefinedIdentifier":"IE00B6X2JP23"

},

{

"Identifier":"LU2083275854",

"IdentifierType":"Isin",

"UserDefinedIdentifier":"LU2083275854"

}

],

"ValidationOptions":{

"AllowDuplicateInstruments":true,

"IncludeParentAndUltimateParent":false,

"AllowUnmanagedOrUnverifiedEntities":true

},

"UseUserPreferencesForValidationOptions":false

}

}

}

It would be great to have a working json.

Also that would be great if there is a documentation with all the routes and fields available.

dss-rest-apidssdatascope-selectfunds
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Accepted
31.7k 37 11 19

Hello @y.bruyere ,

Apologies on delay in responding, I was off.

FundSearch request works with single identifier, there is no provision to pass multiple identifiers into a single request, please refer to DSS REST API Reference Tree.

If I had a requirement to submit these requests programmatically, I would absorb the required identifiers from a configuration, and issue the ID-specific request in a loop, as Search requests do not count toward your DSS Quota.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
31.7k 37 11 19

Hello @y.bruyere ,

Try

{ {protocol}}{ {host}}{ {api}}Search/FundSearch

{
    "SearchRequest": {
        "FundName": null,
        "DomicileCodes": null,
        "CurrencyCodes": null,
        "SubTypes": null,
        "IdentifierType": "Isin",
        "Identifier": "IE00B6X2JP23",
        "PreferredIdentifierType": "OrgId"
    }

}

From my testing, this results in:

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Search.FundSearchResult)",
    "value": [
        {
            "Identifier": "IE00B6X2JP23",
            "IdentifierType": "Isin",
            "Key": "VjF8MHgwMDAzZjgwNmVmZDNmYzNkfE1GUVV8SUUwMEI2WDJKUDIzfElTTg",
            "Description": "Comgest Growth Amer EUR R Acc",
            "InstrumentType": "Fund",
            "FundName": "Comgest Growth Amer EUR R Acc",
            "FundAdministrator": "RBC INVESTOR SERVICES IRELAND LIMITED",
            "PortfolioManager": "COMGEST ASSET MANAGEMENT INTERNATIONAL LIMITED",
            "DomicileCode": "IE",
            "CurrencyCode": "EUR",
            "InvestmentType": "Equity",
            "SubType": "MutualFund",
            "AssetStatus": "Active",
            "IssuerName": "",
            "IssuerOrgId": "105338777"
        }
    ]
}

I notice, that from DSS GUI's Search Bar, if I run a search on this ISIN as Entity, it does not find it, however, if I search it up as Fund, I get the result, so in this way, the behavior is consistent.

Hope this helps

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
5 0 0 2

Thank you @zoya.farberov the request works fine for one instrument.
However I have not found a way to send multiple identifiers using the SearchRequest. If I pass multiple Isins separated by a String the result is empty. Is there a way to pass multiple Isin at the same time like it is done with the EntityIdentifiers field for the ExtractionRequest ?

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.