CODEWITHSUNDEEP
azureazure-data-factoryjotform
kucluk
kucluk

Reputation: 551

Download file Report JotForm using API in Azure Data Factory

I Have Issue with Azure Data Factory, when i tried to download file from API and sink to storage blob , it always error

this is sample api key : https://api.jotform.com/report/222961798189071?apikey=68ba253ddf42c986053f083619fe7591

and this is report link to download : https://www.jotform.com/excel/222961798189071

I've tried using HTTP connector to Pipeline source Copy data enter image description here

this is connection source enter image description here

but when i run the pipepline it always error "ErrorCode=HttpInvalidUrlAddress,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Http Url Address 'https://www.jotform.com/excel/222961798189071https://api.jotform.com/report/222961798189071?apikey=68ba253ddf42c986053f083619fe7591' is invalid.,Source=Microsoft.DataTransfer.ClientLibrary,'"

enter image description here

or am i missing some step?

Upvotes: 0

Views: 234

Answers (1)

Vamsi Bitra
Vamsi Bitra

Reputation: 2764

Excel file has a lot of limitations in ADF and it does not support copy activity sink and data flow sink as well.

To resolve the error. Please follow below steps:

I took both source and sink as binary to perform copy activity.

Step 1: Source as HTTP

enter image description here

  • Make sure to provide proper linked service with base URL:

enter image description here

enter image description here

Step 2: Sink as binary from blob

enter image description here

Output:

enter image description here

This is my blob storage after Succeed. You can download and verify excel file data.

enter image description here

Upvotes: 0

Related Questions