Development: Enriching Linkedin URLs from Internal Search – Work in progress

[dreadpixel]

March 24, 2020 at 4:17 am

Hello everyone,

I am working right now on this feature, I had some issues trying to make the best User Experience for all of you, let me tell you what came to a conclusion. If you have a better idea please express it.

The feature is for the Automator Tab. You will be able to input a search URL such as:
https://www.linkedin.com/search/results/people/?keywords=Marketing%20New%20York&origin=GLOBAL_SEARCH_HEADER

And it will go and paginate till the last page and grab Names and URLs. I decided I would store the Names and URLs into a new table called: search_results, then I will query all search_results that have Linkedin domain on it and proceed to use RocketReach.co API to enrich the URL into the profiles table.
Here is what RocketReach.co API can extract with a Linkedin URL: https://rocketreach.co/api?section=api_section_ex_byLIURL

I will paste the whole result here:

"id": 5244,
    "status": "complete",
    "name": "Marc Benioff",
    "profile_pic": "https://d1hbpr09pwz0sk.cloudfront.net/profile_pic/marc-benioff-4492e698",
    "linkedin_url": "https://www.linkedin.com/in/marcbenioff",
    "links": {
        "google": "https://plus.google.com/109586918294369333764",
        "hi5": "http://www.hi5.com/friend/p45336146--profile--html",
        "angel": "https://angel.co/benioff",
        "twitter": "http://www.twitter.com/benioff",
        "linkedin": "https://www.linkedin.com/in/marcbenioff",
        "crunchbase": "https://www.crunchbase.com/person/marc-benioff",
        "twicsy": "http://twicsy.com/u/%40Benioff",
        "instagram": "http://www.instagram.com/benioff",
        "pinterest": "http://www.pinterest.com/benioff",
        "aboutme": "http://www.about.me/marcbenioff",
        "meetup": "http://www.meetup.com/members/15867891",
        "quora": "http://www.quora.com/marc-benioff",
        "amazon": "http://www.amazon.com/gp/pdp/profile/AZGYQG724J6ON//190-5748375-2756131",
        "facebook": "http://www.facebook.com/benioff",
        "klout": "http://www.klout.com/benioff",
        "gravatar.com": "http://gravatar.com/crmmaster",
        "angellist": "http://www.angel.co/benioff",
        "google+": "https://plus.google.com/108172009599607363531/about",
        "googleplus": "https://plus.google.com/108172009599607363531",
        "salesforce.com": "http://www.salesforce.com/company/leadership/executive-team/index.jsp#benioff",
        "gravatar": "http://www.gravatar.com/crmmaster"
    },
    "location": "San Francisco, California, United States",
    "current_title": "Chair & CEO",
    "current_employer": "salesforce.com - Marc Benioff is Chair, Chief Executive Officer...",
    "current_work_email": "marcb@salesforce.com",
    "current_personal_email": "benioff@gmail.com",
    "emails": [
        {
            "email": "m.benioff@salesforce.com",
            "smtp_valid": "valid",
            "type": "professional"
        },
        {
            "email": "mbenioff@salesforce.com",
            "smtp_valid": "valid",
            "type": "professional"
        },
        {
            "email": "benioff@comcast.net",
            "smtp_valid": "valid",
            "type": "personal"
        },
        {
            "email": "marc@salesforce.com",
            "smtp_valid": "valid",
            "type": "professional"
        },
        {
            "email": "marc_benioff@salesforce.com",
            "smtp_valid": "valid",
            "type": "professional"
        },
        {
            "email": "benioff@gmail.com",
            "smtp_valid": "valid",
            "type": "personal"
        },
        {
            "email": "benioff@aol.com",
            "smtp_valid": "valid",
            "type": "personal"
        },
        {
            "email": "ceo@salesforce.com",
            "smtp_valid": "valid",
            "type": "professional"
        },
        {
            "email": "marcb@salesforce.com",
            "smtp_valid": "valid",
            "type": "professional"
        },
        {
            "email": "marc.benioff@salesforce.com",
            "smtp_valid": "valid",
            "type": "professional"
        },
        {
            "email": "marcbenioff@salesforce.com",
            "smtp_valid": "invalid",
            "type": "professional"
        },
        {
            "email": "benioff@frontiernet.net",
            "smtp_valid": "invalid",
            "type": "personal"
        },
        {
            "email": "cooldwj@chinaren.com",
            "smtp_valid": "invalid",
            "type": "professional"
        },
        {
            "email": "benioff@rcn.com",
            "smtp_valid": "invalid",
            "type": "professional"
        }
    ],
    "phones": []

What do you think about this? Do you have a better idea?

• This topic was modified 4 years, 1 month ago by dreadpixel.
• This topic was modified 4 years, 1 month ago by dreadpixel.
• This topic was modified 4 years, 1 month ago by dreadpixel.

[pdunbar424]

March 24, 2020 at 2:06 pm

This feature will be very helpful! Will users need to purchase their own rocketreach api key?
<div></div>
<div></div>

[dreadpixel]

March 24, 2020 at 8:27 pm

Yes, you will need an API key from RocketReach.co, they offer some free requests when you register.
Also, I think I will add the usage of visiting profiles to gather information too. The thing I struggle the most is thinking about the User Experience.

[topnotch]

March 29, 2020 at 4:32 am

You should add SalesQL API as well its a lot cheaper than RocketReach plus SalesQL allows gives phone numbers with no additional charges.

 

[dreadpixel]

July 1, 2020 at 11:10 pm

I will resume working on that integrations. I had to move from the city and currently, I have more spare time since kids have a garden to play 🙂
This pandemic has changed life for everyone. Expect updates soon.