topic Re: How to write a custom function getting Response from the API or URL. Whether it is Error or Succ in Developer

How to write a custom function getting Response from the API or URL. Whether it is Error or Success.

KR300 — Mon, 27 Jan 2025 06:07:59 GMT

Hi Team,

Description: My team is publishing a document in the web for each Version( Internally how the Team is doing on the Product development).

Let's say Documents are available in the web ( i am creating dynamic links in the PBI desktop SFP.R.1.1, SFP.R.1.2, SFP.R.1.3 ) but not sure when these are published/will publish in web - No perfect date ).

So, I need to write a custome function to check or get response from the API or HTTP request.

1. Can we save that response a table in Power BI

2. Based on the response

If the response is an error or 404 not found -- I need to show Link/URL is not available

If the response is a success or 200 -- I need to show Link/URL is available then The USER's/LEADERSHIP directly get to know that informayon whether the URL/Link is available or not, + They will ask the below one why it is not published/ not ready yet.

Re: How to write a custom function getting Response from the API or URL. Whether it is Error or Succ

nilendraFabric — Mon, 27 Jan 2025 06:18:43 GMT

Hello @KR300

You can create a custom function that calls each URL, checks the HTTP status, and returns a result record to identify whether the link is available or not

read this blog it will be helpful

https://www.tonymcgovern.com/blog/web-api-error-handling/

Try this

(url as text) as record =>
let
response = Web.Contents(url, [ManualStatusHandling={404,400,500}]),
responseStatus = Value.Metadata(response)[Response.Status],
result =
if responseStatus = 200 then
[Status = 200, Message = "Link available"]
else if responseStatus = 404 then
[Status = 404, Message = "Link not available"]
else
[Status = responseStatus, Message = "Other error"]
in
result

1.Create a table of Versions and their corresponding hyperlinks.
2. Add a custom column that invokes the above function for each URL.
3. Expand the returned record to see the status code and the custom message.
4. If the status code is 200, you can treat the link as valid. If it is 404, you can display that the link is not yet published.

This discussion is helpful as well

https://www.reddit.com/r/PowerBI/comments/mm0be7/handling_http_errors_in_webcontents_calls/

Hope this resolves the query. If yes give kudos and accept the answer

Thanks

Re: How to write a custom function getting Response from the API or URL. Whether it is Error or Succ

KR300 — Tue, 28 Jan 2025 07:08:58 GMT

@nilendraFabric , Thank you so much you info. Will test it & let you know..

Would be great if any .pbix file

Re: How to write a custom function getting Response from the API or URL. Whether it is Error or Succ

KR300 — Wed, 29 Jan 2025 16:19:36 GMT

@nilendraFabric Thanks for your info. I am getting responses

Status: 404

Message: Link not Available.

But i want this as a table in power Query so that i can convert likw below for the dynamic purpose

Status Message

404 Link not Available