<aside>

Description

SimpleT JSON Parser converts JSON strings into key value pairs for use in Salesforce Flows. It supports selective extraction, error handling, and works with API responses, webhook data, and configuration files without requiring custom Apex code.

</aside>

Setup

Use these guides before adding the JSON Parser to your Flows:

• Install SimpleT Managed Packages - How to install a package?
• Authentication and Settings - How to set up your Salesforce org?
• Using SimpleT Flow Actions and Components - How to use SimpleT in Flows?

What this tool does

Primary functions

• JSON parsing – converts JSON strings into key-value pairs.
• Selective extraction – extracts only the JSON fields you need.
• Error handling – handles invalid or malformed JSON safely.

When to use this tool

• API responses – process JSON from HTTP callouts.
• Webhook data – parse incoming webhook payloads.
• Configuration files – read settings from JSON configuration.
• Form submissions – process JSON data from embedded forms.

Understanding JSON and key-value pairs

What is JSON?

JSON (JavaScript Object Notation) is a format for storing and exchanging data. Example:

{
  "name": "John Smith",
  "age": 30,
  "email": "[email protected]",
  "active": true
}

What are key-value pairs?

The parser converts JSON into simple pairs where:

• Key – the field name (for example, "name", "age", "email").
• Value – the field value (for example, "John Smith", "30", "[[email protected]](<mailto:[email protected]>)").

Input parameters explained

Required field

JSON String

• What it is: The JSON text you want to parse.
• Format: A valid JSON string.
• Examples:
  • From API callout: {!apiResponse}.
  • From a record field: {!$Record.JSON_Data__c}.
  • From a variable: {!jsonVariable}.
  • Literal JSON: {"name": "John", "status": "active"}.

Optional field

Keys to Extract

• What it is: A list of specific JSON keys to extract.
• Format: List of text values.
• When to use: When you only need certain fields from a large JSON.
• Examples:
  • Extract all fields: leave this empty.
  • Extract specific fields: ["name", "email", "status"].
  • From a variable: {!keysToExtractList}.

Benefits of selective extraction:

• Faster processing for large payloads.
• Cleaner results focused on what you need.
• Simpler Flow logic.

Understanding the results

Result structure

The parser returns a collection of key-value pairs.

parsedResults[0].invocableWrappers[0].key   = "name"
parsedResults[0].invocableWrappers[0].value = "John Smith"
parsedResults[0].invocableWrappers[1].key   = "age"
parsedResults[0].invocableWrappers[1].value = "30"

Accessing results in Flow

Method 1: Loop through all results

• Element: Loop.
• Collection: {!parsedResults[0].invocableWrappers}.
• Current item: {!currentKeyValue}.

Inside the Loop:

• Key: {!currentKeyValue.key}.
• Value: {!currentKeyValue.value}.

Method 2: Find specific values

• Element: Loop over {!parsedResults[0].invocableWrappers}.
• Current item: {!currentKeyValue}.
• Decision: “Find specific key”.
  • Condition: {!currentKeyValue.key} equals "email".
  • True path: store {!currentKeyValue.value} in emailVariable.

Practical examples

Example 1: Processing an API response

Scenario: Get customer information from an external API.

• Step 1 – HTTP Callout
  • Method: GET.
  • URL: https://api.example.com/customers/123.
  • Store response body in {!apiResponse}.
• Step 2 – Parse JSON response
  • Action: SimpleT Parse JSON into Key-Value Pairs.
  • JSON String: {!apiResponse}.
  • Keys to Extract: ["name", "email", "phone", "status"].
  • Store output in {!parsedCustomer}.
• Step 3 – Extract customer data

Example 2: Processing webhook data

Scenario: Handle order updates from an e-commerce platform.

• Step 1 – Receive webhook
• Step 2 – Parse order data
• Step 3 – Process order information

Example 3: Dynamic form processing

Scenario: Process form submissions with different fields.

• Step 1 – Form submission
• Step 2 – Parse all form fields
• Step 3 – Process fields dynamically