dss-generate-python-code-using-postman.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "63f7ec8b",
   "metadata": {},
   "source": [
    "# Generate code for a REST API call using Postman in a few clicks\n",
    "Have you ever had to implement a request for an API call in any programming language? If so and in case you haven't heard about this, the Postman application can convert an API request into a code snippet in a programming language in just a few clicks."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "11e979ec",
   "metadata": {},
   "source": [
    "# 3. Refinitiv DataScope Select - REST API (DSS API)\n",
    "Python code for calling an DSS API\n",
    "## 3.1) User authentication\n",
    "Replace **[DSS_USERNAME]** and **[DSS_PASSWORD]** with your credentials"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "58898bca",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\"@odata.context\":\"https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#Edm.String\",\"value\":\"_BJwHppG12U8_GtdwmBrrCn_gdBFUwendw79bWmavgBcITQcCq8XUy5SL-eP8b-IgvF3--eF-eXCg3rtS6w70cDcRKMMnaSV4nvMkBa_Gnq99WX-yi19H_o5j8uKZJA9aD9a_6SmyoJ-WNnS8LUujKdsfx1g44U4jUwo00VsWyDO_GOT03bGR0eRJBjbAlcrflqs6Pry5RK-wWr-GiO8nX8OU9sbllUq1dDW5wbcdE9QWolpFVg0lmCRBfHoYUJD32reXkkXwdG2fJN5G2MM5uUoDBdrV30RtKS5g1FcS9hs\"}\n"
     ]
    }
   ],
   "source": [
    "import requests\n",
    "import json\n",
    "\n",
    "dss_token_url = \"https://selectapi.datascope.refinitiv.com/RestApi/v1/Authentication/RequestToken\"\n",
    "\n",
    "dss_token_payload = json.dumps({\n",
    "  \"Credentials\": {\n",
    "    \"Username\": \"[DSS_USERNAME]\",\n",
    "    \"Password\": \"[DSS_PASSWORD]\"\n",
    "  }\n",
    "})\n",
    "dss_token_headers = {\n",
    "  'Prefer': 'respond-async',\n",
    "  'Content-Type': 'application/json'\n",
    "}\n",
    "\n",
    "dss_token_response = requests.request(\"POST\", dss_token_url, headers=dss_token_headers, data=dss_token_payload)\n",
    "\n",
    "print(dss_token_response.text)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bd95071a",
   "metadata": {},
   "source": [
    "#### Print the response in JSON format"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c31a982f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\n",
      "    \"@odata.context\": \"https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#Edm.String\",\n",
      "    \"value\": \"_BJwHppG12U8_GtdwmBrrCn_gdBFUwendw79bWmavgBcITQcCq8XUy5SL-eP8b-IgvF3--eF-eXCg3rtS6w70cDcRKMMnaSV4nvMkBa_Gnq99WX-yi19H_o5j8uKZJA9aD9a_6SmyoJ-WNnS8LUujKdsfx1g44U4jUwo00VsWyDO_GOT03bGR0eRJBjbAlcrflqs6Pry5RK-wWr-GiO8nX8OU9sbllUq1dDW5wbcdE9QWolpFVg0lmCRBfHoYUJD32reXkkXwdG2fJN5G2MM5uUoDBdrV30RtKS5g1FcS9hs\"\n",
      "}\n"
     ]
    }
   ],
   "source": [
    "import json\n",
    "dss_token_response_json = json.loads(dss_token_response.text)\n",
    "print(json.dumps(dss_token_response_json, indent=4, sort_keys=True))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ec4c54d0",
   "metadata": {},
   "source": [
    "## 3.2) Request EoD data\n",
    "Replace **[TOKEN]** with Token from the previous step"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "fce16a09",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\"@odata.context\":\"https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult\",\"Contents\":[{\"IdentifierType\":\"Cusip\",\"Identifier\":\"438516AC0\",\"Ask Price\":null,\"Asset Category\":null,\"Asset Category Description\":null,\"Asset ID\":\"0x0000190000004b52\",\"Asset Status\":\"MAT\",\"Asset Status Description\":\"Expired/Matured\",\"Asset SubType\":\"CIND\",\"Asset SubType Description\":\"Industrials\",\"Asset Type\":\"CORP\",\"Asset Type Description\":\"Corporate\",\"Bid Price\":null,\"Block Trades\":null,\"CIN Code\":null,\"Common Code\":\"038610325\",\"Currency Code\":\"USD\",\"Currency Code Description\":\"U.S. Dollar\",\"Currency Code Scaled\":\"USD\",\"Currency Code Scaled Description\":\"U.S. Dollar\",\"CUSIP\":\"438516AC0\",\"Exchange Code\":\"EJV\",\"Exchange Description\":\"REFINITIV PRICING SERVICE\",\"Exercise Style\":null,\"Expiration Date\":null,\"File Code\":null,\"High Price\":null,\"Instrument ID\":\"438516AC0\",\"Instrument ID Type\":\"CSP\",\"ISIN\":\"US438516AC05\",\"Issuer OrgID\":\"18181\",\"Lot Size\":null,\"Low Price\":null,\"Market MIC\":null,\"MIC\":null,\"Mid Price\":null,\"Net Asset Value\":null,\"Number of Price Moves\":null,\"Offer Price\":null,\"Official Close Price\":null,\"Open Price\":null,\"Previous Close Price\":null,\"Put Call Indicator\":null,\"Quote ID\":\"0x000405000002c5c6\",\"RCP ID\":\"300018181\",\"RIC\":null,\"Security Description\":\"HON    9.500 06/01/16 MATd\",\"SEDOL\":null,\"Settlement Date\":null,\"Settlement Price\":null,\"SICC\":null,\"Sicovam\":null,\"Strike Price\":null,\"Ticker\":\"HON\",\"Trade Date\":null,\"Trading Status\":0,\"Trading Symbol\":null,\"Turnover\":null,\"Underlying RIC\":null,\"Universal Ask Price\":null,\"Universal Bid Ask Date\":null,\"Universal Bid Price\":null,\"Universal Close Price\":null,\"Usage Instrument SubType\":null,\"Usage Instrument Type\":\"Corporate\",\"Valoren\":null,\"Volume\":null,\"VWAP Price\":null,\"Wertpapier\":\"A0T020\"},{\"IdentifierType\":\"Ric\",\"Identifier\":\"IBM.N\",\"Ask Price\":130.79,\"Asset Category\":\"ORD\",\"Asset Category Description\":\"Ordinary\",\"Asset ID\":\"0x0003dd001379d460\",\"Asset Status\":\"ISS\",\"Asset Status Description\":\"Issued\",\"Asset SubType\":\"ODSH\",\"Asset SubType Description\":\"Ordinary shares\",\"Asset Type\":\"EQTY\",\"Asset Type Description\":\"Equities\",\"Bid Price\":130.78,\"Block Trades\":2,\"CIN Code\":null,\"Common Code\":null,\"Currency Code\":\"USD\",\"Currency Code Description\":\"U.S. Dollar\",\"Currency Code Scaled\":\"USD\",\"Currency Code Scaled Description\":\"U.S. Dollar\",\"CUSIP\":\"459200101\",\"Exchange Code\":\"NYS\",\"Exchange Description\":\"New York Stock Exchange\",\"Exercise Style\":null,\"Expiration Date\":null,\"File Code\":\"77\",\"High Price\":132.94,\"Instrument ID\":\"IBM.N\",\"Instrument ID Type\":\"RIC\",\"ISIN\":\"US4592001014\",\"Issuer OrgID\":\"18228\",\"Lot Size\":null,\"Low Price\":129.95,\"Market MIC\":\"XNYS\",\"MIC\":\"XNYS\",\"Mid Price\":130.785,\"Net Asset Value\":null,\"Number of Price Moves\":11222,\"Offer Price\":null,\"Official Close Price\":null,\"Open Price\":129.95,\"Previous Close Price\":129.13,\"Put Call Indicator\":null,\"Quote ID\":\"0x0003dc004a024fd8\",\"RCP ID\":\"300018228\",\"RIC\":\"IBM.N\",\"Security Description\":\"INTERNATIONAL BUSINESS MACHINES ORD\",\"SEDOL\":\"2005973\",\"Settlement Date\":null,\"Settlement Price\":null,\"SICC\":null,\"Sicovam\":null,\"Strike Price\":null,\"Ticker\":\"IBM\",\"Trade Date\":\"2022-05-11\",\"Trading Status\":1,\"Trading Symbol\":\"IBM\",\"Turnover\":186178882,\"Underlying RIC\":null,\"Universal Ask Price\":130.79,\"Universal Bid Ask Date\":\"2022-05-11\",\"Universal Bid Price\":130.78,\"Universal Close Price\":130.75,\"Usage Instrument SubType\":null,\"Usage Instrument Type\":\"Equities\",\"Valoren\":\"941800\",\"Volume\":1418834,\"VWAP Price\":131.2196,\"Wertpapier\":\"851399\"}],\"Notes\":[\"Extraction Services Version 15.3.43289 (a0ece9924909), Built Mar  1 2022 16:25:01\\r\\nHoliday Rollover of Universal Close Price waived.\\r\\nProcessing started at 13/05/2022 01:43:18.\\r\\nUser ID: 9029477\\r\\nExtraction ID: 589559761\\r\\nCorrelation ID: CiD/9029477/AAAAAA.0802871061cde3ba/RA/EXT.589559761\\r\\nSchedule: _OnD_0x0802871061dde3ba (ID = 0x08028710676de3ba)\\r\\nInput List (2 items): _OnD_0x0802871061dde3ba (ID = 08028710626de3ba) Created: 13/05/2022 01:43:16 Last Modified: 13/05/2022 01:43:17\\r\\nSchedule Time: 13/05/2022 01:43:17\\r\\nReport Template (73 fields): _OnD_0x0802871061dde3ba (ID = 0x0802871061ede3ba) Created: 13/05/2022 01:43:16 Last Modified: 13/05/2022 01:43:16\\r\\n(CSP,438516AC0,EJV) is inactive.\\r\\nColumn 'CIN Code' suppressed for lack of 'CIN Code' permission.\\r\\nProcessing completed successfully at 13/05/2022 01:43:22, taking 4.33 Secs.\\r\\nExtraction finished at 12/05/2022 18:43:22 UTC, with servers: x01a02, QSDHA1 (0.0 secs), QSHC17 (0.6 secs)\\r\\nUsage Summary for User 9029477, Client 65500, Template Type EOD Pricing\\r\\nBase Usage\\r\\n        Instrument                          Instrument                   Terms          Price\\r\\n  Count Type                                Subtype                      Source         Source\\r\\n------- ----------------------------------- ---------------------------- -------------- ----------------------------------------\\r\\n      1 Corporate                                                        N/A            N/A\\r\\n      1 Equities                                                         N/A            N/A\\r\\n-------\\r\\n      2 Total instruments charged.\\r\\n      0 Instruments with no reported data.\\r\\n=======\\r\\n      2 Instruments in the input list.\\r\\nNo Evaluated Pricing Service complex usage to report -- 2 Instruments in the input list had no reported data.\\r\\n\"]}\n"
     ]
    }
   ],
   "source": [
    "import requests\n",
    "import json\n",
    "\n",
    "dss_eod_url = \"https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes\"\n",
    "\n",
    "dss_eod_payload = json.dumps({\n",
    "  \"ExtractionRequest\": {\n",
    "    \"@odata.type\": \"#DataScope.Select.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest\",\n",
    "    \"ContentFieldNames\": [\n",
    "      \"Ask Price\",\n",
    "      \"Asset Category\",\n",
    "      \"Asset Category Description\",\n",
    "      \"Asset ID\",\n",
    "      \"Asset Status\",\n",
    "      \"Asset Status Description\",\n",
    "      \"Asset SubType\",\n",
    "      \"Asset SubType Description\",\n",
    "      \"Asset Type\",\n",
    "      \"Asset Type Description\",\n",
    "      \"Bid Price\",\n",
    "      \"Block Trades\",\n",
    "      \"CIN Code\",\n",
    "      \"Common Code\",\n",
    "      \"Currency Code\",\n",
    "      \"Currency Code Description\",\n",
    "      \"Currency Code Scaled\",\n",
    "      \"Currency Code Scaled Description\",\n",
    "      \"CUSIP\",\n",
    "      \"Exchange Code\",\n",
    "      \"Exchange Description\",\n",
    "      \"Exercise Style\",\n",
    "      \"Expiration Date\",\n",
    "      \"File Code\",\n",
    "      \"High Price\",\n",
    "      \"Instrument ID\",\n",
    "      \"Instrument ID Type\",\n",
    "      \"ISIN\",\n",
    "      \"Issuer OrgID\",\n",
    "      \"Lot Size\",\n",
    "      \"Low Price\",\n",
    "      \"Market MIC\",\n",
    "      \"MIC\",\n",
    "      \"Mid Price\",\n",
    "      \"Net Asset Value\",\n",
    "      \"Number of Price Moves\",\n",
    "      \"Offer Price\",\n",
    "      \"Official Close Price\",\n",
    "      \"Open Price\",\n",
    "      \"Previous Close Price\",\n",
    "      \"Put Call Indicator\",\n",
    "      \"Quote ID\",\n",
    "      \"RCP ID\",\n",
    "      \"RIC\",\n",
    "      \"Security Description\",\n",
    "      \"SEDOL\",\n",
    "      \"Settlement Date\",\n",
    "      \"Settlement Price\",\n",
    "      \"SICC\",\n",
    "      \"Sicovam\",\n",
    "      \"Strike Price\",\n",
    "      \"Ticker\",\n",
    "      \"Trade Date\",\n",
    "      \"Trading Status\",\n",
    "      \"Trading Symbol\",\n",
    "      \"Turnover\",\n",
    "      \"Underlying RIC\",\n",
    "      \"Universal Ask Price\",\n",
    "      \"Universal Bid Ask Date\",\n",
    "      \"Universal Bid Price\",\n",
    "      \"Universal Close Price\",\n",
    "      \"Usage Instrument SubType\",\n",
    "      \"Usage Instrument Type\",\n",
    "      \"Valoren\",\n",
    "      \"Volume\",\n",
    "      \"VWAP Price\",\n",
    "      \"Wertpapier\"\n",
    "    ],\n",
    "    \"IdentifierList\": {\n",
    "      \"@odata.type\": \"#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList\",\n",
    "      \"InstrumentIdentifiers\": [\n",
    "        {\n",
    "          \"Identifier\": \"438516AC0\",\n",
    "          \"IdentifierType\": \"Cusip\"\n",
    "        },\n",
    "        {\n",
    "          \"Identifier\": \"IBM.N\",\n",
    "          \"IdentifierType\": \"Ric\"\n",
    "        }\n",
    "      ]\n",
    "    },\n",
    "    \"Condition\": None\n",
    "  }\n",
    "})\n",
    "dss_eod_headers = {\n",
    "  'Prefer': 'respond-async',\n",
    "  'Content-Type': 'application/json',\n",
    "  'Authorization': 'Token [TOKEN]'\n",
    "}\n",
    "\n",
    "dss_eod_response = requests.request(\"POST\", dss_eod_url, headers=dss_eod_headers, data=dss_eod_payload)\n",
    "\n",
    "print(dss_eod_response.text)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1693b15f",
   "metadata": {},
   "source": [
    "#### Print the response in JSON format"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "8ffcc79a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\n",
      "    \"@odata.context\": \"https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult\",\n",
      "    \"Contents\": [\n",
      "        {\n",
      "            \"Ask Price\": null,\n",
      "            \"Asset Category\": null,\n",
      "            \"Asset Category Description\": null,\n",
      "            \"Asset ID\": \"0x0000190000004b52\",\n",
      "            \"Asset Status\": \"MAT\",\n",
      "            \"Asset Status Description\": \"Expired/Matured\",\n",
      "            \"Asset SubType\": \"CIND\",\n",
      "            \"Asset SubType Description\": \"Industrials\",\n",
      "            \"Asset Type\": \"CORP\",\n",
      "            \"Asset Type Description\": \"Corporate\",\n",
      "            \"Bid Price\": null,\n",
      "            \"Block Trades\": null,\n",
      "            \"CIN Code\": null,\n",
      "            \"CUSIP\": \"438516AC0\",\n",
      "            \"Common Code\": \"038610325\",\n",
      "            \"Currency Code\": \"USD\",\n",
      "            \"Currency Code Description\": \"U.S. Dollar\",\n",
      "            \"Currency Code Scaled\": \"USD\",\n",
      "            \"Currency Code Scaled Description\": \"U.S. Dollar\",\n",
      "            \"Exchange Code\": \"EJV\",\n",
      "            \"Exchange Description\": \"REFINITIV PRICING SERVICE\",\n",
      "            \"Exercise Style\": null,\n",
      "            \"Expiration Date\": null,\n",
      "            \"File Code\": null,\n",
      "            \"High Price\": null,\n",
      "            \"ISIN\": \"US438516AC05\",\n",
      "            \"Identifier\": \"438516AC0\",\n",
      "            \"IdentifierType\": \"Cusip\",\n",
      "            \"Instrument ID\": \"438516AC0\",\n",
      "            \"Instrument ID Type\": \"CSP\",\n",
      "            \"Issuer OrgID\": \"18181\",\n",
      "            \"Lot Size\": null,\n",
      "            \"Low Price\": null,\n",
      "            \"MIC\": null,\n",
      "            \"Market MIC\": null,\n",
      "            \"Mid Price\": null,\n",
      "            \"Net Asset Value\": null,\n",
      "            \"Number of Price Moves\": null,\n",
      "            \"Offer Price\": null,\n",
      "            \"Official Close Price\": null,\n",
      "            \"Open Price\": null,\n",
      "            \"Previous Close Price\": null,\n",
      "            \"Put Call Indicator\": null,\n",
      "            \"Quote ID\": \"0x000405000002c5c6\",\n",
      "            \"RCP ID\": \"300018181\",\n",
      "            \"RIC\": null,\n",
      "            \"SEDOL\": null,\n",
      "            \"SICC\": null,\n",
      "            \"Security Description\": \"HON    9.500 06/01/16 MATd\",\n",
      "            \"Settlement Date\": null,\n",
      "            \"Settlement Price\": null,\n",
      "            \"Sicovam\": null,\n",
      "            \"Strike Price\": null,\n",
      "            \"Ticker\": \"HON\",\n",
      "            \"Trade Date\": null,\n",
      "            \"Trading Status\": 0,\n",
      "            \"Trading Symbol\": null,\n",
      "            \"Turnover\": null,\n",
      "            \"Underlying RIC\": null,\n",
      "            \"Universal Ask Price\": null,\n",
      "            \"Universal Bid Ask Date\": null,\n",
      "            \"Universal Bid Price\": null,\n",
      "            \"Universal Close Price\": null,\n",
      "            \"Usage Instrument SubType\": null,\n",
      "            \"Usage Instrument Type\": \"Corporate\",\n",
      "            \"VWAP Price\": null,\n",
      "            \"Valoren\": null,\n",
      "            \"Volume\": null,\n",
      "            \"Wertpapier\": \"A0T020\"\n",
      "        },\n",
      "        {\n",
      "            \"Ask Price\": 130.79,\n",
      "            \"Asset Category\": \"ORD\",\n",
      "            \"Asset Category Description\": \"Ordinary\",\n",
      "            \"Asset ID\": \"0x0003dd001379d460\",\n",
      "            \"Asset Status\": \"ISS\",\n",
      "            \"Asset Status Description\": \"Issued\",\n",
      "            \"Asset SubType\": \"ODSH\",\n",
      "            \"Asset SubType Description\": \"Ordinary shares\",\n",
      "            \"Asset Type\": \"EQTY\",\n",
      "            \"Asset Type Description\": \"Equities\",\n",
      "            \"Bid Price\": 130.78,\n",
      "            \"Block Trades\": 2,\n",
      "            \"CIN Code\": null,\n",
      "            \"CUSIP\": \"459200101\",\n",
      "            \"Common Code\": null,\n",
      "            \"Currency Code\": \"USD\",\n",
      "            \"Currency Code Description\": \"U.S. Dollar\",\n",
      "            \"Currency Code Scaled\": \"USD\",\n",
      "            \"Currency Code Scaled Description\": \"U.S. Dollar\",\n",
      "            \"Exchange Code\": \"NYS\",\n",
      "            \"Exchange Description\": \"New York Stock Exchange\",\n",
      "            \"Exercise Style\": null,\n",
      "            \"Expiration Date\": null,\n",
      "            \"File Code\": \"77\",\n",
      "            \"High Price\": 132.94,\n",
      "            \"ISIN\": \"US4592001014\",\n",
      "            \"Identifier\": \"IBM.N\",\n",
      "            \"IdentifierType\": \"Ric\",\n",
      "            \"Instrument ID\": \"IBM.N\",\n",
      "            \"Instrument ID Type\": \"RIC\",\n",
      "            \"Issuer OrgID\": \"18228\",\n",
      "            \"Lot Size\": null,\n",
      "            \"Low Price\": 129.95,\n",
      "            \"MIC\": \"XNYS\",\n",
      "            \"Market MIC\": \"XNYS\",\n",
      "            \"Mid Price\": 130.785,\n",
      "            \"Net Asset Value\": null,\n",
      "            \"Number of Price Moves\": 11222,\n",
      "            \"Offer Price\": null,\n",
      "            \"Official Close Price\": null,\n",
      "            \"Open Price\": 129.95,\n",
      "            \"Previous Close Price\": 129.13,\n",
      "            \"Put Call Indicator\": null,\n",
      "            \"Quote ID\": \"0x0003dc004a024fd8\",\n",
      "            \"RCP ID\": \"300018228\",\n",
      "            \"RIC\": \"IBM.N\",\n",
      "            \"SEDOL\": \"2005973\",\n",
      "            \"SICC\": null,\n",
      "            \"Security Description\": \"INTERNATIONAL BUSINESS MACHINES ORD\",\n",
      "            \"Settlement Date\": null,\n",
      "            \"Settlement Price\": null,\n",
      "            \"Sicovam\": null,\n",
      "            \"Strike Price\": null,\n",
      "            \"Ticker\": \"IBM\",\n",
      "            \"Trade Date\": \"2022-05-11\",\n",
      "            \"Trading Status\": 1,\n",
      "            \"Trading Symbol\": \"IBM\",\n",
      "            \"Turnover\": 186178882,\n",
      "            \"Underlying RIC\": null,\n",
      "            \"Universal Ask Price\": 130.79,\n",
      "            \"Universal Bid Ask Date\": \"2022-05-11\",\n",
      "            \"Universal Bid Price\": 130.78,\n",
      "            \"Universal Close Price\": 130.75,\n",
      "            \"Usage Instrument SubType\": null,\n",
      "            \"Usage Instrument Type\": \"Equities\",\n",
      "            \"VWAP Price\": 131.2196,\n",
      "            \"Valoren\": \"941800\",\n",
      "            \"Volume\": 1418834,\n",
      "            \"Wertpapier\": \"851399\"\n",
      "        }\n",
      "    ],\n",
      "    \"Notes\": [\n",
      "        \"Extraction Services Version 15.3.43289 (a0ece9924909), Built Mar  1 2022 16:25:01\\r\\nHoliday Rollover of Universal Close Price waived.\\r\\nProcessing started at 13/05/2022 01:43:18.\\r\\nUser ID: 9029477\\r\\nExtraction ID: 589559761\\r\\nCorrelation ID: CiD/9029477/AAAAAA.0802871061cde3ba/RA/EXT.589559761\\r\\nSchedule: _OnD_0x0802871061dde3ba (ID = 0x08028710676de3ba)\\r\\nInput List (2 items): _OnD_0x0802871061dde3ba (ID = 08028710626de3ba) Created: 13/05/2022 01:43:16 Last Modified: 13/05/2022 01:43:17\\r\\nSchedule Time: 13/05/2022 01:43:17\\r\\nReport Template (73 fields): _OnD_0x0802871061dde3ba (ID = 0x0802871061ede3ba) Created: 13/05/2022 01:43:16 Last Modified: 13/05/2022 01:43:16\\r\\n(CSP,438516AC0,EJV) is inactive.\\r\\nColumn 'CIN Code' suppressed for lack of 'CIN Code' permission.\\r\\nProcessing completed successfully at 13/05/2022 01:43:22, taking 4.33 Secs.\\r\\nExtraction finished at 12/05/2022 18:43:22 UTC, with servers: x01a02, QSDHA1 (0.0 secs), QSHC17 (0.6 secs)\\r\\nUsage Summary for User 9029477, Client 65500, Template Type EOD Pricing\\r\\nBase Usage\\r\\n        Instrument                          Instrument                   Terms          Price\\r\\n  Count Type                                Subtype                      Source         Source\\r\\n------- ----------------------------------- ---------------------------- -------------- ----------------------------------------\\r\\n      1 Corporate                                                        N/A            N/A\\r\\n      1 Equities                                                         N/A            N/A\\r\\n-------\\r\\n      2 Total instruments charged.\\r\\n      0 Instruments with no reported data.\\r\\n=======\\r\\n      2 Instruments in the input list.\\r\\nNo Evaluated Pricing Service complex usage to report -- 2 Instruments in the input list had no reported data.\\r\\n\"\n",
      "    ]\n",
      "}\n"
     ]
    }
   ],
   "source": [
    "dss_eod_response_json = json.loads(dss_eod_response.text)\n",
    "print(json.dumps(dss_eod_response_json, indent=4, sort_keys=True))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0ac3af3f",
   "metadata": {},
   "source": [
    "# Reference\n",
    "- [Refinitiv DataScope Select - REST API (DSS API)](https://developers.refinitiv.com/en/api-catalog/datascope-select/datascope-select-rest-api)\n",
    " - [Quickstart guide for DSS API](https://developers.refinitiv.com/en/api-catalog/datascope-select/datascope-select-rest-api/quick-start)\n",
    " - [DSS API Documentation](https://developers.refinitiv.com/en/api-catalog/datascope-select/datascope-select-rest-api/documentation)\n",
    " - [DSS REST Tutorials Postman collection](https://developers.refinitiv.com/en/api-catalog/datascope-select/datascope-select-rest-api/download)\n",
    "- [Postman](https://www.postman.com/)\n",
    " - [Generate Code Snippets](https://learning.postman.com/docs/sending-requests/generate-code-snippets/)\n",
    "\n",
    "# Thank you"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}