Hi folks
I have a csv file in Google Drive which I wanted to use from my JavaScript site.
If you copy share link from Google Drive you’ll get something like https://drive.google.com/file/d/1_cG2NrtGfuHv_aQGOHWOAZx7wapBlEah/view
Which is interactive url. So we need to get a download link
It can be done via https://sites.google.com/site/gdocs2direct/
And then we get a link
https://drive.google.com/uc?export=download&id=1_cG2NrtGfuHv_aQGOHWOAZx7wapBlEah
But when you try to get it via AJAX
var xhr = new XMLHttpRequest(); xhr.open('GET', 'https://drive.google.com/uc?export=download&id=1_cG2NrtGfuHv_aQGOHWOAZx7wapBlEah'); xhr.send()Failed to load https://drive.google.com/uc?export=download&id=1_cG2NrtGfuHv_aQGOHWOAZx7wapBlEah: Redirect from 'https://drive.google.com/uc?export=download&id=1_cG2NrtGfuHv_aQGOHWOAZx7wapBlEah' to 'https://doc-04-8s-docs.googleusercontent.com/docs/securesc/ha0ro937gcuc7l7deffksulhg5h7mbp1/mf62896bdal2t1qphepajrlrkcs7i6jp/1517788800000/04678722407924784084/\*/1_cG2NrtGfuHv_aQGOHWOAZx7wapBlEah?e=download' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'https://my-server-url' is therefore not allowed access.Not good. I spent a lot of time and finally found https://cors-anywhere.herokuapp.com/
Prepend this magic url with my url and the problem solved
... xhr.open('GET', 'https://cors-anywhere.herokuapp.com/https://drive.google.com/uc?export=download&id=1_cG2NrtGfuHv_aQGOHWOAZx7wapBlEah');
...Sweet!
Stay tuned