Lookup IPO's Single Card

Lookup Ipo's single card

Options

Entity Id
UUID or permalink of desired entity
Card Id
A card to include on the resulting entity
Card Field Ids (*)
Card fields to include on the specified card - array of field_id strings in JSON encoded as string
After Id (*)
Lookup uuid of the last item in the previous page (not required for first page). Used to iterate a card's results starting at the beginning of the ordered set and moving forward. Suitable for implementing "next page" functionality. May not be provided simultaneously with before_id.
Before Id (*)
Lookup uuid of the first item in the previous page (not required for first page). Used to iterate a card's results starting at the end of the ordered set and moving backward. Suitable for implementing "previous page" functionality. May not be provided simultaneously with after_id.
Order (*)
Field name with order direction (asc/desc)
Limit (*)
Number of rows to return. Default is 100, min is 1, max is 100.
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: Total amount raised from the IPO
    Field Type: money
    Searchable: Yes
    Search Operators: between, blank, eq, gt, gte, lt, lte, not_eq
  • Created At: Field Type: datetime
    Searchable: Yes
    Search Operators: between, blank, eq, gte, lte
  • Delisted On: Date when the organization delisted its stock
    Field Type: date_precision
    Searchable: Yes
    Search Operators: between, blank, eq, gte, lte
  • Entity Def Id:

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

    • ipo - Ipo
  • Identifier: Stock ticker symbol (e.g. AAPL, FB, TWTR)
    Field Type: identifier
    Searchable: Yes
    Search Operators: blank, contains, eq, includes, not_contains, not_eq, not_includes, starts
  • Image Id: Field Type: image_id
    Searchable: No
  • Organization Identifier: Organization went public
    Field Type: identifier
    Searchable: Yes
    Search Operators: blank, contains, eq, includes, not_contains, not_eq, not_includes, starts
  • 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: The share price for the stock at the time of IPO
    Field Type: money_decimal
    Searchable: Yes
    Search Operators: between, blank, eq, gt, gte, lt, lte, not_eq
  • 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: Valuation of the Organization at IPO
    Field Type: money
    Searchable: Yes
    Search Operators: between, blank, eq, gt, gte, lt, lte, not_eq
  • 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

Input Ports

Icon
Configuration data.

Output Ports

Icon
Result of the request depending on the selected Result Format.
Icon
Configuration data (this is the same as the input port; it is provided as passthrough for sequentially chaining nodes to declutter your workflow connections).

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.