Working with Google Sheets API

Question

I'm trying to work with Google Sheets API with Xamarin Forms but I'm facing with problems reading the client_secret.json file that is used to authenticate with Google as it does when programming with .NET. When executing the following lines:

using (var stream =
            new FileStream("client_secret.json", FileMode.Open, FileAccess.Read))
        { ... }

I'm getting an error showing that can't find the file client_secret.json. I'm putting the property for that file in my solution making it to copy to directory with the "Always Copy" option, but no luck with this. (I'm using Visual Studio 2017).

Can anybody help me with this issue? Thank you.

Updated: The code I use is the following (any help would be appreciated):

        AssetManager assets = Android.App.Application.Context.Assets;
        var path = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), @"client_secret.json");
        using (var asset = assets.Open("client_secret.json"))
        using (var dest = System.IO.File.Create(path))
            asset.CopyTo(dest);

        using (var stream = assets.Open(@"client_secret.json"))
        {
            var secrets = GoogleClientSecrets.Load(stream).Secrets;

            string credPath = System.Environment.GetFolderPath(
                System.Environment.SpecialFolder.Personal);
                credPath = Path.Combine(credPath, "sheets.googleapis.com-dotnet-quickstart.json");

                credential = GoogleWebAuthorizationBroker.AuthorizeAsync(
                    GoogleClientSecrets.Load(stream).Secrets,
                    Scopes,
                    "user",
                    CancellationToken.None,
                    new FileDataStore(credPath, true)).Result;
         }

where did you use this code In Portable or In .Android project .. also did you resolve this issue — Mohamad Mahmoud Darwish, Feb 01 '18 at 10:39
I use a crossplatform .NET Standard app solution for use in Android and iOS platform. — Levimatt, Feb 05 '18 at 15:31
could you please add more details and add an answer for this qusetion help me to avoid this issue .. thanks — Mohamad Mahmoud Darwish, Feb 05 '18 at 15:32
@MikeDarwish Sorry but I still haven't found a solution for this issue. It's so annoying — Levimatt, Feb 06 '18 at 16:02
try to check my new answer, it is working fine for me using google api. https://stackoverflow.com/questions/48432846/how-to-read-data-from-google-spreadsheet-in-xamarin-forms/52556347#52556347 — Mohamad Mahmoud Darwish, Sep 28 '18 at 13:41

score 0 · Answer 1 · answered Dec 16 '17 at 05:45

0

I had trouble with the client_secret.json file too. The instructions for where it belonged didn't work for me.

So I put a copy in my home directory's .credentials directory (/user/.credentials ), and I put a copy in the directory of the executing application - and one of the two worked. I would try placing client_secret.json in different directories until the application finds it.

answered Dec 16 '17 at 05:45

NSchorr

875
10
13

could you please explain more .. what i need to do to avoid this issue – Mohamad Mahmoud Darwish Feb 01 '18 at 10:43
The app needs to be able to find it. But perhaps in your case it's more than that. Have you seen this page? https://android-developers.googleblog.com/2016/02/using-credentials-between-your-server.html – NSchorr Feb 02 '18 at 23:55

Mohamad Mahmoud Darwish · Answer 2 · 2018-06-08T14:09:18.023

0

you need to do the following:

1-put the client_secret.json In Assest.

2-try to read the json from Assest

 using (var stream = this.Assets.Open(@"client_secret.json"))
    {
        var secrets = GoogleClientSecrets.Load(stream).Secrets;
    }

edited Jun 08 '18 at 14:09

answered Feb 13 '18 at 09:23

Mohamad Mahmoud Darwish

3,865
9
51
76

Just add the json file in assest. It will working fine . But Google api doesn't support xamarin.android you will face another issue when you are trying to get authorization from Google. I will paste the issue tomorrow morning – Mohamad Mahmoud Darwish Feb 14 '18 at 22:20
can you post your issue to know if it can help me? – Levimatt Feb 19 '18 at 14:36
yes .. check this https://stackoverflow.com/questions/48763914/get-google-credential-throws-unhandled-exception – Mohamad Mahmoud Darwish Feb 19 '18 at 14:40

Working with Google Sheets API

2 Answers2