Grooper Help - Version 25.0
25.0.0023 2,165
  • Overview
  • Help Status

JSON File

Attachment Type Grooper.EDI

Represents a JSON document attachment type for Batch Folders, enabling JSON-specific processing, parsing, and integration in Grooper.

Remarks

The JsonFile class provides support for JavaScript Object Notation (JSON) documents within Batch Folders. It enables Grooper to recognize, cache, and process JSON files as attachments, supporting downstream data extraction, validation, and export workflows.

Overview

  • JsonFile is automatically selected for files with the .json extension or application/json MIME type.

  • Provides efficient JSON document caching for repeated access and parsing.

  • Integrates with Batch Folders to enable document-centric workflows, including classification, extraction, and export.

  • Split: Divides a JSON file into multiple child documents based on a JPath selector.

    • Use the Item Selector property to specify which array or repeating element to split.
    • Example: $.Invoices[*] creates a child document for each invoice.
  • Load Data: Imports data from a JSON file and populates the fields and sections of the associated Data Model.

    • Uses each field or section's Import Source (JPath) to locate values in the JSON.
    • Populates section collections and assigns default values for missing fields.
    • Example: $.Invoice.Number for a field, $.Invoice.LineItems[*] for a repeating section.

Refer to individual command documentation for configuration details and usage examples.

Usage Notes

  • Use JsonFile to enable JSON-aware processing in Grooper, including splitting, extraction, and validation.
  • Combine with Content Type and Data Model configuration to extract structured data from JSON documents.

For more information, see the documentation for Batch Folder, Content Type, and JSON processing in Grooper.

Context Menu Commands

Command Shortcut Description
data_table Load Data Loads data from a JSON file into a Data Model.
arrow_split Split Splits a JSON file.
Notification