Copy SharePoint list attachment with Azure Data Factory pipeline

Jason Campbell 51 Reputation points
2022-12-07T03:10:27.363+00:00

Hi

Is it possible to copy the attachments in a SharePoint list from ADF?

These 2 scenarios work fine:

  • Copy files from a SharePoint document folder
  • Copy text from a SharePoint list

I just don't know how to copy a file that is embedded in the list as an attachment - if that's even possible?

This article seems to suggest that it's not possible: https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,249 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,218 questions
0 comments No comments
{count} votes

Accepted answer
  1. Renjie Sun-MSFT 2,861 Reputation points Microsoft Employee
    2022-12-08T09:12:08.007+00:00

    Hi @Jason Campbell ,

    Great to know that and thanks for sharing the update here.
    By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.". and according to the scenario introduced here: Answering your own questions on Microsoft Q&A, I would make a brief summary of this thread:

    [Copy SharePoint list attachment with Azure Data Factory pipeline]
    Issue Symptom:
    Is it possible to copy the attachments in a SharePoint list from ADF?

    These 2 scenarios work fine:

    Copy files from a SharePoint document folder

    Copy text from a SharePoint list

    I just don't know how to copy a file that is embedded in the list as an attachment - if that's even possible?

    This article seems to suggest that it's not possible: https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list

    Current status:
    It is possible, we could refer to this article:
    https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-folders-and-files-with-rest#working-with-files-attached-to-list-items-by-using-rest

    You could click the "Accept Answer" button for this summary to close this thread, and this can make it easier for other community members to see the useful information when reading this thread. Thanks for your understanding!
    Regards.


1 additional answer

Sort by: Most helpful
  1. Jason Campbell 51 Reputation points
    2022-12-07T17:34:32.317+00:00

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.