Enquiry on behavior of Azure Data Factory web activity

Question

Enquiry on behavior of Azure Data Factory web activity

BrianC 120

Hi community,

We have a Azure Data Factory Pipeline that involves a Web activity. I would like to know what activity status will I get if the API status code return is not 200?

Thanks in advance.

Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator

2025-03-25T09:49:54.4433333+00:00
Can you please provide some more details on your ask:

Is your query regarding what are the different API status codes and their corresponding descriptions?

Is your ask whether every Web activity output would have an API status code?
BrianC 120 Reputation points

2025-03-25T10:15:05.32+00:00

@Nandan Hegde As I have another activity following this Web activity. Therefore, I would like to know if I get status code other than 200, will the pipeline proceed to run the following activity or it will stop.
Venkat Reddy Navari 3,470 Reputation points Microsoft External Staff Moderator

2025-03-28T12:36:48.8833333+00:00

@BrianC Just checking in to see if the below answer provided by @Nandan Hegde helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator

2025-03-25T09:49:54.4433333+00:00

Can you please provide some more details on your ask:

Is your query regarding what are the different API status codes and their corresponding descriptions?

Is your ask whether every Web activity output would have an API status code?
BrianC 120 Reputation points

2025-03-25T10:15:05.32+00:00

@Nandan Hegde As I have another activity following this Web activity. Therefore, I would like to know if I get status code other than 200, will the pipeline proceed to run the following activity or it will stop.
Venkat Reddy Navari 3,470 Reputation points Microsoft External Staff Moderator

2025-03-28T12:36:48.8833333+00:00

@BrianC Just checking in to see if the below answer provided by @Nandan Hegde helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Nandan Hegde 36,151 MVP Volunteer Moderator

Hey,

Please refer the below blog :

https://datasharkx.wordpress.com/2022/11/05/refresh-power-bi-dataflow-dataset-from-azure-data-factory-synapse-pipeline-via-managed-identity/

The scenario depends on the API type, whether the API is a synchronous or an asynchronous API.
In case if it is an asycn API, the web activity status becomes success irrespective whether the output was received or not (As the scenario in above blog)

So you have to use a fail activity depending on the scenario of IF ELSE aspect.

In case if the API on which you are trying to hit, has 40* error, like unauthorized; then the web activity would fail

BrianC 120 Reputation points

2025-03-26T01:48:06.3366667+00:00

@Nandan Hegde Thank you for the information.

My Web activity will call this API (https://learn.microsoft.com/en-us/rest/api/datafactory/pipeline-runs/query-by-factory?view=rest-datafactory-2018-06-01&tabs=HTTP) and I have the "Disable async pattern" setting unchecked.

May I know in such scenario, what will the web activity react? Thanks.
Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator

2025-03-26T04:04:45.69+00:00

In this scenario, in case if the web activity is a success; you can proceed further else the web activity would fail

Meaning: I have not given the ADF any access at the RG level:

Hence there was an authorization failure failing the activity
Venkat Reddy Navari 3,470 Reputation points Microsoft External Staff Moderator

2025-03-27T13:31:34.9566667+00:00

BrianC Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Enquiry on behavior of Azure Data Factory web activity

1 answer

Your answer