With ADF I created web activity with Post method and got my output. I need to get the output that's in json to be stored in my blob storage. I tried copy data method but it gives me error of "Failure happened on 'Source' side." I tried by calling 2 web activity with PUT method to add to blob but getting this error. Verified the container and it exists.
Error code
2108
User configuration issue
Details
<?xml version="1.0" encoding="utf-8"?><Error><Code>ContainerNotFound</Code><Message>The specified container does not exist.</Message></Error>
I have added dynamic value as an input in the copy activity but gives me error in debug. I am able to see the desired output in the input(debug mode) but output in not the same. Here is what it shows as output:
{
"effectiveIntegrationRuntime": "DefaultIntegrationRuntime (West US)",
"executionDuration": 0,
"durationInQueue": {
"integrationRuntimeQueue": 1
},
"billingReference": {
"activityType": "ExternalActivity",
"billableDuration": [
{
"meterType": "AzureIR",
"duration": 0.016666666666666666,
"unit": "Hours"
}
]
}
}
Goal here is to get the output stored in a blob as csv so I can import that file to sql table. How do I get the output stored in blob storage?
its in JSON. I am trying to add the output to a blob. I see the output from the web activity and also in copy activity i see it as input but in the output its not giving me anything. It just errors out and the output shown as above.
Hi @Caycee ,
Thanks for the ask and using the forum.
For the copy activity you used to try and get the JSON output into the blob storage, check if the copy activity properties were correctly configured for a JSON source:
https://learn.microsoft.com/en-us/azure/data-factory/format-json#copy-activity-properties
x Tameika
@Caycee did @HimanshuSinha-msft 's answer solve your issue? If so, please mark as accepted answer, otherwise, let us know how to better assist.
Sign in to comment