cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
philippelinder New Member
New Member

URL validation

Hi everyone

 

I have a list with Picture URL. The Images are displayd perfectly. But what IWould like to get is a formula to indicate if a URL will not work. This way I could get a list with missing images.

 

any Ideas or suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: URL validation

Hi @philippelinder,

 

I have found a way could help your indicate if the the URL is valid, you could have a try with the query below.

 

Here is my test data source. You could copy and paste it in Advanced Editor in Qury Editor.

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fY/LDoIwFET/hbXlXgiocenObyCkqeWGFukjbUU+XwWNC6PrmXMy0zSZSsnHA0CFVUwuUC6dgRKLPWANuIOjDl1kJyN6ygffZ+3mwyga/ZyLzp1XTDqbyCbohFkyIAsPqbyAcjeWHEw6XsXIAk0UIjH9tLJIIkgFfJCBvw1GaMu8CBGWzj+QTSUvEHGut/i18PXqx6m13t4B", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [URL = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"URL", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each try Binary.Length(Binary.From(Web.Contents([URL]))) >0 otherwise false)
in
    #"Added Custom"

We could add a custom column to indicate if a URL will not work by tracing the binary of the url. However, the performance will not good if we in the way, because it will trace each url for some time.

 

More details, you could refer to my attachment.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: URL validation

Hi @philippelinder,

 

I have found a way could help your indicate if the the URL is valid, you could have a try with the query below.

 

Here is my test data source. You could copy and paste it in Advanced Editor in Qury Editor.

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fY/LDoIwFET/hbXlXgiocenObyCkqeWGFukjbUU+XwWNC6PrmXMy0zSZSsnHA0CFVUwuUC6dgRKLPWANuIOjDl1kJyN6ygffZ+3mwyga/ZyLzp1XTDqbyCbohFkyIAsPqbyAcjeWHEw6XsXIAk0UIjH9tLJIIkgFfJCBvw1GaMu8CBGWzj+QTSUvEHGut/i18PXqx6m13t4B", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [URL = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"URL", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each try Binary.Length(Binary.From(Web.Contents([URL]))) >0 otherwise false)
in
    #"Added Custom"

We could add a custom column to indicate if a URL will not work by tracing the binary of the url. However, the performance will not good if we in the way, because it will trace each url for some time.

 

More details, you could refer to my attachment.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.