I have created datasource for Json data.Trying to create table view to render the data.But data is not showing up
Here is sample code which I am trying -
index.py
#! /usr/local/bin/python
-- coding: utf-8 --
from calendar import timegm
from datetime import datetime
import _strptime # https://bugs.python.org/issue7980
from flask import Flask, request, jsonify
app = Flask(name)
app.debug = True
def convert_to_time_ms(timestamp):
return 1000 * timegm(datetime.strptime(timestamp, ‘%Y-%m-%dT%H:%M:%S.%fZ’).timetuple())
@app.route(’/’)
def health_check():
return ‘This datasource is healthy.’
@app.route(’/search’, methods=[‘POST’])
def search():
return jsonify([‘my_series’, ‘another_series’])
@app.route(’/query’, methods=[‘POST’])
def query():
req = request.get_json()
print(req)
data = [
{
“columns”:[
{“text”:“Country”,“type”:“string”},
{“text”:“Number”,“type”:“number”}
],
“rows”:[
[“SE”,123],
[“DE”,231],
[“US”,321]
],
“type”:“table”
}
]
return jsonify(data)
if name == ‘main’:
app.run(host=“0.0.0.0”)
Response in query inspector
{
“xhrStatus”: “complete”,
“request”: {
“method”: “POST”,
“url”: “api/datasources/proxy/7/query”,
“data”: {
“requestId”: “Q114”,
“timezone”: “”,
“panelId”: 2,
“dashboardId”: 7,
“range”: {
“from”: “2019-08-20T02:48:02.906Z”,
“to”: “2019-08-20T08:48:02.906Z”,
“raw”: {
“from”: “now-6h”,
“to”: “now”
}
},
“interval”: “30s”,
“intervalMs”: 30000,
“targets”: [
{
“target”: “my_series”,
“refId”: “A”,
“type”: “table”
}
],
“maxDataPoints”: 604,
“scopedVars”: {
“__interval”: {
“text”: “30s”,
“value”: “30s”
},
“__interval_ms”: {
“text”: “30000”,
“value”: 30000
}
},
“startTime”: 1566290882912,
“rangeRaw”: {
“from”: “now-6h”,
“to”: “now”
},
“adhocFilters”: [],
“endTime”: 1566290882947
}
},
“response”: [
{
“columns”: [
{
“text”: “Country”,
“type”: “string”
},
{
“text”: “Number”,
“type”: “number”
}
],
“rows”: [
[
“SE”,
123
],
[
“DE”,
231
],
[
“US”,
321
]
],
“type”: “table”
}
]
}