GOVSRCH saved template via Refinitv Python code

Rajnish_Kumar1

I have saved quite a few screens on GOVSRCH. The question is how this can be automated so that I get the same output as saved search. I looked into the below code mentioned earlier. However, I have 2 questions:

1. How will it identify which saved search I am calling?
2. Getting this error "No default session created yet. Please create a session first!"
   
   rd.discovery.search(
   view = rd.discovery.Views.GOV_CORP_INSTRUMENTS,
   top = 10,
   filter = "((DbType eq 'AGNC' or DbType eq 'OMUN' or DbType eq 'OTHR') and RCSAssetCategory eq 'A:J' and IsActive eq true and DebtType ne 'SYKHYB' and DebtType ne 'SUK*' and IsConvertible eq false and (IssueDate ge 2019-09-30 and MaturityDate ge 2027-03-01 and RCSCurrency in ('C:3') and FaceOutstanding ge 1000000000))",
   select = "RIC,EJVAssetID,DTSubjectName,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DBSTicker,CouponRate,MaturityDate,IssueDate,ISIN,RCSCurrencyLeaf,RCSCountryLeaf,DbTypeDescription,InstrumentTypeDescription,RCSCouponTypeGenealogy,FaceIssuedUSD,RCSBondGradeLeaf,FaceOutstanding,RCSCurrency"
   )

wasin.w V3

Hello @Rajnish_Kumar1

I can help you with the second question. Did you call the open_session() method before the discovery.search() method?

Example with https://developers.lseg.com/en/api-catalog/lseg-data-platform/lseg-data-library-for-python (Data library version 2, lseg.data, see https://developers.lseg.com/en/article-catalog/article/essential-guide-to-the-data-libraries article for more detail).

import lseg.data as ld


ld.open_session()


ld.discovery.search(

    view = ld.discovery.Views.GOV_CORP_INSTRUMENTS,

    top = 10,

    filter = "((DbType eq 'AGNC' or DbType eq 'OMUN' or DbType eq 'OTHR') and RCSAssetCategory eq 'A:J' and IsActive eq true and DebtType ne 'SYKHYB' and DebtType ne 'SUK*' and IsConvertible eq false and (IssueDate ge 2019-09-30 and MaturityDate ge 2027-03-01 and RCSCurrency in ('C:3') and FaceOutstanding ge 1000000000))",

    select = "RIC,EJVAssetID,DTSubjectName,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DBSTicker,CouponRate,MaturityDate,IssueDate,ISIN,RCSCurrencyLeaf,RCSCountryLeaf,DbTypeDescription,InstrumentTypeDescription,RCSCouponTypeGenealogy,FaceIssuedUSD,RCSBondGradeLeaf,FaceOutstanding,RCSCurrency"

)

My colleague answers on this old post might help you too (please click "All Anwers" tab).

https://community.developers.lseg.com/discussion/103823/replicate-govsrch-search-results-using-search-api