Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
wskallmeyer
Advocate II
Advocate II

web connector and getting HREF value

I have successfully implemented Web connector and it has returned values that I expected.  However, there is one column that has an HREF/http value that I would also like to display not just the name value but also pass the HREF to allow my user to click on that link.  Has anyone attempted to bring back the HREF value?

 

Here is my web connector link ...

 

https://iase.disa.mil/stigs/Lists/stigs-masterlist/AllItems.aspx

 

Also, here is the HTML genereted by that page and in particular that TR/TD

 

<tr class="">
<td class="ms-vb2">Unclassified</td>
<td class="ms-vb2">
<a href="http://iasecontent.disa.mil/stigs/zip/U_A10_Networks_ADC_ALG_V1R1_STIG.zip" target="_blank">
A10 Networks Application Delivery Controller (ADC) ALG STIG Version 1</a></td>
<td class="ms-vb2"><nobr>4/27/2016</nobr></td>
<td class="ms-vb2">267 KB</td>
<td class="ms-vb2">ZIP</td>
<td class="ms-vb-icon">&nbsp;</td>
</tr>

 

Thanks in advance, Scott

1 ACCEPTED SOLUTION

The Web connector relies on the Web.Page( ) M function, which will not get the href value, so you will need to edit the query in the Power Query Editor.

 

Instead of using the default Web.Page( ), try getting the table using Lines.FromBinary( ) and Table.FromColumns( ). The output is not the final clean values, but you can split and remove until you get down to the data down to the values you want. 

 

As a start:

 

let
    Source = Table.FromColumns({Lines.FromBinary(Web.Contents("https://iase.disa.mil/stigs/Lists/stigs-masterlist/AllItems.aspx"))}),
    Custom1 = Table.SelectRows(Source, each Text.Contains([Column1], "https://iasecontent.disa.mil/stigs/zip/"))
in
    Custom1

 

 

View solution in original post

2 REPLIES 2

The Web connector relies on the Web.Page( ) M function, which will not get the href value, so you will need to edit the query in the Power Query Editor.

 

Instead of using the default Web.Page( ), try getting the table using Lines.FromBinary( ) and Table.FromColumns( ). The output is not the final clean values, but you can split and remove until you get down to the data down to the values you want. 

 

As a start:

 

let
    Source = Table.FromColumns({Lines.FromBinary(Web.Contents("https://iase.disa.mil/stigs/Lists/stigs-masterlist/AllItems.aspx"))}),
    Custom1 = Table.SelectRows(Source, each Text.Contains([Column1], "https://iasecontent.disa.mil/stigs/zip/"))
in
    Custom1

 

 

Awesome!  Thanks.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.