Clay Icon

Updating Records in Table 1 Using Data from Table 2 by LinkedIn Profile

ยท
ยท

I need to update table 1 records with table 2 data, specific to a record by a linkedin profile. UPDATE table1 SET table2 column2-x, column3=x, column4=x WHERE table1.colum1 = table2.column1 Is this possible?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Instead of using SQL queries directly, you can use Clay's built-in features to update records between tables: 1. Use the "Lookup Multiple Rows" integration to match records between tables based on the LinkedIn profile identifier. 2. Then use the "Enrich Person from Profile" feature to update the records with the desired information. This integration allows you to retrieve and update comprehensive details about an individual using their LinkedIn URL or User ID.Note that when enriching data from LinkedIn profiles, the process may take some time, especially for data older than 45 days, as it requires live retrieval from social profiles. Source: Enrich Person from Profile with Companies, People, Jobs

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of Mark L.
    Mark L.
    ยท
    ยท

    Hey Lemuel, what other questions do you have? Looks like you're aware that SQL-like operations are not possible in Clay, and that the lookup operations will help you match between tables. Depending on the need, write-to-table could be a great option to make updates. https://www.clay.com/university/lesson/write-to-table-clay-101 https://www.clay.com/university/guide/write-to-table-integration-overview

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Lemuel C.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: