invantive documentation
Invantive Support ForumsLog In / Sign Up

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
domainId ``
modifiedAfter ``
searchOption `` 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
searchValue ``
sortOrder `` 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 /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/AddressLine_1
ADDRESSLINE2 varchar2 Address Line 2 /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/AddressLine_2
BACKOFFICESTATUS varchar2 itgen_yuki_backofficestatus /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/BackofficeStatus
BIC varchar2 itgen_yuki_bic /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/BIC
CITY varchar2 City /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/City
COCNUMBER varchar2 CoC Number /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/CoCNumber
CODE varchar2 Code /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/Code
COUNTRY varchar2 Country /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/Country
CREATED datetime itgen_yuki_created /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/Created
DOMAINID varchar2(36) Domain ID
DOMAINNAME varchar2(240) Domain Name
EMAILHOME varchar2 itgen_yuki_emailhome /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/EMailHome
EMAILWORK varchar2 itgen_yuki_emailwork /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/EMailWork
FIRSTNAME varchar2 itgen_yuki_firstname /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/FirstName
HID int32 Human ID /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/HID
IBAN varchar2 itgen_yuki_iban /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/IBAN
ID guid ID /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/ID
INCOMETAXNUMBER varchar2 itgen_yuki_incometaxnumber /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/IncomeTaxNumber
ISCUSTOMER char itgen_yuki_iscustomer /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/IsCustomer
ISSUPPLIER char itgen_yuki_issupplier /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/IsSupplier
LASTNAME varchar2 itgen_yuki_lastname /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/LastName
MAILADDRESSLINE1 varchar2 itgen_yuki_mailaddressline1 /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/MailAddressLine_1
MAILADDRESSLINE2 varchar2 itgen_yuki_mailaddressline2 /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/MailAddressLine_2
MAILCITY varchar2 Mail City /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/MailCity
MAILPOSTCODE varchar2 Mail ZIP Code /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/MailPostcode
MAINCONTACTPERSON varchar2 itgen_yuki_maincontactperson /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/MainContactPerson
MIDDLENAME varchar2 itgen_yuki_middlename /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/MiddleName
MOBILEHOME varchar2 itgen_yuki_mobilehome /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/MobileHome
MOBILEWORK varchar2 itgen_yuki_mobilework /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/MobileWork
MODIFIED datetime itgen_yuki_modified /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/Modified
NAME varchar2 Name /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/Name
PHONEHOME varchar2 itgen_yuki_phonehome /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/PhoneHome
PHONEWORK varchar2 itgen_yuki_phonework /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/PhoneWork
POSTCODE varchar2 ZIP Code /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/Postcode
TAGS varchar2 Tags /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/Tags
TYPE varchar2 Type /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/Type
VATNUMBER varchar2 VAT Number /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/VATNumber
WEBSITE varchar2 itgen_yuki_website /soap11:Envelope/soap11:Body/tns:SearchContactsResponse/tns:SearchContactsResult/Contacts/Contact/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)

All changes of the driver, 26.0 to 27.0