question

Upvotes
Accepted
5 5 3 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.

Hello @Aishwarya.s1,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

Hello @Aishwarya.s1,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

1 Answer

· Write an 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

Hi,

This should be permission issue. I have submitted a query to DSS support team on your behalf. The case# is 06015409.

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.