python 获取json接口数据写入influxdb(或telegraf)

当然还可以使用telegraf获取json接口更方便，但是没研究透他的tags就自己转化下

#!/usr/bin/python

# -*- coding: UTF-8 -*-
import time
import urllib2
import urllib
import json
import sys


#roomid=sys.argv[1]
#lag=sys.argv[2]


def http_get():
        #url='http://XXXX1:9090/api/v1/query?query=kube_pod_container_status_restarts_total%3E0&time=1523950678.451&_=1523950678355'
        url='http://XXXX:60007/kibana-intf/mts_api/get_online_num?username=xxx&password=xxx&channel=idc-third-ws.longzhu.com'
response = urllib.urlopen(url)
        return response.read()


ret = http_get()
json_dict = json.loads(ret)


for item in json_dict['data']:
        #print '%s' % item
        roomid  = item['room_id']
        online_num = item['online_num']
#print '%s %s'%(roomid,online_num)
dbreqdata =  "wangsu_online_num," + "roomid=" + str(roomid) + " online_num=" + str(online_num)
dbrequrl = "http://XXXXX:8086/write?db=wangsu_online_num"
dbreq= urllib2.Request(url = dbrequrl,data =dbreqdata)
urllib2.urlopen(dbreq)