MailMessageAttachmentsRead: Exact Online Mail Message Attachments (Read-only)
read only per partition REST
- Catalogus:
ExactOnlineREST - Schema:
Mailbox - Primaire sleutels:
ID - Label: Mail Message Attachments (Read-only)
Mail message attachments, partitioned per Exact Online subscription.
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Kan alleen gegevens ophalen.
Samenvatting
Each Exact Online subscription can have a number of mailboxes. When you query any division, you will retrieve all mail message attachments in the mailboxes on that subscription. A list of duplicate mail message attachments will be retrieved when you query multiple divisions within the same Exact Online subscription.
API-bron
- Eindpunt:
/api/v1/{division}/read/mailbox/MailMessageAttachments - Metagegevens:
/api/v1/{division}/read/mailbox/$metadata
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 5 |
| Aantal rijen per minuut bij volledige scan | 7,200 |
| Aantal rijen per minuut in een Query | 300 |
| Aantal rijen per minuut schrijven | 300 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Tabelkolommen
De kolommen van de tabel MailMessageAttachmentsRead worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Attachment |
blob |
Attachment | filters on the platform, writable | For performance reasons Attachment is Write-Only.The blob can be downloaded using the supplied Url. | |
Attachment |
varchar2 |
Bijlage Bestandsextensie | filters on the platform, writable | File extension of attachment. | |
Attachment |
varchar2 |
Bijlage Bestandsnaam | filters on the platform, writable | File name of attachment. | |
Attachment |
varchar2 |
Bijlage URL | filters on the platform, writable | ||
Can |
char |
itgen_eol_canshowinwebview | filters on the platform, writable | ||
Division |
int32 |
Divisie ID | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Divisie Kamer van Koophandel Nummer | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Divisie IBAN Nummer | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisie Bedrijfsnaam | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Divisie RSIN Nummer | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Divisie BTW Nummer | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Divisie Loonbelastingnummer | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Divisie Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administratie Naam | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Naam Abonnementhouder | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Abonnementhoudernummer | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Divisie Korte Naam | writable | Short name of the Exact Online division. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Mail |
guid |
Mailbericht ID | filters on the platform, writable | Reference to Mail message. | |
Type |
int32 |
Type | filters on the platform, writable | Type of mail message attachment. |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: