Legal Entity OrgId for Fund

Options
y.bruyere
y.bruyere Newcomer
in DSS

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.

Tagged:

Best Answer

  • zoya faberov
    zoya faberov ✭✭✭✭✭
    Answer ✓

    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.

Answers

  • zoya faberov
    zoya faberov ✭✭✭✭✭

    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

  • y.bruyere
    y.bruyere Newcomer

    Thank you @zoya faberov 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 ?

Categories