invantive documentation
Invantive SupportforenAnmelden / Eintragen

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_FATAL_ERROR int64 #Fataler Fehler Number of uploads with a fatal error.
COUNT_NORMAL_ERROR int64 #Error Number of erroneous uploads.
COUNT_NO_ACCESS_ERROR int64 Zugriffsfehler Number of no-access erroneous uploads.
COUNT_SUCCESS int64 #Success Number of successful uploads.
COUNT_WARNING int64 #Warning Number of uploads with a warning.
DATE_ENDED_UTC datetime Enddatum Date and time at which the upload ended (UTC).
DATE_STARTED_UTC datetime Startdatum Date and time at which the upload started (UTC).
DIVISION_CODE varchar2 Division Division.
FRAGMENT_NUMBER int64 Fragmentnummer Number of fragment within transaction.
ORIG_SYSTEM_GROUP varchar2 Original System Gruppe Original system group.
ORIG_SYSTEM_REFERENCE varchar2 Ursprünglicher Systembezug Original system reference.
PAYLOAD varchar2 Payload Payload.
PAYLOAD_LENGTH int32 Ladungslänge Payload length in characters.
PAYLOAD_NODE_COUNT int64 Anzahl der Knoten der Ladung Payload number of topic nodes.
PAYLOAD_RETRY_FAILED varchar2 Ladung für Wiederholungsversuch fehlgeschlagen Payload to retry to load the failed elements..
RESULT varchar2 Result Result.
RESULT_ERRORS 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_ID 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: