Clay Icon
Join the Community
02 Support

Is there a way to create a tale from a postgres fetch?

Avatar of Manuel B.Manuel B.
·
·

Is there a way to create a tale from a postgres fetch?

13 comments

  • 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 Manuel B.
    Manuel B.
    ·
    ·

    Only workaround so far is creating a csv export of the ids and then doing a lookup.

  • Avatar of Manuel B.
    Manuel B.
    ·
    ·

    Ideally we could create table from postgres by inputing a sql statement and the results being loaded into column1

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Manuel!! We don't currently have a source to create a table from this but can submit the request so it's considered soon. Not sure if webhooks + zapier would help or are an option for this?

  • Avatar of Manuel B.
    Manuel B.
    ·
    ·

    Can I just directly work with a Clay API?

  • Avatar of Manuel B.
    Manuel B.
    ·
    ·

    Saw that I can get the API key but can't seem to find the API Docs

  • Avatar of Manuel B.
    Manuel B.
    ·
    ·
  • Avatar of Manuel B.
    Manuel B.
    ·
    ·

    Found the webhook, will try with that. Are there any other functionalities of the API or just adding data to a Table?

  • Avatar of Manuel B.
    Manuel B.
    ·
    ·

    I'm trying to figure out if there is a way that I can keep a clay table in sync with a postgres database

  • Avatar of Manuel B.
    Manuel B.
    ·
    ·

    Webhook can only handle individual rows, correct? I can't bulk upload my data?

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Manuel B. - sorry for the delay here. You can use HTTP API to push data out. We don't have other functions like enriching data through a traditional API right now though.

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    And correct you will need to send individual rows