Buy LinkDB People Profile Dataset and implement talent searches on the dataset.
SELECT
id,
parsed_data->>'first_name' AS first_name,
parsed_data->'last_name' AS last_name,
jsonb_path_query_first(parsed_data, '$.experiences[*] ? (@.ends_at == null && @.company == "Electronic Arts (EA)").title') AS title
FROM profile
WHERE to_tsvector('simple', parsed_data) @@ plainto_tsquery('simple', 'Electronic Arts (EA)') -- general full text search
AND parsed_data @> '{"experiences": [{"ends_at": null, "company": "Electronic Arts (EA)"}]}' -- confirm
SELECT
id,
parsed_data->>'first_name' AS first_name,
parsed_data->'last_name' AS last_name,
jsonb_path_query_first(parsed_data, '$.experiences[*] ? (@.ends_at == null && @.company == "Electronic Arts (EA)").title') AS title
FROM profile
WHERE to_tsvector('simple', parsed_data) @@ plainto_tsquery('simple', 'Electronic Arts (EA)') -- general full text search
AND parsed_data @> '{"experiences": [{"ends_at": null, "company": "Electronic Arts (EA)"}]}' -- confirm
SELECT
id,
parsed_data->>'first_name' AS first_name,
parsed_data->'last_name' AS last_name,
jsonb_path_query_first(parsed_data, '$.experiences[*] ? (@.ends_at == null && @.company == "Electronic Arts (EA)").title') AS title
FROM profile
WHERE to_tsvector('simple', parsed_data) @@ plainto_tsquery('simple', 'Electronic Arts (EA)') -- general full text search
AND parsed_data @> '{"experiences": [{"ends_at": null, "company": "Electronic Arts (EA)"}]}' -- confirm
SELECT
id,
parsed_data->>'first_name' AS first_name,
parsed_data->'last_name' AS last_name,
jsonb_path_query_first(parsed_data, '$.experiences[*] ? (@.ends_at == null && @.company == "Electronic Arts (EA)").title') AS title
FROM profile
WHERE to_tsvector('simple', parsed_data) @@ plainto_tsquery('simple', 'Electronic Arts (EA)') -- general full text search
AND parsed_data @> '{"experiences": [{"ends_at": null, "company": "Electronic Arts (EA)"}]}' -- confirm
Reach out with personal emails
After finding the right people, you can reach out to them via:
We built Proxycurl to empower data-driven products. Talk to Steven, the product manager of Proxycurl today
Here's what we've been up to recently.
Learn all about the Professional Social Network API, with comprehensive Python code demos. Dive into the world of Professional Social Network APIs, official and third-party alternatives, and understand how to access and utilize Professional Social Network profile data through Python code examples.
15 MIN READ
💡Old post - republished with new content You are probably reading this article because you are seeking a solution to fetch fresh Professional Social Network profile data at scale. In this article, I'll introduce and provide a cursory review of the top 5 Professional Social Network scraping API
6 MIN READ
In this first chapter of the "Ultimate Guide to the Professional Social Network API" series, my goal is to get your product integrated with Professional Social Network API without the need to be approved as a Professional Social Network Partner. This guide is intended for software engineers comfortable
11 MIN READ