Tabula Documentation
Tabula HomeCommunity
  • 👋Introduction to Tabula
  • Getting Started
    • Product Updates
    • Getting Started
      • Installation and Login
      • Beginner's Guide
    • FAQ
  • Product overview
    • Home Page
    • Exploring Data
      • Data Catalog
      • Exploring Datasets
      • Statistics Panel
    • Designing Flows
      • Creating Flows
      • Flow Designer Guide
        • Working with Canvas
        • Using Groups
        • Working with Table
      • Managing Flows
      • Sharing Flows
      • Demo: Building a Simple Flow
    • Executing Flows
      • Running Flows
      • Jobs overview
    • Building Reports
      • Designing Reports
      • Running Reports
      • Reports Page
    • Connecting Data
  • Integrations
    • Enrichments
      • How to add your API key in Tabula
      • List of Supported Queries
      • Enrichment Providers
        • AnymailFinder
        • Apollo
          • How to find Apollo API key
          • Enrich person by LinkedIn
          • Enrich company by domain
        • Bounceban
        • Bouncer
        • Bouncify
        • CaptainVerify
        • Cleanify
        • Clearout
        • CompanyEnrich
        • ContactOut
          • How to find ContactOut API key
          • Enrich person by LinkedIn
          • Enrich person by email
        • Discolike
        • TheCompaniesAPI
        • Findymail
        • Emailable
        • EmailListVerify
        • Enrichley
        • Heybounce
        • Hunter
        • Kickbox
        • Mails
        • MailChecker
        • MillionVerifier
        • NeverBounce
        • Nubela (Proxycurl)
        • PeopleDataLabs
        • Prospeo
        • ZeroBounce
        • ReverseContact
          • How to find Reverse Contact API key
          • Enrich person by LinkedIn
          • Enrich person and company by email
          • Enrich company by domain
          • Enrich company by LinkedIn
        • UpLead
    • Data Sources
      • Configuring Fivetran Integration
    • Data Storages
      • PostgreSQL
      • Snowflake
      • BigQuery
      • ClickHouse
  • Data Transformation
    • Transforms
      • Source
      • New Empty Table
      • Output
      • Chart
      • Enrichment
      • New Column
      • If...Then
      • Rolling Functions
      • Column Type
      • Columns Edit
      • Filter
      • Remove Duplicates
      • Sort
      • Find and Replace Text
      • Split Column
      • Extract Text
      • Match Text
      • Join
      • Union
      • Group By
      • Pivot
      • Unpivot
      • To JSON
      • From JSON
      • API Call
      • AI Column
      • AI Table
    • Formulas
      • What are Formulas?
      • Math Functions
        • Abs
        • Ceiling
        • Exp
        • Floor
        • IsEven
        • IsOdd
        • Ln
        • Log
        • Log10
        • Mod
        • Pi
        • Power
        • Quotient
        • Round
        • RoundDown
        • RoundUp
        • Sign
        • Sqrt
        • Truncate
      • Trigonometric Functions
        • Acos
        • Asin
        • Atan
        • Atan2
        • Cos
        • Cot
        • Degrees
        • Radians
        • Sin
        • Tan
      • String Functions
        • Compare
        • Concat
        • Contains
        • In
        • CountMatches
        • CountMatchesRegexp
        • EndsWith
        • EndsWithRegexp
        • Extract
        • FindMatchOfString
        • FindMatchOfRegexp
        • FindMatchesOfString
        • FindMatchesOfRegexp
        • Left
        • Length
        • Lower
        • Matches
        • Pad
        • ProperCase
        • RemoveSymbols
        • RemoveWhitespaces
        • Repeat
        • Replace
        • ReplaceRegexp
        • Reverse
        • Right
        • Spaces
        • Split
        • SplitRegexp
        • StartsWith
        • StartsWithRegexp
        • Stuff
        • Substring
        • SubstringDelimiter
        • SubstringRegexpDelimiter
        • Trim
        • Upper
      • Date & Time Functions
        • Date
        • DateAdd
        • DateAdd2
        • DateDiff
        • DateDiff2
        • DateFromParts
        • DateTime
        • DateTimeFromParts
        • DateTrunc
        • DayName
        • DayOfMonth
        • DayOfWeek
        • DayOfYear
        • Hour
        • Minute
        • Month
        • MonthName
        • Now
        • Quarter
        • Second
        • Time
        • TimeFromParts
        • Today
        • Week
        • Year
      • Aggregate Functions
        • Any
        • AnyIf
        • Array
        • ArrayIf
        • Avg
        • AvgIf
        • AvgInRow
        • Count
        • CountA
        • CountIf
        • CountUnique
        • Max
        • MaxIf
        • MaxInRow
        • Median
        • MedianIf
        • Min
        • MinIf
        • MinInRow
        • Mode
        • ModeIf
        • Percentile
        • Quartile
        • StdDev
        • StdDevIf
        • Sum
        • SumIf
        • SumProduct
        • Variance
        • VarianceIf
      • Conversion Functions
        • ToArray
        • ArrayToString
        • ToBoolean
        • ToDate
        • ToDateTime
        • ToDecimal
        • ToInteger
        • ToObject
        • ToTime
        • ToString
      • Misc Functions
        • At
        • IsMissing
        • RowNumber
        • Random
        • If
        • Coalesce
        • True
        • False
        • Null
        • $target
      • Window Functions
      • Custom Functions
      • Data Types
      • Supported Date Parts
      • Regex: List of Tokes
  • Pricing & Billing
    • Plans, Subscriptions, and Credits
    • Tabula for Education
  • Tutorials
    • Tabula Use Cases
    • Merge Columns
    • Join Types
    • Union Introduction
    • Window Functions
    • What is Unpivot?
    • JSON Format Tutorial
    • Using Regex
Powered by GitBook
On this page
  • Overview
  • Input parameters
  • Output fields
  • Sample response

Was this helpful?

  1. Integrations
  2. Enrichments
  3. Enrichment Providers
  4. Apollo

Enrich person by LinkedIn

Provider Apollo.io

Overview

Return person's details based on personal LinkedIn URL.

Input parameters

Name
Is Required
Type
Description

LinkedIn URL

required

text column

Personal LinkedIn URL

Email

optional

text column

Person's email address

First Name

optional

text column

Person's first name

Last Name

optional

text column

Person's last name

Full Name

optional

text column

Person's full name

Company Name

optional

text column

The company a person is working at

Company Domain

optional

text column

The company website, e.g google.com

Output fields

Fields that are not extracted by default can be found in a column with an original response (select option "Save original response" in advanced settings). Use the Unnest node or JSON preview window to extract such fields to the new columns.

Name
Type
Extracted
Description

Full Name

text

yes

The person's complete name, e.g., John Doe

First Name

text

yes

The person's given name, e.g., John

Last Name

text

yes

The person's last name, e.g. Doe

Headline

text

yes

Brief professional title or tagline, e.g., Data Analyst at Tabula

Title

text

yes

Professional title or job position of the person, e.g., Senior Data Analyst

LinkedIn URL

text

yes

Personal LinkedIn URL

Sample response

{
    "person": {
        "id": "6453e9bd8f50d40001f1e348",
        "first_name": "Tim",
        "last_name": "Zheng",
        "name": "Tim Zheng",
        "linkedin_url": "http://www.linkedin.com/in/tim-zheng-677ba010",
        "title": "Founder & CEO",
        "email_status": null,
        "photo_url": "https://media.licdn.com/dms/image/D5603AQEFiVRxq2aFCg/profile-displayphoto-shrink_200_200/0/1676521918175?e=1701907200&v=beta&t=6QqL_xwsDybj-FIUTr6XaEeLyrHxs7QS-IHSbVtYCak",
        "twitter_url": null,
        "github_url": null,
        "facebook_url": null,
        "extrapolated_email_confidence": null,
        "headline": "Founder & CEO at Apollo",
        "email": "name@domain.io",
        "organization_id": "5e66b6381e05b4008c8331b8",
        "employment_history": [
            {
                "_id": "651e57392998d400013ac5bd",
                "created_at": null,
                "current": true,
                "degree": null,
                "description": null,
                "emails": null,
                "end_date": null,
                "grade_level": null,
                "kind": null,
                "major": null,
                "organization_id": "5e66b6381e05b4008c8331b8",
                "organization_name": "Apollo",
                "raw_address": null,
                "start_date": "2016-01-01",
                "title": "Founder & CEO",
                "updated_at": null,
                "id": "651e57392998d400013ac5bd",
                "key": "651e57392998d400013ac5bd"
            },
            {
                "_id": "651e57392998d400013ac5be",
                "created_at": null,
                "current": false,
                "degree": null,
                "description": null,
                "emails": null,
                "end_date": "2015-01-01",
                "grade_level": null,
                "kind": null,
                "major": null,
                "organization_id": null,
                "organization_name": "Braingenie",
                "raw_address": null,
                "start_date": "2011-01-01",
                "title": "Founder & CEO",
                "updated_at": null,
                "id": "651e57392998d400013ac5be",
                "key": "651e57392998d400013ac5be"
            },
            {
                "_id": "651e57392998d400013ac5bf",
                "created_at": null,
                "current": false,
                "degree": null,
                "description": null,
                "emails": null,
                "end_date": "2011-01-01",
                "grade_level": null,
                "kind": null,
                "major": null,
                "organization_id": "54a22f23746869331840e813",
                "organization_name": "Citadel Investment Group",
                "raw_address": null,
                "start_date": "2011-01-01",
                "title": "Investment & Trading Associate",
                "updated_at": null,
                "id": "651e57392998d400013ac5bf",
                "key": "651e57392998d400013ac5bf"
            }
        ],
        "state": "California",
        "city": "San Francisco",
        "country": "United States",
        "organization": {
            "id": "5e66b6381e05b4008c8331b8",
            "name": "Apollo.io",
            "website_url": "http://www.apollo.io",
            "blog_url": null,
            "angellist_url": null,
            "linkedin_url": "http://www.linkedin.com/company/apolloio",
            "twitter_url": "https://twitter.com/meetapollo/",
            "facebook_url": "https://www.facebook.com/MeetApollo",
            "primary_phone": {
                "number": "+1415-640-9303",
                "source": "Owler",
                "country_code_added_from_hq": true
            },
            "languages": [],
            "alexa_ranking": 3514,
            "phone": "+1415-640-9303",
            "linkedin_uid": "18511550",
            "founded_year": 2015,
            "publicly_traded_symbol": null,
            "publicly_traded_exchange": null,
            "logo_url": "https://zenprospect-production.s3.amazonaws.com/uploads/pictures/64beb2c5e966df0001384ac1/picture",
            "crunchbase_url": null,
            "primary_domain": "apollo.io",
            "sanitized_phone": "+14156409303",
            "industry": "information technology & services",
            "keywords": [
                "sales engagement",
                "lead generation",
                "predictive analytics",
                "lead scoring",
                "sales strategy",
                "conversation intelligence",
                "sales enablement",
                "lead routing",
                "sales development",
                "email engagement",
                "revenue intelligence",
                "sales operations",
                "demand generation"
            ],
            "estimated_num_employees": 1200,
            "industries": [
                "information technology & services"
            ],
            "secondary_industries": [],
            "snippets_loaded": true,
            "industry_tag_id": "5567cd4773696439b10b0000",
            "industry_tag_hash": {
                "information technology & services": "5567cd4773696439b10b0000"
            },
            "retail_location_count": 0,
            "raw_address": "535 mission street, san francisco, california, united states",
            "street_address": "535 Mission Street",
            "city": "San Francisco",
            "state": "California",
            "postal_code": "94105",
            "country": "United States",
            "owned_by_organization_id": null,
            "suborganizations": [],
            "num_suborganizations": 0,
            "seo_description": "Search, engage, and convert over 265 million contacts at over 70 million companies with Apollo's sales intelligence and engagement platform.",
            "short_description": "Apollo.io combines a buyer database of over 270M contacts and powerful sales engagement and automation tools in one, easy to use platform. Trusted by over 160,000 companies including Autodesk, Rippling, Deel, Jasper.ai, Divvy, and Heap, Apollo has more than one million users globally. By helping sales professionals find their ideal buyers and intelligently automate outreach, Apollo helps go-to-market teams sell anything.\n\nCelebrating a $100M Series D Funding Round 🦄",
            "annual_revenue_printed": "###.#",
            "annual_revenue": ###.#,
            "total_funding": 251200000,
            "total_funding_printed": "251.2M",
            "latest_funding_round_date": "2023-08-01T00:00:00.000+00:00",
            "latest_funding_stage": "Series D",
            "funding_events": [
                {
                    "id": "6520fc8e0f5b210001b5285b",
                    "date": "2023-08-01T00:00:00.000+00:00",
                    "news_url": null,
                    "type": "Series D",
                    "investors": "Bain Capital Ventures, Sequoia Capital, Tribe Capital, Nexus Venture Partners",
                    "amount": "100M",
                    "currency": "$"
                },
                {
                    "id": "624f4dfec786590001768016",
                    "date": "2022-03-01T00:00:00.000+00:00",
                    "news_url": null,
                    "type": "Series C",
                    "investors": "Sequoia Capital, Tribe Capital, Nexus Venture Partners, NewView Capital",
                    "amount": "110M",
                    "currency": "$"
                },
                {
                    "id": "61b13677623110000186a478",
                    "date": "2021-10-01T00:00:00.000+00:00",
                    "news_url": null,
                    "type": "Series B",
                    "investors": "Tribe Capital, NewView Capital, Nexus Venture Partners",
                    "amount": "32M",
                    "currency": "$"
                },
                {
                    "id": "5ffe93caa54d75077c59acef",
                    "date": "2018-06-26T00:00:00.000+00:00",
                    "news_url": "https://techcrunch.com/2018/06/26/yc-grad-zenprospect-rebrands-as-apollo-lands-7-m-series-a/",
                    "type": "Series A",
                    "investors": "Nexus Venture Partners, Social Capital, Y Combinator",
                    "amount": "7M",
                    "currency": "$"
                },
                {
                    "id": "6520fc8f0f5b210001b52860",
                    "date": "2016-10-01T00:00:00.000+00:00",
                    "news_url": null,
                    "type": "Other",
                    "investors": "Y Combinator, SV Angel, Social Capital, Nexus Venture Partners",
                    "amount": "2.2M",
                    "currency": "$"
                }
            ]
        },
        "phone_numbers": [
            {
                "raw_number": "+1415-640-9303",
                "sanitized_number": "+14156409303",
                "type": "work_hq",
                "position": 0,
                "status": "no_status",
                "dnc_status": null,
                "dnc_other_info": null
            }
        ],
        "intent_strength": null,
        "show_intent": false,
        "revealed_for_current_team": true,
        "hashed_email": "8d935115b9ff4489f2d1f9249503cadf",
        "personal_emails": [],
        "departments": [
            "c_suite"
        ],
        "subdepartments": [
            "executive",
            "founder"
        ],
        "functions": [
            "entrepreneurship"
        ],
        "seniority": "founder"
    }
}
{
    "person": {
        "id": "66c62ff44bbdec01b29f5d74",
        "name": "",
        "email": null,
        "title": null,
        "headline": null,
        "functions": [],
        "last_name": null,
        "photo_url": null,
        "seniority": null,
        "first_name": null,
        "github_url": null,
        "departments": [],
        "show_intent": false,
        "twitter_url": null,
        "email_status": null,
        "facebook_url": null,
        "linkedin_url": "1233838383",
        "subdepartments": [],
        "intent_strength": null,
        "organization_id": null,
        "employment_history": [],
        "is_likely_to_engage": false,
        "revealed_for_current_team": true,
        "extrapolated_email_confidence": null
    }
}

PreviousHow to find Apollo API keyNextEnrich company by domain

Last updated 8 months ago

Was this helpful?