Search IPO Entities

Options

Body

Search Query Parameters

Request body which must comply to the following JSON Schema:

{
  "required" : [ "field_ids", "query" ],
  "type" : "object",
  "properties" : {
    "field_ids" : {
      "type" : "array",
      "description" : "Fields to include as columns in the search result entities - array of field_id strings",
      "items" : {
        "type" : "string"
      }
    },
    "query" : {
      "type" : "array",
      "description" : "Search query to perform on the designated entity",
      "items" : {
        "required" : [ "field_id", "operator_id", "type" ],
        "type" : "object",
        "properties" : {
          "type" : {
            "required" : [ "predicate" ],
            "type" : "string",
            "description" : "The type of query",
            "enum" : [ "predicate" ]
          },
          "field_id" : {
            "type" : "string",
            "description" : "The field to operate on"
          },
          "operator_id" : {
            "type" : "string",
            "description" : "Description of operators:\n * blank - Blank\n * eq - Equal\n * not_eq - Not equal\n * gt - Greater than\n * gte - Greater than or equal\n * lt - Less than\n * lte - Less than or equal\n * starts - Starts\n * contains - Contains\n * between - Between\n * includes - Includes\n * not_includes - Does not include\n * includes_all - Includes all\n * not_includes_all - Does not include all\n * domain_eq - Domain equals\n * domain_blank - Domain is blank\n",
            "enum" : [ "blank", "eq", "not_eq", "gt", "gte", "lt", "lte", "starts", "contains", "between", "includes", "not_includes", "includes_all", "not_includes_all", "domain_eq", "domain_blank" ]
          },
          "values" : {
            "type" : "array",
            "description" : "values array with data type matching field_id type",
            "items" : {
              "type" : "object"
            }
          }
        },
        "description" : "A simple search criterion"
      }
    },
    "order" : {
      "type" : "array",
      "description" : "Order in which the search results should be returned",
      "items" : {
        "required" : [ "field_id", "sort" ],
        "type" : "object",
        "properties" : {
          "field_id" : {
            "type" : "string",
            "description" : "Name of the field to sort on"
          },
          "sort" : {
            "type" : "string",
            "description" : "Direction of sorting",
            "default" : "asc",
            "enum" : [ "asc", "desc" ]
          },
          "nulls" : {
            "type" : "string",
            "description" : "Whether to include null values at the beginning or end of the sort. Defaults to end.",
            "default" : "last",
            "enum" : [ "first", "last" ]
          }
        }
      }
    },
    "limit" : {
      "type" : "integer",
      "description" : "Number of rows to return. Default is 100, min is 1, max is 2000."
    },
    "before_id" : {
      "type" : "string",
      "description" : "Used to paginate search results to the previous page. before_id should be the uuid of the first item in the current page. May not be provided simultaneously with after_id.",
      "format" : "uuid"
    },
    "after_id" : {
      "type" : "string",
      "description" : "Used to paginate search results to the next page. after_id should be the uuid of the last item in the current page. May not be provided simultaneously with before_id.",
      "format" : "uuid"
    }
  }
}

Result Format

Specify how the response should be mapped to the table output. The following formats are available:

• Structured Table: Returns a parsed table with data split into rows and columns.
  • Amount Raised:
  • Created At:

    Field Type: datetime
    Searchable: Yes
    Search Operators: between, blank, eq, gte, lte

  • Delisted On:
  • Entity Def Id:

    Field Type: enum
    Searchable: Yes
    Search Operators: blank, eq, includes, not_eq, not_includes
    Possible values are:

    • ipo - Ipo
  • Identifier:
  • Image Id:

    Field Type: image_id
    Searchable: No

  • Organization Identifier:
  • Permalink:

    Field Type: permalink
    Searchable: No

  • Rank Ipo:

    Algorithmic rank assigned to the top 100,000 most active IPOs
    Field Type: integer
    Searchable: Yes
    Search Operators: between, blank, eq, gt, gte, lt, lte, not_eq

  • Share Price:
  • Shares Outstanding:

    Number of shares that were outstanding at the time of IPO
    Field Type: integer
    Searchable: Yes
    Search Operators: between, blank, eq, gt, gte, lt, lte, not_eq

  • Shares Sold:

    Number of shares sold at the time of IPO
    Field Type: integer
    Searchable: Yes
    Search Operators: between, blank, eq, gt, gte, lt, lte, not_eq

  • Short Description:

    Field Type: text_long
    Searchable: Yes
    Search Operators: blank, contains, not_contains

  • Stock Exchange Symbol:

    Stock exchange where the Organization is listed (e.g. NYSE, NASDAQ)
    Field Type: enum
    Searchable: Yes
    Search Operators: blank, eq, includes, not_eq, not_includes
    Possible values are:

    • adx - ADX - Abu Dhabi Securities Exchange
    • afx - AFX - Afghanistan Stock Exchange
    • altx - ALTX - ALTX East Africa Exchange
    • amex - AMEX - American Stock Exchange
    • ams - AMS - Euronext Amsterdam
    • amx - AMX - Armenia Securities Exchange
    • asce - ASCE - Abuja Securities and Commodities Exchange
    • asx - ASX - Australian Securities Exchange
    • ath - ATH - Athens Stock Exchange
    • bcba - BCBA - Buenos Aires Stock Exchange
    • bdp - BDP - Budapest Stock Exchange
    • belex - BELEX - Belgrade Stock Exchange
    • ber - BER - Berliner Börse
    • bfb - BFB - Baku Stock Exchange
    • bit - BIT - Italian Stock Exchange
    • bkk - BKK - Thailand Stock Exchange
    • blse - BLSE - Banja Luka Stock Exchange
    • bme - BME - Madrid Stock Exchange
    • bmv - BMV - Mexican Stock Exchange
    • bom - BOM - Bombay Stock Exchange
    • brvm - BRVM - Regional Securities Exchange SA
    • bse - BSE - Bulgarian Stock Exchange
    • bse_lb - BSE - Beirut Stock Exchange
    • bsse - BSSE - Bratislava Stock Exchange
    • bsx - BSX - Bermuda Stock Exchange
    • bvb - BVB - Bucharest Stock Exchange
    • bvc - BVC - Colombian Stock Exchange
    • bvfb - BVFB - Belarusian Currency and Stock Exchange
    • bvm - BVM - Montevideo Stock Exchange
    • bvmf - B3 - Brazil Stock Exchange and OTC Market
    • bvmt - BVMT - Tunis Stock Exchange
    • bx - BX - Berne Stock Exchange
    • cas - CAS - Casablanca Stock Exchange
    • cise - CISE - Channel Islands Stock Exchange
    • cnsx - CNSX - Canadian National Stock Exchange
    • col - COL - Colombo Stock Exchange
    • cph - CPH - Copenhagen Stock Exchange
    • cse - CSE - Canadian Securities Exchange
    • cse_cy - CSE - Cyprus Stock Exchange
    • csx - CSX - Cambodia Securities Exchange
    • cve - TSX-V - Toronto TSX Venture Exchange
    • dfm - DFM - Dubai Financial Market
    • dse - DSE - Dhaka Stock Exchange
    • dsx - DSX - Douala Stock Exchange
    • dus - DUS - Börse Düsseldorf
    • ebr - EBR - Euronext Brussels
    • egx - EGX - Egypt Stock Exchange
    • eli - ELI - Euronext Lisbon
    • epa - EPA - Euronext Paris
    • etr - ETR - Deutsche Börse XETRA
    • eurex - EUREX - Eurex Exchange
    • fra - FRA - Frankfurt Stock Exchange
    • fwb - FWB - Börse Frankfurt Stock Exchange
    • gha - GHA - Ghana Stock Exchange
    • gsx - GSX - Georgian Stock Exchange
    • gsx_gi - GSX - Gibraltar Stock Exchange
    • hel - HEL - Helsinki Stock Exchange
    • hkg - HKG - Hong Kong Stock Exchange
    • hnx - HNX - Hanoi Stock Exchange
    • hose - HOSE - Ho Chi Minh Stock Exchange
    • ice - ICE - Iceland Stock Exchange
    • idx - IDX - Indonesia Stock Exchange
    • iex - IEX - Investors Exchange
    • ifb - IFB - Iran Fara Bourse
    • ime - IME - Iran Mercantile Exchange
    • irenex - IRENEX - Iran Energy Exchange
    • ise - ISE - Irish Stock Exchange
    • ist - IST - Istanbul Stock Exchange
    • isx - ISX - Iraq Stock Exchange
    • jp - JP - Japan Exchange
    • jsc - JSC - Belarusian Currency and Stock Exchange
    • jse - JSE - Johannesburg Stock Exchange
    • jse_jam - JSE - Jamaica Stock Exchange
    • kase - KASE - Kazakhstan Stock Exchange
    • klse - KLSE - Malaysia Stock Exchange
    • kosdaq - KOSDAQ - Korean Securities Dealers Automated Quotations
    • krx - KRX - Korea Stock Exchange
    • kse - KSE - Kuwait Stock Exchange
    • lje - LJE - Ljubljana Stock Exchange
    • lse - LSE - London Stock Exchange
    • lsm - LSM - Libyan Stock Market
    • lsx - LSX - Lao Securities Exchange
    • luse - LuSE - Lusaka Securities Exchange
    • luxse - LuxSE - Luxembourg Stock Exchange
    • mal - MAL - Malta Stock Exchange
    • mcx - MCX - Multi Commodity Exchange of India
    • meff - MEFF - Mercado Spanish Financial Futures Market
    • mnse - MNSE - Montenegro Stock Exchange
    • moex - MOEX - Moscow Exchange
    • mse - MSE - Metropolitan Stock Exchange
    • mse_md - MSE - Moldova Stock Exchange
    • mse_mk - MSE - Macedonian Stock Exchange
    • msei - MSEI - Metropolitan Stock Exchange of India
    • msm - MSM - Muscat Securities Market
    • mun - MUN - Börse München
    • nasdaq - NASDAQ
    • nbo - NSE - Nairobi Securities Exchange
    • neeq - NEEQ - National Equities Exchange and Quotations
    • nepse - NEPSE - Nepal Stock Exchange
    • nex - NEX - NEX Exchange
    • ngm - NGM - Nordic Growth Market Exchange
    • nig - NIG - Nigerian Stock Exchange
    • notc - NOTC - Norwegian OTC
    • npex - NPEX - NPEX Stock Exchange
    • nse - NSE - National Stock Exchange of India
    • nsx - NSX - National Stock Exchange of Australia
    • nyse - NYSE - New York Stock Exchange
    • nysearca - NYSEARCA - NYSE Arca
    • nysemkt - NYSEAMERICAN - NYSE American
    • nze - NZE - New Zealand Stock Exchange
    • ose - OSE - Oslo Stock Exchange
    • otcbb - OTCBB - FINRA OTC Bulletin Board
    • otcpink - OTC Pink
    • otcqb - OTCQB
    • otcqx - OTCQX
    • pdex - PDEx - Philippine Dealing Exchange
    • pex - PEX - Palestine Exchange
    • pfts - PFTS - PFTS Ukraine Stock Exchange
    • pomsox - POMSoX - Port Moresby Stock Exchange
    • prg - PRA - Prague Stock Exchange
    • pse - PSE - Philippine Stock Exchange
    • psx - PSX - Pakistan Stock Exchange
    • qse - QSE - Qatar Stock Exchange
    • rfb - RFB - Riga Stock Exchange
    • rse - RSE - Rwanda Stock Exchange
    • rsebl - RSEBL - Royal Securities Exchange of Bhutan
    • sase - SASE - Sarajevo Stock Exchange
    • sbx - SBX - BX Swiss
    • sehk - SEHK - The Stock Exchange of Hong Kong
    • sem - SEM - Stock Exchange of Mauritius
    • sgbv - SGBV - Algiers Stock Exchange
    • sgx - SGX - Singapore Stock Exchange
    • six - SIX - SIX Swiss Exchange
    • spbex - SPBEX - Saint Petersburg Stock Exchange
    • spse - SPSE - South Pacific Stock Exchange
    • sse - SSE - Shanghai Stock Exchange
    • ssx - SSX - Sydney Stock Exchange
    • sto - STO - Stockholm Stock Exchange
    • stu - STU - Börse Stuttgart
    • swx - SWX - SIX Swiss Exchange
    • szse - SZSE - Shenzhen Stock Exchange
    • tadawul - Tadawul - Saudi Stock Exchange
    • tal - TSE - Tallinn Stock Exchange
    • tfex - TFEX - Thailand Futures Exchange
    • tise - TISE - The International Stock Exchange
    • tlv - TLV - Tel Aviv Stock Exchange
    • tpe - TWSE - Taiwan Stock Exchange
    • tse_al - TSE - Tirana Stock Exchange
    • tse_ir - TSE - Tehran Stock Exchange
    • tsec - TWO - Taiwan OTC Exchange
    • tsx - TSX - Toronto Stock Exchange
    • ttse - TTSE - Trinidad and Tobago Stock Exchange
    • tyo - TYO - Tokyo Stock Exchange
    • use - USE - Uganda Securities Exchange
    • ux - UX - Ukrainian Exchange
    • vie - VIE - Vienna Stock Exchange
    • vmf - VMF - Faroese Securities Market
    • vse - VSE - Vancouver Stock Exchange
    • wse - WSE - Warsaw Stock Exchange
    • ysx - YSX - Yangon Stock Exchange
    • zamace - ZAMACE - Zambian Commodity Exchange
    • zse - ZSE - Zimbabwe Stock Exchange
    • zse_hr - ZSE - Zagreb Stock Exchange
  • Stock Full Symbol:

    Field Type: text_blob
    Searchable: No

  • Stock Symbol:

    Stock ticker symbol (e.g. AAPL, FB, TWTR)
    Field Type: text_short
    Searchable: Yes
    Search Operators: blank, contains, eq, not_contains, not_eq, starts

  • Updated At:

    Field Type: datetime
    Searchable: Yes
    Search Operators: between, blank, eq, gte, lte

  • Uuid:

    Field Type: uuid
    Searchable: Yes
    Search Operators: blank, eq, includes, not_eq, not_includes

  • Valuation:
  • Went Public On:

    Date the Organization went public
    Field Type: date
    Searchable: Yes
    Search Operators: between, blank, eq, gte, lte

• Raw Response: Returns the raw response in a single row with the following columns:
  • body: Response body
  • status: HTTP status code

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers