Failed To Import / Download

[lazism]

안녕하세요 개발자님. 그동안 1년 이상 잘 사용하고 있다가, 어제부터 Import가 안되는 이슈가 생겼습니다.

Authentication도 문제없이 진행되는데, Import하려고 하면

이렇게 나오는데, 링크를 찾아서 들어가도 페이지가 없다고 나옵니다.

Download시 발생하는 에러는

System.AggregateException: One or more errors occurred. ---> System.Net.WebException: The remote server returned an error: (401) Unknown authorization header.
at System.Net.HttpWebRequest+d__240.MoveNext () [0x00152] in :0
--- End of stack trace from previous location where exception was thrown ---
at System.Net.HttpWebRequest.EndGetResponse (System.IAsyncResult asyncResult) [0x0001d] in :0
at System.Threading.Tasks.TaskFactory1[TResult].FromAsyncCoreLogic (System.IAsyncResult iar, System.Func2[T,TResult] endFunction, System.Action1[T] endAction, System.Threading.Tasks.Task1[TResult] promise, System.Boolean requiresSynchronization) [0x0000f] in <695d1cc93cca45069c528c15c9fdd749>:0 <---

이렇게 나옵니다.

구글 프로젝트 문제인가 싶어서 gcp에서 새로운 프로젝트로 시도해보았지만 여전히 되지 않았습니다. 해결방법이 있을까요?

[lazism]

오늘 다시 잘 작동하네요. 일시적인 문제였던것 같습니다. 이슈는 닫겠습니다

[kimsama]

Sounds great! Cheers.

[lazism]

안녕하세요. 그이후로 이슈가 발생해서 이번엔 사라지지 않는데, 혹시 개발자님은 잘 되시나요? ㅠㅠ

[azuma560]

Hi, Thanks for your great library.

I can no longer fetch from google spread sheet. After some research, Google Sheets API v3 may be deprecated and this may be need to move to API v4.

Intermittent 404 Errors on Google Sheet Feed

[JonathanReid]

I'm also getting this error as well, and its stopping me from updating any text. When can we expect an update?

[YuriiZhuk]

Hi, Thanks for your great library.

I can no longer fetch from google spread sheet. After some research, Google Sheets API v3 may be deprecated and this may be need to move to API v4.

Intermittent 404 Errors on Google Sheet Feed

I've got the same problem today. Does anybody have a solution?

[kimsama]

Would you share more information about this?
Google Sheets API v3 may be deprecated and this may be need to move to API v4.

If API would be a problems, we may need to replace the existing DLLs. (not 100% sure)

[JonathanReid]

I was looking into this myself, it looks like GData, the library that is used to talk to the spreadsheet API is now being deprecated and replaced with Spreadsheet API v4. Google say the GData version is still live, but obviously that isnt the case...

https://developers.google.com/gdata/docs/directory

There seems to be other projects that use API v4 in unity, so it is possible to get it working:
https://github.com/UniGameTeam/UniGame.GoogleSpreadsheetsImporter

I believe it is a case of removing the gdata DLL's and using this new API to do all the spreadsheet calls to pull down data.

I haven't tried to set this up yet, I just fell back to using the excel version for now as I needed to update copy in various projects.

[YuriiZhuk]

My solution is: I removed this plugin from my project and wrote a wrapper for Google Sheets API v4. I imported the API using the Nuget package manager in Visual studio. Then I removed unnecessary plugins and kept only folders called "net45" and "net40" (for Google.Apis.Sheets.v4.1.54.0.2371). In the import settings of each plugin, I changed the "Editor" option to true so it's only is using in Unity Editor. Then I wrote few scripts to use the API. The samples of code you can find here . This API I use in Unity 2019.4.20f and everything works perfectly. Thanks, Google for the .NET API.

[JonathanReid]

My solution is: I removed this plugin from my project and wrote a wrapper for Google Sheets API v4. I imported the API using the Nuget package manager in Visual studio. Then I removed unnecessary plugins and kept only folders called "net45" and "net40" (for Google.Apis.Sheets.v4.1.54.0.2371). In the import settings of each plugin, I changed the "Editor" option to true so it's only is using in Unity Editor. Then I wrote few scripts to use the API. The samples of code you can find here . This API I use in Unity 2019.4.20f and everything works perfectly. Thanks, Google for the .NET API.

does your solution import the text into the scriptable objects that quicksheets uses? Would you mind sharing some of your wrapper code?

[YuriiZhuk]

I uploaded my solution sample. You have to modify the code for yourself.

https://github.com/YuriiZhuk/Google-Sheets-API-Wrapper-C-.git

[kimsama]

@JonathanReid Thank you for sharing the info. If the cause of this problem is becasue of the change of Google API, it makes sense.

I believe it is a case of removing the gdata DLL's and using this new API to do all the spreadsheet calls to pull down data.

I agree. it would need replacing old APIs with new Spreadsheet API v4.

@YuriiZhuk
Thank you for sharing the code. I grasped quickly your code and just found that there's only some code for credentials.

You have to modify the code for yourself.

Meaning, it still needs to modify the rest of the code regarding Google API, correct? Hope to be very clarified because you've mentioned that "My Solution-" in your answer so, I wonder whether the above approach is the way can resolve the issue entirely.