Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.2   6.3   6.4   6.5   7.0   7.1   7.2   7.3   7.4   7.5    Statistic  

XML.GetPathValue

Queries value in XML.

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

MBS( "XML.GetPathValue"; XML; Path { ; Flags } )

Parameters

Parameter Description Example value
XML The XML to process. "<test>Hello</test>"
Path The path to the node or attribute to query. "name"
Flags Optional
Various Flags.
Add 1 to ignore errors in xml and continue parsing. This may lead to not everything in the xml being read.
Add 4 to format returned XML.
Add 32 to return result as XML, if it’s more than just a text.
0

Result

Returns text or error.

Description

Queries value in XML.
This function uses a path notation like the JSON functions in FileMaker to describe paths.
You can use name of a node followed by option index in square brackets. On the end you can use # followed by a name of an attribute to select only the attribute.
Delimiter between items can be dot like FileMaker or newline.

Examples

Return test node value:

MBS( "XML.GetPathValue"; "<test>Hello</test>"; "test"; 0)

Example result: "Hello"

Query value of attribute:

MBS( "XML.GetPathValue"; "<test id=\"123\">Hello</test>"; "test#id")

Example result: "123"

Query value of node:

MBS( "XML.GetPathValue"; "<outer><inner>Hello</inner></outer>"; "outer.inner")

Example result: "Hello"

Query subtree as XML:

MBS( "XML.GetPathValue"; "<outer><middle><inner>Hello</inner></middle></outer>"; "outer.middle"; 32+4)

Example result:
"<?xml version="1.0" encoding="UTF-8"?>
<middle>
<inner>Hello</inner>
</middle>"

Query items with index:

MBS( "XML.GetPathValue"; "<people><personid>123</personid><personid>456</personid><personid>789</personid></people>"; "people.personid[2]"; 0)

Example result: "789"

Query value from complex XML:

MBS("XML.GetPathValue"; XML::BKML_data; "bkml.form106AB.data.line1.realProperty.property[0].citystatezip";0)

See also


XML.GetAttribute   -   XML.HasAttribute

Feedback: Report problem or ask question.




Links
MBS Xojo Plugins