Since version 24.2.240410.0 you are able to save all data of a table as JSON - including all fields.

Here you can find an example how to do so:

Document Definition

1. Create a new document definition and fill following fields:

   1. Description

   2. Usage: Save Table Data

   3. ECM Server Code

   4. ECM Repository/Library Code

   5. Recommended: Document Category

2. Fill the lines with function “Initialize Lines”, either with the notification or the action:

   

   Initialize Lines

3. Fill the tab usage:

   

   Tab Usage

   1. In the field “Last Used Field No.” you can select a field, which is going to be filtered to ascending. The system fields “Modified at” and “Created at” are best suitable by default, so only new and/or changed records will be archived. The last, highest value will be saved in “Last Used Value” and can be editted as well. The filtering in the target record is: “Last Used Field No.” > “Last Used Value”. Is no “Last Used Field No.” specified, all records will be archived on every run.

   2. “Additional Filter”: Specify additional filters if needed.

   3. Time calculation method code: You need to specify a time calculation method code, to define when this document definition is run earliest.

   4. Next run at: Defines when the document definition is startest earlist. This will be updated according to the time calculation method specified.

ECM Job Queue Entries

To save periodically, you need to add and enable the job “Save Table Data” in the “ECM Job Queue Entries”::

Alternatively you can trigger the saving manually with action or by search “ECM Save Table Data”:

How does the JSON file look like:

The file from the example above will contain following data:

Viewing the file with “ECM JSON Viewer”

Open the page “ECM JSON Viewer” with the search and import the JSON file, alternatively you can open the “ECM JSON Viewer” from the “ECM Document Entry” with the file automatically: