GovCorp Search showing limited data

jose.weigand1

One major client is doing a GovCorp search via API and the response from the API is limited compared to the results in the GUI (I am able to reproduce it). They are specially interested in getting if the bond is a corporate or government bond.

Fields responded by the API with GovCorpSearch:

{'Identifier': 'XS3102778191', 'IdentifierType': 'Isin', 'Source': 'UTT', 'Key': 'VjF8MHgwMDEwNTUxYzBkODcxYmM4fDB4MDAxMDU1MDBiZTkxMWI3MXxVVFR8R0NCRHx8fEd8RXxYUzMxMDI3NzgxOTE9VVNUV3w', 'Description': "REP 4.500 Perp '31 FRN", 'InstrumentType': 'GovCorpBond', 'Status': 'Valid'}

Indeed the response from the GVOCorpSearch is the same answer as with a generic InstrumentSearch (weird).

{'Identifier': 'XS3102778191', 'IdentifierType': 'Isin', 'Source': 'UTT', 'Key': 'VjF8MHgwMDEwNTUxYzBkODcxYmM4fDB4MDAxMDU1MDBiZTkxMWI3MXxVVFR8R0NCRHxDT1JQfENGSU58R3xFfFhTMzEwMjc3ODE5MT1VU1RXfA', 'Description': "REP 4.500 Perp '31 FRN", 'InstrumentType': 'GovCorpBond', 'Status': 'Valid'}

GUI GovCorp Search shows "Debt Type" and other fields.

Can you please ley me know if we are doing something incorrectly ? Is it possible to perform a bond search and retrieve the Debt Type ?

Thanks

Jirapongse

@jose.weigand1

Thank you for reaching out to us.

I checked the REST API Reference Tree, the response of the /Search/GovCorpSearch search doesn't have the Debt Type field. For example:

  "value": [

        {

            "Identifier": "037833AK6",

            "IdentifierType": "Cusip",

            "Source": "FNS",

            "Key": "VjF8MHgwMDA0MDUxMjZiNzA4NjhlfDB4MDAwNDA1MTI2YjcwODY4ZXxGTlN8R0NRVXx8fEd8Tnx8",

            "Description": "AAPL   2.400 05/03/23",

            "InstrumentType": "GovCorpQuote",

            "Status": "Valid"

        },

        {

            "Identifier": "037833AK6",

            "IdentifierType": "Cusip",

            "Source": "JIO",

            "Key": "VjF8MHgwMDA0MDUxMjZiNzA4NjhlfDB4MDAwNDA1MTI2YjcwODY4ZXxKSU98R0NRVXx8fEd8Tnx8",

            "Description": "AAPL   2.400 05/03/23",

            "InstrumentType": "GovCorpQuote",

            "Status": "Valid"

        },

You can't specify which fields to retrieve when using search so this is an expected behavior.

The client needs to use another extraction to retrieve the Debt Type value. I found that the Composite and Terms and Conditions extractions can provide the Debt Type and Bond Type values. For example:

{

    "ExtractionRequest": {

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

        "ContentFieldNames": [

            "RIC",

            "CUSIP",

            "ISIN",

            "SEDOL",

            "Issuer OrgID",

            "Currency Code",

            "Debt Type",

            "Debt Type Description",

            "Bond Type Description"

        ],

        "IdentifierList": {

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

            "InstrumentIdentifiers": [

                {

                    "Identifier": "XS3102778191",

                    "IdentifierType": "Isin"

                },

                {

                    "Identifier": "DEA4ECY3=D",

                    "IdentifierType": "Ric"

                }

            ],

            "ValidationOptions": {

                "AllowHistoricalInstruments": true

            }

        }

    }

}

The output is:

    "Contents": [

        {

            "IdentifierType": "Isin",

            "Identifier": "XS3102778191",

            "RIC": "ES310277819=RRPS",

            "CUSIP": null,

            "ISIN": "XS3102778191",

            "SEDOL": "BVDCTJ1",

            "Issuer OrgID": "112102696",

            "Currency Code": "EUR",

            "Debt Type": "SUBNT",

            "Debt Type Description": "Subordinated Note",

            "Bond Type Description": "Corporate"

        },

        {

            "IdentifierType": "Ric",

            "Identifier": "DEA4ECY3=D",

            "RIC": "DEA4ECY3=D",

            "CUSIP": null,

            "ISIN": "XS3102778191",

            "SEDOL": "BVDCTJ1",

            "Issuer OrgID": "112102696",

            "Currency Code": "EUR",

            "Debt Type": "SUBNT",

            "Debt Type Description": "Subordinated Note",

            "Bond Type Description": "Corporate"

        }

You can refer to the LSEG DataScope Select Data Content Guide for other fields.