ContactsRead: Exact Online Contacts (Read-only)
read only per partition REST
- Catalogo:
ExactOnlineREST - Schema:
CRM - Chiavi primarie:
ID - Label: Contacts (Read-only)
I dati in questa tabella sono partizionati per valore della colonna Division.
È possibile solo recuperare i dati.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/read/crm/Contacts - Metadati:
/api/v1/{division}/read/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 ContactsRead. 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 | filtri sulla piattaforma | ||
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 | First name.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 | Language code. | |
Last |
varchar2 |
Cognome | filters on the platform, writable | Last name.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 | Middle name. | |
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 | filtri sulla piattaforma | ||
Title |
varchar2 |
itgen_eol_titledescription | filtri sulla piattaforma |
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 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: