xls file through http

asked 2021-11-08T12:46:18.613+00:00
Hassan Waseem 1 Reputation point

Hi All,
I am using Azure Dat Factory to GET data from an RESTAPI and storing it in Data Lake. This data link is in xls format. I am wondering if this will work as according to the documentation it doesnt. Moreover if their is any other way through which I can get this data.
https://learn.microsoft.com/en-us/azure/data-factory/format-excel

147296-sdsds.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,248 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2021-11-09T01:13:04.707+00:00
    KranthiPakala-MSFT 32,891 Reputation points Microsoft Employee

    Hi @HassanWaseem-7729,

    Welcome to Microsoft Q&A forum and thanks for posting your query.

    As a workaround you can use a Binary Dataset both on source and sink side and use HTTP linked service in the source dataset and point to your endpoint. Then download the file your sink using a Binary dataset on the sink side. Then use excel connector to transform your data and load to desired sink.

    147571-image.png

    When using Binary dataset in copy activity, you can only copy from Binary dataset to Binary dataset. When using Binary dataset, the service does not parse file content but treat it as-is. For more info regarding Binary format please refer to this doc: Binary format in Azure Data Factory and Synapse Analytics

    Hope this info helps. Do let us know how it goes.

    ----------

    • Please don't forget to click on 130616-image.png and upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators