วีดีโอ

Can this work the other way round? Output/Sink to SharePoint online and replace excel file if exists.

You are amazing!!! If you are doing an xlsx file, instead of Binary use xlsx file type and you can copy right into SQL rather than having to drop into data lake or blob storage first.

This is a useful tips but I have question, if you have multiple files in SharePoint document folder how do you read the folder metadata to get ChildItem to iterate in the ForEach activity since metadata activity has no connector for SharePoint?

Extremely useful and explained much better than any other article that I've come across on getting this setup - thanks for saving me hair loss!

Hi Javibi,I'm getting an error after 4:34 when I click on "Trust," which says, "Sorry, you don't have access." Could this be because I don’t have access to the SharePoint site, or should I inform the Azure admin to grant the necessary API permissions for the app? I see that the permissions are currently "Not granted." Please advise.

Thanks for the great video. Can I also copy excel stored in sharepoint library into SQL database using same method?

Can I also upload the data to Sharepoint?

I want pull the secrent form Keyvault how can I do that

How can you copy multiple files in a particualr sharepoint folder

How to do it for multiple files like entire sp library

@javibi, What an excellent video!!!. This process also works for MS Fabric? In my case, I will copy txt data from SharePoint to the bronze layer in MS Fabric.

Error during server relative url, says specified value not supported

is anonymous access mandatory for this process to work? our SP replies with "... Type=System.Net.WebException,Message=The remote server returned an error: (403) Forbidden" i can run the link moving the file into $value both from my personal browser aswell as for a technical user i gave access to the folder where the file is ... but running it from ADF results in the (shortened) error message from above

So useful! Excuse me, i have a question, can redirect data after use ADF to Azure datalake gen 2. Thanks!

Hi how to get multiple files from sharepoint site folder

Thank You for the Video, I've followed all the steps, but I still get the following error. "ErrorCode=HttpRequestFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Http request failed with client error, status code 403 Forbidden, please check your activity settings. If you configured a baseUrl that includes path, please make sure it ends with '/'

HI, Thank You for the Video. I followed all the steps but still I am getting below Error. "Operation on target Copy from Share Point failed: ErrorCode=HttpRequestFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Http request failed with client error, status code 403 Forbidden, please check your activity settings. If you configured a baseUrl that includes path, please make sure it ends with '/'." Please help on this.

How to extract items from sharepoint to ADF?

I followed all the steps and i have the following error : ErrorCode=HttpRequestFailedWithUnauthorizedError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Http request failed with status code 401 Unauthorized, usually this is caused by invalid credentials, please check your activity settings. Request URL: help my plis

Hi, It was a great video. I wanted to know if I am copying data from sharepoint to ADLS and if I delete one file from sharepoint then I want to delete the same file from ADLS too. How can I implement this?

I keep getting this error; "Input Payload is invalid, validation result - '[\"Connector or activity name: Datalake_LSb00ee7af200d441da59965050eb96f7d, connector or activity type: AzureBlobFS, error: The domain of this endpoint is not in allow list. Original endpoint: does any one faced it?

Great tutorial! Wanted to know if there is a way to use this to pull down the entire documents library?

simple and straight , nice video. can you please make video like vararible value in dev and variable value in prd is different . like variable in container name ( var1 = dev_calls) when migrated to prod same var1=prod_call

Is it possible to give the app permission to all sharepoint sites in your tenant? Instead of 1 by 1

Hi, why it don't have a HTTP source??

Exactly what I needed and nothing more. This was perfect. Tnx a lot!

Thanks for sharing, I have tried the same steps to get data from a SharePoint list and it keeps saying Unauthorized, I already checked the URL passed to the copy activity returns values. I did not see access to SharePoint was given when the app was registered in Azure App Registration. Can this be the reason?

Very good explaination!!!Thank you!

Great tutorial! Is there a way to make the filename dynamic for xlsx? So if we have filename.xlsx, how do we do it for *.xlsx or %file%.xlsx to capture anything named file or all files in the directory?

supper clear! Thanks for your time and effort!

Hello ! thank youu for the video.. I suppose we can do reverse the same way? by switching sink and source in copy data? from datalake to sharepoint? if not, why? thank you again 👍

Hii i hv built the pipeline like you said and it was working very well, but suddenly it is throwing error. I also checked the linked service which is also testing connection successfully. But i'm getting the error ErrorCode=HttpFileFailedToRead,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to read data from http server. Check the error from http server：The underlying connection was closed: An unexpected error occurred on a send.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The underlying connection was closed: An unexpected error occurred on a send.,Source=System,''Type=System.IO.IOException,Message=Authentication failed because the remote party has closed the transport stream.,Source=System,' can you let me know what may be the issue ??

As per the Lastest update by Microsoft. This process of http is no more acceptable

Hi javibi , after giving appid while lookuping app name not coming, iam using different adf account and different SharePoint

Straight to the point, no bs. Thanks for the tutorial.

Outstanding!!! Thank you!!!

can we try this with .xlsx file. I done with .xlsx file with utf-8 encoding, but still i'm finding � like characters when i open in notepad. Is there any way to this ?

Is it requires Microsoft Grap API Permission?

So well explained. Well done man. Thank you.

hello there, the video is such usefull, have you posted any other video copying data from an excel file?

thanks, very informative.

Hi Sir, Thanks for the video. How to capture the info of modified by and Last updated time from share point to maintain a audit log.

I already have the data in json format in the web activity, it is according to your video but how I took this data to azure blob storage or table storage you did not show that part, thank you very much if you can help me pleaseeee

I have created a project in Visual Studio and created the function GetOAuthToken but when I publish it, I am not able to see the function under my GetGoogleAnalyticsToken Function App in Azure. I am not sure what to do at this point with the code. Is there anyway I can get a copy of the program from someone who has made it work?

can we connect ibm i series ?

it works, thanks!

If I have more than one property in analytics, should I give access to the API email for each of them?

Excellent!

Graciela!

Get this error on last step: ErrorCode=HttpRequestFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Http request failed with client error, status code 411 LengthRequired, please check your activity settings.