All Apps and Add-ons

Google Sheet import/export app

pablo_sanchez
New Member

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?

0 Karma
1 Solution

LukeMurphey
Champion

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

View solution in original post

0 Karma

LukeMurphey
Champion

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

0 Karma

pablo_sanchez
New Member

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

0 Karma

pablo_sanchez
New Member

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.

0 Karma

LukeMurphey
Champion

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

I'll update the answer accordingly.

0 Karma

pablo_sanchez
New Member

Much appreciated!

0 Karma
Get Updates on the Splunk Community!

Splunk Platform | Upgrading your Splunk Deployment to Python 3.9

Splunk initially announced the removal of Python 2 during the release of Splunk Enterprise 8.0.0, aiming to ...

From Product Design to User Insights: Boosting App Developer Identity on Splunkbase

co-authored by Yiyun Zhu & Dan Hosaka Engaging with the Community at .conf24 At .conf24, we revitalized the ...

Detect and Resolve Issues in a Kubernetes Environment

We’ve gone through common problems one can encounter in a Kubernetes environment, their impacts, and the ...