DSS Rest API - Unable to retrieve output from Bond Schedules

waseem.bari

Could you please help me figure out how to make a request to Bond Schedule Template? Seems it is expecting a ‘Condition’ but I am not aware of the available values. Thanks!

@{ "ExtractionRequest": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.BondScheduleExtractionRequest", "ContentFieldNames": [ "Use of Proceeds Code", "Use of Proceeds Code Description" ], "IdentifierList": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList", "InstrumentIdentifiers": [ { "Identifier": "XS2374621493", "IdentifierType": "Isin" }, { "Identifier": "XS2631204182", "IdentifierType": "Isin" }, { "Identifier": "XS2604843206", "IdentifierType": "Isin" } ] }, "Condition": null } }

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='1d6c5146-29c3-4d26-bd50-c106953f9068'" } }

gareth.teage

@waseem.bari Hi Waseem, hope that helped, any follow up please reach out to me on internal Teams chat.

{
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.BondScheduleExtractionRequest",
        "ContentFieldNames": [
            "Asset ID",
            "Issue PermID",
            "Schedule Type",
            "Use of Proceeds Settlement Date",
            "Use of Proceeds Code",
            "Use of Proceeds Code Description",
            "Use of Proceeds Amount"
        ],
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "XS2374621493",
                    "IdentifierType": "Isin"
                },
                {
                    "Identifier": "XS2631204182",
                    "IdentifierType": "Isin"
                },
                {
                    "Identifier": "XS2604843206",
                    "IdentifierType": "Isin"
                }
            ],
            "ValidationOptions": {
                "AllowHistoricalInstruments": true,
                "AllowInactiveInstruments": true,
                "AllowLimitedTermInstruments": true,
                "AllowOpenAccessInstruments": true,
                "AllowSubclassImport": true,
                "AllowUnsupportedInstruments": false,
                "ExcludeFinrAsPricingSourceForBonds": false,
                "UseConsolidatedQuoteSourceForCanada": false,
                "UseConsolidatedQuoteSourceForUsa": false,
                "UseDebtOverEquity": true,
                "UseExchangeCodeInsteadOfLipper": false,
                "UseOtcPqSource": false,
                "UseUsQuoteInsteadOfCanadian": false
            },
            "UseUserPreferencesForValidationOptions": false
        },
        "Condition": {
            "BondScheduleTypeCodes": [
                "UOPH"
            ]
        }
    }
}