Hi Team,
I have a list of RIC codes and I'm trying to get the corresponding CUSIP/ISIN and the dates for which the mapping is valid using RTH Python. I use the following code, but the CUSIP field always returns a null value. Not sure about the corresponding field for the Bloomberg ticker.
instrument_list = [{'Identifier': '3412583.XD', 'IdentifierType': 'Ric'}, {'Identifier': 'A.N', 'IdentifierType': 'Ric'}, {'Identifier': 'AA.N', 'IdentifierType': 'Ric'}, {'Identifier': 'AAL.N', 'IdentifierType': 'Ric'}, {'Identifier': 'AAL.OQ', 'IdentifierType': 'Ric'}]
requestBody = { 'ExtractionRequest': { '@odata.type': '#DataScope.Select.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest', 'ContentFieldNames': [ "Company Name", "Currency Code", "CUSIP", "ISIN", "Start date", "Change Date",], 'IdentifierList': { '@odata.type': '#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList', 'InstrumentIdentifiers': instrument_list, 'ValidationOptions': {'AllowHistoricalInstruments': 'true', 'AllowInactiveInstruments' : 'true'}, "UseUserPreferencesForValidationOptions": 'false' }, "Condition": {"ReportDateRangeType": "Range", "QueryStartDate": "2010-01-01", "QueryEndDate": "2015-09-09"} } } requestUrl = 'https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes' requestHeaders_extraction = { 'Prefer':'respond-async', 'Content-Type':'application/json', 'Authorization': 'token ' + auth_token } extraction_response = requests.post(requestUrl, json = requestBody, headers = requestHeaders_extraction)
can you please help me with the correct 'ContentFieldNames'/quert?
Thanks.