HtmlNode

Retrieves an HTML Node via XPath query

Free Function
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

SELECT SQLHTTP.net.HTMLNode ( @Html, @Xpath, @Index )

Arguments:

Name	Type	Description
@Html	nvarchar(MAX)	String containing HTML
@Xpath	nvarchar(MAX)	An Xpath query
@Index	bigint	Index position of the XPath query result



Return Type:

nvarchar(MAX)



Sample Usage:

This example demonstrates retrieving the first <tr> tag from an HTML Table:


DECLARE @HTML nvarchar(MAX)
DECLARE @Xpath nvarchar(MAX)
DECLARE @Index bigint
 
SET @HTML = '
<table align="center">
    <thead>
        <tr>
            <th>Year</th>
            <th>Start date</th>
            <th>Ending date</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td>2017</td>
            <td>March 12</td>
            <td>November 5</td>
        </tr>
        <tr>
            <td>2018</td>
            <td>March 11</td>
            <td>November 4</td>
        </tr>
        <tr>
            <td>2019</td>
            <td>March 10</td>
            <td>November 3</td>
        </tr>
        <tr>
            <td>2020</td>
            <td>March 8</td>
            <td>November 1</td>
        </tr>
    </tbody>
</table>'
 
SET @Xpath = N'//tr'
 
SET @Index = 1
 
SELECT SQLHTTP.net.HTMLNode(@Html, @Xpath, @Index)

DECLARE @HTML nvarchar(MAX)

DECLARE @Xpath nvarchar(MAX)

DECLARE @Index bigint

SET @HTML = '

<thead>

<tr>

<th>Start date</th>

<th>Ending date</th>

</tr>

</thead>

<tbody>

<tr>

<td>March 12</td>

<td>November 5</td>

</tr>

<tr>

<td>March 11</td>

<td>November 4</td>

</tr>

<tr>

<td>March 10</td>

<td>November 3</td>

</tr>

<tr>

<td>March 8</td>

<td>November 1</td>

</tr>

</tbody>

</table>'

SET @Xpath = N'//tr'

SET @Index = 1

SELECT SQLHTTP.net.HTMLNode(@Html, @Xpath, @Index)

-------------------------------------

<tr>

<th>Start date</th>

<th>Ending date</th>

</tr>



HtmlNode

Featured API Wrapper Code / SQL Server