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

Home Forums Link & Grow Development: Enriching Linkedin URLs from Internal Search – Work in progress

Tagged: ,

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

    • dreadpixel
      Keymaster
      Topics: 14
      Replies: 21

      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 1 year, 1 month ago by dreadpixel.
      • This topic was modified 1 year, 1 month ago by dreadpixel.
      • This topic was modified 1 year, 1 month ago by dreadpixel.
    • pdunbar424
      Participant
      Topics: 0
      Replies: 1

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

    • dreadpixel
      Keymaster
      Topics: 14
      Replies: 21

      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
      Member
      Topics: 0
      Replies: 1

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

       

    • dreadpixel
      Keymaster
      Topics: 14
      Replies: 21

      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.

Viewing 4 reply threads

You must be logged in to reply to this topic.