Why does Splunk Export to JSON give only strings?

[edwintom]

Hi,

When we try to export a stats table to JSON, the integer values are also represented as string in the JSON.

Example:

My query returns the below Json

{"preview":false,"result":{"URL":"/?-","SL":"0","cs_method":"GET","Average":"6.67","p90(time_taken)":"31","URLCount":"66"}}

The URLCount,p90(time_taken),Average and SL should be in Int

Expected Json

{"preview":false,"result":{"URL":"/?-","Swimlane":0,"cs_method":"GET","Average":6.67,"p90(time_taken)":31,"URLCount":66}}

can someone please let me know how can we achieve this?

Thanks,