Facebook pages

Tables in the Facebook pages connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	post	69		Full Refresh		API Reference
2	page_insights	6		Full Refresh
3	post_insights	6		Full Refresh
4	page	208		Full Refresh		API Reference

Table: post

No	Column Name	Type	Notes
1	comments_mirroring_domain	VARCHAR
2	updated_time	VARCHAR
3	call_to_action	VARCHAR
4	full_picture	VARCHAR
5	is_published	BOOLEAN
6	message_tags	VARCHAR
7	status_type	VARCHAR
8	caption	VARCHAR
9	source	VARCHAR
10	type	VARCHAR
11	via	VARCHAR
12	allowed_advertising_objectives	VARCHAR
13	sharedposts	VARCHAR
14	promotable_id	VARCHAR
15	subscribed	BOOLEAN
16	sponsor_tags	VARCHAR
17	dynamic_posts	VARCHAR
18	from	VARCHAR
19	id	VARCHAR
20	child_attachments	VARCHAR
21	height	INTEGER
22	created_time	VARCHAR
23	multi_share_end_card	BOOLEAN
24	insights	VARCHAR
25	object_id	VARCHAR
26	is_popular	BOOLEAN
27	parent_id	VARCHAR
28	story_tags	VARCHAR
29	name	VARCHAR
30	timeline_visibility	VARCHAR
31	permalink_url	VARCHAR
32	actions	VARCHAR
33	video_buying_eligibility	VARCHAR
34	icon	VARCHAR
35	is_hidden	BOOLEAN
36	link	VARCHAR
37	description	VARCHAR
38	privacy	VARCHAR
39	is_app_share	BOOLEAN
40	shares	VARCHAR
41	expanded_height	INTEGER
42	targeting	VARCHAR
43	scheduled_publish_time	DOUBLE
44	is_instagram_eligible	BOOLEAN
45	place	VARCHAR
46	event	VARCHAR
47	promotion_status	VARCHAR
48	is_eligible_for_promotion	BOOLEAN
49	comments	VARCHAR
50	can_reply_privately	BOOLEAN
51	coordinates	VARCHAR
52	multi_share_optimized	BOOLEAN
53	message	VARCHAR
54	picture	VARCHAR
55	target	VARCHAR
56	feed_targeting	VARCHAR
57	instagram_eligibility	VARCHAR
58	admin_creator	VARCHAR
59	is_expired	BOOLEAN
60	application	VARCHAR
61	expanded_width	INTEGER
62	is_inline_created	BOOLEAN
63	width	INTEGER
64	backdated_time	VARCHAR
65	reactions	VARCHAR
66	to	VARCHAR
67	is_spherical	BOOLEAN
68	properties	VARCHAR
69	story	VARCHAR

Table: page_insights

No	Column Name	Type	Notes
1	period	VARCHAR
2	values	VARCHAR
3	name	VARCHAR
4	description	VARCHAR
5	id	VARCHAR
6	title	VARCHAR

Table: post_insights

No	Column Name	Type	Notes
1	period	VARCHAR
2	values	VARCHAR
3	name	VARCHAR
4	description	VARCHAR
5	id	VARCHAR
6	title	VARCHAR

Table: page

No	Column Name	Type	Notes
1	name_with_location_descriptor	VARCHAR
2	attire	VARCHAR
3	messaging_feature_status	VARCHAR
4	subscribed_apps	VARCHAR
5	about	VARCHAR
6	videos	VARCHAR
7	published_posts	VARCHAR
8	cover	VARCHAR
9	culinary_team	VARCHAR
10	tagged	VARCHAR
11	app_id	VARCHAR
12	is_community_page	BOOLEAN
13	events	VARCHAR
14	custom_labels	VARCHAR
15	offer_eligible	BOOLEAN
16	messaging_feature_review	VARCHAR
17	global_brand_page_name	VARCHAR
18	page_backed_instagram_accounts	VARCHAR
19	personas	VARCHAR
20	image_copyrights	VARCHAR
21	mission	VARCHAR
22	release_date	VARCHAR
23	global_brand_root_id	VARCHAR
24	connected_instagram_account	VARCHAR
25	store_number	INTEGER
26	description_html	VARCHAR
27	instagram_accounts	VARCHAR
28	albums	VARCHAR
29	nativeoffers	VARCHAR
30	leadgen_tos_acceptance_time	VARCHAR
31	mini_shop_storefront	VARCHAR
32	ads_posts	VARCHAR
33	new_like_count	INTEGER
34	genre	VARCHAR
35	record_label	VARCHAR
36	start_info	VARCHAR
37	store_code	VARCHAR
38	website	VARCHAR
39	global_brand_children	VARCHAR
40	differently_open_offerings	VARCHAR
41	canvas_elements	VARCHAR
42	business	VARCHAR
43	founded	VARCHAR
44	is_owned	BOOLEAN
45	privacy_info_url	VARCHAR
46	company_overview	VARCHAR
47	unread_message_count	INTEGER
48	indexed_videos	VARCHAR
49	restaurant_specialties	VARCHAR
50	single_line_address	VARCHAR
51	promotion_ineligible_reason	VARCHAR
52	checkins	INTEGER
53	pickup_options	VARCHAR
54	written_by	VARCHAR
55	crosspost_whitelisted_pages	VARCHAR
56	engagement	VARCHAR
57	keywords	VARCHAR
58	overall_star_rating	DOUBLE
59	price_range	VARCHAR
60	pharma_safety_info	VARCHAR
61	features	VARCHAR
62	affiliation	VARCHAR
63	current_location	VARCHAR
64	whatsapp_number	VARCHAR
65	instagram_business_account	VARCHAR
66	fan_count	INTEGER
67	talking_about_count	INTEGER
68	live_videos	VARCHAR
69	name	VARCHAR
70	is_webhooks_subscribed	BOOLEAN
71	produced_by	VARCHAR
72	booking_agent	VARCHAR
73	custom_user_settings	VARCHAR
74	can_checkin	BOOLEAN
75	roles	VARCHAR
76	description	VARCHAR
77	merchant_id	VARCHAR
78	voip_info	VARCHAR
79	emails	VARCHAR
80	supports_instant_articles	BOOLEAN
81	messenger_profile	VARCHAR
82	ratings	VARCHAR
83	display_subtext	VARCHAR
84	copyright_whitelisted_partners	VARCHAR
85	best_page	VARCHAR
86	contact_address	VARCHAR
87	hometown	VARCHAR
88	hours	VARCHAR
89	screenplay_by	VARCHAR
90	delivery_and_pickup_option_info	VARCHAR
91	is_always_open	BOOLEAN
92	secondary_receivers	VARCHAR
93	agencies	VARCHAR
94	commerce_payouts	VARCHAR
95	is_eligible_for_branded_content	BOOLEAN
96	media_fingerprints	VARCHAR
97	schedule	VARCHAR
98	is_unclaimed	BOOLEAN
99	admin_notes	VARCHAR
100	followers_count	INTEGER
101	recipient	VARCHAR
102	location	VARCHAR
103	video_lists	VARCHAR
104	username	VARCHAR
105	were_here_count	INTEGER
106	parking	VARCHAR
107	studio	VARCHAR
108	visitor_posts	VARCHAR
109	food_styles	VARCHAR
110	messenger_ads_default_page_welcome_message	VARCHAR
111	restaurant_services	VARCHAR
112	is_published	BOOLEAN
113	bio	VARCHAR
114	has_whatsapp_number	BOOLEAN
115	displayed_message_response_time	VARCHAR
116	is_permanently_closed	BOOLEAN
117	chat_plugin	VARCHAR
118	public_transit	VARCHAR
119	category_list	VARCHAR
120	is_messenger_bot_get_started_enabled	BOOLEAN
121	copyright_whitelisted_ig_partners	VARCHAR
122	claimed_urls	VARCHAR
123	season	VARCHAR
124	leadgen_tos_accepting_user	VARCHAR
125	store_location_descriptor	VARCHAR
126	id	VARCHAR
127	band_members	VARCHAR
128	payment_options	VARCHAR
129	instant_articles_insights	VARCHAR
130	mpg	VARCHAR
131	shop_setup_status	VARCHAR
132	access_token	VARCHAR
133	product_catalogs	VARCHAR
134	commerce_orders	VARCHAR
135	instant_articles_review_status	VARCHAR
136	phone	VARCHAR
137	commerce_eligibility	VARCHAR
138	country_page_likes	INTEGER
139	video_copyright_rules	VARCHAR
140	tabs	VARCHAR
141	plot_outline	VARCHAR
142	leadgen_forms	VARCHAR
143	products	VARCHAR
144	commerce_transactions	VARCHAR
145	promotion_eligible	BOOLEAN
146	blocked	VARCHAR
147	messenger_ads_default_quick_replies	VARCHAR
148	place_type	VARCHAR
149	general_manager	VARCHAR
150	supports_donate_button_in_live_video	BOOLEAN
151	is_verified	BOOLEAN
152	scheduled_posts	VARCHAR
153	picture	VARCHAR
154	artists_we_like	VARCHAR
155	page_token	VARCHAR
156	rtb_dynamic_posts	VARCHAR
157	parent_page	VARCHAR
158	call_to_actions	VARCHAR
159	photos	VARCHAR
160	posts	VARCHAR
161	impressum	VARCHAR
162	press_contact	VARCHAR
163	band_interests	VARCHAR
164	has_whatsapp_business_number	BOOLEAN
165	members	VARCHAR
166	has_added_app	BOOLEAN
167	personal_interests	VARCHAR
168	likes	VARCHAR
169	settings	VARCHAR
170	insights	VARCHAR
171	merchant_review_status	VARCHAR
172	assigned_users	VARCHAR
173	connected_page_backed_instagram_account	VARCHAR
174	rating_count	INTEGER
175	feed	VARCHAR
176	canvases	VARCHAR
177	featured_video	VARCHAR
178	is_messenger_platform_bot	BOOLEAN
179	commerce_merchant_settings	VARCHAR
180	birthday	VARCHAR
181	has_transitioned_to_new_page_experience	BOOLEAN
182	instant_articles	VARCHAR
183	link	VARCHAR
184	ad_campaign	VARCHAR
185	verification_status	VARCHAR
186	conversations	VARCHAR
187	network	VARCHAR
188	directed_by	VARCHAR
189	personal_info	VARCHAR
190	influences	VARCHAR
191	general_info	VARCHAR
192	can_post	BOOLEAN
193	preferred_audience	VARCHAR
194	temporary_status	VARCHAR
195	is_chain	BOOLEAN
196	built	VARCHAR
197	groups	VARCHAR
198	threads	VARCHAR
199	messenger_ads_quick_replies_type	VARCHAR
200	thread_owner	VARCHAR
201	awards	VARCHAR
202	messenger_ads_default_icebreakers	VARCHAR
203	starring	VARCHAR
204	unseen_message_count	INTEGER
205	locations	VARCHAR
206	category	VARCHAR
207	unread_notif_count	INTEGER
208	leadgen_tos_accepted	BOOLEAN

External Resources

• Instruction
• Facebook App
• Generate
• Page Insights
• Post Insights
• Documentation On Rate Limiting

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.