API via Web Activity

Question

API via Web Activity

Rohit Kulkarni 731

Hello Team,

I am calling API via Web Activity and wants to transfer the data to Blob storage in CSV format.

Pipeline :

Error Message :

Blob Output :

URL :https://storagename.blob.core.windows.net/Warehouse/EmployeDetails.csv

Please advise how this issue can be resolved

Regards
Rk

MartinJaffer-MSFT 26,161 Reputation points

2022-02-23T16:43:39.337+00:00

Hello @Rohit Kulkarni
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
MartinJaffer-MSFT 26,161 Reputation points

2022-02-28T16:50:38.007+00:00

Hello @Rohit Kulkarni ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread .

Thanks
Martin

1 answer

Your answer

MartinJaffer-MSFT 26,161 Reputation points

2022-02-23T16:43:39.337+00:00

Hello @Rohit Kulkarni
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
MartinJaffer-MSFT 26,161 Reputation points

2022-02-28T16:50:38.007+00:00

Hello @Rohit Kulkarni ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread .

Thanks
Martin

Answer 1

Welcome back @Rohit Kulkarni .

As I understand the ask, you are using Web Activity to do blob operations, and are getting unexpected errors, and want to know what might be the cause.

It looks like you are using a PUT on a blob, but somehow getting 404 not found. For writing normal block blobs, this shouldn't happen because putting a blob should create it. So, I am looking into what combination could result in 404. There are several other operations which also use the PUT verb on a blob. They typically take the form of adding ?comp={operation} to the URL, and generally require the blob already exist. Some examples are:

https://myaccount.blob.core.windows.net/mycontainer/myblob?comp=properties
https://myaccount.blob.core.windows.net/mycontainer/myblob?comp=metadata
https://myaccount.blob.core.windows.net/mycontainer/myblob?comp=tags
https://myaccount.blob.core.windows.net/mycontainer/myblob?comp=tier

If there is no ?comp= after your URL, there are still a couple possibilities. The Copy Blob operation and the put blob from url operation, which looks like a normal put block, except for the addition of the header x-ms-copy-source:name. They need a source, so 404 might happen when source url has a typo.

Another option is to use Copy activity with HTTP dataset instead of multiple web activities.

Share via

API via Web Activity

1 answer

Your answer