Skip to main content
Version: 1

Convert to JSON Collection

  • Category​

    • JSON

    • Array

    • List

    • Loop

  • Flow Icon​

Overview​

The Convert to JSON Collection component in Plinqx is adept at parsing a JSON string that represents an array or list, and converting it into a collection of individual JSON string objects. This functionality is particularly useful in scenarios where you need to process multiple items from a JSON array within your flows, making it an essential tool for data handling and transformation in integration processes.

Inputs​

  1. JSON String to Convert01-05:

    Up to five input parameters are available for converting multiple JSON strings. Each parameter accepts a JSON string representing an array or list of objects. You can use just one or multiple parameters based on your specific requirement.

Outputs​

  1. JSON Collection01-05:

    Each output parameter corresponds to an input and provides a collection of JSON object strings. These collections are particularly useful for processing within loop functions in flows.

Example Scenario - Processing Bulk Order Updates​

Scenario Overview:

A Salesforce org receives bulk order updates from an external e-commerce platform in the form of a single JSON string. Each order update within the string needs to be individually processed and updated in Salesforce.

Implementation with Convert to JSON Collection Component:

  1. Flow Setup for Handling Order Updates:

    • Create a Salesforce flow triggered by the receipt of the JSON string from the e-commerce platform.

  2. Adding Convert to JSON Collection Component:

    • Incorporate the Convert to JSON Collection component at the beginning of the flow to handle the JSON string.

  3. Configuring Inputs:

    • Use 'JSON String to Convert01' to input the JSON string containing the bulk order updates.

  4. Converting JSON String to Collection:

    • The flow processes the JSON string, and the component converts it into a collection of individual JSON objects, each representing a single order update.

  5. Looping Through Orders:

    • Implement a loop function within the flow to iterate through the 'JSON Collection01', processing each order update separately.

    • For each order in the collection, parse the JSON object, extract order details, and perform necessary updates in Salesforce.

Results:

The implementation of the Convert to JSON Collection component enables efficient handling of bulk data from the e-commerce platform. By converting the JSON array into individual objects and processing each one in a loop, the Salesforce org ensures that all order updates are accurately reflected, enhancing data integrity and operational efficiency.