Hi Team,
We get 400 bad request error with refinitiv data api.
"Backend error. 400 Bad Request Requested universes: ['AAPL.OQ']. Requested fields: ['TR.IPODATE', 'TR.OFFICERNAME', 'TR.OFFICERTITLE', 'TR.OFFICERTITLESINCE', 'TR.OFFICERAGE', 'TR.ODOFFICERBIOGRAPHY', 'TR.COMPANYINCORPDATE', 'TR.ODOFFICERRANK', 'TR.ODOFFICERSTATUS', 'TR.ODOFFICERSTARTDATE', 'TR.ODOFFICERENDDATE', 'TR.ODOFFICERISDIRECTOR', 'TR.ODDIRECTORSTARTDATE', 'TR.ODOFFICERISOFFICER', 'TR.ODOFFICERISNONEXECUTIVE', 'TR.INVESTORFULLNAME', 'TR.PCTOFSHARESOUTHELD']"
I am trying to get officer data using below code snippet.
self.fields = [
'TR.IPODate',
'TR.OfficerName',
'TR.OfficerTitle',
'TR.OfficerTitleSince',
'TR.OfficerAge',
'TR.ODOfficerBiography',
'TR.CompanyIncorpDate',
'TR.ODOfficerRank',
'TR.ODOfficerStatus',
'TR.ODOfficerStartDate',
'TR.ODOfficerEndDate',
'TR.ODOfficerIsDirector',
'TR.ODDirectorStartDate',
'TR.ODOfficerIsOfficer',
'TR.ODOfficerIsNonExecutive',
'TR.InvestorFullName',
'TR.PctOfSharesOutHeld'
]
self.parameters={'RNK':'R1:R20','ODRnk':'R1:R20','TheInvestorType': '303:306', 'CH': 'Fd'}
self.column_mapping = {
'Instrument': 'ric',
'IPO Date': 'ipo_date',
'Officer Name': 'officer_name',
'Officer Title': 'officer_title',
'Officer Title Since': 'officer_title_since',
'Officer Age': 'office_age',
'Biography': 'biography',
'Date of Incorporation': 'date_of_incorporation',
'OD Officer Rank': 'od_officer_rank',
'Officer Status within the company': 'officer_status_within_the_company',
'Officer Start Date': 'officer_start_date',
'Officer End Date': 'officer_end_date',
'OD Officer Is Director': 'od_officer_is_director',
'Director Start Date': 'director_start_date',
'OD Officer Is Officer': 'od_officer_is_officer',
'OD Officer Is Non-Executive': 'od_officer_is_non_executive',
'Investor Full Name': 'investor_full_name',
'Holdings Pct Of Traded Shares Held': 'holdings_pct'
}
df=rd.get_data(
universe=['AAPL.OQ'],
# universe=rics[i:(i+500)],
fields=self.fields,
parameters=self.parameters
)
Please not that this had been working everyday. Today it fails suddenly.
Thanks,
