JSON
JSON is an open standard file format and data interchange format that uses human-readable text to store and transmit data objects.
The JSON File Reader allows reading a JSON file as Context in a given Data Stream.
The JSON Serializer allows you to convert the state of an object, that is, the values of its properties, into a form that can be stored or transmitted as JSON.
The JSON Deserializer allows you to convert a column that is serialized as JSON to valid data for manipulation within a data stream
Pre-requisites
The JSON files used in the File Reader and Serializer Agents must be accessible to the Stream Host via the File System.
Current Version
Download the JSON File Reader Context Provider v1.22 (Last Update: 22 Jan 2025)
Download the JSON Serializer Transformation v1.12 (Last Update: 22 Jan 2025)
Download the JSON Deserializer Transformation v1.32 (Last Update: 22 Jan 2025)
Please contact XMPro if you're looking for an older version of this Agent.
JSON File Reader Release Notes
1.22
22 Jan 2025
Repackaged to translate the Agent's properties.
1.21
06 Sep 2022
Repackaged to include the Agents Category.
1.20
03 Mar 2022
Remove redundant double quotes around the values.
1.10
23 Mar 2020
The ability to specify Data Type for output columns is added.
1.00
27 Sep 2018
Initial Release.
JSON Serializer Release Notes
1.12
22 Jan 2025
Repackaged to translate the Agent's properties.
1.11
07 Jun 2023
Renamed Results Returned As option ExistingAndNew to Append to Existing.
Renamed Output as JAarry? to Output as JArray?.
1.10
30 Mar 2020
Added JPath Option and ability to combine the data as JArray.
1.00
19 Mar 2020
Initial Release.
JSON Deserializer Release Notes
1.32
22 Jan 2025
Repackaged to translate the Agent's properties.
1.31
07 Jun 2022
Repackaged to include the Agents Category.
1.30
13 Jul 2020
Updated deserializer to a clean version.
1.20
21 May 2020
Fixed the payload alias.
1.10
21 May 2020
Added functionality to select which columns to keep.
1.00
03 Apr 2020
Initial Release.
Last updated
Was this helpful?