For a deeper look into our DataScope Select SOAP API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
CharlesCooke avatar image
3 ●0 ●2 ●1

Query Bond Schedule Table Error:

I am trying to query the bond schedule (specifically the call option within the gui) through the api. To test the query I am using the following:

{
   "ExtractionRequest": {
       "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.BondScheduleExtractionRequest",
       "ContentFieldNames": [
          "Asset ID"
       ],
       "IdentifierList": {
           "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
           "InstrumentIdentifiers": [
               {
                   "Identifier": "05490NAG0",
                   "IdentifierType": "Cusip"
               }
           ]
       }
   }
}

I can see that Asset ID is an option within the gui for Bond Schedule template with Report Option = Call

The code above generates the following error:

{
   "error": {
       "message": "Validation Error:\r\n\r\nInternal constraint \"ReportTemplate.Conditions.InvalidBondScheduleTypeCode\" execution failure: message='Value cannot be null.\r\nParameter name: source' / exid='5b8489d2-31e0-4d96-b4ed-0cc21f454074'"
   }
}

Thanks in advance for your assistance!

dss-rest-apidatascope-selectdsserrorbondssymbology
bondschedules.png (6.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
veerapath.rungruengrayubkul avatar image
11.3k ●25 ●8 ●13

From the error message, the BondScheduleTypeCode parameter is required and cannot be null. This parameters should be equivalent to the Generic Schedule Types in GUI.

For example, the following request is for Call Schedule Type.

{
   "ExtractionRequest": {
       "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.BondScheduleExtractionRequest",
       "ContentFieldNames": [
          "Asset ID"
       ],
       "IdentifierList": {
           "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
           "InstrumentIdentifiers": [
               {
                   "Identifier": "05490NAG0",
                   "IdentifierType": "Cusip"
               }
           ]
       },
       "Condition":
       {
       		"BondScheduleTypeCodes": ["CALS"]
       }
       
   }
}

You can find all defined values for this parameter in the REST API Reference Tree.


genericscheduletypes.png (19.1 KiB)
bondscheduletypecodes.png (36.7 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea