Skip to main content

News api

Tables in the News api connector

NoTable NameColumnsPrimary KeysRead ModeInc. Sync KeysAPI Info
1top_headlines5Full Refresh
2everything5Full Refresh

Table: top_headlines

NoColumn NameTypeNotes
1publishedAtVARCHAR
2authorVARCHAR
3sourceVARCHAR
4titleVARCHAR
5urlVARCHAR

Table: everything

NoColumn NameTypeNotes
1publishedAtVARCHAR
2authorVARCHAR
3sourceVARCHAR
4titleVARCHAR
5urlVARCHAR

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.