Insightly

Tables in the Insightly connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	projects	21				API Reference
2	notes	7				API Reference
3	tickets	19				API Reference
4	pipeline_stages	6
5	prospects	37				API Reference
6	knowledge_article_folders	8
7	opportunity_state_reasons	3
8	pricebook_entries	11
9	quotes	39				API Reference
10	products	15				API Reference
11	lead_statuses	5
12	emails	12				API Reference
13	relationships	7				API Reference
14	opportunity_products	15
15	lead_sources	4
16	pipelines	5				API Reference
17	organisations	31				API Reference
18	events	14				API Reference
19	tasks	31				API Reference
20	task_categories	4
21	knowledge_articles	23
22	opportunity_categories	4
23	project_categories	4
24	teams	6				API Reference
25	knowledge_article_categories	6
26	countries	1				API Reference
27	opportunities	28				API Reference
28	users	20	USER_ID	Full Refresh, Incremental	DATE_UPDATED_UTC	API Reference
29	tags	1				API Reference
30	pricebooks	10
31	leads	39				API Reference
32	team_members	3	MEMBER_USER_ID	Full Refresh
33	milestones	10				API Reference
34	activity_sets	9
35	quote_products	16
36	contacts	41				API Reference
37	currencies	2				API Reference

Table: projects

No	Column Name	Type	Notes
1	CATEGORY_ID	INTEGER
2	RESPONSIBLE_USER_ID	INTEGER
3	STARTED_DATE	VARCHAR
4	CREATED_USER_ID	INTEGER
5	DATE_UPDATED_UTC	VARCHAR
6	LAST_ACTIVITY_DATE_UTC	VARCHAR
7	LINKS	VARCHAR
8	OWNER_USER_ID	INTEGER
9	PIPELINE_ID	INTEGER
10	CUSTOMFIELDS	VARCHAR
11	PROJECT_NAME	VARCHAR
12	DATE_CREATED_UTC	VARCHAR
13	STATUS	VARCHAR
14	PROJECT_DETAILS	VARCHAR
15	COMPLETED_DATE	VARCHAR
16	OPPORTUNITY_ID	INTEGER
17	STAGE_ID	INTEGER
18	NEXT_ACTIVITY_DATE_UTC	VARCHAR
19	PROJECT_ID	INTEGER
20	TAGS	VARCHAR
21	IMAGE_URL	VARCHAR

Table: notes

No	Column Name	Type	Notes
1	DATE_CREATED_UTC	VARCHAR
2	DATE_UPDATED_UTC	VARCHAR
3	LINKS	VARCHAR
4	OWNER_USER_ID	INTEGER
5	TITLE	VARCHAR
6	NOTE_ID	INTEGER
7	BODY	VARCHAR

Table: tickets

No	Column Name	Type	Notes
1	CREATED_USER_ID	INTEGER
2	DATE_SOLVED_UTC	VARCHAR
3	DATE_UPDATED_UTC	VARCHAR
4	ORGANISATION_ID	INTEGER
5	TICKET_TYPE	VARCHAR
6	OWNER_USER_ID	INTEGER
7	TICKET_NUMBER	VARCHAR
8	DATE_CLOSED_UTC	VARCHAR
9	PRIORITY	VARCHAR
10	TO_EMAIL_ADDRESS	VARCHAR
11	CUSTOMFIELDS	VARCHAR
12	TicketCommentBodyHtml	VARCHAR
13	TICKET_STATUS	VARCHAR
14	DATE_CREATED_UTC	VARCHAR
15	TICKET_ID	INTEGER
16	SOURCE	VARCHAR
17	SUBJECT	VARCHAR
18	CONTACT_ID	INTEGER
19	TAGS	VARCHAR

Table: pipeline_stages

No	Column Name	Type	Notes
1	STAGE_ORDER	INTEGER
2	STAGE_NAME	VARCHAR
3	ACTIVITYSET_ID	INTEGER
4	OWNER_USER_ID	INTEGER
5	PIPELINE_ID	INTEGER
6	STAGE_ID	INTEGER

Table: prospects

No	Column Name	Type	Notes
1	SCORE	INTEGER
2	PHONE	VARCHAR
3	PROSPECT_ID	INTEGER
4	LAST_NAME	VARCHAR
5	FIRST_NAME	VARCHAR
6	ORGANISATION_NAME	VARCHAR
7	DO_NOT_EMAIL	BOOLEAN
8	LEAD_CONVERSION_DATE_UTC	VARCHAR
9	DATE_CREATED_UTC	VARCHAR
10	OPTED_OUT	BOOLEAN
11	LEAD_ID	INTEGER
12	GRADE_PROFILE_ID	INTEGER
13	EMAIL_ADDRESS	VARCHAR
14	SALUTATION	VARCHAR
15	DESCRIPTION	VARCHAR
16	EMPLOYEE_COUNT	INTEGER
17	ADDRESS_COUNTRY	VARCHAR
18	ADDRESS_POSTCODE	VARCHAR
19	INDUSTRY	VARCHAR
20	CREATED_USER_ID	INTEGER
21	DATE_UPDATED_UTC	VARCHAR
22	LAST_ACTIVITY_DATE_UTC	VARCHAR
23	ORGANISATION_ID	INTEGER
24	OWNER_USER_ID	INTEGER
25	ADDRESS_STREET	VARCHAR
26	ADDRESS_CITY	VARCHAR
27	CUSTOMFIELDS	VARCHAR
28	ADDRESS_STATE	VARCHAR
29	DO_NOT_SYNC	BOOLEAN
30	GRADE	VARCHAR
31	DO_NOT_CALL	BOOLEAN
32	CONTACT_ID	INTEGER
33	TITLE	VARCHAR
34	FAX	VARCHAR
35	WEBSITE	VARCHAR
36	TAGS	VARCHAR
37	MOBILE	VARCHAR

Table: knowledge_article_folders

No	Column Name	Type	Notes
1	CATEGORY_ID	VARCHAR
2	DATE_CREATED_UTC	VARCHAR
3	ORDER_ARTICLES	VARCHAR
4	FOLDER_NAME	VARCHAR
5	VISIBILITY	VARCHAR
6	FOLDER_ID	INTEGER
7	CREATED_USER_ID	INTEGER
8	DATE_UPDATED_UTC	VARCHAR

Table: opportunity_state_reasons

No	Column Name	Type	Notes
1	STATE_REASON	VARCHAR
2	STATE_REASON_ID	INTEGER
3	FOR_OPPORTUNITY_STATE	VARCHAR

Table: pricebook_entries

No	Column Name	Type	Notes
1	DATE_CREATED_UTC	VARCHAR
2	PRICE	INTEGER
3	ACTIVE	BOOLEAN
4	CREATED_USER_ID	INTEGER
5	DATE_UPDATED_UTC	VARCHAR
6	PRICEBOOK_ENTRY_ID	INTEGER
7	USE_STANDARD_PRICE	BOOLEAN
8	PRODUCT_ID	INTEGER
9	CUSTOMFIELDS	VARCHAR
10	CURRENCY_CODE	VARCHAR
11	PRICEBOOK_ID	INTEGER

Table: quotes

No	Column Name	Type	Notes
1	ADDRESS_SHIPPING_CITY	VARCHAR
2	ADDRESS_SHIPPING_POSTCODE	VARCHAR
3	TAX	INTEGER
4	ADDRESS_SHIPPING_STATE	VARCHAR
5	QUOTATION_EMAIL	VARCHAR
6	DATE_CREATED_UTC	VARCHAR
7	IS_SYNCING	BOOLEAN
8	SUBTOTAL	INTEGER
9	TOTAL_PRICE	INTEGER
10	QUOTATION_EXPIRATION_DATE	VARCHAR
11	OPPORTUNITY_ID	INTEGER
12	SHIPPING_HANDLING	INTEGER
13	ADDRESS_BILLING_COUNTRY	VARCHAR
14	QUOTE_ID	INTEGER
15	QUOTATION_NAME	VARCHAR
16	PRICEBOOK_ID	INTEGER
17	QUOTATION_NUMBER	VARCHAR
18	ADDRESS_BILLING_CITY	VARCHAR
19	ADDRESS_BILLING_STATE	VARCHAR
20	ADDRESS_BILLING_POSTCODE	VARCHAR
21	CREATED_USER_ID	INTEGER
22	DATE_UPDATED_UTC	VARCHAR
23	QUOTATION_FAX	VARCHAR
24	ADDRESS_SHIPPING_NAME	VARCHAR
25	ORGANISATION_ID	INTEGER
26	GRAND_TOTAL	INTEGER
27	OWNER_USER_ID	INTEGER
28	CUSTOMFIELDS	VARCHAR
29	DISCOUNT	INTEGER
30	QUOTE_STATUS	VARCHAR
31	QUOTATION_CURRENCY_CODE	VARCHAR
32	ADDRESS_SHIPPING_COUNTRY	VARCHAR
33	ADDRESS_BILLING_STREET	VARCHAR
34	LINE_ITEM_COUNT	INTEGER
35	ADDRESS_BILLING_NAME	VARCHAR
36	CONTACT_ID	INTEGER
37	QUOTATION_PHONE	VARCHAR
38	ADDRESS_SHIPPING_STREET	VARCHAR
39	QUOTATION_DESCRIPTION	VARCHAR

Table: products

No	Column Name	Type	Notes
1	ACTIVE	BOOLEAN
2	CREATED_USER_ID	INTEGER
3	DATE_UPDATED_UTC	VARCHAR
4	OWNER_USER_ID	INTEGER
5	PRODUCT_ID	INTEGER
6	PRODUCT_NAME	VARCHAR
7	CUSTOMFIELDS	VARCHAR
8	CURRENCY_CODE	VARCHAR
9	PRODUCT_CODE	VARCHAR
10	DEFAULT_PRICE	INTEGER
11	DATE_CREATED_UTC	VARCHAR
12	PRODUCT_SKU	VARCHAR
13	DESCRIPTION	VARCHAR
14	PRODUCT_FAMILY	VARCHAR
15	PRODUCT_IMAGE_URL	VARCHAR

Table: lead_statuses

No	Column Name	Type	Notes
1	FIELD_ORDER	INTEGER
2	LEAD_STATUS_ID	INTEGER
3	LEAD_STATUS	VARCHAR
4	DEFAULT_STATUS	BOOLEAN
5	STATUS_TYPE	INTEGER

Table: emails

No	Column Name	Type	Notes
1	DATE_CREATED_UTC	VARCHAR
2	QUEUED_SEND_DATE_UTC	VARCHAR
3	FORMAT	VARCHAR
4	CREATED_USER_ID	INTEGER
5	SIZE	INTEGER
6	LINKS	VARCHAR
7	SUBJECT	VARCHAR
8	OWNER_USER_ID	INTEGER
9	EMAIL_ID	INTEGER
10	EMAIL_FROM	VARCHAR
11	TAGS	VARCHAR
12	EMAIL_DATE_UTC	VARCHAR

Table: relationships

No	Column Name	Type	Notes
1	RELATIONSHIP_ID	INTEGER
2	FOR_ORGANISATIONS	BOOLEAN
3	REVERSE_TITLE	VARCHAR
4	FORWARD	VARCHAR
5	REVERSE	VARCHAR
6	FOR_CONTACTS	BOOLEAN
7	FORWARD_TITLE	VARCHAR

Table: opportunity_products

No	Column Name	Type	Notes
1	LIST_PRICE	INTEGER
2	QUANTITY	INTEGER
3	DATE_UPDATED_UTC	VARCHAR
4	SERVICE_DATE	VARCHAR
5	UNIT_PRICE	INTEGER
6	PRICEBOOK_ENTRY_ID	INTEGER
7	CUSTOMFIELDS	VARCHAR
8	CURRENCY_CODE	VARCHAR
9	DISCOUNT	INTEGER
10	DATE_CREATED_UTC	VARCHAR
11	SUBTOTAL	INTEGER
12	DESCRIPTION	VARCHAR
13	OPPORTUNITY_ITEM_ID	INTEGER
14	TOTAL_PRICE	INTEGER
15	OPPORTUNITY_ID	INTEGER

Table: lead_sources

No	Column Name	Type	Notes
1	FIELD_ORDER	INTEGER
2	DEFAULT_VALUE	BOOLEAN
3	LEAD_SOURCE	VARCHAR
4	LEAD_SOURCE_ID	INTEGER

Table: pipelines

No	Column Name	Type	Notes
1	FOR_PROJECTS	BOOLEAN
2	OWNER_USER_ID	INTEGER
3	PIPELINE_ID	INTEGER
4	FOR_OPPORTUNITIES	BOOLEAN
5	PIPELINE_NAME	VARCHAR

Table: organisations

No	Column Name	Type	Notes
1	SOCIAL_TWITTER	VARCHAR
2	PHONE	VARCHAR
3	LINKS	VARCHAR
4	SOCIAL_FACEBOOK	VARCHAR
5	ORGANISATION_NAME	VARCHAR
6	ADDRESS_SHIP_STATE	VARCHAR
7	DATE_CREATED_UTC	VARCHAR
8	ADDRESS_SHIP_COUNTRY	VARCHAR
9	EMAILDOMAINS	VARCHAR
10	PHONE_FAX	VARCHAR
11	ADDRESS_BILLING_COUNTRY	VARCHAR
12	IMAGE_URL	VARCHAR
13	ADDRESS_BILLING_CITY	VARCHAR
14	ADDRESS_BILLING_STATE	VARCHAR
15	ADDRESS_BILLING_POSTCODE	VARCHAR
16	ADDRESS_SHIP_POSTCODE	VARCHAR
17	CREATED_USER_ID	INTEGER
18	DATE_UPDATED_UTC	VARCHAR
19	LAST_ACTIVITY_DATE_UTC	VARCHAR
20	ORGANISATION_ID	INTEGER
21	OWNER_USER_ID	INTEGER
22	BACKGROUND	VARCHAR
23	CUSTOMFIELDS	VARCHAR
24	ADDRESS_SHIP_STREET	VARCHAR
25	ADDRESS_SHIP_CITY	VARCHAR
26	ADDRESS_BILLING_STREET	VARCHAR
27	SOCIAL_LINKEDIN	VARCHAR
28	DATES	VARCHAR
29	NEXT_ACTIVITY_DATE_UTC	VARCHAR
30	WEBSITE	VARCHAR
31	TAGS	VARCHAR

Table: events

No	Column Name	Type	Notes
1	LOCATION	VARCHAR
2	START_DATE_UTC	VARCHAR
3	DETAILS	VARCHAR
4	DATE_UPDATED_UTC	VARCHAR
5	LINKS	VARCHAR
6	OWNER_USER_ID	INTEGER
7	CUSTOMFIELDS	VARCHAR
8	DATE_CREATED_UTC	VARCHAR
9	REMINDER_DATE_UTC	VARCHAR
10	EVENT_ID	INTEGER
11	TITLE	VARCHAR
12	END_DATE_UTC	VARCHAR
13	ALL_DAY	BOOLEAN
14	REMINDER_SENT	BOOLEAN

Table: tasks

No	Column Name	Type	Notes
1	CATEGORY_ID	INTEGER
2	DETAILS	VARCHAR
3	OWNER_VISIBLE	BOOLEAN
4	MILESTONE_ID	INTEGER
5	LINKS	VARCHAR
6	PRIORITY	INTEGER
7	DATE_CREATED_UTC	VARCHAR
8	COMPLETED	BOOLEAN
9	STATUS	VARCHAR
10	PERCENT_COMPLETE	INTEGER
11	REMINDER_DATE_UTC	VARCHAR
12	COMPLETED_DATE_UTC	VARCHAR
13	RECURRENCE	VARCHAR
14	STAGE_ID	INTEGER
15	OPPORTUNITY_ID	INTEGER
16	PROJECT_ID	INTEGER
17	REMINDER_SENT	BOOLEAN
18	RESPONSIBLE_USER_ID	INTEGER
19	ASSIGNED_DATE_UTC	VARCHAR
20	DUE_DATE	VARCHAR
21	CREATED_USER_ID	INTEGER
22	DATE_UPDATED_UTC	VARCHAR
23	OWNER_USER_ID	INTEGER
24	START_DATE	VARCHAR
25	CUSTOMFIELDS	VARCHAR
26	PARENT_TASK_ID	INTEGER
27	ASSIGNED_BY_USER_ID	INTEGER
28	TITLE	VARCHAR
29	EMAIL_ID	INTEGER
30	ASSIGNED_TEAM_ID	INTEGER
31	TASK_ID	INTEGER

Table: task_categories

No	Column Name	Type	Notes
1	CATEGORY_ID	INTEGER
2	ACTIVE	BOOLEAN
3	CATEGORY_NAME	VARCHAR
4	BACKGROUND_COLOR	VARCHAR

Table: knowledge_articles

No	Column Name	Type	Notes
1	CATEGORY_ID	INTEGER
2	Status	VARCHAR
3	ARCHIVED_DATE_UTC	VARCHAR
4	FOLDER_ID	INTEGER
5	CREATED_USER_ID	INTEGER
6	DATE_UPDATED_UTC	VARCHAR
7	Title	VARCHAR
8	OWNER_USER_ID	INTEGER
9	PROMOTED	BOOLEAN
10	LAST_PUBLISHED_DATE_UTC	VARCHAR
11	CUSTOMFIELDS	VARCHAR
12	DOWNVOTE_COUNT	INTEGER
13	URL_SLUG	VARCHAR
14	DATE_CREATED_UTC	VARCHAR
15	ExternalLinkCount	VARCHAR
16	FIRST_PUBLISHED_DATE_UTC	VARCHAR
17	Language	VARCHAR
18	ARTICLE_NO	INTEGER
19	UPVOTE_COUNT	INTEGER
20	ARTICLE_ID	INTEGER
21	ArticleVersion	VARCHAR
22	Body	VARCHAR
23	TAGS	VARCHAR

Table: opportunity_categories

No	Column Name	Type	Notes
1	CATEGORY_ID	INTEGER
2	ACTIVE	BOOLEAN
3	CATEGORY_NAME	VARCHAR
4	BACKGROUND_COLOR	VARCHAR

Table: project_categories

No	Column Name	Type	Notes
1	CATEGORY_ID	INTEGER
2	ACTIVE	BOOLEAN
3	CATEGORY_NAME	VARCHAR
4	BACKGROUND_COLOR	VARCHAR

Table: teams

No	Column Name	Type	Notes
1	DATE_CREATED_UTC	VARCHAR
2	ANONYMOUS_TEAM	BOOLEAN
3	TEAM_NAME	VARCHAR
4	DATE_UPDATED_UTC	VARCHAR
5	TEAMMEMBERS	VARCHAR
6	TEAM_ID	INTEGER

Table: knowledge_article_categories

No	Column Name	Type	Notes
1	CATEGORY_ID	INTEGER
2	DATE_CREATED_UTC	VARCHAR
3	DESCRIPTION	VARCHAR
4	CREATED_USER_ID	INTEGER
5	DATE_UPDATED_UTC	VARCHAR
6	CATEGORY_NAME	VARCHAR

Table: countries

No	Column Name	Type	Notes
1	COUNTRY_NAME	VARCHAR

Table: opportunities

No	Column Name	Type	Notes
1	CATEGORY_ID	INTEGER
2	FORECAST_CLOSE_DATE	VARCHAR
3	BID_AMOUNT	INTEGER
4	LINKS	VARCHAR
5	PIPELINE_ID	INTEGER
6	DATE_CREATED_UTC	VARCHAR
7	ACTUAL_CLOSE_DATE	VARCHAR
8	OPPORTUNITY_DETAILS	VARCHAR
9	OPPORTUNITY_NAME	VARCHAR
10	OPPORTUNITY_ID	INTEGER
11	STAGE_ID	INTEGER
12	IMAGE_URL	VARCHAR
13	PRICEBOOK_ID	INTEGER
14	RESPONSIBLE_USER_ID	INTEGER
15	BID_DURATION	INTEGER
16	CREATED_USER_ID	INTEGER
17	DATE_UPDATED_UTC	VARCHAR
18	LAST_ACTIVITY_DATE_UTC	VARCHAR
19	OWNER_USER_ID	INTEGER
20	ORGANISATION_ID	INTEGER
21	CUSTOMFIELDS	VARCHAR
22	BID_CURRENCY	VARCHAR
23	PROBABILITY	INTEGER
24	OPPORTUNITY_VALUE	INTEGER
25	BID_TYPE	VARCHAR
26	NEXT_ACTIVITY_DATE_UTC	VARCHAR
27	OPPORTUNITY_STATE	VARCHAR
28	TAGS	VARCHAR

Table: users

No	Column Name	Type	Notes
1	PROFILE_ID	INTEGER
2	EMAIL_DROPBOX_IDENTIFIER	VARCHAR
3	ACCOUNT_OWNER	BOOLEAN
4	ACTIVE	BOOLEAN
5	TASK_WEEK_START	INTEGER
6	DATE_UPDATED_UTC	VARCHAR	Incremental sync key
7	USER_ID	INTEGER	Primary Key
8	LAST_NAME	VARCHAR
9	FIRST_NAME	VARCHAR
10	TIMEZONE_ID	VARCHAR
11	INSTANCE_ID	INTEGER
12	ADMINISTRATOR	BOOLEAN
13	DATE_CREATED_UTC	VARCHAR
14	CONTACT_DISPLAY	VARCHAR
15	EMAIL_ADDRESS	VARCHAR
16	CONTACT_ORDER	VARCHAR
17	ROLE_ID	INTEGER
18	CONTACT_ID	INTEGER
19	USER_CURRENCY	VARCHAR
20	EMAIL_DROPBOX_ADDRESS	VARCHAR

Table: tags

No	Column Name	Type	Notes
1	TAG_NAME	VARCHAR

Table: pricebooks

No	Column Name	Type	Notes
1	DATE_CREATED_UTC	VARCHAR
2	ACTIVE	BOOLEAN
3	DESCRIPTION	VARCHAR
4	CREATED_USER_ID	INTEGER
5	DATE_UPDATED_UTC	VARCHAR
6	OWNER_USER_ID	INTEGER
7	IS_STANDARD	BOOLEAN
8	CURRENCY_CODE	VARCHAR
9	PRICEBOOK_ID	INTEGER
10	NAME	VARCHAR

Table: leads

No	Column Name	Type	Notes
1	CONVERTED_OPPORTUNITY_ID	INTEGER
2	EMAIL_OPTED_OUT	BOOLEAN
3	PHONE	VARCHAR
4	LINKS	VARCHAR
5	CONVERTED_DATE_UTC	VARCHAR
6	LAST_NAME	VARCHAR
7	EMAIL	VARCHAR
8	CONVERTED	BOOLEAN
9	FIRST_NAME	VARCHAR
10	ORGANISATION_NAME	VARCHAR
11	DATE_CREATED_UTC	VARCHAR
12	LEAD_ID	INTEGER
13	LEAD_STATUS_ID	INTEGER
14	SALUTATION	VARCHAR
15	CONVERTED_CONTACT_ID	INTEGER
16	LEAD_RATING	INTEGER
17	IMAGE_URL	VARCHAR
18	EMPLOYEE_COUNT	INTEGER
19	RESPONSIBLE_USER_ID	INTEGER
20	ADDRESS_COUNTRY	VARCHAR
21	ADDRESS_POSTCODE	VARCHAR
22	INDUSTRY	VARCHAR
23	CREATED_USER_ID	INTEGER
24	DATE_UPDATED_UTC	VARCHAR
25	LAST_ACTIVITY_DATE_UTC	VARCHAR
26	OWNER_USER_ID	INTEGER
27	ADDRESS_STREET	VARCHAR
28	ADDRESS_CITY	VARCHAR
29	CUSTOMFIELDS	VARCHAR
30	CONVERTED_ORGANISATION_ID	INTEGER
31	ADDRESS_STATE	VARCHAR
32	TITLE	VARCHAR
33	LEAD_SOURCE_ID	INTEGER
34	FAX	VARCHAR
35	LEAD_DESCRIPTION	VARCHAR
36	NEXT_ACTIVITY_DATE_UTC	VARCHAR
37	WEBSITE	VARCHAR
38	TAGS	VARCHAR
39	MOBILE	VARCHAR

Table: team_members

No	Column Name	Type	Notes
1	MEMBER_USER_ID	INTEGER	Primary Key
2	PERMISSION_ID	INTEGER
3	TEAM_ID	INTEGER

Table: milestones

No	Column Name	Type	Notes
1	DATE_CREATED_UTC	VARCHAR
2	COMPLETED	BOOLEAN
3	DUE_DATE	VARCHAR
4	DATE_UPDATED_UTC	VARCHAR
5	MILESTONE_ID	INTEGER
6	RESPONSIBLE_USER	INTEGER
7	OWNER_USER_ID	INTEGER
8	TITLE	VARCHAR
9	COMPLETED_DATE_UTC	VARCHAR
10	PROJECT_ID	INTEGER

Table: activity_sets

No	Column Name	Type	Notes
1	FOR_PROJECTS	BOOLEAN
2	FOR_ORGANISATIONS	BOOLEAN
3	ACTIVITYSET_ID	INTEGER
4	ACTIVITIES	VARCHAR
5	OWNER_USER_ID	INTEGER
6	FOR_CONTACTS	BOOLEAN
7	FOR_LEADS	BOOLEAN
8	FOR_OPPORTUNITIES	BOOLEAN
9	NAME	VARCHAR

Table: quote_products

No	Column Name	Type	Notes
1	LIST_PRICE	INTEGER
2	QUOTATION_ITEM_ID	INTEGER
3	QUANTITY	INTEGER
4	DATE_UPDATED_UTC	VARCHAR
5	UNIT_PRICE	INTEGER
6	PRICEBOOK_ENTRY_ID	INTEGER
7	CUSTOMFIELDS	VARCHAR
8	CURRENCY_CODE	VARCHAR
9	DISCOUNT	INTEGER
10	DATE_CREATED_UTC	VARCHAR
11	SUBTOTAL	INTEGER
12	DESCRIPTION	VARCHAR
13	OPPORTUNITY_ITEM_ID	INTEGER
14	TOTAL_PRICE	INTEGER
15	SORT_ORDER	INTEGER
16	QUOTE_ID	INTEGER

Table: contacts

No	Column Name	Type	Notes
1	PHONE_HOME	VARCHAR
2	SOCIAL_TWITTER	VARCHAR
3	EMAIL_OPTED_OUT	BOOLEAN
4	ADDRESS_OTHER_POSTCODE	VARCHAR
5	PHONE	VARCHAR
6	ADDRESS_OTHER_STATE	VARCHAR
7	LINKS	VARCHAR
8	ADDRESS_MAIL_COUNTRY	VARCHAR
9	SOCIAL_FACEBOOK	VARCHAR
10	ASSISTANT_NAME	VARCHAR
11	LAST_NAME	VARCHAR
12	FIRST_NAME	VARCHAR
13	DATE_CREATED_UTC	VARCHAR
14	ADDRESS_OTHER_STREET	VARCHAR
15	ADDRESS_MAIL_STREET	VARCHAR
16	EMAIL_ADDRESS	VARCHAR
17	SALUTATION	VARCHAR
18	ADDRESS_OTHER_CITY	VARCHAR
19	PHONE_FAX	VARCHAR
20	DATE_OF_BIRTH	VARCHAR
21	IMAGE_URL	VARCHAR
22	ADDRESS_MAIL_POSTCODE	VARCHAR
23	CREATED_USER_ID	INTEGER
24	DATE_UPDATED_UTC	VARCHAR
25	LAST_ACTIVITY_DATE_UTC	VARCHAR
26	OWNER_USER_ID	INTEGER
27	ORGANISATION_ID	INTEGER
28	PHONE_MOBILE	VARCHAR
29	BACKGROUND	VARCHAR
30	CUSTOMFIELDS	VARCHAR
31	ADDRESS_MAIL_STATE	VARCHAR
32	ADDRESS_OTHER_COUNTRY	VARCHAR
33	SOCIAL_LINKEDIN	VARCHAR
34	DATES	VARCHAR
35	CONTACT_ID	INTEGER
36	PHONE_ASSISTANT	VARCHAR
37	TITLE	VARCHAR
38	PHONE_OTHER	VARCHAR
39	NEXT_ACTIVITY_DATE_UTC	VARCHAR
40	ADDRESS_MAIL_CITY	VARCHAR
41	TAGS	VARCHAR

Table: currencies

No	Column Name	Type	Notes
1	CURRENCY_SYMBOL	VARCHAR
2	CURRENCY_CODE	VARCHAR

External Resources

• Activity Sets
• Knowledge Article Categories
• Knowledge Article Folders
• Knowledge Articles
• Lead Sources
• Lead Statuses
• Opportunity Categories
• Opportunity Products
• Opportunity State Reasons
• Pipeline Stages
• Price Book Entries
• Price Books
• Project Categories
• Quote Products
• Task Categories
• Team Members
• Requests Limitation

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.