I'm trying to work with the jsonfilter program included in the jsonpath project from Jo-Philipp (https://git.openwrt.org/?p=project/jsonpath.gi <https://git.openwrt.org/?p=project/jsonpath.git;a=summary>t)
Perhaps this is a failure on my part to understand the documentation provided by this referenced webpage: http://goessner.net/articles/JsonPath/ I'm trying to filter out parts of a json string while still retaining some structured identifying information. For example, lets say, hypothetically, I had some JSON string containing an array of objects, and I want only two key / value pairs to be returned. Let's use the result of "ubus call network.interface dump" as the example: This shell script > ubus call network.interface dump | jsonfilter -e '@.interface' | jsonfilter -e '@[@.up=true].interface' Will return the following, on my OpenWRT system: lan loopback wan wan6 wwan What I want to do is return a JSON string with this representation: [ { "interface" : "lan", "uptime" : 11111 }, ... ] E.g., I want to filter the json not down to a single value, but to a collection of key-value pairs by excluding items that don't match. So, based on the documentation that I've read, the expression might look something like this: > ubus call network.interface dump | jsonfilter -e '@.interface' | jsonfilter -e '@[@.up=true].[interface, uptime]' Of course, that syntax does not work, and so far the only use of the union operator in jsonfilter is like this expression, which returns all interfaces (e.g. either up OR not up) > ubus call network.interface dump | jsonfilter -e '@.interface' | jsonfilter -e '@[@.up=true, @.up=false].interface' I can't find any examples (beyond one or two very simplistic examples) of how to use the jsonfilter program on stackoverflow, nor the OpenWRT mailing list, nor the OpenWRT Discourse I'm quite reluctant to do multiple processing sweeps. E.g. the following (probably syntax-error-full, and erroneous output) shell script is extremely unattractive json=`ubus call network.interface dump | jsonfilter -e '@.interface'` echo '[' for itf in $(echo $json | jsonfilter -e '@[@.up=true].interface') do echo "{ \"interface\" : \"$itf\" , \"uptime\" : $(echo $json | jsonfilter -e "@[@.interface=$itf].uptime") }," # Oh look, an unconditional trailing comma... that won't parse until JSON5... done echo ']' Of course, the json string that I'm trying to manipulate is not coming from "ubus call network.interface dump", it's from a third party program that can't be modified, I'm only using the ubus JSON as an example to illustrate the general concept of what I'm asking for. Is this something that jsonfilter is capable of doing at all? Or am I having a fundamental misunderstanding of the program's capabilities?
_______________________________________________ openwrt-devel mailing list openwrt-devel@lists.openwrt.org https://lists.openwrt.org/mailman/listinfo/openwrt-devel
