ISO Country Code and CFI code from DSS Terms and Conditions Request

rahul.deshmukh

Dear All,

I want to pass two different request to DSS Terms and Conditions Request.

In one request i want to pass ISO 3166 as Country code and get the response.

In second request i want to pass CFI Code: Code indicating the ISO10962 standard for the security classification and get the reponse.

I want to get the response for the below fields:

Normally i pass ISIN as a requests in DSS extraction but can we pass Country code/CFI code as a request ?

Thanks and regards,

Rahul D

Jirapongse

@rahul.deshmukh

You need to login to MyRefinitiv to see the GCODES.

Sorry. This forum is for programming type queries, rather than content queries. Please contact the helpdesk support team via MyRefinitiv regarding how to get those information.

Jirapongse

@rahul.deshmukh

Thank you for reaching out to us.

In order to perform extractions, you need to pass:

1. An instrument list that contains a list of instruments
2. A report template that contains a list of content fields

The DSS will extraction the content fields of the instrument list.

According to the question, I assume that you would like to add Country codes or CFI Codes into an instrument list. I don't think that you can do it. The "ISO Country Code" and "CFI Code" are content fields of the Terms and Conditions report template.

However, you can contact the Datascope Select support team directly via MyRefinitiv to confirm this.

Please correct me, if my understanding is wrong.

rahul.deshmukh

Hi
@Jirapongse ,

Sorry i did not mention in question. But i am looking for Master data information actually. For MIC, ISO Currency normally we dont need to pass any Instruments. Its just Currency or MIC data independant of any Instruments.

Does Refinitiv dont provide any Master Data Information ?

Thanks and regards,

Rahul D

Jirapongse

@rahul.deshmukh

If you mean the list of all possible values, please contact the Datascope Select support team directly via MyRefinitiv.

rahul.deshmukh

i already created ticket and they mentioned to use below api but i didnt understood which extration request we need :

URL: https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/GetCurrencies
Method: GET
Headers:
Prefer: odata.maxpagesize=10; respond-async

Jirapongse

@rahul.deshmukh

It uses DSS REST API to get this data.

The response looks like this:

You can refer to the DSS REST API Tutorials.

rahul.deshmukh

@Jirapongse thanks. But still i dont know for example in Python code i always provide extraction request with the request URL what you mentioned. So in this case what extraction request i can pass and what fields i can provide ? Or i dont need to provide any extraction request at all but with just the request url i can fetch iso codes from Python code ?

Jirapongse

@rahul.deshmukh

This endpoint (https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/GetCurrencies) is used to get the list of currency codes, ISO codes and their descriptions.

import requests
import json


url = "https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/GetCurrencies"


payload = {}
headers = {
  'Prefer': 'respond-async',
  'Content-Type': 'application/json',
  'Authorization': 'Token <token>'
}


response = requests.request("GET", url, headers=headers, data=payload)


print(response.text)

The output is:

You can also refer to the REST API Reference Tree to get other information.

rahul.deshmukh

@Jirapongse thanks i am able to get all currencies now. I tried to search for all MIC's also but could not find in the document. Do you know how to get that ? I got response from the ticket that MIC list cannot be extracted from REST API but it can be extracted with gcode but the link they provided is not working. Do you know about this ?

MIC Codes link: https://my.refinitiv.com/gcodes/mic_cds.html
Currency Code links: https://my.refinitiv.com/gcodes/currency_cds.html

We would also like to get below information but dont know how to get it :

• CFI Klassifikation ISO 10962 (:2015 - :2021)

• Country EEA Membership Information