UploadXMLTopicFragments: Exact Online XML Onderwerp Fragmenten Bijwerken |
XML Onderwerp Fragmenten Bijwerken
Catalogus: ExactOnlineXML
Schema: XML
Alias: xuf
Label: XML Onderwerp Fragmenten Bijwerken
Documentatie:
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.
Ondersteunde extra where-clause kolommen:
- division
Dit is een alleen-lezen view. De Exact Online API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive UniversalSQL-stuurprogramma voor Exact Online ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Exact Online-API.
Filters op API-server: division
View Kolommen
De kolommen van de view UploadXMLTopicFragments worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
COUNT_FATAL_ERROR |
int64 |
#Fatale Fout |
☑ |
Number of uploads with a fatal error. |
COUNT_NO_ACCESS_ERROR |
int64 |
Geen-toegang Fouten |
☑ |
Number of no-access erroneous uploads. |
COUNT_NORMAL_ERROR |
int64 |
#Fout |
☑ |
Number of erroneous uploads. |
COUNT_SUCCESS |
int64 |
#Succesvol |
☑ |
Number of successful uploads. |
COUNT_WARNING |
int64 |
#Waarschuwing |
☑ |
Number of uploads with a warning. |
DATE_ENDED_UTC |
datetime |
Einddatum |
☐ |
Date and time at which the upload ended (UTC). |
DATE_STARTED_UTC |
datetime |
Startdatum |
☐ |
Date and time at which the upload started (UTC). |
DIVISION_CODE |
string |
Divisie |
☑ |
Divisie. |
FRAGMENT_NUMBER |
int64 |
Fragmentnummer |
☑ |
Number of fragment within transaction. |
ORIG_SYSTEM_GROUP |
string |
Oorspronkelijke Systeemgroep |
☐ |
Original system group. |
ORIG_SYSTEM_REFERENCE |
string |
Oorspronkelijk Systeemreferentie |
☐ |
Originele systeemreferentie. |
PAYLOAD_LENGTH |
int32 |
Lengte Lading |
☐ |
Payload length in characters. |
PAYLOAD_NODE_COUNT |
int64 |
Lading Aantal Knopen |
☐ |
Payload number of topic nodes. |
PAYLOAD_RETRY_FAILED |
string |
Payload om opnieuw te proberen mislukt |
☐ |
Payload to retry to load the failed elements.. |
PAYLOAD |
string |
Nettolading |
☐ |
Payload. |
RESULT_ERRORS |
string |
Resultaatfouten |
☐ |
Errors and warnings in result. |
RESULT |
string |
Resultaat |
☐ |
Result. |
ROWNUM |
int64 |
Rijnummer |
☑ |
Nummer van de regel binnen de resultaten, te beginnen bij 1. |
SUCCESSFUL |
boolean |
Geslaagd |
☑ |
Successful. |
TOPIC |
string |
Onderwerp |
☐ |
Topic. |
TRANSACTION_ID |
int64 |
Transactie ID |
☑ |
Toenemende ID van de transactie. |
30-05-2024 10:44 Versie 24.1.3-BETA+4689