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!
