Problem with making extraction from DSS using REST API with Python

Arthur_Dent

Hi, I am having issues when trying to retrieve output using the following code. It looks like the token is retrieved but after that the extraction output location is not identified. The error I get is:

Error: 400 Client Error: Bad Request for url: https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw

Here is the code. Many thanks, in advance.

import requests
import json

#DSS credentials

USERNAME = 'myUsername'
PASSWORD = 'myPassword'
DSS_BASE_URL = 'https://selectapi.datascope.refinitiv.com/RestApi/v1'
#DSS_BASE_URL = 'https://selectapi.datascope.refinitiv.com/DatascopeApi/v1'

#Authenticate and get token

def get_dss_token():
url = f"{DSS_BASE_URL}/Authentication/RequestToken"
headers = {'Content-Type': 'application/json'}
data = {
"Credentials": {
"Username": USERNAME,
"Password": PASSWORD
}
}
response = requests.post(url, headers=headers, json=data)
response.raise_for_status()
return response.json()['value']

#Extract bond data using ISIN

def get_bond_info_by_isin(token, isin):
#url = f"{DSS_BASE_URL}/Extractions/ExtractWithNotes"

url = f"{DSS_BASE_URL}/Extractions/ExtractRaw"

headers = {

    'Content-Type': 'application/json',

    'Prefer': 'respond-async',

    'Authorization': f'Token {token}'

}


payload = {

    "ExtractionRequest": {

        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentExtractionRequest",

        "ContentFieldNames": [

            "RDMP.MaturityDate",         # Maturity Date

            "RDMP.Coupon",               # Coupon Rate

            "TR.TRBCIndustry",           # Industry (issuer)

            "TR.HeadquartersCountry"     # Country (issuer)

        ],

        "IdentifierList": {

            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",

            "InstrumentIdentifiers": [

                {"Identifier": isin, "IdentifierType": "ISIN"}

            ],

            "ValidationOptions": None,

            "UseUserPreferencesForValidationOptions": False

        },

        "Condition": None

    }

}


response = requests.post(url, headers=headers, json=payload)

response.raise_for_status()

results = response.json()


# Parse and print result

for row in results['Contents'][0]['Rows']:

    maturity = row['Cells'][0]['Value']

    coupon = row['Cells'][1]['Value']

    industry = row['Cells'][2]['Value']

    country = row['Cells'][3]['Value']

    print(f"ISIN: {isin}")

    print(f"  Maturity Date: {maturity}")

    print(f"  Coupon Rate: {coupon}")

    print(f"  Industry: {industry}")

    print(f"  Country: {country}")

#Main execution

if name == "main":
isin = "US91282CAV37" # Example: US Treasury Bond
try:
token = get_dss_token()
get_bond_info_by_isin(token, isin)
except Exception as e:
print("Error:", e)

Jirapongse

@Arthur_Dent

Thank you for reaching out to us.

According to the request message, you are using the InstrumentExtractionRequest request. I couldn't find it in the list of available extraction requests.

You can check it in the REST API Reference Tree.

You can refer to the following resources:

• LSEG DataScope Select Data Content Guide provides definitions of all of the data fields available in LSEG DataScope Select.
• LSEG DataScope Select - REST API Tutorials

Otherwise, you can contact the DSS support team directly via MyAccount and ask for report templates and content fields that can provide the required data.