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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
y.bruyere avatar image
5 ●0 ●0 ●3

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-apidatascope-selectdssfunds
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.

Jirapongse avatar image   Jirapongse

@y.bruyere

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

3 Answers

· Write an Answer
Upvotes
Accepted
zoya faberov avatar image
32.2k ●40 ●11 ●20

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
zoya faberov avatar image
32.2k ●40 ●11 ●20

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
y.bruyere avatar image
5 ●0 ●0 ●3

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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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