LOADXMLJSONOBJECT cron task

To import data in XML and JSON formats from Simple Storage Service (S3) cloud object storage, add a cron task instance to the LOADXMLJSONOBJECT cron task and specify the appropriate parameters for importing the files.

Table 1. LOADXMLJSONOBJECT cron task parameters
Parameter Description
FILETYPE Parameter that specifies whether the files to process are in XML or JSON format.
ENDPOINTNAME Parameter that specifies the name of the endpoint to use for loading files. The endpoint name must be in upper case.
ENTERPRISESERVICE A required parameter value that identifies the enterprise service name that the cron task uses to process all files that are located in the source bucket.
ISFILEEXTRACT When set to 1 (true), this parameter indicates that file-based error management is used for inbound message processing.
USEREXITCLASS An optional custom processing class value that defines additional cron task capability (for example, file load order).
EXTERNALSYSTEM A required parameter value that identifies the external system value that the cron task data load process uses.
BATCHSIZE The parameter determines the writing frequency of records that are processed in the recovery file. The default value is 1, which indicates that the count is updated in the recovery file after processing each record from the load file object. While this provides the best resilience, it is often not optimal for performance, specifically with large files. Consider setting a batch size like 100. This results in the update process happening for every 100 records, resulting in less network traffic and improved performance.