New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
rahul.deshmukh avatar image
23 ●11 ●18 ●24

DSS API request RICs and get the fields as response

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


#productdss-rest-apidssrics
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

· Write an Answer
Upvotes
Accepted
raksina.samasiri avatar image
15.6k ●33 ●5 ●10

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

1691724042516.png



1691724042516.png (55.0 KiB)
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.

rahul.deshmukh avatar image rahul.deshmukh
Hi @raksina.samasiri, thanks for the feedback. I will check this Request.
rahul.deshmukh avatar image rahul.deshmukh rahul.deshmukh
@raksina.samasiri thanks its working. We can close the ticket.
rahul.deshmukh avatar image rahul.deshmukh rahul.deshmukh
@raksina.samasiri @Jirapongse can we get history data starting from 01.01.2023 for this request ?

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.