I have issues in getting published google csv file using fetch_csv(). It has been working fine for a long time until recently. Every sheet that I used to be able to access has an error message like below. What does it mean when it says "from a redirected url"?
LoadCSVRedirect: 0065 Attempt to fetch_csv from a redirected url.
must be changed to https://doc-0s-80-sheets.googleusercontent.com/pub/l5l039s6ni5uumqbsj9o11lmdc/7p8u4u4ov9k25encoidjibbct0/1593314920000/116614430574839741191/*/[email protected]_VQeqfuvmAFlEGn3XqDUfNCCGd90A?output=csv
I'm simply using the following commend to get the csv, but it just fails with the above message.
url = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vTqvRexaufUgjjmrc-RUZ-llIo85xR69-T1suGZt4az4eWjKCc_VQeqfuvmAFlEGn3XqDUfNCCGd90A/pub?output=csv' fetch_csv(url, date_column='Date', date_format='%Y-%m-%d', symbol='breadth', usecols = ['Breadth_Strength'], )
Does anyone has similar issues? Is it a google issue or not? What is the solution for this?