UploadXMLTopicFragments: Exact Online Update XML Topic Fragments
read only XML
- Catalogue :
ExactOnlineXML - Schéma :
XML - Label: Update XML Topic Fragments
Mettre à jour les fragments de rubrique XML
Permet uniquement de récupérer des données.
Résumé
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
Source de l'API
- Rubrique XML :
UploadXMLTopicFragments
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Nombre estimé de lignes | 500 |
| Taille estimée (octets) | 0 |
Colonnes de table
Les colonnes de la table UploadXMLTopicFragments sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
COUNT_ |
int64 |
#Erreur fatale | Number of uploads with a fatal error. | ||
COUNT_ |
int64 |
#Error | Number of erroneous uploads. | ||
COUNT_ |
int64 |
Erreurs d'accès refusé | Number of no-access erroneous uploads. | ||
COUNT_ |
int64 |
#Success | Number of successful uploads. | ||
COUNT_ |
int64 |
#Warning | Number of uploads with a warning. | ||
DATE_ |
datetime |
Date de fin | Date and time at which the upload ended (UTC). | ||
DATE_ |
datetime |
Date de début | Date and time at which the upload started (UTC). | ||
DIVISION_ |
varchar2 |
Division | Division. | ||
FRAGMENT_ |
int64 |
Numéro du fragment | Number of fragment within transaction. | ||
ORIG_ |
varchar2 |
Groupe de système d'origine | Original system group. | ||
ORIG_ |
varchar2 |
Référence système originale | Original system reference. | ||
PAYLOAD |
varchar2 |
Payload | Payload. | ||
PAYLOAD_ |
int32 |
Longueur de la charge utile | Payload length in characters. | ||
PAYLOAD_ |
int64 |
Nombre de nœuds de charge utile | Payload number of topic nodes. | ||
PAYLOAD_ |
varchar2 |
Échec de la transmission de la charge utile : nouvelle tentative | Payload to retry to load the failed elements.. | ||
RESULT |
varchar2 |
Result | Result. | ||
RESULT_ |
varchar2 |
Erreurs de résultat | Errors and warnings in result. | ||
ROWNUM |
int64 |
Numéro de ligne | Numéro de la ligne dans les résultats, en commençant par 1. | ||
SUCCESSFUL |
char |
Successful | Successful. | ||
TOPIC |
varchar2 |
Topic | Topic. | ||
TRANSACTION_ |
int64 |
ID de transaction | Incrementing ID of the transaction. |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :