question

Upvotes
Accepted
5 3 2 5

NFE REF data download using Term and Conditions

Hi,

Would you please provide the RestAPI call for requesting the “Term and Conditions” data for NFE using static RIC chains. Also provide the list of columns to be added in request. We are currently downloading NFE REF data using HistoricalReferenceExtractionRequest. PFA the request format that we use currently.reqfile-refdata-1809.txt. and help us in understanding the difference between these 2 data and also the way to download data from “Term and Conditions”

Thanks,

Aishwarya

tick-history-rest-apidata
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.

1 Answer

Upvotes
Accepted
4.4k 10 6 9

Hi @Aishwarya.s1

We have a tutorial on the DSS product page.

First, you could request a list of available fields from either /Extractions/GetValidContentFieldTypes or /Extractions/GetValidExtractionFieldNames end point.

GET "https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/GetValidContentFieldTypes(ReportTemplateType=ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ReportTemplateTypes'TermsAndConditions')"
GET "https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/GetValidExtractionFieldNames(ReportTemplateType=ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ReportTemplateTypes'TermsAndConditions')"

Once you choose the fields you want, you can just use the same IdentifierList from your HistoricalReference request if you want to request the same RIC chains.

POST "https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/Extract"
Prefer: respond-async
Content-Type: application/json
Authorization: Token
{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
    "ContentFieldNames": [
      "RIC",
      "CUSIP",
      "ISIN",
      "SEDOL",
      "Issuer OrgID",
      "Currency Code"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [
        {"Identifier": "0#1NBB:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#1NGB:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#1NGV:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#1NZO:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#2NBB:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#2NGB:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#2NGV:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#2NZO:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NBB:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEA:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEAH8+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEAM8+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEAU7+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEAU8+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEAYFS-:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEAYZ0+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEAYZ8+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEAYZ9+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEAZ7+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEAZ8+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NED:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEE:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEEH8+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEEM8+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEEU7+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEEU8+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEEYFS-:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEEYZ0+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEEYZ8+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEEYZ9+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEEZ7+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEEZ8+",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEG:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEH:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEO:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEX:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NEY:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NGB:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NGV:",
        "IdentifierType": "ChainRIC"},
        {"Identifier": "0#NZO:",
        "IdentifierType": "ChainRIC"}
      ]
    }
  }
}
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.

Hi,

We have tried to download the data using attached the attached fields tick-history-custom-extractions-data-dictionary-oc.zip shared by TRTH. The Request throws the following error nfe-tnc-request-processed.txt. It looks like permission is restricted for few of the fields. Would you please help us in getting this resolved?

Thanks,

Aishwarya