Forum Discussion
Ingesting data from Google Drive folder
Hello bao_phan
The copy link gives you a URL that points to a web page, not the file that you're after. The HTTP activity finds it as a huge first row and throws that error. This is not an issue with connectivity, but the content of the URL being deciphered as a row, hence test connection succeeds!
The workaround is to change the URL into a downloadable direct file URL, so Fabric can download. Change the URL as per this -
Original (share) link looks like:Convert to direct download:Use this in the HTTP connectors source. This should return the file content. This is explained here:
Hello bao_phan
The copy link gives you a URL that points to a web page, not the file that you're after. The HTTP activity finds it as a huge first row and throws that error. This is not an issue with connectivity, but the content of the URL being deciphered as a row, hence test connection succeeds!
The workaround is to change the URL into a downloadable direct file URL, so Fabric can download. Change the URL as per this -
oh, so we need to change the url like the format you mentioned to allow Fabric to be able to download the files and read that file. Thank you!!! Your solution works.