Visma economic

Prerequisites

• Your Visma e-conomic Agreement Grant Token
• Your Visma e-conomic App Secret Token

This page guides you through the different ways of connecting to the api. In sort your options are:

• Developer agreement
• Create a free sandbox account, valid for 14 days.
• Demo tokens: app_secret_token=demo and agreement_grant_token=demo

Tables in the Visma economic connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	invoices_total	4		Full Refresh
2	invoices_paid	23		Full Refresh
3	invoices_booked_document	26		Full Refresh
4	customers	35		Full Refresh		API Reference
5	accounts	14		Full Refresh		API Reference
6	invoices_booked	25		Full Refresh
7	products	15		Full Refresh		API Reference

Table: invoices_total

No	Column Name	Type	Notes
1	booked	VARCHAR
2	predefinedPeriodFilters	VARCHAR
3	self	VARCHAR
4	drafts	VARCHAR

Table: invoices_paid

No	Column Name	Type	Notes
1	date	VARCHAR
2	roundingAmount	DOUBLE
3	delivery	VARCHAR
4	notes	VARCHAR
5	deliveryLocation	VARCHAR
6	references	VARCHAR
7	netAmount	DOUBLE
8	dueDate	VARCHAR
9	project	VARCHAR
10	grossAmount	DOUBLE
11	sent	VARCHAR
12	vatAmount	DOUBLE
13	layout	VARCHAR
14	remainderInBaseCurrency	DOUBLE
15	pdf	VARCHAR
16	bookedInvoiceNumber	INTEGER
17	recipient	VARCHAR
18	netAmountInBaseCurrency	DOUBLE
19	self	VARCHAR
20	currency	VARCHAR
21	remainder	DOUBLE
22	paymentTerms	VARCHAR
23	customer	VARCHAR

Table: invoices_booked_document

No	Column Name	Type	Notes
1	date	VARCHAR
2	roundingAmount	DOUBLE
3	notes	VARCHAR
4	references	VARCHAR
5	dueDate	VARCHAR
6	project	VARCHAR
7	grossAmountInBaseCurrency	DOUBLE
8	remainderInBaseCurrency	DOUBLE
9	bookedInvoiceNumber	INTEGER
10	exchangeRate	DOUBLE
11	netAmountInBaseCurrency	DOUBLE
12	currency	VARCHAR
13	lines	VARCHAR
14	paymentTerms	VARCHAR
15	delivery	VARCHAR
16	deliveryLocation	VARCHAR
17	netAmount	DOUBLE
18	grossAmount	DOUBLE
19	sent	VARCHAR
20	vatAmount	DOUBLE
21	layout	VARCHAR
22	pdf	VARCHAR
23	recipient	VARCHAR
24	self	VARCHAR
25	remainder	DOUBLE
26	customer	VARCHAR

Table: customers

No	Column Name	Type	Notes
1	country	VARCHAR
2	city	VARCHAR
3	deliveryLocations	VARCHAR
4	vatZone	VARCHAR
5	lastUpdated	VARCHAR
6	defaultDeliveryLocation	VARCHAR
7	ean	VARCHAR
8	balance	DOUBLE
9	customerContact	VARCHAR
10	invoices	VARCHAR
11	corporateIdentificationNumber	VARCHAR
12	barred	BOOLEAN
13	creditLimit	DOUBLE
14	currency	VARCHAR
15	telephoneAndFaxNumber	VARCHAR
16	email	VARCHAR
17	paymentTerms	VARCHAR
18	eInvoicingDisabledByDefault	BOOLEAN
19	zip	VARCHAR
20	website	VARCHAR
21	address	VARCHAR
22	customerGroup	VARCHAR
23	templates	VARCHAR
24	totals	VARCHAR
25	customerNumber	INTEGER
26	pNumber	VARCHAR
27	layout	VARCHAR
28	publicEntryNumber	VARCHAR
29	mobilePhone	VARCHAR
30	name	VARCHAR
31	attention	VARCHAR
32	self	VARCHAR
33	salesPerson	VARCHAR
34	contacts	VARCHAR
35	vatNumber	VARCHAR

Table: accounts

No	Column Name	Type	Notes
1	accountsSummed	VARCHAR
2	draftBalance	DOUBLE
3	accountType	VARCHAR
4	accountNumber	INTEGER
5	accountingYears	VARCHAR
6	balance	DOUBLE
7	name	VARCHAR
8	vatAccount	VARCHAR
9	totalFromAccount	VARCHAR
10	barred	BOOLEAN
11	contraAccount	VARCHAR
12	self	VARCHAR
13	blockDirectEntries	BOOLEAN
14	debitCredit	VARCHAR

Table: invoices_booked

No	Column Name	Type	Notes
1	date	VARCHAR
2	roundingAmount	DOUBLE
3	notes	VARCHAR
4	references	VARCHAR
5	dueDate	VARCHAR
6	project	VARCHAR
7	grossAmountInBaseCurrency	DOUBLE
8	remainderInBaseCurrency	DOUBLE
9	bookedInvoiceNumber	INTEGER
10	exchangeRate	DOUBLE
11	netAmountInBaseCurrency	DOUBLE
12	currency	VARCHAR
13	paymentTerms	VARCHAR
14	delivery	VARCHAR
15	deliveryLocation	VARCHAR
16	netAmount	DOUBLE
17	grossAmount	DOUBLE
18	sent	VARCHAR
19	vatAmount	DOUBLE
20	layout	VARCHAR
21	pdf	VARCHAR
22	recipient	VARCHAR
23	self	VARCHAR
24	remainder	DOUBLE
25	customer	VARCHAR

Table: products

No	Column Name	Type	Notes
1	recommendedPrice	DOUBLE
2	salesPrice	DOUBLE
3	costPrice	DOUBLE
4	description	VARCHAR
5	departmentalDistribution	VARCHAR
6	productNumber	VARCHAR
7	inventory	VARCHAR
8	barCode	VARCHAR
9	lastUpdated	VARCHAR
10	unit	VARCHAR
11	invoices	VARCHAR
12	productGroup	VARCHAR
13	name	VARCHAR
14	barred	BOOLEAN
15	self	VARCHAR

External Resources

• Visma E-conomic
• This Page
• Sandbox Account
• Invoices Booked
• Invoices Booked Document
• Invoices Paid
• Invoices Total
• E-conomic Rest Api Documentation

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.