---
title: "UploadXMLTopics (Exact Online)"
description: "Upload XML Topics"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/exactonline/ExactOnlineXML.XML.UploadXMLTopics
original: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineXML.XML.UploadXMLTopics
updated: 2026-11-16T20:59:44Z
license: https://documentation.invantive.eu/de/
---

# UploadXMLTopics: Exact Online Upload XML Topics

`insert` `XML`

- Katalog: `ExactOnlineXML`
- Schema: `XML`
- Label: Upload XML Topics

Massen-XML-Upload-Schnittstellentabelle

Mit `insert` können Daten abgerufen und geändert werden.

## Zusammenfassung

The table UploadXMLTopics provides a bulk loader for business data into one or many Exact Online companies. All topics provided by the Exact Online Import/Export XML feature are supported. The Exaxct Online documentation provides ample samples how to structure such a XML payload, and the easiest way is to export an object using the Export/Import XML user interface feature. Provided with an arbitrary large XML payload in the column PAYLOAD, individual fragments are created meeting the size specifications of the Exact Online XML Upload API. The size of fragments can be varied using FRAGMENT_MAX_SIZE_CHARACTERS and FRAGMENT_MAX_SIZE_ELEMENTS. The data is loaded at maximum Exact Online XML speed of 1 API call per second; the speed can be varied using FRAGMENT_POST_LOAD_DELAY_MS and FRAGEMENT_PRE_LOAD_DELAY_MS to meet advanced load balancing scenarios across hundreds of Exact Online companies. Once processed, the fragments and their load results are registered in UploadXMLTopicFragments.

Additional where-clause columns supported:
- division

## Beispiel

Load a sales invoice with lines.

## API-Quelle

- XML-Thema: `UploadXMLTopics`

## Leistungsmerkmale

| Characteristic | Value |
|---|---:|
| Geschätzte Zeilenanzahl | 500 |
| Geschätzte Größe (Bytes) | 0 |

## Tabellenspalten

Die Spalten der Tabelle `UploadXMLTopics` 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 |
|---|---|---|:---:|---|---|
| `DIVISION_CODE` | `varchar2` | Division | [x] |  | Division. |
| `DRY_RUN` | `char` | Probelauf | [x] |  | Whether to skip actual loading of the XML. |
| `FAIL_ON_ERROR` | `char` | Bei Fehler scheitern | [x] |  | Whether to raise an exception at the end of loading all fragments of a XML message when an error occurs during loading any fragment in that XML message. |
| `FRAGMENT_MAX_SIZE_CHARACTERS` | `int32` | Maximale Fragmentgröße | [x] |  | Maximum fragment size when fragmenting. |
| `FRAGMENT_MAX_SIZE_ELEMENTS` | `int32` | Maximale Fragmentgröße in Elements | [x] |  | Maximum fragment size in elements when fragmenting. |
| `FRAGMENT_PAYLOAD_FLAG` | `char` | Fragment-Ladung | [x] |  | Whether to fragment the payload when it exceeds the desired maximum size. |
| `FRAGMENT_POST_LOAD_DELAY_MS` | `int32` | Verzögerung nach dem Laden eines Fragments (ms) | [x] |  | Delay in milliseconds after a fragment is loaded. |
| `FRAGMENT_PRE_LOAD_DELAY_MS` | `int32` | Verzögerung beim Vorladen von Fragmenten (ms) | [x] |  | Delay in milliseconds before a fragment is loaded. |
| `ORIG_SYSTEM_GROUP` | `varchar2` | Original System Gruppe | [ ] |  | Original system group. |
| `ORIG_SYSTEM_REFERENCE` | `varchar2` | Ursprünglicher Systembezug | [ ] |  | Original system reference. |
| `PAYLOAD` | `varchar2` | Payload | [x] |  | Payload. |
| `ROWNUM` | `int64` | Zeilennummer | [x] |  | Nummer der Reihe innerhalb der Ergebnisse, startend bei 1. |
| `TOPIC` | `varchar2` | Topic | [x] |  | Topic. |
| `TRANSACTION_ID` | `int64` | Transaktions-ID | [x] |  | 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:

- [Exact Online](/de/release-notes/drivers?driver=exact-online)
