Contacts: Exact Online Contacts
insert update delete per partition webhook REST
- Catalogo:
ExactOnlineREST - Schema:
CRM - Chiavi primarie:
ID - Etichetta: Contatti
I dati in questa tabella sono partizionati per valore della colonna Division.
È possibile recuperare e modificare i dati utilizzando insert, update e delete.
Le modifiche vengono inviate tramite il topic del webhook Contacts.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/crm/Contacts - Metadati:
/api/v1/{division}/crm/$metadata
Caratteristiche prestazionali
| Characteristic | Value |
|---|---|
| Latenza media di accesso (ms) | 5 |
| Righe di scansione completa al minuto | 7,200 |
| Numero di righe di Query al minuto | 300 |
| Scrittura di righe al minuto | 300 |
Il risultato può essere memorizzato nella memoria cache sul client.
Colonne della tabella
Di seguito sono riportate le colonne della tabella Contacts. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Account |
guid |
Account | filters on the platform, writable | The account to which the contact belongs. | |
Account |
char |
L'account è quello del cliente | filters on the platform, writable | Indicates if account is a customer. | |
Account |
char |
L'account è un fornitore | filters on the platform, writable | Indicates if account is a supplier. | |
Account |
guid |
Account - Contatto principale | filters on the platform, writable | Reference to the main contact of the account. | |
Account |
varchar2 |
Nome dell'account | filters on the platform, writable | Name of account. | |
Address |
varchar2 |
Indirizzo 2 | filters on the platform, writable | Second address line. | |
Address |
varchar2 |
Indirizzo: Via | filters on the platform, writable | Street name of the address. | |
Address |
varchar2 |
Indirizzo numero civico | filters on the platform, writable | Street number of the address. | |
Address |
varchar2 |
Suffisso del numero civico dell'indirizzo | filters on the platform, writable | Street number suffix of the address. | |
Allow |
int32 |
Consenti l'invio di posta | writable | Obsolete. | |
Birth |
datetime |
Data di nascita | filters on the platform, writable | Birth date. | |
Birth |
varchar2 |
Nome di nascita | filters on the platform, writable | Obsolete.Please don't use this field anymore as it may overwrite LastName. | |
Birth |
varchar2 |
Prefisso del nome di nascita | filters on the platform, writable | Obsolete.Please don't use this field anymore as it may overwrite MiddleName. | |
Birth |
varchar2 |
Luogo di nascita | filters on the platform, writable | Birth place. | |
Business |
varchar2 |
Indirizzo e-mail | filters on the platform, writable | Email address of the contact. | |
Business |
varchar2 |
Fax aziendale | filters on the platform, writable | Fax of the contact. | |
Business |
varchar2 |
Mobile aziendale | filters on the platform, writable | Mobile of the contact. | |
Business |
varchar2 |
Telefono aziendale | filters on the platform, writable | Phone of the contact. | |
Business |
varchar2 |
Interno telefonico aziendale | filters on the platform, writable | Phone extension of the contact. | |
City |
varchar2 |
City | filters on the platform, writable | City. | |
Code |
varchar2 |
Code | filters on the platform, writable | Code of the account. | |
Country |
varchar2 |
Country | filters on the platform, writable | Country code. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Creato | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nome completo del creatore | filters on the platform, writable | Name of creator. | |
Custom |
varchar2 |
Campo personalizzato | filters on the platform, writable | ||
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Numero di iscrizione alla Camera di Commercio della Divisione | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Codice IBAN della divisione | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisione - Nome dell'azienda | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Numero di divisione RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Partita IVA della divisione | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Codice fiscale salariale della divisione | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Etichetta della divisione | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nome dell'amministrazione | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nome del titolare dell'abbonamento | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Numero di abbonato | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nome abbreviato della divisione | writable | Short name of the Exact Online division. | |
Email |
varchar2 |
filters on the platform, writable | Email address of the contact. | ||
End |
datetime |
Data di fine | filters on the platform, writable | End date. | |
First |
varchar2 |
Nome | filters on the platform, writable | Nome.Provide at least first name or last name to create a new contact. | |
Full |
varchar2 |
Nome completo per l'uso nelle liste | filters on the platform, writable | Full name (First name Middle name Last name). | |
Gender |
varchar2 |
Gender | filters on the platform, writable | Gender. | |
HID |
int32 |
HID | filters on the platform, writable | Contact ID. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Identification |
datetime |
Data di identificazione | filters on the platform, writable | Identification date. | |
Identification |
guid |
Documento di identificazione | filters on the platform, writable | Reference to the identification document of the contact. | |
Identification |
guid |
Identificazione utente | filters on the platform, writable | Reference to the user responsible for identification. | |
Initials |
varchar2 |
Initials | filters on the platform, writable | Initials. | |
Is |
int16 |
È anonimizzato | filters on the platform, writable | Indicates whether the contact is anonymised. | |
Is |
char |
La spedizione postale è esclusa? | filters on the platform, writable | Indicates whether contacts are excluded from the marketing list. | |
Is |
char |
È il referente principale | filters on the platform, writable | Indicates if this is the main contact of the linked account. | |
Job |
varchar2 |
Descrizione della posizione lavorativa | filters on the platform, writable | Jobtitle of the contact. | |
Language |
varchar2 |
Language | filters on the platform, writable | Codice lingua. | |
Last |
varchar2 |
Cognome | filters on the platform, writable | Cognome.Provide at least first name or last name to create a new contact. | |
Lead |
guid |
Obiettivo principale | filters on the platform, writable | Reference to Lead Purpose. | |
Lead |
guid |
Database di origine del cliente potenziale | filters on the platform, writable | Reference to Lead Source. | |
Marketing |
varchar2 |
Note di marketing | filters on the platform, writable | The user should be able to do a full text search on these notes to gather contacts for a marketing campaign. | |
Middle |
varchar2 |
Secondo nome | filters on the platform, writable | Secondo nome. | |
Mobile |
varchar2 |
Mobile | filters on the platform, writable | Business phone of the contact. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modificato (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nome completo modificato | filters on the platform, writable | Name of modifier. | |
Nationality |
varchar2 |
Nationality | filters on the platform, writable | Nationality. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Extra remarks. | |
Partner |
varchar2 |
Nome partner | filters on the platform, writable | Last name of partner. | |
Partner |
varchar2 |
Prefisso del nome del partner | filters on the platform, writable | Middlename of partner. | |
Person |
guid |
Person | filters on the platform, writable | Reference to the personal information of this contact such as name, gender, address etc. | |
Phone |
varchar2 |
Phone | filters on the platform, writable | Phone of the contact. | |
Phone |
varchar2 |
Estensione del telefono | filters on the platform, writable | Phone extension of the contact. | |
Picture |
blob |
Picture | writable | This field is write-only.The picture can be downloaded through PictureUrl and PictureThumbnailUrl. | |
Picture |
varchar2 |
Nome immagine | filters on the platform, writable | Filename of the picture. | |
Picture |
varchar2 |
Miniatura dell'immagine (URL) | writable | Url to retrieve the picture thumbnail. | |
Picture |
varchar2 |
Immagine (URL) | writable | Url to retrieve the picture. | |
Postcode |
varchar2 |
Codice postale | filters on the platform, writable | Postcode. | |
Social |
varchar2 |
Numero della sicurezza sociale | filters on the platform, writable | Social security number. | |
Start |
datetime |
Data di inizio | filters on the platform, writable | Start date. | |
State |
varchar2 |
State | filters on the platform, writable | State/Province code. | |
Title |
varchar2 |
Title | filters on the platform, writable | Title. | |
Title |
varchar2 |
itgen_eol_titleabbreviation | filters on the platform, writable | ||
Title |
varchar2 |
itgen_eol_titledescription | filters on the platform, writable |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
Contacts_ |
Account |
Contacts.ID |
Key | |
Contacts_ |
Account |
Accounts.ID |
Key | |
Contacts_ |
Creator |
Users. |
Key | |
Contacts_ |
Identification |
Documents.ID |
Key | |
Contacts_ |
Identification |
Users. |
Key | |
Contacts_ |
Lead |
LeadPurposes.ID |
Key | |
Contacts_ |
Lead |
LeadSources.ID |
Key | |
Contacts_ |
Modifier |
Users. |
Key |
Riferito da
- CommunicationNotes
Contact(Key) - Complaints
Contact(Key) - Events
Contact(Key) - ServiceRequests
Contact(Key) - Tasks
Contact(Key) - Accounts
MainContact(Key) - AccountsBulk
MainContact(Key) - Addresses
Contact(Key) - AddressesBulk
Contact(Key) - AddressesRead
Contact(Key) - Contacts
AccountMainContact(Key) - ContactsBulk
AccountMainContact(Key) - ContactsRead
AccountMainContact(Key) - CrmDocuments
Contact(Key) - OpportunityContactsRead
AccountMainContact(Key) - OpportunityContactsRead
Contact(Key) - Quotations
DeliveryAccountContact(Key) - Quotations
InvoiceAccountContact(Key) - Quotations
OrderAccountContact(Key) - QuotationsBulk
DeliveryAccountContact(Key) - QuotationsBulk
InvoiceAccountContact(Key) - QuotationsBulk
OrderAccountContact(Key) - Payments
AccountContact(Key) - PaymentsBulk
AccountContact(Key) - Receivables
AccountContact(Key) - ReceivablesBulk
AccountContact(Key) - Documents
Contact(Key) - DocumentsBulk
Contact(Key) - Projects
AccountContact(Key) - PurchaseInvoices
ContactPerson(Key) - GoodsReceipts
SupplierContact(Key) - PurchaseOrders
DeliveryContact(Key) - PurchaseOrders
SupplierContact(Key) - SalesInvoices
DeliverToContactPerson(Key) - SalesInvoices
InvoiceToContactPerson(Key) - SalesInvoices
OrderedByContactPerson(Key) - SalesInvoicesBulk
DeliverToContactPerson(Key) - SalesInvoicesBulk
InvoiceToContactPerson(Key) - SalesInvoicesBulk
OrderedByContactPerson(Key) - GoodsDeliveries
DeliveryContact(Key) - GoodsDeliveriesBulk
DeliveryContact(Key) - PlannedSalesReturns
DeliveredToContactPerson(Key) - SalesOrders
DeliverToContactPerson(Key) - SalesOrders
InvoiceToContactPerson(Key) - SalesOrders
OrderedByContactPerson(Key) - SalesOrdersBulk
DeliverToContactPerson(Key) - SalesOrdersBulk
InvoiceToContactPerson(Key) - SalesOrdersBulk
OrderedByContactPerson(Key) - Subscriptions
InvoiceToContactPerson(Key) - Subscriptions
OrderedByContactPerson(Key)
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: