topic Re: Google Sheet import/export app in All Apps and Add-ons

Google Sheet import/export app

pablo_sanchez — Wed, 13 May 2020 22:38:35 GMT

Wanted to ask the following, hopefuly getting an answer from Luke M. but anybody else's comment is appreciated.

So I've installed the 'Google Import/Export' app (https://splunkbase.splunk.com/app/2630) and it's working pretty good for what is intended.
I am able to export data from Splunk to Google Sheets.
The problem I am facing is that when exporting a lookup table from Splunk which contains numbers, the numbers go to the google sheet as strings.
For example, if the number was a 15 in the lookup table, when it shows up in Sheets it will be '15. And sheets is treating it as a string.

Is there a recommendation on how to get around that?

Re: Google Sheet import/export app

LukeMurphey — Thu, 14 May 2020 17:14:56 GMT

I think it would take a feature request to make that work. The library I am using in the app treats everything as strings. I might be able to add something that detects if the string could be a number and then convert it accordingly.

Feature request created here: https://lukemurphey.net/issues/2739

Re: Google Sheet import/export app

pablo_sanchez — Thu, 14 May 2020 19:06:32 GMT

Thanks Luke. We will request it. We will be using it more if that's the case.

Re: Google Sheet import/export app

pablo_sanchez — Thu, 14 May 2020 22:08:34 GMT

Is there an specific way to submit a feature request for your app?
Dont think it has to be done through Splunk Support Portal, is it?
Please advise.

Re: Google Sheet import/export app

LukeMurphey — Thu, 14 May 2020 22:13:42 GMT

I opened one here: https://lukemurphey.net/issues/2739

I'll update the answer accordingly.

Re: Google Sheet import/export app

pablo_sanchez — Thu, 14 May 2020 22:29:03 GMT

Much appreciated!