How to download a smartsheet in xls/xlsx format into blob storage?

Question

I have created a smartsheet linked service using the following instructions.

he connection is successful but where do it enter the link of my Smartsheet that I want to download in my blobstorage?

https://learn.microsoft.com/en-us/azure/data-factory/connector-smartsheet?tabs=data-factory

Answer 1

Hi Mehreen Ikram ,

Welcome to Microsoft Q&A platform and thanks for posting your question here.

As per my understanding of your question, it seems that you want to connect to the smartsheet as the source and import the data using ADF pipeline. Please let me know if that is not the ask.

Smartsheet connector is under preview and can only be utilized as inline dataset in Mapping data flow.

Go to the source option tab, and select the entity- sheet/report and provide the sheetname in the entityname section.

Hope it helps. Kindly accept the answer by clicking on Accept answer button or reach out in case you have any additional query. Thankyou.

Answer 2

I have tried two ways:

First:

• HTTP connector is generic to retrieve data from any HTTP endpoint, for example, to download file. Before this REST connector you may happen to use HTTP connector to copy data from RESTful APIs, which is supported but less functional comparing to REST connector.

However the file downloaded from smartsheet does not have any data also it does not have xlsx extension.

Second:

Transform data in Smartsheet (Preview) using Azure Data Factory or Synapse Analytics (in this one I cannt find a way on where to add the URL of the smartsheet.)

https://learn.microsoft.com/en-us/azure/data-factory/connector-smartsheet?tabs=data-factory

Answer 3

I am getting the following error when I try to save the linked service with Smartsheet

Error details

{"$id":"1","innerException":null,"message":"The path '//linkedService/Smartsheet1.json' does not exist at commit 'b2d69161966901ad452c68b06ae3fce8013d6b41'\r\nParameter name: newPush","typeName":"Microsoft.TeamFoundation.SourceControl.WebServer.InvalidArgumentValueException, Microsoft.TeamFoundation.SourceControl.WebServer, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a","typeKey":"InvalidArgumentValueException","errorCode":0,"eventId":0}