Onesignal

Prerequisites

• User Auth Key
• Applications credentials (App Id & REST API Key)

Setting up the Onesignal connector

No	Item	Required	Example	Notes
1	User Auth Key	Yes		OneSignal User Auth Key, see the docs for more information on how to obtain this key.
2	Applications	Yes		Applications keys, see the docs for more information on how to obtain this data
3	Start Date	Yes	2020-11-16T00:00:00Z	The date from which you'd like to replicate data for OneSignal API, in the format YYYY-MM-DDT00:00:00Z. All data generated after this date will be replicated.
4	Outcome Names	Yes	ossession_duration.count,osclick.count,CustomOutcomeName.sum	Comma-separated list of names and the value (sum/count) for the returned outcome data. See the docs for more details

Tables in the Onesignal connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	outcomes	3		Full Refresh		API Reference
2	devices	21		Full Refresh, Incremental		API Reference
3	notifications	104		Full Refresh, Incremental		API Reference
4	apps	26		Full Refresh		API Reference

Table: outcomes

No	Column Name	Type	Notes
1	aggregation	VARCHAR
2	id	VARCHAR
3	value	INTEGER

Table: devices

No	Column Name	Type	Notes
1	identifier	VARCHAR
2	game_version	VARCHAR
3	device_model	VARCHAR
4	timezone	INTEGER
5	ip	VARCHAR
6	created_at	INTEGER
7	language	VARCHAR
8	device_type	INTEGER
9	playtime	INTEGER
10	device_os	VARCHAR
11	test_type	VARCHAR
12	tags	VARCHAR
13	amount_spent	DOUBLE
14	external_user_id	VARCHAR
15	ad_id	VARCHAR
16	session_count	INTEGER
17	id	VARCHAR
18	last_active	INTEGER
19	sdk	VARCHAR
20	invalid_identifier	BOOLEAN
21	badge_count	INTEGER

Table: notifications

No	Column Name	Type	Notes
1	sms_from	VARCHAR
2	email_click_tracking_disabled	BOOLEAN
3	apns_alert	VARCHAR
4	android_group_message	VARCHAR
5	amazon_background_data	BOOLEAN
6	huawei_channel_id	VARCHAR
7	firefox_icon	VARCHAR
8	id	VARCHAR
9	app_id	VARCHAR
10	excluded_segments	VARCHAR
11	wp_sound	VARCHAR
12	wp_wns_sound	VARCHAR
13	delayed_option	VARCHAR
14	queued_at	INTEGER
15	received	INTEGER
16	priority	INTEGER
17	remaining	INTEGER
18	tags	VARCHAR
19	huawei_accent_color	VARCHAR
20	canceled	BOOLEAN
21	chrome_icon	VARCHAR
22	completed_at	INTEGER
23	isSMS	BOOLEAN
24	send_after	INTEGER
25	chrome_web_image	VARCHAR
26	contents	VARCHAR
27	global_image	VARCHAR
28	android_visibility	INTEGER
29	headings	VARCHAR
30	isChromeWeb	BOOLEAN
31	adm_group	VARCHAR
32	huawei_group_message	VARCHAR
33	spoken_text	VARCHAR
34	isChrome	BOOLEAN
35	android_group	VARCHAR
36	huawei_visibility	VARCHAR
37	content_available	BOOLEAN
38	adm_small_icon	VARCHAR
39	ios_badgeType	VARCHAR
40	huawei_msg_type	VARCHAR
41	delivery_time_of_day	VARCHAR
42	large_icon	VARCHAR
43	fcap_group_ids	VARCHAR
44	url	VARCHAR
45	include_player_ids	VARCHAR
46	android_led_color	VARCHAR
47	isWP_WNS	BOOLEAN
48	adm_group_message	VARCHAR
49	adm_big_picture	VARCHAR
50	template_id	VARCHAR
51	isIos	BOOLEAN
52	errored	INTEGER
53	isFirefox	BOOLEAN
54	data	VARCHAR
55	platform_delivery_stats	VARCHAR
56	huawei_sound	VARCHAR
57	included_segments	VARCHAR
58	isAlexa	BOOLEAN
59	thread_id	VARCHAR
60	chrome_web_icon	VARCHAR
61	ios_sound	VARCHAR
62	ios_attachments	VARCHAR
63	ios_category	VARCHAR
64	android_sound	VARCHAR
65	chrome_big_picture	VARCHAR
66	isEdge	BOOLEAN
67	huawei_small_icon	VARCHAR
68	failed	INTEGER
69	ios_relevance_score	DOUBLE
70	huawei_group	VARCHAR
71	isWP	BOOLEAN
72	sms_media_urls	VARCHAR
73	adm_sound	VARCHAR
74	converted	INTEGER
75	name	VARCHAR
76	target_content_identifier	VARCHAR
77	huawei_large_icon	VARCHAR
78	isSafari	BOOLEAN
79	chrome_web_badge	VARCHAR
80	ios_badgeCount	INTEGER
81	huawei_big_picture	VARCHAR
82	alexa_ssml	VARCHAR
83	huawei_led_color	VARCHAR
84	fcap_status	VARCHAR
85	alexa_display_title	VARCHAR
86	android_accent_color	VARCHAR
87	include_external_user_ids	VARCHAR
88	isAdm	BOOLEAN
89	successful	INTEGER
90	web_push_topic	VARCHAR
91	adm_large_icon	VARCHAR
92	buttons	VARCHAR
93	huawei_existing_channel_id	VARCHAR
94	app_url	VARCHAR
95	ios_interruption_level	VARCHAR
96	big_picture	VARCHAR
97	filters	VARCHAR
98	ttl	INTEGER
99	isHuawei	BOOLEAN
100	web_url	VARCHAR
101	small_icon	VARCHAR
102	throttle_rate_per_minute	INTEGER
103	web_buttons	VARCHAR
104	isAndroid	BOOLEAN

Table: apps

No	Column Name	Type	Notes
1	safari_site_origin	VARCHAR
2	safari_apns_certificate	VARCHAR
3	created_at	VARCHAR
4	safari_icon_64_64	VARCHAR
5	chrome_web_sub_domain	VARCHAR
6	gcm_key	VARCHAR
7	chrome_key	VARCHAR
8	safari_push_id	VARCHAR
9	updated_at	VARCHAR
10	apns_certificates	VARCHAR
11	safari_icon_128_128	VARCHAR
12	id	VARCHAR
13	safari_icon_32_32	VARCHAR
14	additional_data_is_root_payload	BOOLEAN
15	apns_env	VARCHAR
16	chrome_web_key	VARCHAR
17	players	INTEGER
18	messageable_players	INTEGER
19	chrome_web_gcm_sender_id	VARCHAR
20	chrome_web_origin	VARCHAR
21	basic_auth_key	VARCHAR
22	site_name	VARCHAR
23	safari_icon_16_16	VARCHAR
24	chrome_web_default_notification_icon	VARCHAR
25	name	VARCHAR
26	safari_icon_256_256	VARCHAR

External Resources

• User Auth Key
• Credentials
• App Id
• Rest Api Key
• Api Docs
• Rate Limits

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.