UploadXMLTopicFragments: Exact Online Update XML Topic Fragments
read only XML
- Catálogo:
ExactOnlineXML - Esquema:
XML - Label: Update XML Topic Fragments
Actualizar fragmentos de temas XML
Solo puede recuperar datos.
Resumen
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
Fuente de la API
- Tema XML:
UploadXMLTopicFragments
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 UploadXMLTopicFragments. 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 |
|---|---|---|---|---|---|
COUNT_ |
int64 |
#Error grave | Number of uploads with a fatal error. | ||
COUNT_ |
int64 |
#Error | Number of erroneous uploads. | ||
COUNT_ |
int64 |
Errores de acceso denegado | Number of no-access erroneous uploads. | ||
COUNT_ |
int64 |
#Success | Number of successful uploads. | ||
COUNT_ |
int64 |
#Warning | Number of uploads with a warning. | ||
DATE_ |
datetime |
Fecha de finalización | Date and time at which the upload ended (UTC). | ||
DATE_ |
datetime |
Fecha de inicio | Date and time at which the upload started (UTC). | ||
DIVISION_ |
varchar2 |
Division | Division. | ||
FRAGMENT_ |
int64 |
Número de fragmento | Number of fragment within transaction. | ||
ORIG_ |
varchar2 |
Grupo del Sistema Original | Original system group. | ||
ORIG_ |
varchar2 |
Referencia del Sistema Original | Original system reference. | ||
PAYLOAD |
varchar2 |
Payload | Payload. | ||
PAYLOAD_ |
int32 |
Longitud de la carga | Payload length in characters. | ||
PAYLOAD_ |
int64 |
Número de nodos de carga | Payload number of topic nodes. | ||
PAYLOAD_ |
varchar2 |
La carga no se ha podido volver a enviar | Payload to retry to load the failed elements.. | ||
RESULT |
varchar2 |
Result | Result. | ||
RESULT_ |
varchar2 |
Errores en los resultados | Errors and warnings in result. | ||
ROWNUM |
int64 |
Número de la Fila | Número de fila dentro de los resultados, empezando por el 1. | ||
SUCCESSFUL |
char |
Successful | Successful. | ||
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: