Hello,
I have a download restriction of 10'000 lines and am doing data analysis in Python. So that I do not have to down all of this, I would like to use an API and loop it to download all the data. I am struggling with this. Below a screenshot of what I would like to download, and here the query:
rd.discovery.search(
view = rd.discovery.Views.GOV_CORP_INSTRUMENTS,
top = 10,
filter = "(DbType eq 'CORP' and RCSAssetCategory eq 'A:J' and DebtType ne 'SYKHYB' and DebtType ne 'SUK*' and (IsGreenBond eq false and (IssueDate ge 2011-12-31 and IssueDate le 2025-01-05)))",
select = "RIC,EJVAssetID,DTSubjectName,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DBSTicker,CouponRate,MaturityDate,IssueDate,ISIN,RCSCurrencyLeaf,RCSCountryLeaf,DbTypeDescription,InstrumentTypeDescription,RCSCouponTypeGenealogy,FaceIssuedUSD,RCSBondGradeLeaf,CUSIP,SEDOL,SICC,RCSFIClassificationCodes,IsGreenBond,IsESGBond,ESGScore,ESGEnvironmentPillarScore,ESGSocialPillarScore,ESGGovernancePillarScore,ParentIssuerName,Wert,NextPayDate,RCSCouponCurrencyLeaf,IsDualCurrency,IsStraight,FloatIndexTypeDescription,FallbackLanguageExists,IndexTransitioned,FloatOffset,FloatMultiplier,CurrentCouponClassDescription,CouponFrequencyDescription,InflationProtected,SecondPartyOpinionProvider,UNSDGGoalDescription,KPITypeDescription,KPIThemeDescription,SPTDate,KPIActionTypeDescription,ScheduledPayPercent,ESGCombinedScore,ESGControversiesScore,ESGFinancialPeriodEndDate,ESGEmissionsScore,ESGInnovationScore,ESGResourceUseScore,ESGCommunityScore,ESGHumanRightsScore,ESGProductResponsibilityScore,ESGWorkforceScore,ESGCSRStrategyScore,ESGManagementScore,ESGShareholdersScore,IssuePrice,DescriptionDetail,IssuedAs,Series,HasProspectus,UnderwriterName,RCSUseOfProceedsLeaf,AssetStatusDescription,IsExchangeListed,IsExecutableQuoted,MaturityStandardYield,WorstCorpModDuration,MaturityCorpModDuration,OptionAdjustedSpread,WorstCorpStandardSpread,OptionAdjustedZeroVolSpread,Price,PricingTradeDate,WorstCorpOTRSpread,MaturityCorpOTRSpread,WorstStandardYield,MaturityCorpMacDuration,FaceIssuedTotal,RCSCDCAssetClassGenealogy,RCSAssetLinkedSecurityLeaf,RCSConvertibleLeaf,RepoEligBankCountry,PBOCRatings,PBOCCodesRanks,BorrowerName,RCSBorrowerCountry,IsGuaranteed,GuarantorName,RCSGuarantorCountryLeaf,SeniorityTypeDescription,CapitalTierName,SukukExchangeName,RCSMarketOfIssueLeaf,RCSTRBC2012Leaf,RCSDomicileLeaf,RCSParentDomicileLeaf,IsSubsidiary,RCSCountryOfIncorporationLeaf,SIC,IndustrySubSectorDescription,RCSRiskOrganisationCountry,IsActive,RecordDate,RCSCoveredBondGenealogy,RCSGovtBondTypeLeaf,RCSSukuk,OfferingTypeDescription,IsPreferred,RCSStripType,DenominationMinimum,DenominationTypeDescription,IsPrivatePlacement,FaceOutstanding,FaceOutstandingUSD,HasAnnuity,IsCallable,IsExtendible,IsSinkable,IsMultiStepFloat,NextCallDate,NextPutDate,NextSinkDate,IsPayInPart,IsPayInKind,IsPerpetualSecurity,IsPutable,IsEUSDTaxEligible,IsWarrant,HasEmaxx,SolvabilityRatio,IsEUSDSwissExempt,IsTRACEEligible,IsEUSDTapped,IsAAOIFICompliant,IsFatwaText,IsShariaOpinion,IsSukukStructure,NoteTypeDescription,EcbCode,RiskClassificationDescription,RCSRiskCountry,ProgrammeTypeDescription,ShariahBoardNames,SukukObligorNames,GoverningLawNames,AssetStatusEffDate,FirstAnnouncementDate,CallTypeDescription,ProspectusID,RCSCDCAssetClassLeaf,RCSGovtBondTypeGenealogy",
order_by = "IssueDate desc"
)
How can I do this in Python with an Eikon API (I have an Eikon App Key). Any help is appreciated.
