Ad Widget

**dmarsh** · 17-01-2021, 17:07

I'm struggling with this problem as well. I asked a question in stack overflow on how to do this with json files:

https://stackoverflow.com/questions/...le-as-a-source

**dmarsh** · 02-02-2021, 06:37

This is what I'm doing:

dump proxy and preservekeys and save to proxy.keys.json

Code:

obj = zapi.proxy.get(
    preservekeys=True,
    output=('host',),
    limit=1000,
)

dump items from host to hosts.json

run jq:

Code:

jq 'input as { $proxies } | .hosts[] |= . + { proxy_host: $proxies[.proxy_hostid].host }' hosts.json proxies.keys.json > hosts_and_proxyname.json

Depending on the json, you might need to make .hosts[] just .[]

Anyway, hope that helps

Host.get can only get proxy_hostid of proxy can not get name host?