ContactsByDomainId: Yuki Contacts by Domain ID
read only XML
- Catalog:
Yuki - Schema:
Contact - Label: Contacts by Domain ID
Can only retrieve data.
API Source
- XML service:
https://api.yukiworks.nl/ws/Contact.asmx - XML topic:
SearchContacts - XML path:
/tns:SearchContactsResult/Contacts/Contact
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 31 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
active |
`` | Both or Active or Inactive | ||
domain |
`` | |||
modified |
`` | |||
search |
`` | All or Name or City or Postcode or Tag or Email or Website or Phone or Code or CoCNumber or VATNumber or BankAccount or ID | ||
search |
`` | |||
sort |
`` | Name or LastName or CreatedAsc or CreatedDesc or ModifiedAsc or ModifiedDesc or HID |
Table Columns
The columns of the table ContactsByDomainId 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 |
|---|---|---|---|---|---|
ADDRESSLINE1 |
varchar2 |
itgen_yuki_addressline1 | / |
||
ADDRESSLINE2 |
varchar2 |
Address Line 2 | / |
||
BACKOFFICESTATUS |
varchar2 |
itgen_yuki_backofficestatus | / |
||
BIC |
varchar2 |
itgen_yuki_bic | / |
||
CITY |
varchar2 |
City | / |
||
COCNUMBER |
varchar2 |
CoC Number | / |
||
CODE |
varchar2 |
Code | / |
||
COUNTRY |
varchar2 |
Country | / |
||
CREATED |
datetime |
itgen_yuki_created | / |
||
DOMAINID |
varchar2 |
Domain ID | |||
DOMAINNAME |
varchar2 |
Domain Name | |||
EMAILHOME |
varchar2 |
itgen_yuki_emailhome | / |
||
EMAILWORK |
varchar2 |
itgen_yuki_emailwork | / |
||
FIRSTNAME |
varchar2 |
itgen_yuki_firstname | / |
||
HID |
int32 |
Human ID | / |
||
IBAN |
varchar2 |
itgen_yuki_iban | / |
||
ID |
guid |
ID | / |
||
INCOMETAXNUMBER |
varchar2 |
itgen_yuki_incometaxnumber | / |
||
ISCUSTOMER |
char |
itgen_yuki_iscustomer | / |
||
ISSUPPLIER |
char |
itgen_yuki_issupplier | / |
||
LASTNAME |
varchar2 |
itgen_yuki_lastname | / |
||
MAILADDRESSLINE1 |
varchar2 |
itgen_yuki_mailaddressline1 | / |
||
MAILADDRESSLINE2 |
varchar2 |
itgen_yuki_mailaddressline2 | / |
||
MAILCITY |
varchar2 |
Mail City | / |
||
MAILPOSTCODE |
varchar2 |
Mail ZIP Code | / |
||
MAINCONTACTPERSON |
varchar2 |
itgen_yuki_maincontactperson | / |
||
MIDDLENAME |
varchar2 |
itgen_yuki_middlename | / |
||
MOBILEHOME |
varchar2 |
itgen_yuki_mobilehome | / |
||
MOBILEWORK |
varchar2 |
itgen_yuki_mobilework | / |
||
MODIFIED |
datetime |
itgen_yuki_modified | / |
||
NAME |
varchar2 |
Name | / |
||
PHONEHOME |
varchar2 |
itgen_yuki_phonehome | / |
||
PHONEWORK |
varchar2 |
itgen_yuki_phonework | / |
||
POSTCODE |
varchar2 |
ZIP Code | / |
||
TAGS |
varchar2 |
Tags | / |
||
TYPE |
varchar2 |
Type | / |
||
VATNUMBER |
varchar2 |
VAT Number | / |
||
WEBSITE |
varchar2 |
itgen_yuki_website | / |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 27.0
Yuki.Contact.ContactsByDomainId: table parameters changes
Table parameters of Yuki.Contact.ContactsByDomainId changes from domainId, searchOption, searchValue, modifiedAfter, active to domainId, searchOption, searchValue, modifiedAfter, active, sortOrder.
domainId, searchOption, searchValue, modifiedAfter, active→domainId, searchOption, searchValue, modifiedAfter, active, sortOrder- importance 3
+ADDRESSLINE1(varchar2)+ADDRESSLINE2(varchar2)+BACKOFFICESTATUS(varchar2)+BIC(varchar2)+CITY(varchar2)+COCNUMBER(varchar2)+CODE(varchar2)+COUNTRY(varchar2)+CREATED(datetime)+EMAILHOME(varchar2)+EMAILWORK(varchar2)+FIRSTNAME(varchar2)+HID(int32)+IBAN(varchar2)
22 more changes
Parameter sortOrder is added to Yuki.Contact.ContactsByDomainId
Optional.
- importance 2
+ID(guid)+INCOMETAXNUMBER(varchar2)+ISCUSTOMER(char)+ISSUPPLIER(char)+LASTNAME(varchar2)+MAILADDRESSLINE1(varchar2)+MAILADDRESSLINE2(varchar2)+MAILCITY(varchar2)+MAILPOSTCODE(varchar2)+MAINCONTACTPERSON(varchar2)+MIDDLENAME(varchar2)+MOBILEHOME(varchar2)+MOBILEWORK(varchar2)+MODIFIED(datetime)+PHONEHOME(varchar2)+PHONEWORK(varchar2)+POSTCODE(varchar2)+TAGS(varchar2)+TYPE(varchar2)+VATNUMBER(varchar2)+WEBSITE(varchar2)