Contacts: Bouw7 Contacts
popular read only REST
- Catalog:
Bouw7 - Schema:
Contact - Label: Contacts
Returns a list of contacts associated with the organization. Returns a list of contacts associated with the organization.
Can only retrieve data.
Summary
Returns a list of contacts associated with the organization.
API Source
- Endpoint:
/list/contacts - Operation:
get /list/contacts
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 151 |
| Full scan rows per minute | 712,000 |
| Point query rows per minute | 666 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
q |
`` | A Heimdall Query Language string. |
Table Columns
The columns of the table Contacts are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
address |
varchar2 |
Address | filters on the platform, writable, address |
The address. | |
agreed |
varchar2 |
Agreed Hourly Rate | filters on the platform, writable, agreed |
The agreed hourly rate. | |
associated |
varchar2 |
This field is dynamically hydrated by the 'addVirtualFields'-method in the schema factory. | filters on the platform, writable, associated |
All property asset names related to this contact. | |
ca |
varchar2 |
CA Contact Tekstgebied | filters on the platform, writable, ca |
||
city |
varchar2 |
City | filters on the platform, writable, city |
The city name. | |
coc |
varchar2 |
Chamber of Commerce Number | filters on the platform, writable, coc |
The chamber of commerce number. | |
contact |
varchar2 |
Contact Person Name | filters on the platform, writable, contact |
The name of the financial contact person, Primarily used for invoicing purposes. | |
country |
varchar2 |
Country Code | filters on the platform, writable, country |
An ISO 3166-2 representation of the country. | |
created |
datetime |
Created at | filters on the platform, writable, created |
The creation date of the object in ATOM/ISO-8601 format | |
created |
int64 |
Created by ID | filters on the platform, writable, created |
The ID of the user. | |
created |
varchar2 |
Created by User Name | filters on the platform, writable, created |
The username of the user. | |
debtor |
varchar2 |
Debtor Number | filters on the platform, writable, debtor |
The debtor number. Only used if the organization has no divisions. | |
debtor |
varchar2 |
This field is dynamically hydrated by the 'addVirtualFields'-method in the schema factory. | filters on the platform, writable, debtor |
The deptor numbers for each contact division associated with the contact. Only available if the organization has divisions. | |
email |
varchar2 |
Email Address | filters on the platform, writable, email |
The email address. | |
expiration |
int64 |
Expiration Reminder | filters on the platform, writable, expiration |
The expiration reminder days. | |
g |
varchar2 |
G-Account Percentage | filters on the platform, writable, g |
G-account percentage. | |
g |
varchar2 |
G-Account Text | filters on the platform, writable, g |
G-account text. | |
gln |
varchar2 |
GLN Number | filters on the platform, writable, gln |
The Global Location Number. | |
has |
char |
This field is dynamically hydrated by the 'addVirtualFields'-method in the schema factory. | filters on the platform, writable, has |
Whether the contact has either Exact or Twinfield accounting software. Not applicable if the organization has divisions. | |
hourly |
varchar2 |
Hourly Rate | filters on the platform, writable, hourly |
The hourly rate. | |
house |
varchar2 |
House Number | filters on the platform, writable, house |
The house number (incl. additions). | |
iban |
varchar2 |
IBAN | filters on the platform, writable, iban |
The IBAN account number. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of contact. | |
information |
varchar2 |
Information | filters on the platform, writable, information |
Additional information about the contact. | |
invoice |
varchar2 |
Invoice Mail | filters on the platform, writable, invoice |
The invoice email address. | |
invoice |
varchar2 |
Invoice Subject | filters on the platform, writable, invoice |
The invoice subject. | |
invoice |
varchar2 |
Invoice UBL Version | filters on the platform, writable, invoice |
The invoice ubl version. | |
is |
char |
Is VAT Shifted | filters on the platform, writable, is |
True if VAT is shifted from the invoice. | |
mobile |
varchar2 |
Mobile Phone Number | filters on the platform, writable, mobile |
The mobile phone number. | |
n |
varchar2 |
N-Account Text | filters on the platform, writable, n |
N-account text. | |
name |
varchar2 |
Name | filters on the platform, writable, name |
The contact name. | |
phone |
varchar2 |
Phone Number | filters on the platform, writable, phone |
The phone number. | |
planning |
varchar2 |
Planning Text | filters on the platform, writable, planning |
The planning text. | |
reminder |
varchar2 |
Reminder Mail | filters on the platform, writable, reminder |
The reminder email address. | |
selling |
varchar2 |
Selling Hourly Rate | filters on the platform, writable, selling |
The selling hourly rate. | |
street |
varchar2 |
Street Name | filters on the platform, writable, street |
The street name of contact. | |
type_ |
int64 |
Type ID | filters on the platform, writable, type. |
The ID of the contact type. | |
type_ |
varchar2 |
Type Name | filters on the platform, writable, type. |
The internal name of contact type. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The creation date of the object in ATOM/ISO-8601 format | |
updated |
int64 |
Updated by ID | filters on the platform, writable, updated |
The ID of the user. | |
updated |
varchar2 |
Updated by User Name | filters on the platform, writable, updated |
The username of the user. | |
vat |
varchar2 |
VAT Number | filters on the platform, writable, vat |
The value added tax number. | |
wage |
varchar2 |
Wage Component Percentage | filters on the platform, writable, wage |
Wage component percentage. | |
zip |
varchar2 |
ZIP Code | filters on the platform, writable, zip |
The zip-code. |
Sample Queries
--
-- Retrieve list of all Bouw7 companies.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/bouw7-data-model/webhelp/bouw7-connector-contact-contacts.html
--
select *
from Bouw7.Contact.Contacts@bow
limit 100
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: