NFE REF data download using Term and Conditions

Aishwarya.s1

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

warat.boonyanit

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"}
      ]
    }
  }
}

Aishwarya.s1

https://community.developers.refinitiv.com/discussion/comment/20585#Comment_20585

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