topic Re: Google import/export app not accepting the JSON token from Google API in All Apps and Add-ons

Google import/export app not accepting the JSON token from Google API

astein_splunk — Fri, 05 Aug 2016 20:39:22 GMT

On Splunk Oxygen server, I have installed the Google Import/Export app. On google developmers I have created a project and enabled the API as outlined in the instructions, and downloaded the service authentication json.

A pop up saying" unable to get information about the current service key" comes up every time I attempt to run setup in the Google import/Export app from the splunk oxygen server.

When I select the downloaded JSON key from https://console.developers.google.com/project (after following the steps on (http://lukemurphey.net/projects/splunk-google-docs/wiki/How_to_setup_app) ) nothing happens - no error message, no indication the file is being uploaded or examined.

I attempted to run the app from my local splunk instance on my latop, and had the same error and behavior.

Many thanks for any help you can provide.

Re: Google import/export app not accepting the JSON token from Google API

LukeMurphey — Fri, 05 Aug 2016 21:25:44 GMT

I wonder if Google changed their format of the service keys. Let me try to reproduce this.

Re: Google import/export app not accepting the JSON token from Google API

LukeMurphey — Fri, 05 Aug 2016 21:26:10 GMT

hmm, I generated a new key and it set up fine for me.

Re: Google import/export app not accepting the JSON token from Google API

LukeMurphey — Fri, 05 Aug 2016 21:29:34 GMT

Could you check if the browser is reporting Javascript errors? See https://kb.yoast.com/kb/how-to-find-javascript-errors-with-your-browsers-console/ for some instructions.

Re: Google import/export app not accepting the JSON token from Google API

astein_splunk — Fri, 05 Aug 2016 23:46:33 GMT

Yep I see java script errors
the first error is from just getting to the setup page
the other two are from trying to upload the JSON.
trying on local machine next !

Re: Google import/export app not accepting the JSON token from Google API

astein_splunk — Fri, 05 Aug 2016 23:48:21 GMT

Same problem
https://postimg.org/image/4xovs5r81/

Re: Google import/export app not accepting the JSON token from Google API

JDukeSplunk — Sat, 06 Aug 2016 22:44:48 GMT

I had a similar issue with Google Developer sites, unrelated, but the problem was that the JDK on the Linux box did not have a cert for api.google.com, and I had to install the developers.google.com certificate into the Java 3rd-party key ring.

I guess what I am saying is, does Splunk/Python/Java on your system trust the url? If not, it might explain why it is failing on the handshake and not able to verify your API key.
-JD

Re: Google import/export app not accepting the JSON token from Google API

LukeMurphey — Sun, 07 Aug 2016 04:48:06 GMT

Could you be so kind to run the following search and let me know what it provides?

index=_internal (service_account_keys AND sourcetype=splunk_web_service) OR (sourcetype=google_spreadsheet_modular_input)

Re: Google import/export app not accepting the JSON token from Google API

astein_splunk — Sun, 07 Aug 2016 14:57:40 GMT

https://s8.postimg.org/569uufpxh/Screen_Shot_2016_08_07_at_7_58_49_AM.png

Re: Google import/export app not accepting the JSON token from Google API

astein_splunk — Sun, 07 Aug 2016 15:00:37 GMT

and on splunk oxygen I got something different
https://s7.postimg.org/vqwwe16rv/Screen_Shot_2016_08_07_at_8_01_31_AM.png

Re: Google import/export app not accepting the JSON token from Google API

astein_splunk — Tue, 29 Sep 2020 10:32:01 GMT

Ah, I see, the both have
"2016-08-05 16:49:43,597 INFO [57a52617971125fcf10] error:138 - Masking the original 404 message: 'The path '/en-US/custom/google_drive/service_account_keys/uploadServiceAccountKey' was not found.' with 'Page not found!' for security reasons"

in their history if I expand past 60 minutes.

Re: Google import/export app not accepting the JSON token from Google API

LukeMurphey — Tue, 29 Sep 2020 10:33:44 GMT

This is strange, I expected that the endpoint that this app uses didn't get registered but it looks like it did; the "Registering custom endpoint" event indicates that it had loaded.

Sorry, to keep asking you questions, I'm just struggling to figure out what is happening here.

Could you be so kind to go the following URL and see if there are any entries listed for /custom/google_drive/service_account_keys?

You can see the list at"/en-US/paths".

Re: Google import/export app not accepting the JSON token from Google API

LukeMurphey — Tue, 09 Aug 2016 05:37:59 GMT

Another option: I added instructions here that indicate how to manually setup the key by editing conf files.

Re: Google import/export app not accepting the JSON token from Google API

astein_splunk — Wed, 10 Aug 2016 14:04:43 GMT

...Spaces.
The original key was "Splunk dashboards-86e3193df54c.json" download from the instructions listed.
I followed all the steps, including the addition notes on how to manually configure . Nothing worked. In a fit of laziness I renamed the keyfile locally as "Splunkdashboards-86e3193df54c.json" to make my autocomplete linux command lines smooth, and everything magically works.

Thank you.

Re: Google import/export app not accepting the JSON token from Google API

LukeMurphey — Mon, 15 Aug 2016 21:47:02 GMT

Thanks for the follow-up. I made a bug ticket and will be fixing that issue where spaces in the key isn't allowed (http://lukemurphey.net/issues/1410). I'll fix that soon.

Sorry about the extra headache.