I have successfully used the Google Import/Export app to import lookups from Google Drive, but when trying to export a lookup table to a sheet, only the first (header) row actually appears in the sheet. I tried to investigate and found this error in google_spreadsheet_modular_input.log
, which may or may not be related:
2019-02-19 20:21:18,258 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 143, in export_file last_updated = google_lookup_sync.export_lookup_file(lookup_name, None, None, spreadsheet_title, worksheet_name, session_key) File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/__init__.py", line 197, in export_lookup_file return self.export_lookup_file_full_path(destination_full_path, namespace, owner, google_spread_sheet_name, worksheet_name, session_key, lookup_name=lookup_name) File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/__init__.py", line 264, in export_lookup_file_full_path google_work_sheet.update_cell(row_number, col_number, value) File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/models.py", line 445, in update_cell self.client.put_feed(uri, ElementTree.tostring(feed)) File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/client.py", line 277, in put_feed raise ex HTTPErrorIs there something I need to do to get a lookup to export correctly? I am certain that the app has write access to the sheet in question. Thank you!
Is there any more details about the HTTPError (like the HTTP code)?
No, there is no HTTP code specified, and that seems to be the extent of the error message.
I am seeing the exact same issue. Only header row is updated similar errors:
2019-05-23 23:43:11,489 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 143, in export_file
last_updated = google_lookup_sync.export_lookup_file(lookup_name, None, None, spreadsheet_title, worksheet_name, session_key)
File "/data/splunk/etc/apps/google_drive/bin/google_drive_app/__init__.py", line 197, in export_lookup_file
return self.export_lookup_file_full_path(destination_full_path, namespace, owner, google_spread_sheet_name, worksheet_name, session_key, lookup_name=lookup_name)
File "/data/splunk/etc/apps/google_drive/bin/google_drive_app/__init__.py", line 264, in export_lookup_file_full_path
google_work_sheet.update_cell(row_number, col_number, value)
File "/data/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/models.py", line 445, in update_cell
self.client.put_feed(uri, ElementTree.tostring(feed))
File "/data/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/client.py", line 277, in put_feed
raise ex
HTTPError