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

·

· Sorted by Oldest

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 😉
Manuel (.
·
·
Only workaround so far is creating a csv export of the ids and then doing a lookup.
Manuel (.
·
·
Ideally we could create table from postgres by inputing a sql statement and the results being loaded into column1
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?
Manuel (.
·
·
Can I just directly work with a Clay API?
Manuel (.
·
·
Saw that I can get the API key but can't seem to find the API Docs
Manuel (.
·
·
Arturo O.
Manuel (.
·
·
Found the webhook, will try with that. Are there any other functionalities of the API or just adding data to a Table?
Manuel (.
·
·
I'm trying to figure out if there is a way that I can keep a clay table in sync with a postgres database
Manuel (.
·
·
Webhook can only handle individual rows, correct? I can't bulk upload my data?
Clay Team
APP
·
·
Hey Manuel (. - 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.
Clay Team
APP
·
·
And correct you will need to send individual rows
Clay Team
APP
·
·
https://docs.clay.com/enrichments-and-providers/enrichments/all-providers/http-api

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 😉
Manuel (.
·
·
Only workaround so far is creating a csv export of the ids and then doing a lookup.
Manuel (.
·
·
Ideally we could create table from postgres by inputing a sql statement and the results being loaded into column1
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?
Manuel (.
·
·
Can I just directly work with a Clay API?
Manuel (.
·
·
Saw that I can get the API key but can't seem to find the API Docs
Manuel (.
·
·
Arturo O.
Manuel (.
·
·
Found the webhook, will try with that. Are there any other functionalities of the API or just adding data to a Table?
Manuel (.
·
·
I'm trying to figure out if there is a way that I can keep a clay table in sync with a postgres database
Manuel (.
·
·
Webhook can only handle individual rows, correct? I can't bulk upload my data?
Clay Team
APP
·
·
Hey Manuel (. - 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.
Clay Team
APP
·
·
And correct you will need to send individual rows
Clay Team
APP
·
·
https://docs.clay.com/enrichments-and-providers/enrichments/all-providers/http-api