DSS API request RICs and get the fields as response

rahul.deshmukh

Dear All,

We are using DSS REST API request and we need daily access to various central bank reference interest rates for below RIC:

USF=

USFFTARGET=

ECBDF=ECBF

SARON.S

SONIAOSR=

EUROND=

CORRA=

AUDOND=

JPONMU=RR

We need to request above RIC to the DSS Rest API request and get response for the below fields:

• RIC
• Security Description
• Universal Close Price Date
• Universal Close Price
• Base Currency

Can you please tell us which DSS REST Api we need to use which can provide us above information.

Thanks and regards,

Rahul D

raksina.samasiri

Hi @rahul.deshmukh ,

EndOfDayPricingExtractionRequest can be used,

url = "https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes"

With the request body below

{
   "ExtractionRequest":{
      "@odata.type":"#DataScope.Select.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest",
      "ContentFieldNames":[
         "RIC",
         "Security Description",
         "Universal Close Price Date",
         "Universal Close Price",
         "Base Currency Code"
      ],
      "IdentifierList":{
         "@odata.type":"#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
         "InstrumentIdentifiers":[
            { "Identifier":"USF=", "IdentifierType":"Ric" },
            { "Identifier":"USFFTARGET=", "IdentifierType":"Ric" },
            { "Identifier":"ECBDF=ECBF", "IdentifierType":"Ric" },
            { "Identifier":"SARON.S", "IdentifierType":"Ric" },
            { "Identifier":"SONIAOSR=", "IdentifierType":"Ric" },
            { "Identifier":"EUROND=", "IdentifierType":"Ric" },
            { "Identifier":"CORRA=", "IdentifierType":"Ric" },
            { "Identifier":"AUDOND=", "IdentifierType":"Ric" },
            { "Identifier":"JPONMU=RR", "IdentifierType":"Ric" }
         ],
         "ValidationOptions":null,
         "UseUserPreferencesForValidationOptions":false
      },
      "Condition":null
   }
}

response

rahul.deshmukh

https://community.developers.refinitiv.com/discussion/comment/107948#Comment_107948

Hi @raksina.samasiri, thanks for the feedback. I will check this Request.

rahul.deshmukh

https://community.developers.refinitiv.com/discussion/comment/108132#Comment_108132

@raksina.samasiri thanks its working. We can close the ticket.

rahul.deshmukh

https://community.developers.refinitiv.com/discussion/comment/108139#Comment_108139

@raksina.samasiri @Jirapongse can we get history data starting from 01.01.2023 for this request ?