Table of contents
TOC
Collapse the table of content
Expand the table of content

Xml.Tables

Owen Duncan|Last Updated: 4/19/2018

About

Returns the contents of an XML document as a nested collection of flattened tables.

Xml.Tables(contents as any, optional options as nullable record, optional encoding as nullable number) as table  

Arguments

ArgumentDescription
ContentsThe contents may be directly passed to the function as text, or it may be the binary value returned by a function like File.Contents or Web.Contents.
optional optionsControl the behavior of this function.
encodingEncoding value.

options Settings

SettingDescription
NavigationTableIf true, output tables are navigation tables. Default value is true.

Example

Xml.Tables("<books>  

    <book>  

        <name>Book1</name>  

    </book>  

    <book>  

        <name>Book2</name>  

    </book>  

</books>")  

equals  

(Table.FromRecords({ [  

    Name = "book",  

    Table = (Table.FromRecords({ [  

        name = "Book1"  

    ], [  

        name = "Book2"  

    ]  

)  
© 2018 Microsoft