Clay Icon

How to Update, Run, and Extract Specific Columns from a Table via API.

Β·
Β·

Is there a way to both update a table, run specific coloums, and extract a specific coloum via an API?

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫢 Don't worry, only admins will be able to open your table πŸ˜‰

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Hi, thanks for getting in touch! I think this automation can be created through and API

  • Avatar of Guy M.
    Guy M.
    Β·
    Β·

    can you elaborate? I didn't find a way to pull back the data directly from clay

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    currently this is not possible inside clay but I think this can be created through an API, but I am not 100% sure

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    please check this API video:

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    HTTP API integration Quick video on how HTTP API works: https://www.loom.com/share/114ff06973bd4ed7985b32fa031be867 -Bonus! troubleshooting example of failed body parse issues: https://www.loom.com/share/678e4c40e8c14894a6cd53948176e434

  • Avatar of Guy M.
    Guy M.
    Β·
    Β·

    This requires me to build a server that will receive Clay's requests, no? Can't I POLL the table instead from a client?

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Not yet, the shared tables feature still on beta and even with that I think it won't be possible for only one column, but maybe combining that with the write to table enrichment can pull that column as long as the the table is shared with you, but there is also one extra probrem which is that schedulled runs are not possible yet (this would need a trigger custom builded in the API)

  • Avatar of Guy M.
    Guy M.
    Β·
    Β·

    so what kind of automatic way do I currently have to feed the table with data and then extract the results?

  • Avatar of Guy M.
    Guy M.
    Β·
    Β·

    programatically/automatically

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    probably a webhook

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Here's a video showing a few automations you can set up in Clay (webhook example in the first few minutes of this video): https://youtu.be/yw5paDolwTQ?feature=shared

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    ant to extract the results automatically the http API

  • Avatar of Guy M.
    Guy M.
    Β·
    Β·

    ok, thanks