Fastbill

Prerequisites

You can find your Project ID and find or create an API key within Fastbill.

Tables in the Fastbill connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	invoices	49		Full Refresh		API Reference
2	recurring_invoices	43		Full Refresh		API Reference
3	customers	40		Full Refresh		API Reference
4	revenues	49		Full Refresh		API Reference
5	products	10		Full Refresh		API Reference

Table: invoices

No	Column Name	Type	Notes
1	ITEMS	VARCHAR
2	INVOICE_DATE	VARCHAR
3	LASTUPDATE	VARCHAR
4	SALUTATION	VARCHAR
5	SERVICE_PERIOD_END	VARCHAR
6	BANK_ACCOUNT_OWNER	VARCHAR
7	BANK_ACCOUNT_NUMBER	VARCHAR
8	VAT_ITEMS	VARCHAR
9	TYPE	VARCHAR
10	PAYMENTS	VARCHAR
11	CUSTOMER_NUMBER	VARCHAR
12	CASH_DISCOUNT_DAYS	VARCHAR
13	CUSTOMER_ID	VARCHAR
14	PAYMENT_TYPE	VARCHAR
15	BANK_BIC	VARCHAR
16	IS_CANCELED	VARCHAR
17	DELIVERY_DATE	VARCHAR
18	ADDRESS	VARCHAR
19	ADDRESS_2	VARCHAR
20	COUNTRY_CODE	VARCHAR
21	DOCUMENT_URL	VARCHAR
22	LAST_NAME	VARCHAR
23	CURRENCY_CODE	VARCHAR
24	FIRST_NAME	VARCHAR
25	TEMPLATE_ID	VARCHAR
26	ORGANIZATION	VARCHAR
27	INVOICE_ID	VARCHAR
28	NOTE	VARCHAR
29	CASH_DISCOUNT_PERCENT	VARCHAR
30	PAYMENT_INFO	VARCHAR
31	PAID_DATE	VARCHAR
32	INVOICE_TITLE	VARCHAR
33	BANK_CODE	VARCHAR
34	PROJECT_ID	VARCHAR
35	TOTAL	DOUBLE
36	INTROTEXT	VARCHAR
37	DUE_DATE	VARCHAR
38	CUSTOMER_COSTCENTER_ID	VARCHAR
39	BANK_IBAN	VARCHAR
40	ZIPCODE	VARCHAR
41	SERVICE_PERIOD_START	VARCHAR
42	INVOICE_NUMBER	VARCHAR
43	VAT_CASE	VARCHAR
44	VAT_ID	VARCHAR
45	CITY	VARCHAR
46	SUB_TOTAL	DOUBLE
47	VAT_TOTAL	DOUBLE
48	CONTACT_ID	VARCHAR
49	BANK_NAME	VARCHAR

Table: recurring_invoices

No	Column Name	Type	Notes
1	ITEMS	VARCHAR
2	OUTPUT_TYPE	VARCHAR
3	LAST_NAME	VARCHAR
4	CURRENCY_CODE	VARCHAR
5	OCCURENCES	VARCHAR
6	FIRST_NAME	VARCHAR
7	TEMPLATE_ID	VARCHAR
8	ORGANIZATION	VARCHAR
9	INVOICE_ID	VARCHAR
10	EMAIL_NOTIFY	VARCHAR
11	SALUTATION	VARCHAR
12	SERVICE_PERIOD_END	VARCHAR
13	BANK_ACCOUNT_OWNER	VARCHAR
14	NOTE	VARCHAR
15	BANK_ACCOUNT_NUMBER	VARCHAR
16	VAT_ITEMS	VARCHAR
17	FREQUENCY	VARCHAR
18	CASH_DISCOUNT_PERCENT	VARCHAR
19	INVOICE_TITLE	VARCHAR
20	BANK_CODE	VARCHAR
21	TYPE	VARCHAR
22	PROJECT_ID	VARCHAR
23	TOTAL	DOUBLE
24	INTROTEXT	VARCHAR
25	CUSTOMER_NUMBER	VARCHAR
26	CUSTOMER_COSTCENTER_ID	VARCHAR
27	CASH_DISCOUNT_DAYS	VARCHAR
28	BANK_IBAN	VARCHAR
29	ZIPCODE	VARCHAR
30	CUSTOMER_ID	VARCHAR
31	SERVICE_PERIOD_START	VARCHAR
32	START_DATE	VARCHAR
33	VAT_CASE	VARCHAR
34	PAYMENT_TYPE	VARCHAR
35	BANK_BIC	VARCHAR
36	CITY	VARCHAR
37	DELIVERY_DATE	VARCHAR
38	SUB_TOTAL	DOUBLE
39	ADDRESS	VARCHAR
40	VAT_TOTAL	DOUBLE
41	CONTACT_ID	VARCHAR
42	ADDRESS_2	VARCHAR
43	BANK_NAME	VARCHAR

Table: customers

No	Column Name	Type	Notes
1	CUSTOMER_ACCOUNT	VARCHAR
2	CUSTOMER_TYPE	VARCHAR
3	PHONE	VARCHAR
4	LAST_NAME	VARCHAR
5	PHONE_2	VARCHAR
6	EMAIL	VARCHAR
7	CURRENCY_CODE	VARCHAR
8	FIRST_NAME	VARCHAR
9	ACADEMIC_DEGREE	VARCHAR
10	ORGANIZATION	VARCHAR
11	POSITION	VARCHAR
12	CREATED	VARCHAR
13	LASTUPDATE	VARCHAR
14	BANK_ACCOUNT_OWNER	VARCHAR
15	SALUTATION	VARCHAR
16	BANK_ACCOUNT_NUMBER	VARCHAR
17	NEWSLETTER_OPTIN	VARCHAR
18	SECONDARY_ADDRESS	VARCHAR
19	BANK_CODE	VARCHAR
20	BANK_ACCOUNT_MANDATE_REFERENCE	VARCHAR
21	CUSTOMER_NUMBER	VARCHAR
22	DAYS_FOR_PAYMENT	VARCHAR
23	BANK_IBAN	VARCHAR
24	ZIPCODE	VARCHAR
25	CUSTOMER_ID	VARCHAR
26	DOCUMENT_HISTORY_URL	VARCHAR
27	VAT_ID	VARCHAR
28	PAYMENT_TYPE	VARCHAR
29	BANK_BIC	VARCHAR
30	SHOW_PAYMENT_NOTICE	VARCHAR
31	TOP	VARCHAR
32	CITY	VARCHAR
33	ADDRESS	VARCHAR
34	FAX	VARCHAR
35	WEBSITE	VARCHAR
36	TAGS	VARCHAR
37	BANK_NAME	VARCHAR
38	ADDRESS_2	VARCHAR
39	COUNTRY_CODE	VARCHAR
40	MOBILE	VARCHAR

Table: revenues

No	Column Name	Type	Notes
1	ITEMS	VARCHAR
2	INVOICE_DATE	VARCHAR
3	LASTUPDATE	VARCHAR
4	SALUTATION	VARCHAR
5	SERVICE_PERIOD_END	VARCHAR
6	BANK_ACCOUNT_OWNER	VARCHAR
7	BANK_ACCOUNT_NUMBER	VARCHAR
8	VAT_ITEMS	VARCHAR
9	TYPE	VARCHAR
10	PAYMENTS	VARCHAR
11	CUSTOMER_NUMBER	VARCHAR
12	CASH_DISCOUNT_DAYS	VARCHAR
13	CUSTOMER_ID	VARCHAR
14	PAYMENT_TYPE	VARCHAR
15	BANK_BIC	VARCHAR
16	IS_CANCELED	VARCHAR
17	DELIVERY_DATE	VARCHAR
18	ADDRESS	VARCHAR
19	ADDRESS_2	VARCHAR
20	COUNTRY_CODE	VARCHAR
21	DOCUMENT_URL	VARCHAR
22	LAST_NAME	VARCHAR
23	CURRENCY_CODE	VARCHAR
24	FIRST_NAME	VARCHAR
25	TEMPLATE_ID	VARCHAR
26	ORGANIZATION	VARCHAR
27	INVOICE_ID	VARCHAR
28	NOTE	VARCHAR
29	CASH_DISCOUNT_PERCENT	VARCHAR
30	PAYMENT_INFO	VARCHAR
31	PAID_DATE	VARCHAR
32	INVOICE_TITLE	VARCHAR
33	BANK_CODE	VARCHAR
34	PROJECT_ID	VARCHAR
35	TOTAL	DOUBLE
36	INTROTEXT	VARCHAR
37	DUE_DATE	VARCHAR
38	CUSTOMER_COSTCENTER_ID	VARCHAR
39	BANK_IBAN	VARCHAR
40	ZIPCODE	VARCHAR
41	SERVICE_PERIOD_START	VARCHAR
42	INVOICE_NUMBER	VARCHAR
43	VAT_CASE	VARCHAR
44	VAT_ID	VARCHAR
45	CITY	VARCHAR
46	SUB_TOTAL	INTEGER
47	VAT_TOTAL	DOUBLE
48	CONTACT_ID	VARCHAR
49	BANK_NAME	VARCHAR

Table: products

No	Column Name	Type	Notes
1	UNIT	VARCHAR
2	DESCRIPTION	VARCHAR
3	UNIT_PRICE	VARCHAR
4	IS_GROSS	DOUBLE
5	TITLE	VARCHAR
6	ARTICLE_ID	VARCHAR
7	ARTICLE_NUMBER	VARCHAR
8	CURRENCY_CODE	VARCHAR
9	VAT_PERCENT	VARCHAR
10	TAGS	VARCHAR

External Resources

• Fastbill
• Here

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.