Search API filter

vitali

Hi everybody! I am currently utilizing the Search API for my project, which involves gathering data on delisted companies. I have successfully collected the required data, but I am now facing a challenge in filtering this dataset to include only companies based in the United States. Despite trying various values, I have not been able to retrieve any relevant data.

Could anyone guide how to adjust my code to effectively filter for U.S. companies that were also delisted in the past two years?

Thank you in advance for your assistance.

def search_delisted_companies():
    response = rd.discovery.search(
        view = "Organisations
        filter = "OrganisationStatus xeq 'Delisted'",
        select ="DocumentTitle, DelistedDate, OrganisationStatus, ReasonDelisted
        top = 100
    )
    return response

jonathan.legrand

Hi @vitali ,

I have the impression that `OrganisationStatus` is only `Unlisted` or `Listed`. Have you tried:

rd.discovery.search(
        view = "Organisations",
        filter ="OrganisationStatus xeq 'Unlisted'",
        select ="DocumentTitle, DelistedDate, OrganisationStatus, ReasonDelisted, IsExchangeListed",
        top = 100
    )