We are not receiving any SWIFT data for either Debt or Equity.
Request body for Debt -
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.DebtCorporateActionsIsoExtractionRequest",
"Condition": {
"ReportDateRangeType": "Init",
"IncludeInstrumentsWithNoEvents": true,
"IncludeNullDates": true,
"ExcludeDeletedEvents": true,
"IncludeNonPendingEvents": true,
"ReportIsoEvents": [
"BIDS",
"DTCH",
"TEND",
"CONS",
"BPUT",
"CONV",
"EXOF"
],
"IncludeCusipCinsIn35B": true,
"Wrap35BLines": true
},
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "US172967MD09",
"IdentifierType": "Isin"
},
{
"Identifier": "US12543DBN93",
"IdentifierType": "Isin"
},
{
"Identifier": "US50202MAB81",
"IdentifierType": "Isin"
}
],
"ValidationOptions": {
"AllowOpenAccessInstruments": true,
"AllowHistoricalInstruments": true,
"AllowLimitedTermInstruments": true,
"AllowInactiveInstruments": true,
"AllowUnsupportedInstruments": true,
"ExcludeFinrAsPricingSourceForBonds": true,
"UseExchangeCodeInsteadOfLipper": true,
"UseUsQuoteInsteadOfCanadian": true,
"UseConsolidatedQuoteSourceForUsa": true,
"UseConsolidatedQuoteSourceForCanada": true,
"UseDebtOverEquity": true,
"UseOtcPqSource": true,
"AllowSubclassImport": true
},
"UseUserPreferencesForValidationOptions": false
}
}
}
Request body for Equity -
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.CorporateActionsIsoExtractionRequest",
"Condition": {
"ReportDateRangeType": "Init",
"ReportIsoEvents": [
"BIDS",
"TEND",
"EXRI",
"PRIO",
"CONV",
"EXOF",
"MRGR"
],
"IncludeNonPendingEvents": true,
"GrossAmountOnlyForPaymentEvents": true,
"ExcludeNilPaidFromPaymentEvents": true,
"IncludeCusipCinsIn35B": true,
"Wrap35BLines": true
},
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "US8256901005",
"IdentifierType": "Isin"
},
{
"Identifier": "US172967MD09",
"IdentifierType": "Isin"
},
{
"Identifier": "US12543DBN93",
"IdentifierType": "Isin"
},
{
"Identifier": "US50202MAB81",
"IdentifierType": "Isin"
}
],
"ValidationOptions": {
"AllowOpenAccessInstruments": true,
"AllowHistoricalInstruments": true,
"AllowLimitedTermInstruments": true,
"AllowInactiveInstruments": true,
"AllowUnsupportedInstruments": true,
"ExcludeFinrAsPricingSourceForBonds": true,
"UseExchangeCodeInsteadOfLipper": true,
"UseUsQuoteInsteadOfCanadian": true,
"UseConsolidatedQuoteSourceForUsa": true,
"UseConsolidatedQuoteSourceForCanada": true,
"UseDebtOverEquity": true,
"UseOtcPqSource": true,
"AllowSubclassImport": true
},
"UseUserPreferencesForValidationOptions": false
}
}
}
Valid SWIFTs exist for these ISINs, but the response we’re receiving is shown below:
For Equity -
{
"@odata.context": https://selectapi.datascope.lseg.com/RestApi/v1/$metadata#RawExtractionResults/$entity,
"JobId": "0x09d2d6411c5be753",
"Notes": [
"Extraction Services Version 19.1.1.49259 (329bc4e78f6b), Built Jan 13 2026 08:05:31\r\nCorporate Action ISO Report Type is Initialization.\r\nProcessing started at 04/24/2026 11:08:47.\r\nUser ID: 9040669\r\nExtraction ID: 691538966\r\nCorrelation ID: CiD/9040669/AAAAAA.09d2d6411c3be753/RA/EXT.691538966\r\nSchedule: _OnD_0x09d2d6411c5be753 (ID = 0x09d2d6411cebe753)\r\nInput List (4 items): _OnD_0x09d2d6411c5be753 (ID = 09d2d6411c9be753) Created: 04/24/2026 11:08:20 Last Modified: 04/24/2026 11:08:20\r\nSchedule Time: 04/24/2026 11:08:21\r\nReport Template (0 fields): _OnD_0x09d2d6411c5be753 (ID = 0x09d2d6411c8be753) Created: 04/24/2026 11:08:20 Last Modified: 04/24/2026 11:08:20\r\nRequested Corporate Action ISO events: BIDS,CONV,EXOF,EXRI,MRGR,PRIO,TEND\r\nReporting all Pending Corporate Actions.\r\nProcessing completed successfully at 04/24/2026 11:09:24, taking 36.4 Secs.\r\nExtraction finished at 04/24/2026 10:09:24 UTC, with servers: xc92jxchA05, QSDHA1 (0.0 secs), QSHC02 (36.3 secs)\r\n2 Corporate Action ISO messages were generated.\r\nUsage Summary for User 9040669, Client 117926, Template Type Corporate Actions, ISO15022\r\nBase Usage\r\n Instrument Instrument Terms Price\r\n Count Type Subtype Source Source\r\n------- ----------------------------------- ---------------------------- -------------- ----------------------------------------\r\n 1 Corporate Convertible N/A N/A\r\n 1 Corporate High Yield N/A N/A\r\n 1 Corporate Investment Grade N/A N/A\r\n 1 Equities N/A N/A\r\n-------\r\n 4 Total instruments charged.\r\n 0 Instruments with no reported data.\r\n=======\r\n 4 Instruments in the input list.\r\n"
]
}
For Debt -
{
"@odata.context": https://selectapi.datascope.lseg.com/RestApi/v1/$metadata#RawExtractionResults/$entity,
"JobId": "0x09d3211b594be7bd",
"Notes": [
"Extraction Services Version 19.1.1.49259 (329bc4e78f6b), Built Jan 13 2026 08:14:37\r\nProcessing started at 04/24/2026 11:12:31.\r\nUser ID: 9040669\r\nExtraction ID: 2000001170094269\r\nCorrelation ID: CiD/9040669/AAAAAA.09d3211b591be7bd/RA\r\nSchedule: 0x09d3211b594be7bd (ID = 0x0000000000000000)\r\nInput List (3 items): (ID = 0x09d3211b594be7bd) Created: 04/24/2026 11:12:31 Last Modified: 04/24/2026 11:12:31\r\nReport Template (0 fields): _OnD_0x09d3211b594be7bd (ID = 0x09d3211b598be7bd) Created: 04/24/2026 11:12:29 Last Modified: 04/24/2026 11:12:29\r\nSchedule dispatched via message queue (0x09d3211b594be7bd)\r\nSchedule Time: 04/24/2026 11:12:31\r\nRequested Debt Corporate Action ISO events: BIDS,DTCH,TEND,CONS,BPUT,CONV,EXOF\r\nReporting all Pending Debt Corporate Actions\r\nProcessing completed successfully at 04/24/2026 11:12:33, taking 1.188 Secs.\r\nExtraction finished at 04/24/2026 10:12:33 UTC, with servers: xc27en3nQ23, QSDHA1 (0.0 secs), QSHC06 (0.1 secs)\r\nUsage Summary for User 9040669, Client 117926, Template Type Debt Corporate Actions, ISO15022\r\nBase Usage\r\n Instrument Instrument Terms Price\r\n Count Type Subtype Source Source\r\n------- ----------------------------------- ---------------------------- -------------- ----------------------------------------\r\n 1 Corporate Convertible N/A N/A\r\n 1 Corporate High Yield N/A N/A\r\n 1 Corporate Investment Grade N/A N/A\r\n-------\r\n 3 Total instruments charged.\r\n 0 Instruments with no reported data.\r\n=======\r\n 3 Instruments in the input list.\r\nNo Corporate Debt ISO messages were generated.\r\n"
]
}
Can you please help are we doing anything wrong here? Also, can you validate whether the request body will return the latest SWIFTs, or if any changes are required?
Also, want to know under which json key value we will get valid SWIFT message and if any error is there then will we get that tag or what tag we will receive?
