PapaJSON Documentation

PapaJSON is a comprehensive suite of JSON tools designed for developers and data analysts. This documentation provides detailed information about all features and functionalities available in PapaJSON.

Quick Start Guide

Get started with PapaJSON in three simple steps:

1. Import your JSON data using any of our import methods
2. Use the validation and formatting tools to clean your data
3. Analyze, query, or export your data as needed

Excel Import

Convert Excel spreadsheets to JSON format with our Excel import feature.

Supported Formats

• .xlsx (Excel 2007+)
• .xls (Excel 97-2003)

JSON Import

Import JSON data directly from files or paste it into the editor.

Features

• Automatic validation on import
• Large file support (up to 100MB)
• UTF-8 encoding support

URL Import

Fetch JSON data directly from URLs.

Configuration Options

{
  "url": "https://api.example.com/data",
  "method": "GET",
  "headers": {
    "Authorization": "Bearer token"
  }
}

API Import

Connect to APIs with advanced configuration options.

Authentication Methods

Google Sheets Import

Import data directly from Google Sheets into JSON format with our seamless integration tool.

Features

• Direct import from public Google Sheets
• Automatic column header detection
• Smart data type conversion
• Support for multiple sheets
• Configuration saving for frequent imports

How to Use

1. Make your Google Sheet public or share with "Anyone with the link"
2. Copy the Google Sheet URL from your browser
3. Paste the URL into the Google Sheets import field
4. Click "Fetch" to import the data

URL Format

https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/edit?usp=sharing

Data Type Conversion

Configuration Management

Save and manage frequently used Google Sheet configurations:

• Save configurations with custom names
• Quick load of saved configurations
• Delete outdated configurations
• Multiple configuration support

Limitations

• Maximum 50,000 rows per sheet recommended
• Sheet must be publicly accessible
• First row must contain column headers
• Complex formatting and formulas are not imported

JSON Validation

Ensure your JSON is valid with our real-time validation tool.

Validation Checks

• Syntax validation
• Structure validation
• Data type checking
• Error location identification

JSON Formatting

The JSON formatter provides a clean, properly indented representation of your JSON data, making it human-readable and easier to understand.

Features

• Proper indentation with configurable spacing
• Syntax highlighting
• Real-time validation while formatting
• Copy formatted JSON to clipboard

Example

{"name":"John","age":30,"address":{"street":"123 Main St","city":"Boston"}}

{
  "name": "John",
  "age": 30,
  "address": {
    "street": "123 Main St",
    "city": "Boston"
  }
}

JSON Minification

The minification tool removes all unnecessary whitespace and formatting to create the smallest possible valid JSON string.

Benefits

• Reduced file size for storage and transmission
• Improved parsing performance
• Optimal for production environments
• Maintains data integrity while reducing size

Size Reduction Example

JSON Interpreter

The JSON Interpreter provides detailed analysis and insights about your JSON data structure.

Analysis Features

• Data type detection and validation
• Structure analysis and visualization
• Property type mapping
• Array content analysis

Data Type Detection

JSON Tree View

The Tree View provides a hierarchical visualization of your JSON structure, making it easy to navigate and understand complex data relationships.

Key Features

• Collapsible/expandable nodes
• Visual hierarchy representation
• Type indicators for each value
• Optimized rendering for large datasets
• Interactive navigation

Performance Optimization

For large JSON structures, the tree view implements several optimizations:

• Lazy loading of nested structures
• Showing only first items of large arrays
• Collapsible sections for better navigation
• Memory-efficient rendering

Visual Indicators

JSON Differ

The JSON Differ tool allows you to compare two JSON structures and identify all differences between them, including added, removed, and modified values.

Key Features

• Side-by-side comparison of two JSON structures
• Color-coded differences for easy identification
• Support for nested object comparison
• Summary of changes with counts
• Format both JSONs for better readability

Difference Types

How to Use

1. Paste your original JSON in the left textarea
2. Paste your new JSON in the right textarea
3. Click "Compare" to see the differences
4. Optionally use "Format Both" to improve readability

Output Format

The comparison results show:

• A summary count of added, removed, and modified items
• Detailed list of all differences with:
• The exact path of each difference
• Original and new values for modified items
• Clear indicators for added and removed items

Example Output

Removed: 1 Added: 2 Modified: 3

- user.name: "John Smith" (Modified in new JSON)
  From: "John Smith"
  To: "John Doe"

- user.age: 25 (Removed in new JSON)

- user.email: "john@example.com" (Added in new JSON)

JSON to XML Conversion

Convert JSON data to XML format with our JSON to XML tool. This feature is useful when you need to transform JSON data into XML for compatibility with systems that require XML input.

How to Use

1. Paste your JSON data into the JSON input area.
2. Click the "Convert" button to transform the JSON into XML.
3. The XML output will appear in the XML output area.
4. You can copy the XML output or clear the input/output areas using the provided buttons.

Example

{
  "name": "PapaJson",
  "version": "1.0.0",
  "features": {
    "parsing": true,
    "validation": true,
    "formatting": true
  }
}

<root>
  <name>PapaJson</name>
  <version>1.0.0</version>
  <features>
    <parsing>true</parsing>
    <validation>true</validation>
    <formatting>true</formatting>
  </features>
</root>

Features

• Supports nested JSON objects and arrays.
• Automatic conversion of JSON data types to XML elements.
• Formatted XML output for readability.
• Copy XML output to clipboard with a single click.
• Clear both input and output areas with the "Clear" button.

Limitations

• Complex JSON structures with deeply nested objects may result in verbose XML output.
• XML does not support all JSON data types natively (e.g., JSON arrays are converted to repeated XML elements).
• Large JSON files may take longer to convert and result in large XML files.

Query Builder

Build complex queries to filter and analyze your JSON data.

Filter Components

• Filter Groups (AND/OR logic between groups)
• Filter Lines (AND/OR logic within group)
• Field Selection (supports nested properties)
• Operators (based on data type)
• Value Input with Smart Helpers

Operator Types

Value Helpers

The Value Helper system provides smart assistance when entering filter values:

• Auto-Detection: Automatically detects field type and shows relevant operators
• Suggestions: Shows unique values from the dataset for quick selection
• Dynamic Updates: Updates suggestions based on current dataset
• Type Validation: Ensures entered values match the field type

Query Types

• AND/OR conditions
• Multiple filter groups
• Nested property queries
• Array filtering

Filter Groups

Create complex queries using multiple filter groups:

• Main AND: All conditions within the group must match
• Main OR: Any condition within the group can match
• Nested Groups: Combine multiple groups for complex logic
• Group Management: Add, delete, or modify groups dynamically

Example Query

{
  "group": "AND",
  "rules": [
    {
      "field": "age",
      "operator": ">",
      "value": 18
    },
    {
      "field": "status",
      "operator": "equals",
      "value": "active"
    }
  ]
}

Query Results

After executing a query, you can:

• View filtered results in table format
• Sort results by clicking column headers
• Copy filtered JSON to clipboard
• Download results as JSON or Excel
• See the count of matching records
• View active filters in breadcrumb format

Data Export

Export your filtered or transformed JSON data in various formats.

Export Options