Log LinkedIn profile page information into Data Blaze

Show and Tell
1

Read Linkedin profile information and store it in a Data Blaze table
Create a Data Blaze table with the following columns:
First name, Last name, Job title, Location, Company, URL and email
Update the DB insert command to point to the correct table

{note}{`first name`={linkedin-firstname}}
{`last name`=split({linkedin-name}, " ")[2]}
{company=selector1} {`job title`=selector2}
{selector1=catch({site: text; selector=section:has(#experience) ul li:first-child .full-width[data-field=experience_company_logo] div:first-child span[aria-hidden]}, split({site: text; selector=section:has(#experience) ul li:first-child .full-width .full-width > span span[aria-hidden]}, " · ")[1])} {selector2=catch({site: text; selector=section:has(#experience) ul li:first-child .full-width ul.pvs-list li .pvs-entity--with-path .full-width span[aria-hidden]}, {site: text; selector=section:has(#experience) ul li:first-child .full-width span[aria-hidden]})}
{location=catch({site: text; selector=.text-body-small.inline},"")}
{url={site: url}}
{dbinsert: INSERT INTO LinkedIn SET `first name`=`@first name`, `last name`=`@last name`, `job title`=`@job title`, location=@location, company=@company, url=@url; space=3jOppIn3VfKVnIKOXgVYZR; autoaddfields=yes}
{endnote: trim=right}

Writing LinkedIn Profile info to Data Blaze - Watch Video
3 Likes
2

Extract the email from the clipboard and update the contact information with it. This uses the URL to find the correct contact.

{url={site: url}}{email=catch(extractregex({clipboard}, "([\w-]+@([\w-]+\.)+[\w-]+)"),"")}
{if: email<>""; trim=left}{dbupdate: UPDATE LinkedIn SET email=@email WHERE url == @url; space=3jOppIn3VfKVnIKOXgVYZR; autoaddfields=no}{endif: trim=right}

2 Likes