Skip to main content

Convertkit

Tables in the Convertkit connector

NoTable NameColumnsPrimary KeysRead ModeInc. Sync KeysAPI Info
1subscribers6Full Refresh
2broadcasts3Full Refresh
3sequences5Full Refresh
4forms13Full Refresh
5tags3Full Refresh

Table: subscribers

NoColumn NameTypeNotes
1email_addressVARCHAR
2created_atVARCHAR
3idINTEGER
4stateVARCHAR
5fieldsVARCHAR
6first_nameVARCHAR

Table: broadcasts

NoColumn NameTypeNotes
1subjectVARCHAR
2created_atVARCHAR
3idINTEGER

Table: sequences

NoColumn NameTypeNotes
1repeatBOOLEAN
2nameVARCHAR
3created_atVARCHAR
4idINTEGER
5holdBOOLEAN

Table: forms

NoColumn NameTypeNotes
1embed_urlVARCHAR
2created_atVARCHAR
3descriptionVARCHAR
4typeVARCHAR
5titleVARCHAR
6urlVARCHAR
7uidVARCHAR
8archivedBOOLEAN
9success_messageVARCHAR
10sign_up_button_textVARCHAR
11nameVARCHAR
12embed_jsVARCHAR
13idINTEGER

Table: tags

NoColumn NameTypeNotes
1nameVARCHAR
2created_atVARCHAR
3idINTEGER

External Resources

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.