Please enable JavaScript to view this site.

Navigation: Catalog: ExactOnlineXML > Schemas > Schema: XML > Tables

UploadXMLTopics: Exact Online Upload XML Topics

Mass XML Upload Interface Table

Catalog: ExactOnlineXML

Schema: XML

Alias: xuc

Label: Upload XML Topics

Documentation:

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.

 

Additional where-clause columns supported:

- division

Example: Load a sales invoice with lines.

Retrieve: true

Insert: true

Update: false

Delete: false

Topic: UploadXMLTopics

Filters on API Server: division

View Columns

The columns of the view UploadXMLTopics are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert.

Name

Data Type

Label

Required

Documentation

DIVISION_CODE

string

Division

Division.

DRY_RUN

boolean

Dry Run

Whether to skip actual loading of the XML.

FAIL_ON_ERROR

boolean

Fail on Error

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 Maximum Size

Maximum fragment size when fragmenting.

FRAGMENT_MAX_SIZE_ELEMENTS

int32

Fragment Maximum Size in Elements

Maximum fragment size in elements when fragmenting.

FRAGMENT_PAYLOAD_FLAG

boolean

Fragment Payload

Whether to fragment the payload when it exceeds the desired maximum size.

FRAGMENT_POST_LOAD_DELAY_MS

int32

Fragment Post Load Delay (ms)

Delay in milliseconds after a fragment is loaded.

FRAGMENT_PRE_LOAD_DELAY_MS

int32

Fragment Pre Load Delay (ms)

Delay in milliseconds before a fragment is loaded.

ORIG_SYSTEM_GROUP

string

Original System Group

Original system group.

ORIG_SYSTEM_REFERENCE

string

Original System Reference

Original system reference.

PAYLOAD

string

Payload

Payload.

ROWNUM

int32

Row Number

Number of the row within the results, starting at 1.

TOPIC

string

Topic

Topic.

TRANSACTION_ID

int32

Transaction ID

Incrementing ID of the transaction.

 

15-06-2022 19:32 Version 22.0.232-PROD+3445