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:
11.1
11.2
11.3
11.4
11.5
12.0
12.1
12.2
12.3
12.4
Statistic
FMM
Blog
XML.ToJSON
Converts XML to JSON.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| XML | 8.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
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. Add 2 to put attributs inline. Add 4 to make entries with true/false being boolean. Add 8 to make entries with numbers as numbers. Add 16 to include namespaces. |
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.
Namespaces are stripped.
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.
Added option flags 4 and 8 for version 11.2 to handle boolean and numbers.
Added option flag 16 in version 12.1 to include namespaces.
Examples
Try it:
Set Variable [ $XML ; Value: MBS( "JSON.ToXML"; "{\"Hello\": \"World\"}"; "test") ]
Show Custom Dialog [ $xml ]
Set Variable [ $JSON ; Value: MBS( "XML.ToJSON"; $XML) ]
Show Custom Dialog [ $json ]
Try with boolean and number detection:
MBS( "XML.ToJSON";
"<test>
<value>123</value>
<value>45.67</value>
<value>true</value>
<value>false</value>
<value>Hello</value>
</test>"; 4 + 8 )
Example result:
{
"test": {
"value": [123, 45.67, true, false, "Hello"]
}
}
See also
Release notes
- Version 12.4
- Improved XML.ToJSON to handle data type conversion for attributes, too.
- Version 12.1
- Added new flag for XML.ToJSON to include namespaces.
- Version 11.2
- Added new flags for XML.ToJSON to detect numbers and booleans better.
- 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.
Example Databases
Blog Entries
- MBS FileMaker Plugin, version 12.1pr2
- MBS FileMaker Plugin, version 11.2pr4
- MBS FileMaker Plugin, version 10.5pr1
- MBS FileMaker Plugin, version 10.4pr8
- MBS FileMaker Plugin 10.0 - More than 6000 Functions In One Plugin
- MBS FileMaker Plugin, version 9.6pr2
- MBS FileMaker Plugin, version 9.5pr8
- MBS FileMaker Plugin 8.2 - More than 5200 Functions In One Plugin
- MBS FileMaker Plugin, version 8.2pr7
Created 27th April 2018, last changed 7th February 2022
Feedback: Report problem or ask question.
