Monkeybread Software - MBS FileMaker Plugin: XML.ToJSON

Topics All MacOS (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples Videos
New in version: 9.2 9.3 9.4 9.5 10.0 10.1 10.2 10.3 10.4 10.5 Statistic FMM Blog

XML.ToJSON

Converts XML to JSON.

Component	Version	macOS	Windows	Server	FileMaker Cloud	FileMaker iOS SDK
XML	8.2	Yes	Yes	Yes	Yes	Yes

MBS( "XML.ToJSON"; XML { ; Flags } ) More

Parameters

Parameter Description Example Flags

XML The XML to process. "<test>Hello</test>"

Flags Various Flags.
Add 1 to ignore errors in xml and continue parsing. This may lead to not everything in the xml being read. 0 Optional

Parameter	Description	Example	Flags
XML	The XML to process.	"<test>Hello</test>"
Flags	Various Flags. Add 1 to ignore errors in xml and continue parsing. This may lead to not everything in the xml being read.	0	Optional

Result

Returns JSON or error.

Description

Converts XML to JSON.
For nodes in the XML we create objects and key/values.
Attributes are put in @attributes nodes.

Added option flag 2 in version 10.5 to not use @attributes object, but put attributes directly in objects with "@" prefix. The JSON.ToXML function unpacks that.

Example Databases

XML/XML to JSON

Blog Entries

Release notes

Version 10.5
- Changed XML.ToJSON and added option for compacter attributes processing.
Version 10.4
- Changed JSON.ToXML to recreate attributes stored as @attributes entry by XML.ToJSON function.
Version 10.0
- Improved CData handling for XML.ToJSON function.
Version 9.5
- Fixed bug in XML.ToJSON function.
Version 8.2
- Added XML.ToJSON function.
- Changed XML.ToJSON to create array if a key is used several times.

Created 27th April 2018, last changed 16th September 2020

XML.SubTree - XML.Validate

Feedback: Report problem or ask question.