Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Decoding a hyperlink column from a Rally API Connection

I have a Rally API connection that is returning a few fields that are hyperlinks as the actual link itself. I want to get at the text from the hyperlink not the URL associated with it. 

 

Is there any way to decode this URL to get at these hyperlink's text or is there a way to get at the data from the URL?

 

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,Anonymous 

    Regarding the issue you raised, my solution is as follows:

    1.Here are some sample m languages that I hope will help you:

    let
    Source = "",
    Sheet1=Source{[Item="Sheet1",kind="Sheet"]}[Date],
    Addcontentcolumn=Table.AddColumn(Sheet1,"content",each 
    let
    Url1=[url],
    source1=Web.Contents(Url1),
    content1=Text.FromBinary(source1)
    in
    content1
    ),
    final1=Addcontentcolumn
in
    final1

    2.Here is the relevant documentation:

    Web.Contents - PowerQuery M | Microsoft Learn

     

    3.Of course, you can also use the following code in powerquery to view the sample documentation in the following language:

    et
    Source = #shared,
    #"Web Contents" = Source[Web.Contents]
in
    #"Web Contents"

    If you have new discoveries, you are welcome to share them with us.

     

     

    Best Regards,

    Leroy Lu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,Anonymous 

    Regarding the issue you raised, my solution is as follows:

    1.Here are some sample m languages that I hope will help you:

    let
    Source = "",
    Sheet1=Source{[Item="Sheet1",kind="Sheet"]}[Date],
    Addcontentcolumn=Table.AddColumn(Sheet1,"content",each 
    let
    Url1=[url],
    source1=Web.Contents(Url1),
    content1=Text.FromBinary(source1)
    in
    content1
    ),
    final1=Addcontentcolumn
in
    final1

    2.Here is the relevant documentation:

    Web.Contents - PowerQuery M | Microsoft Learn

     

    3.Of course, you can also use the following code in powerquery to view the sample documentation in the following language:

    et
    Source = #shared,
    #"Web Contents" = Source[Web.Contents]
in
    #"Web Contents"

    If you have new discoveries, you are welcome to share them with us.

     

     

    Best Regards,

    Leroy Lu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.