CustomerContactsForCustomerByCustomerCode: Visma.net Financials Customer Contacts by Customer Code
read only REST
- Catalog:
VismaNet - Schema:
Customer - Label: Customer Contacts by Customer Code
Get a range of Contacts of a specific customer
Can only retrieve data.
API Source
- Endpoint:
/v1/customer/{customerCd}/contact - Operation:
get /v1/customer/{customerCd}/contact
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 155 |
| Full scan rows per minute | 29,100 |
| Point query rows per minute | 387 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
active |
`` | |||
business |
`` | |||
customer |
`` | |||
display |
`` | |||
email |
`` | |||
first |
`` | |||
greater |
`` | |||
last |
`` | This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present. Accepted format: * yyyy- * yyyy- * yyyy- * yyyy- * yyyy- Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive. |
||
last |
`` | This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive. | ||
last |
`` |
Table Columns
The columns of the table CustomerContactsForCustomerByCustomerCode 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 |
|---|---|---|---|---|---|
COMPANY_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
active |
char |
Active | filters on the platform, writable, active |
The top part > Active > A check box that indicates (if selected) that the contact is active. | |
address_ |
int32 |
Address ID | filters on the platform, writable, address. |
||
address_ |
varchar2 |
Address Line 1 | filters on the platform, writable, address. |
Address 1 > The first line of the customer's/supplier's/company's/employee's contact address. | |
address_ |
varchar2 |
Address Line 2 | filters on the platform, writable, address. |
Address 2 > The second line of the address. | |
address_ |
varchar2 |
Address Line 3 | filters on the platform, writable, address. |
Address 3 > The third line of the address. | |
address_ |
varchar2 |
City | filters on the platform, writable, address. |
City > The city. | |
address_ |
varchar2 |
itgen_vnet_address_country_errorinfo | filters on the platform, writable, address. |
||
address_ |
varchar2 |
Country ID | filters on the platform, writable, address. |
Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166. | |
address_ |
int64 |
itgen_vnet_address_country_metadata_maxpagesize | filters on the platform, writable, address. |
||
address_ |
int64 |
itgen_vnet_address_country_metadata_totalcount | filters on the platform, writable, address. |
||
address_ |
varchar2 |
Country Name | filters on the platform, writable, address. |
Mandatory field: Country name* > The complete name of the country. | |
address_ |
varchar2 |
County ID | filters on the platform, writable, address. |
Click the magnifier > The identifier | |
address_ |
varchar2 |
County Name | filters on the platform, writable, address. |
Click the magnifier > The displayed name | |
address_ |
varchar2 |
Postal Code | filters on the platform, writable, address. |
Postcode > The postcode. | |
business |
varchar2 |
Business Account | filters on the platform, writable, business |
The top part > Business account > The business account associated with the contact. | |
business |
varchar2 |
itgen_vnet_businessaccounttype | filters on the platform, writable, business |
The top part > Business account > The business account type of the business account associated with the contact. | |
contact |
int32 |
Contact ID | filters on the platform, writable, contact |
The top part > Contact ID > The unique identifier of the contact, which the system generates automatically. | |
contact |
varchar2 |
Contact Method | filters on the platform, writable, contact |
CRM section not available in Visma.net ERP | |
display |
varchar2 |
Display Name | filters on the platform, writable, display |
||
do |
char |
Do Not Call | filters on the platform, writable, do |
CRM section not available in Visma.net ERP | |
do |
char |
Do Not Email | filters on the platform, writable, do |
CRM section not available in Visma.net ERP | |
do |
char |
Do Not Fax | filters on the platform, writable, do |
CRM section not available in Visma.net ERP | |
do |
char |
Do Not Mail | filters on the platform, writable, do |
CRM section not available in Visma.net ERP | |
email |
varchar2 |
filters on the platform, writable, email |
The Details tab > Contact section > Email > The email address of the contact. | ||
error |
varchar2 |
Error Message | filters on the platform, writable, error |
||
fax |
varchar2 |
Fax | filters on the platform, writable, fax |
The Details tab > Contact section > Business fax > The fax number of the contact. | |
first |
varchar2 |
First Name | filters on the platform, writable, first |
The top part > First name > The first name of the contact. | |
last |
datetime |
Last Modified | filters on the platform, writable, last |
Background information: The date and time when the details of the contact were last updated. | |
last |
varchar2 |
Last Name | filters on the platform, writable, last |
Mandatory field: The top part > Last name* > The last name of the contact. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, metadata. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, metadata. |
||
no |
char |
No Marketing | filters on the platform, writable, no |
CRM section not available in Visma.net ERP | |
no |
char |
No Mass Mail | filters on the platform, writable, no |
CRM section not available in Visma.net ERP | |
phone1 |
varchar2 |
Phone 1 | filters on the platform, writable, phone1 |
The Details tab > Contact section > Business 1/Business 2/Business 3/Business assistant 1/Business fax /Home/Home fax/Mobile > The primary phone number of the contact. Select the type from the drop down. | |
phone2 |
varchar2 |
Phone 2 | filters on the platform, writable, phone2 |
The Details tab > Contact section > Business 1/Business 2/Business 3/Business assistant 1/Business fax /Home/Home fax/Mobile > The primary phone number of the contact. Select the type from the drop down. | |
phone3 |
varchar2 |
Phone 3 | filters on the platform, writable, phone3 |
The Details tab > Contact section > Business 1/Business 2/Business 3/Business assistant 1/Business fax /Home/Home fax/Mobile > The primary phone number of the contact. Select the type from the drop down. | |
position |
varchar2 |
Position | filters on the platform, writable, position |
The top part > Job title > The contact’s job title or position. | |
same |
char |
Same as Account | filters on the platform, writable, same |
The Details tab > Same as in account > A check box that indicates (if selected) that the contact's address is the same as the address of the business account. | |
time |
blob |
Timestamp | filters on the platform, writable, time |
Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers) | |
title |
varchar2 |
Title | filters on the platform, writable, title |
The top part > First name > The contact's courtesy title. | |
web |
varchar2 |
Web | filters on the platform, writable, web |
The Details tab > Contact section > Web > The website of the contact, if any. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: