search

a-marenkov / gsheets

A Dart library for working with Google Sheets API.
Other
79 stars 31 forks source link

The given string does not have the correct begin/end markers expected in a PEM file. #33

Closed AlexSavinien closed 3 years ago

AlexSavinien commented 3 years ago

It seems to be a credentials issue. I'm new to google apis.

In your exemple, what need to be filled ? I think i have correctly found my 'project_id' in Service Account's field 'Unique ID' I think the 'private_key' is the the key when you had a key (on your tutorial) I don't know where to find 'private_key_id' Same for'client_id' And do i have to do things with the left credentials fields ?

"auth_uri": "https://accounts.google.com/o/oauth2/auth",
"token_uri": "https://oauth2.googleapis.com/token",
"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
"client_x509_cert_url": ""

Here is the full error : 

[ERROR:flutter/lib/ui/ui_dart_state.cc(177)] Unhandled Exception: Invalid argument(s): The given string does not have the correct begin/end markers expected in a PEM file.
E/flutter (19618): #0      _getBytesFromPEMString (package:googleapis_auth/src/crypto/pem.dart:36:5)
E/flutter (19618): #1      keyFromString (package:googleapis_auth/src/crypto/pem.dart:22:15)
E/flutter (19618): #2      new ServiceAccountCredentials (package:googleapis_auth/auth.dart:157:25)
E/flutter (19618): #3      new ServiceAccountCredentials.fromJson (package:googleapis_auth/auth.dart:138:16)
E/flutter (19618): #4      new GSheets (package:gsheets/src/gsheets.dart:53:50)
E/flutter (19618): #5      HomeViewModel.addConsult (package:compta_remplacement_app/ui/views/home/home_viewmodel.dart:58:19)
E/flutter (19618): #6      HomeView.build.<anonymous closure> (package:compta_remplacement_app/ui/views/home/home_view.dart:77:37)
E/flutter (19618): #7      GestureRecognizer.invokeCallback (package:flutter/src/gestures/recognizer.dart:183:24)
E/flutter (19618): #8      TapGestureRecognizer.handleTapUp (package:flutter/src/gestures/tap.dart:598:11)
E/flutter (19618): #9      BaseTapGestureRecognizer._checkUp (package:flutter/src/gestures/tap.dart:287:5)
E/flutter (19618): #10     BaseTapGestureRecognizer.handlePrimaryPointer (package:flutter/src/gestures/tap.dart:222:7)
E/flutter (19618): #11     PrimaryPointerGestureRecognizer.handleEvent (package:flutter/src/gestures/recognizer.dart:476:9)
E/flutter (19618): #12     PointerRouter._dispatch (package:flutter/src/gestures/pointer_router.dart:77:12)
E/flutter (19618): #13     PointerRouter._dispatchEventToRoutes.<anonymous closure> (package:flutter/src/gestures/pointer_router.dart:122:9)
E/flutter (19618): #14     _LinkedHashMapMixin.forEach (dart:collection-patch/compact_hash.dart:377:8)
E/flutter (19618): #15     PointerRouter._dispatchEventToRoutes (package:flutter/src/gestures/pointer_router.dart:120:18)
E/flutter (19618): #16     PointerRouter.route (package:flutter/src/gestures/pointer_router.dart:106:7)
E/flutter (19618): #17     GestureBinding.handleEvent (package:flutter/src/gestures/binding.dart:358:19)
E/flutter (19618): #18     GestureBinding.dispatchEvent (package:flutter/src/gestures/binding.dart:338:22)
E/flutter (19618): #19     RendererBinding.dispatchEvent (package:flutter/src/rendering/binding.dart:267:11)
E/flutter (19618): #20     GestureBinding._handlePointerEvent (package:flutter/src/gestures/binding.dart:295:7)
E/flutter (19618): #21     GestureBinding._flushPointerEventQueue (package:flutter/src/gestures/binding.dart:240:7)
E/flutter (19618): #22     GestureBinding._handlePointerDataPacket (package:flutter/src/gestures/binding.dart:213:7)
E/flutter (19618): #23     _rootRunUnary (dart:async/zone.dart:1206:13)
E/flutter (19618): #24     _CustomZone.runUnary (dart:async/zone.dart:1100:19)
E/flutter (19618): #25     _CustomZone.runUnaryGuarded (dart:async/zone.dart:1005:7)
E/flutter (19618): #26     _invoke1 (dart:ui/hooks.dart:265:10)
E/flutter (19618): #27     _dispatchPointerDataPacket (dart:ui/hooks.dart:174:5)
E/flutter (19618):

Hope someone can help me :)

AlexSavinien commented 3 years ago

My bad, i didn't see the json file download when creating a new key :). This thread can be closed