Jid – Drill down JSON data incrementally • Hacker News Board

    require 'json'
    require 'open-uri'

    data = JSON.load(open("https://api.github.com/users/Dorian"))

    data.keys
    data.first
    data["public_repos"]

etc.

Re: Jid – Drill down JSON data incrementally

#5

Post by Animats » Sat, Dec 03, 2016, 10:48 PM UTC

The JSON crowd is re-inventing LISP. Originally, JSON was a subset of what you could pass to "eval()". Yesterday, state machine programming in JSON. Today, an inspector.

Re: Jid – Drill down JSON data incrementally

#6

Post by asimjalis » Sat, Dec 03, 2016, 11:01 PM UTC

How can I use wildcards in queries?

For example consider this.

    echo '{"users":[{"name":"s1","id":1},{"name":"s2","id":2}]}'|jid

I can query users[0].id or users[1].id. How can I get all the ids? I tried users[*].id which didn’t work.

In Clojure I use specter [1] for this which is able to handle wildcards using ALL.

[1] https://github.com/nathanmarz/specter

Re: Jid – Drill down JSON data incrementally

#7

Post by bbrks » Sat, Dec 03, 2016, 11:18 PM UTC

asimjalis wrote: post #6

How can I use wildcards in queries? For example consider this. echo '{"users":[{"name":"s1","id":1},{"name":"s2","id":2}]}'|jid I can query users[0].id or users[1].id. How can I get all the ids? I tried users[*].id which didn’t work. In Clojure I use specter [1] for this which is able to handle wildcards using ALL. [1] https://github.com/nathanmarz/specter

jq uses empty square brackets as a way of accessing all of an arrays elements. Not sure if this tool uses the same syntax?

E.g. users[].id

Re: Jid – Drill down JSON data incrementally

#8

Post by fiatjaf » Sat, Dec 03, 2016, 11:19 PM UTC

Animats wrote: post #5

The JSON crowd is re-inventing LISP. Originally, JSON was a subset of what you could pass to "eval()". Yesterday, state machine programming in JSON. Today, an inspector.

Do you think that is bad?

Many people like LISP.

Re: Jid – Drill down JSON data incrementally

#9

Post by fiatjaf » Sat, Dec 03, 2016, 11:20 PM UTC

Does it use jq internally?

Re: Jid – Drill down JSON data incrementally

#10

Post by fiatjaf » Sat, Dec 03, 2016, 11:21 PM UTC

dorianm wrote: post #4

I personally like digging in a ruby console, e.g.: require 'json' require 'open-uri' data = JSON.load(open("https://api.github.com/users/Dorian")) data.keys data.first data["public_repos"] etc.

You personally like to suffer.

I used to do that in Python, but it is a pain. jq is great for these things, and jid seems to be also.