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

Mehreen Ikram 20 Reputation points
2023-08-01T22:09:04.47+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,661 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,990 questions
0 comments No comments
{count} votes

Accepted answer
  1. AnnuKumari-MSFT 34,561 Reputation points Microsoft Employee Moderator
    2023-08-03T06:10:20.39+00:00

    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.

    User's image

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

    User's image

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


2 additional answers

Sort by: Most helpful
  1. Mehreen Ikram 20 Reputation points
    2023-08-03T13:00:00.6533333+00:00

    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


  2. Mehreen Ikram 20 Reputation points
    2023-08-03T13:22:24.78+00:00

    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}

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.