Просмотр кода страницы Zabbix. Task. Getting JSON with ONE variable

[[Категория:Zabbix]]
[[Категория:Python]]
[[Категория:Bash]]

= Description =
Getting JSON with ONE variable ('''{#MIKROTIKIP}''') for putting it to autodiscoverable Items and Triggers.

= Configuring =

=== Bash ===

==== Input data ====
We have array '''${arrayHostIps[]}''', which contains: '''"192.168.14.8 192.168.4.8 192.168.59.8"'''

It's necassary to convert it to JSON and to put it to zabbix for Items and Triggers creating.

==== Script ====
 hostIps=$(for i in "${arrayHostIps[@]}"; do echo $i; done)
 echo "$hostIps" | /usr/bin/awk 'BEGIN { printf "{\"data\": ["; } { if (NR != 1) printf ","; printf "{\"{#MIKROTIKIP}\": \"%s\"}", $1; } END { printf "]}"; }'

==== Output ====
     ...
     {"data": [{"{#MIKROTIKIP}": "192.168.14.8"},{"{#MIKROTIKIP}": "192.168.4.8"},{"{#MIKROTIKIP}": "192.168.59.8"}]}
     ...    

=== Python ===

==== Source JSON ====
 [{'TYPE': 'cloud', 'CONFIG_ID': '2', 'REG_ID': '77300', 'SERVER': 'sip.novofon.com', 'LOGIN': '111111', 'PASSWORD': 'PassWord#1', 'AUTH_USER': '111111', 'OUTBOUND_PROXY': <nowiki>''</nowiki>, 'DETECT_LINE_NUMBER': 'N', 'LINE_DETECT_HEADER_ORDER': 'diversion;to', 'REGISTRATION_STATUS_CODE': '200', 'REGISTRATION_ERROR_MESSAGE': <nowiki>''</nowiki>, 'TITLE': 'zadarma-74732000274'}, {'TYPE': 'cloud', 'CONFIG_ID': '4', 'REG_ID': '77481', 'SERVER': 'vpbx400170172.mangosip.ru', 'LOGIN': '222222', 'PASSWORD': 'PassWord#2', 'AUTH_USER': '222222', 'OUTBOUND_PROXY': <nowiki>''</nowiki>, 'DETECT_LINE_NUMBER': 'N', 'LINE_DETECT_HEADER_ORDER': 'diversion;to', 'REGISTRATION_STATUS_CODE': '200', 'REGISTRATION_ERROR_MESSAGE': <nowiki>''</nowiki>, 'TITLE': 'mango-78005003377'},'''<...>''']

==== Script ====
<syntaxhighlight lang="python3">
from bitrix24 import *
import json

# base bxApi request with url
bxApi = Bitrix24('https://alefstudio.bitrix24.ru/rest/140/3dn54rm3n2d08bu4/')

sipResponse = bxApi.callMethod('voximplant.sip.get')

# create raw empty list of ips
trunksNamesListRaw = []

# debug
#print(sipResponse)

# for each trunk full info
for a in range(len(sipResponse)):
    trunkFull = (sipResponse[a])

    # debug
    #print(json.dumps(trunkFull['TITLE']).strip('"'))

    trunkName = (json.dumps(trunkFull['TITLE']).strip('"'))

    # put ip to raw list
    trunksNamesListRaw.append(trunkName)

# null string list of ips
trunksNamesListJsonForZabbix = ""

# add str data to str json

trunksNamesListJsonForZabbix = (trunksNamesListJsonForZabbix + "{\"data\":[")

for x in range(len(trunksNamesListRaw)):
    trunksNamesListJsonForZabbix = (trunksNamesListJsonForZabbix + "{\"{#TRUNKNAME}\"" + ":" + "\"" + trunksNamesListRaw[
        x] + "\"" + "}")

    if not x == len(trunksNamesListRaw) - 1:
        trunksNamesListJsonForZabbix = (trunksNamesListJsonForZabbix + ",")

trunksNamesListJsonForZabbix = (trunksNamesListJsonForZabbix + "]}")

# json of ips to output
print(trunksNamesListJsonForZabbix)
</syntaxhighlight>

==== Output ====
 {"data":[{"{#TRUNKNAME}":"zadarma-74732000274"},{"{#TRUNKNAME}":"mango-78005003377"},'''<...>''']}