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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
waseem.bari avatar image
3 ●0 ●0 ●1

DSS Rest API - Unable to retrieve output from Bond Schedules

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'" } }

#technologydss-rest-api
icon clock
10 |1500

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

wasin.w avatar image   wasin.w

Hello @waseem.bari

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

aramyan.h avatar image   aramyan.h

Hi,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thank you,

AHS


1 Answer

· Write an Answer
Upvotes
Accepted
gareth.teage avatar image
260 ●2 ●2 ●4

@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"
            ]
        }
    }
}
icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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