-
Navigating the CBPR+ November 2025 Deadline: A Technical Guide to Schema Validation and Data Transformation
The global payments landscape is transforming due to the ISO 20022 standard, with SWIFT’s CBPR+ program phasing out legacy MT messages by November 2025. This transition involves complex challenges requiring a deep understanding of XML-based MX formats, schema validation, data mapping, and specialized tools to ensure compliance and data integrity throughout the migration process.
-
JSON to EDI Transform – Conditional Segments
Learn how to create an EDI 810 Invoice message from a JSON document using Liquid Data Mapper. We focus on mapping invoice items to the optional SAC segment, avoiding empty segments, and filtering out zero discount values in the output.
-
Convert BSON to JSON in Liquid Studio
JSON is a lightweight, human-readable data format used for data interchange, while BSON is its binary equivalent, suitable for machine use. Liquid Studio offers two methods for converting BSON to JSON: the Conversion Wizard and Liquid Data Mapper, facilitating data integration without coding.
-
Reading from multiple regions in an Excel worksheet with Liquid Data Mapper
This tutorial demonstrates how to extract and transform data from multiple regions within an Excel worksheet and use them within a data mapper transform, merging the data into a single output file.
-
NEW VIDEO: Replace Data Values using Lookup Component in Liquid Data Mapper…
This video tutorial teaches users how to replace data values using the Lookup and Cast components in Liquid Data Mapper. It provides a straightforward transformation method. A free trial of the software is available for download at the provided link.
-
Azure Function to Convert XML to JSON using Liquid Data Mapper
Liquid Data Mapper enables graphical data transformation for Microsoft Azure Functions. By adding input and output parameter components, users can seamlessly convert XML data into JSON format. The example illustrates creating a test application in C# that sends XML data to the Azure function, showcasing Liquid Data Mapper’s capabilities for data integration and transformation.
-
Creating Multiple Sample XML Documents from an Excel Spreadsheet with Liquid Data Mapper
This article shows you how to generate multiple XML documents, one for each row in an Excel spreadsheet, using Liquid Data Mapper.
-
Output Formatting in Liquid Data Mapper
Liquid Data Mapper includes Output Formatting options for data nodes, illustrated in the ’07 – Aggregate Functions.dm’ example. For more information on formatting various data types, consult the data mapper documentation. A free trial of Liquid Data Mapper is available for download at the provided link.
-
Using the Cast Component in Liquid Data Mapper
Liquid Data Mapper is a versatile tool for transforming diverse data formats like CSV, EDI, and JSON. It includes the Cast Component to convert incompatible data types, such as transforming a string date into an EDI-required format. Users can customize properties and format specifications for accurate data casting.
-
Recent XML Community Forum Questions
The Liquid Technologies XML Community Forum recently addressed several user inquiries, including adding schemaLocation to XML elements, generating standalone directives in C#, command line generation of code, handling destination filename errors, mapping XML to JSON, and utilizing DataMapper-generated DLLs. These discussions provide valuable insights for users.
