UploadXMLTopics: Exact Online Upload XML Onderwerpen |
Massaal XML-Upload Interfacetabel
Catalogus: ExactOnlineXML
Schema: XML
Alias: xuc
Label: Upload XML Onderwerpen
Documentatie:
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.
Ondersteunde extra where-clause kolommen:
- division
Voorbeeld: Load a sales invoice with lines.
Ophalen: true
Invoegen: true
Bijwerken: false
Verwijderen: false
Filters op API-server: division
View Kolommen
De kolommen van de view UploadXMLTopics worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet tijdens het invoegen steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
DIVISION_CODE |
string |
Divisie |
☑ |
Divisie. |
DRY_RUN |
boolean |
Drooglopen |
☑ |
Whether to skip actual loading of the XML. |
FAIL_ON_ERROR |
boolean |
Faal bij Fouten |
☑ |
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_MAX_SIZE_CHARACTERS |
int32 |
Fragment Maximale Grootte |
☑ |
Maximum fragment size when fragmenting. |
FRAGMENT_MAX_SIZE_ELEMENTS |
int32 |
Fragment Maximum Omvang in Elementen |
☑ |
Maximum fragment size in elements when fragmenting. |
FRAGMENT_PAYLOAD_FLAG |
boolean |
Fragment Nettolading |
☑ |
Whether to fragment the payload when it exceeds the desired maximum size. |
FRAGMENT_POST_LOAD_DELAY_MS |
int32 |
Fragment Post-laden Vertraging (ms) |
☑ |
Delay in milliseconds after a fragment is loaded. |
FRAGMENT_PRE_LOAD_DELAY_MS |
int32 |
Fragment Pre-laden Vertraging (ms) |
☑ |
Delay in milliseconds before a fragment is loaded. |
ORIG_SYSTEM_GROUP |
string |
Oorspronkelijke Systeemgroep |
☐ |
Original system group. |
ORIG_SYSTEM_REFERENCE |
string |
Oorspronkelijk Systeemreferentie |
☐ |
Originele systeemreferentie. |
PAYLOAD |
string |
Nettolading |
☑ |
Payload. |
ROWNUM |
int64 |
Rijnummer |
☑ |
Nummer van de regel binnen de resultaten, te beginnen bij 1. |
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