UploadXMLTopicFragments: Exact Online Update XML Topic Fragments
read only XML
- Katalog:
ExactOnlineXML - Schema:
XML - Label: Update XML Topic Fragments
XML-Themenfragmente aktualisieren
Es können nur Daten abgerufen werden.
Zusammenfassung
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-Quelle
- XML-Thema:
UploadXMLTopicFragments
Leistungsmerkmale
| Characteristic | Value |
|---|---|
| Geschätzte Zeilenanzahl | 500 |
| Geschätzte Größe (Bytes) | 0 |
Tabellenspalten
Die Spalten der Tabelle UploadXMLTopicFragments sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
COUNT_ |
int64 |
#Fataler Fehler | Number of uploads with a fatal error. | ||
COUNT_ |
int64 |
#Error | Number of erroneous uploads. | ||
COUNT_ |
int64 |
Zugriffsfehler | Number of no-access erroneous uploads. | ||
COUNT_ |
int64 |
#Success | Number of successful uploads. | ||
COUNT_ |
int64 |
#Warning | Number of uploads with a warning. | ||
DATE_ |
datetime |
Enddatum | 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 |
Original System Gruppe | Original system group. | ||
ORIG_ |
varchar2 |
Ursprünglicher Systembezug | Original system reference. | ||
PAYLOAD |
varchar2 |
Payload | Payload. | ||
PAYLOAD_ |
int32 |
Ladungslänge | Payload length in characters. | ||
PAYLOAD_ |
int64 |
Anzahl der Knoten der Ladung | Payload number of topic nodes. | ||
PAYLOAD_ |
varchar2 |
Ladung für Wiederholungsversuch fehlgeschlagen | Payload to retry to load the failed elements.. | ||
RESULT |
varchar2 |
Result | Result. | ||
RESULT_ |
varchar2 |
Ergebnisfehler | Errors and warnings in result. | ||
ROWNUM |
int64 |
Zeilennummer | Nummer der Reihe innerhalb der Ergebnisse, startend bei 1. | ||
SUCCESSFUL |
char |
Successful | Successful. | ||
TOPIC |
varchar2 |
Topic | Topic. | ||
TRANSACTION_ |
int64 |
Transaktions-ID | Incrementing ID of the transaction. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: