invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

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_FATAL_ERROR int64 #Error grave Number of uploads with a fatal error.
COUNT_NORMAL_ERROR int64 #Error Number of erroneous uploads.
COUNT_NO_ACCESS_ERROR int64 Errores de acceso denegado 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 Fecha de finalización Date and time at which the upload ended (UTC).
DATE_STARTED_UTC datetime Fecha de inicio Date and time at which the upload started (UTC).
DIVISION_CODE varchar2 Division Division.
FRAGMENT_NUMBER int64 Número de fragmento Number of fragment within transaction.
ORIG_SYSTEM_GROUP varchar2 Grupo del Sistema Original Original system group.
ORIG_SYSTEM_REFERENCE varchar2 Referencia del Sistema Original Original system reference.
PAYLOAD varchar2 Payload Payload.
PAYLOAD_LENGTH int32 Longitud de la carga Payload length in characters.
PAYLOAD_NODE_COUNT int64 Número de nodos de carga Payload number of topic nodes.
PAYLOAD_RETRY_FAILED varchar2 La carga no se ha podido volver a enviar Payload to retry to load the failed elements..
RESULT varchar2 Result Result.
RESULT_ERRORS 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_ID 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: