UploadXMLTopicFragments: Exact Online Update XML Topic Fragments
read only XML
- Catalogus:
ExactOnlineXML - Schema:
XML - Label: Update XML Topic Fragments
XML Onderwerp Fragmenten Bijwerken
Kan alleen gegevens ophalen.
Samenvatting
Individual fragments upload XML topics using the table UploadXMLTopics. After fragmentation to meet Exact Online size limitations, a fragment is uploaded to the XML API of Exact Online. The outcome of each upload is registered as a single row in UploadXMLTopicFragments. Each fragment can contain many objects, such as sales invoices. Each individual object can fail uploading into a selected Exact Online company. The collected errors can be found in the column RESULT_ERRORS. An XML text containing solely the payload to retry failed objects is available in the column PAYLOAD_RETRY_FAILED. This XML text can be copied into a text file and manually uploaded through the Import/Export XML menu option of Exact Online to reconstruct missing data.
Additional where-clause columns supported:
- division
API-bron
- XML-onderwerp:
UploadXMLTopicFragments
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Geschat aantal rijen | 500 |
| Geschatte grootte (bytes) | 0 |
Tabelkolommen
De kolommen van de tabel UploadXMLTopicFragments 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 |
|---|---|---|---|---|---|
COUNT_ |
int64 |
#Fatale Fout | Number of uploads with a fatal error. | ||
COUNT_ |
int64 |
#Error | Number of erroneous uploads. | ||
COUNT_ |
int64 |
Geen-toegang Fouten | Number of no-access erroneous uploads. | ||
COUNT_ |
int64 |
#Success | Number of successful uploads. | ||
COUNT_ |
int64 |
#Warning | Number of uploads with a warning. | ||
DATE_ |
datetime |
Einddatum | Date and time at which the upload ended (UTC). | ||
DATE_ |
datetime |
Startdatum | Date and time at which the upload started (UTC). | ||
DIVISION_ |
varchar2 |
Division | Division. | ||
FRAGMENT_ |
int64 |
Fragmentnummer | Number of fragment within transaction. | ||
ORIG_ |
varchar2 |
Oorspronkelijke Systeemgroep | Original system group. | ||
ORIG_ |
varchar2 |
Oorspronkelijk Systeemreferentie | Original system reference. | ||
PAYLOAD |
varchar2 |
Payload | Payload. | ||
PAYLOAD_ |
int32 |
Lengte Lading | Payload length in characters. | ||
PAYLOAD_ |
int64 |
Lading Aantal Knopen | Payload number of topic nodes. | ||
PAYLOAD_ |
varchar2 |
Payload om opnieuw te proberen mislukt | Payload to retry to load the failed elements.. | ||
RESULT |
varchar2 |
Result | Result. | ||
RESULT_ |
varchar2 |
Resultaatfouten | Errors and warnings in result. | ||
ROWNUM |
int64 |
Rijnummer | Nummer van de regel binnen de resultaten, te beginnen bij 1. | ||
SUCCESSFUL |
char |
Successful | Successful. | ||
TOPIC |
varchar2 |
Topic | Topic. | ||
TRANSACTION_ |
int64 |
Transactie ID | Incrementing ID of the transaction. |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: