Using JQ in python like using it through cli

Question

I have some cli commands that run through an api and then pass to jq like so

cat json.txt | jq '.members[] | [.name]

But now i am trying to do some logic in python and then pipe it out to jq, but i can't figure out how to do it even in a similar way to the above.

I read through the documentation for jq module in python, but i just can't get it to work, can someone please help me out with this?

user_997358 · Answer

After: pip3 install pyjq

the following runs without problems:

import pyjq
print(pyjq.all( ".members[] | [.name]", {"members": [ {"name": "foo"} ]} ))

Output:

[['foo']]

The documentation for pyjq is at https://pypi.org/project/pyjq/

Note in particular the url optional argument.

user_19182291 · Answer

import os

sd = os.system('cat json.txt | jq ".members[] | [.name]"')

print(sd)

user_12269857 · Answer

Using subprocess module:

import subprocess

cmd=["cat", "json.txt", "|", "jq", "'.members[]", "|", "[.name]"]
result = subprocess.check_output(cmd, shell=True)

print(result)