UploadXMLTopics: Exact Online Upload XML Topics
insert XML
- Catálogo:
ExactOnlineXML - Esquema:
XML - Label: Upload XML Topics
Tabla de la interfaz de carga masiva de XML
Permite recuperar y modificar datos mediante insert.
Resumen
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
Ejemplo
Load a sales invoice with lines.
Fuente de la API
- Tema XML:
UploadXMLTopics
Características de rendimiento
| Characteristic | Value |
|---|---|
| Número estimado de filas | 500 |
| Tamaño estimado (bytes) | 0 |
Columnas de la Tabla
A continuación se muestran las columnas de la tabla UploadXMLTopics. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
DIVISION_ |
varchar2 |
Division | Division. | ||
DRY_ |
char |
Ensayo general | Whether to skip actual loading of the XML. | ||
FAIL_ |
char |
Fallo en caso de error | 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_ |
int32 |
Tamaño máximo del fragmento | Maximum fragment size when fragmenting. | ||
FRAGMENT_ |
int32 |
Tamaño máximo de los fragmentos en Elements | Maximum fragment size in elements when fragmenting. | ||
FRAGMENT_ |
char |
Carga del fragmento | Whether to fragment the payload when it exceeds the desired maximum size. | ||
FRAGMENT_ |
int32 |
Retardo de carga de fragmentos (ms) | Delay in milliseconds after a fragment is loaded. | ||
FRAGMENT_ |
int32 |
Retardo de precarga de fragmentos (ms) | Delay in milliseconds before a fragment is loaded. | ||
ORIG_ |
varchar2 |
Grupo del Sistema Original | Original system group. | ||
ORIG_ |
varchar2 |
Referencia del Sistema Original | Original system reference. | ||
PAYLOAD |
varchar2 |
Payload | Payload. | ||
ROWNUM |
int64 |
Número de la Fila | Número de fila dentro de los resultados, empezando por el 1. | ||
TOPIC |
varchar2 |
Topic | Topic. | ||
TRANSACTION_ |
int64 |
Identificación de la Transacción | Incrementing ID of the transaction. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: