All Apps and Add-ons

Google Import/Export app: Problems importing a spreadsheet

vhsg
New Member

544/5000
Hello,

Please, someone can guide me with an error that I am getting when importing a spreadsheet.

Perform the installation according to what is indicated here (https://lukemurphey.net/projects/splunk-google-docs/wiki/How_to_setup_app)

after...
1) Create a lookup file
Create a lookup file. You can use the Lookup Editor app to do this if you want.

2) Write the search to populate the lookup
Create your search to populate the lookup with the data that you want it to contain. You can use the "outputlookup" search command to do this. You will probably want to use the "append" argument.

3) Create the input
Create the Google Import/Export input. Select the lookup file you created and make sure that you make the operation "export".

Then, I shared a spreadsheet with the service user (You can edit), I have installed the version of the app v1.0.2. When throwing the query:

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

I get the following error:

2018-06-19 11:36:39,234 ERROR A general exception was thrown when executing the export
Traceback (most recent call last):
File "/opt/splunk/etc/apps/google_drive/bin/google_spreadsheet.py", line 142, in export_file
google_lookup_sync = GoogleLookupSync(client_email, private_key, logger=self.logger)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/init.py", line 62, in init
self.gspread_client = self.make_client(private_key, client_email)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/init.py", line 87, in make_client
return gspread.authorize(credentials)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/client.py", line 326, in authorize
client.login()
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/client.py", line 85, in login
self.auth.refresh(http)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/oauth2client/client.py", line 633, in refresh
self._refresh(http.request)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/oauth2client/client.py", line 842, in _refresh
self._do_refresh_request(http_request)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/oauth2client/client.py", line 869, in _do_refresh_request
body = self._generate_refresh_request_body()
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/oauth2client/client.py", line 1549, in _generate_refresh_request_body
assertion = self._generate_assertion()
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/oauth2client/client.py", line 1677, in _generate_assertion
private_key, self.private_key_password), payload)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/oauth2client/crypt.py", line 92, in make_signed_jwt
signature = signer.sign(signing_input)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/oauth2client/_openssl_crypt.py", line 99, in sign
return crypto.sign(self._key, message, 'sha256')
AttributeError: 'module' object has no attribute 'sign'

Thank!

Tags (1)
0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...