Commands tagged json sorted by votes

Commands tagged json (45)

sorted by

Validate and pretty-print JSON expressions.

You can use a site like http://www.jsonlint.com/ or use the command line to validate your long and complex json data. This is part of the simplejson package for python http://undefined.org/python/#simplejson. Wrong json expression example: echo '{ 1.2:3.4}' | python -m simplejson.tool Expecting property name: line 1 column 2 (char 2) Show Sample Output
This is sample output - yours may be different.
```
{
    "json": "obj"
}
```
14

echo '{"json":"obj"}' | python -m simplejson.tool

azeey · 2009-05-10 13:58:05 17

Validates and pretty-prints the content fetched from the URL. Show Sample Output

This is sample output - yours may be different.

[
    {
        "d": "22 Useful Online Chart & Graph Generators | Tools", 
        "dt": "2010-03-24T00:00:00Z", 
        "t": [
            "charts", 
            "tools", 
            "chart", 
            "generator", 
            "graph", 
            "online", 
            "graphs", 
            "web", 
            "design", 
            "webdesign"
        ], 
        "u": "http://www.hongkiat.com/blog/22-useful-chart-graph-diagram-generators/"
    }, 
    {
        "d": "Official Google Data APIs Blog: Bringing OpenID and OAuth Together", 
        "dt": "2010-03-24T00:00:00Z", 
        "t": [
            "openid", 
            "oauth", 
            "google", 
            "identity", 
            "security", 
            "authentication", 
            "api", 
            "plaxo", 
            "protocol", 
            "data"
        ], 
        "u": "http://googledataapis.blogspot.com/2009/01/bringing-openid-and-oauth-together.html"
    }, 
    {
        "d": "Great Girl Manipulations by Digital Artist Michael O. | Abduzeedo - design inspiration and tutorials", 
        "dt": "2010-03-24T00:00:00Z", 
        "t": [
            "photoshop", 
            "art", 
            "photography", 
            "inspiration", 
            "design", 
            "photos", 
            "women", 
            "blog", 
            "awesome", 
            "cool"
        ], 
        "u": "http://abduzeedo.com/great-girl-manipulations-digital-artist-michael-o"
    }, 
    {
        "d": "Nightline Face-Off - ABC News", 
        "dt": "2010-03-24T00:00:00Z", 
        "t": [
            "debate", 
            "satan", 
            "theology", 
            "video", 
            "driscoll", 
            "news", 
            "education", 
            "religion", 
            "faceoff", 
            "television"
        ], 
        "u": "http://www.abcnews.go.com/Nightline/FaceOff/"
    }, 
    {
        "d": "How Twitter and Facebook Make Us More Productive | Magazine", 
        "dt": "2010-03-24T00:00:00Z", 
        "t": [
            "twitter", 
            "facebook", 
            "productivity", 
            "socialmedia", 
            "creativity", 
            "wired", 
            "research", 
            "social", 
            "socialnetworking", 
            "work"
        ], 
        "u": "http://www.wired.com/magazine/2010/02/st_essay_distraction/"
    }
]

curl -s "http://feeds.delicious.com/v2/json?count=5" | python -m json.tool | less -R

keimlink · 2010-03-24 09:15:12 24

Convert JSON to YAML

Show Sample Output
This is sample output - yours may be different.
```
Note: you need Ruby 1.9 or better
```
11

ruby -ryaml -rjson -e 'puts YAML.dump(JSON.parse(STDIN.read))' < file.json > file.yaml

wejn · 2013-04-24 07:20:37 128
Convert JSON to YAML

Convert JSON to YAML. Note that you'll need to have PyYaml installed.
This is sample output - yours may be different.
9

python -c 'import sys, yaml, json; yaml.safe_dump(json.load(sys.stdin), sys.stdout, default_flow_style=False)' < file.json > file.yaml

tebeka · 2013-04-24 00:31:39 94
Simple colourized JSON formatting for BASH

Leave out pygmentize or `pip install pygments` first. Show Sample Output
This is sample output - yours may be different.
```
$ curl -s http://api.openweathermap.org/data/2.5/weather?q=Amsterdam,nl | pp

# this output is colourized
{
    "base": "cmc stations",
    "clouds": {
        "all": 20
    },
    "cod": 200,
    "coord": {
        "lat": 52.37,
        "lon": 4.89
    }
    /* ... */
}
```
5

alias pp='python -mjson.tool|pygmentize -l js'

wires · 2014-05-22 10:29:44 11
Convert YAML to JSON

Converts YAML file to JSON. Note that you'll need to install PyYAML. Also some YAML data types (like dates) are not supported by JSON).
This is sample output - yours may be different.
4

python -c 'import sys, yaml, json; json.dump(yaml.load(sys.stdin), sys.stdout, indent=4)' < file.yaml > file.json

tebeka · 2013-04-24 00:28:55 117
Convert CSV to JSON

Replace 'csv_file.csv' with your filename.
This is sample output - yours may be different.
4

python -c "import csv,json;print json.dumps(list(csv.reader(open('csv_file.csv'))))"

malathion · 2017-05-17 19:35:53 39
Get a diff of two json arrays

jq is amazing for manipulating json on the commandline, but the developers have some weird ideas about how to handle shell redirections. This command works around them. Further reading: https://github.com/stedolan/jq/issues/1110
This is sample output - yours may be different.
4

diff <(jq . -M -S < old.json) <(jq . -M -S < new.json)

malathion · 2018-10-11 20:59:48 491
Google voice recognition "API"

The FLAC audio must be encoded at 16000Hz sampling rate (SoX is your friend). Outputs a short JSON string, the actual speech is in the hypotheses->utterance, the accuracy is stored in hypotheses->confidence (ranging from 0 to 1). Google also accepts audio in some special speex format (audio/x-speex-with-header-byte), which is much smaller in comparison with losless FLAC, but I haven't been able to encode such a sample. Show Sample Output
This is sample output - yours may be different.
```
{"status":0,"id":"7c5893bbf1eb378686bdf3aa369f1a44-1","hypotheses":[{"utterance":"hello world","confidence":0.6340324}]}
```
3

wget -q -U "Mozilla/5.0" --post-file speech.flac --header="Content-Type: audio/x-flac; rate=16000" -O - "http://www.google.com/speech-api/v1/recognize?lang=en-us&client=chromium"

sairon · 2011-03-08 13:39:01 5
Display disk partition sizes

It is the same but more faster real 0m0,007s user 0m0,011s sys 0m0,000s with my solution real 0m0,038s user 0m0,044s sys 0m0,000s with your solution :) Show Sample Output
This is sample output - yours may be different.
```
NAME	SIZE
loop0	55,5M
loop1	55,5M
loop2	42,2M
loop3	43,3M
loop4	18,4M
loop5	61,9M
loop6	18,4M
loop7	61,9M
sda	55,9G
sdb	298,1G
sr0	1024M
```
3

lsblk | grep -v part | awk '{print $1 "\t" $4}'

gecco · 2022-01-11 13:31:04 268
Colorized JSON pretty printing

Uses pygmentize and python to create indented and colorized JSON output Show Sample Output
This is sample output - yours may be different.
```
curl -s http://www.reddit.com/.json | pp
```
2

alias pp='python -mjson.tool | pygmentize -l javascript'

wires · 2012-10-16 13:55:38 22
Get your outgoing IP address
This is sample output - yours may be different.
2

curl -s httpbin.org/ip | jq -r .origin

tebeka · 2016-08-11 04:20:48 15
Convert YAML to JSON

* Output is jq compatible * Output is single lines - unix compatible * Multiple files supported
This is sample output - yours may be different.
2

perl -MYAML::XS=LoadFile -MJSON::XS=encode_json -e 'for (@ARGV) { for (LoadFile($_)) { print encode_json($_),"\n" } }' *.yaml

bsb · 2017-11-17 09:33:56 40
Convert tab separate file (TSV) to JSON with jq

With this command you can convert a tab separate file (TSV) into a JSON file with jq. For example, this input.tsv i-0b9adca882e5e6326 172.16.0.188 i-088dd69e5c3624888 172.16.0.102 i-0e70eac180537d4aa 172.16.0.85 will produce the showed output. Show Sample Output
This is sample output - yours may be different.
```
[
  {
    "id": "i-0b9adca882e5e6326",
    "ip": "172.16.0.188"
  },
  {
    "id": "i-088dd69e5c3624888",
    "ip": "172.16.0.102"
  },
  {
    "id": "i-0e70eac180537d4aa",
    "ip": "172.16.0.85"
  }
]
```
2

cat input.tsv | jq --raw-input --slurp 'split("\n") | map(split("\t")) | .[0:-1] | map( { "id": .[0], "ip": .[1] } )'

nordri · 2019-10-01 10:52:35 323
Convert CSV to JSON with miller

Using the csv tool `miller` you can transform a csv file into a json array of objects, where the properties are the values of the csv header line and the values are the values of the subsequent lines. Show Sample Output
This is sample output - yours may be different.
```
[
 { "H1": "a1", "H2": "a2", "H3": "a3" },
 { "H1": "b1", "H2": "b2", "H3": "b3" },
 { "H1": "c1", "H2": "c2", "H3": "c3" }
]
```
2

mlr --c2j --jlistwrap cat file.csv

pepa65 · 2019-12-06 07:16:58 160
Display disk partition sizes

Use lsbk (list block) and jq (to manipulate a JSON on the command line) to display partition information: Show Sample Output
This is sample output - yours may be different.
```
["loop0","55.5M"]
["loop1","156M"]
["loop2","32.3M"]
["zram0","4G"]
["nvme0n1","476.9G"]
```
2

lsblk --json | jq -c '.blockdevices[]|[.name,.size]'

mikhail · 2021-12-22 22:31:07 306
Google dictionary of word definitions

wget -qO - "http://www.google.com/dictionary/json?callback=dict_api.callbacks.id100&q=steering+wheel&sl=en&tl=en&restrict=pr,de&client=te" this does the actual google dictionary query, returns a JSON string encapsulated in some fancy tag sed 's/dict_api\.callbacks.id100.//' here we remove the tag beginning sed 's/,200,null)//' and here the tag end There are also some special characters which could cause problems with some JSON parsers, so if you get some errors, this is probably the case (sed is your friend). I laso like to trim the "webDefinitions" part, because it (sometimes) contains misleading information. sed 's/\,\"webDefinitions.*//' (but remember to append a "}" at the end, because the JSON string will be invalid) The output also contains links to mp3 files with pronounciation. As of now, this is only usable in the English language. If you choose other than English, you will only get webDefinitions (which are crap).
This is sample output - yours may be different.
1

wget -qO - "http://www.google.com/dictionary/json?callback=dict_api.callbacks.id100&q=steering+wheel&sl=en&tl=en&restrict=pr,de&client=te" | sed 's/dict_api\.callbacks.id100.//' | sed 's/,200,null)//'

sairon · 2011-03-08 15:00:39 17
sort a JSON blob

For situations where you keep JSON in a VCS and you want your diffs to be sane, such as within a Chef configuration repo.
This is sample output - yours may be different.
1

cat foo.json | python -mjson.tool

jeffgage · 2013-05-06 20:11:05 1489
Convert JSON to YAML

You need to install the Catmandu Perl module via `cpanm Catmandu`
This is sample output - yours may be different.
1

catmandu convert JSON to YAML < file.json > file.yaml

unixmonkey73469 · 2014-02-25 08:27:05 12
Convert JSON to YAML

This is based on __unixmonkey73469__ answer. You will need to supply `--multiline 1` option to JSON importer if your .json is multiline (i.e. it was prettyfied) And you still need catmandu installed via `cpanm Catmandu`
This is sample output - yours may be different.
1

catmandu convert JSON --multiline 1 to YAML < file.json > file.yaml

pavelkaroukin · 2014-09-29 16:45:24 11
Convert JSON to YAML (unicode safe)

If you tried the other Python version of Convert JSON to YAML and you end up with lines that has "!!python/unicode", this version of the command is for you.
This is sample output - yours may be different.
1

python -c 'import sys, yaml, json; yaml.safe_dump(json.load(sys.stdin), sys.stdout, allow_unicode=True)' < foo.json > foo.yaml

renoirb · 2015-01-20 15:58:29 7
Convert CSV to JSON - Python3 and Bash function

Based / Inspired by malathion's below command http://www.commandlinefu.com/commands/view/20528/convert-csv-to-json Is written for python3 and is very easy to use csv2json *csv will convert all files ending in csv to json eg csv2json file.csv will output a file to file.json Validity of json tested in python3 and below site https://jsonformatter.curiousconcept.com/
This is sample output - yours may be different.
1

csv2json() { for file in $@; do python -c "import csv,json,fileinput; print(json.dumps(list(csv.reader(fileinput.input()))))" "$file" 1> "${file%%csv}json"; done; }

snipertyler · 2017-06-28 04:28:32 16
use jq to validate and pretty-print json output

the `jq` tool can also be used do validate json files and pretty print output `cat file.json | jq` available on several platforms, including newer debian-based systems via `#sudo apt install jq`, mac via `brew install jq`, and from source https://stedolan.github.io/jq/download/ Show Sample Output
This is sample output - yours may be different.
```
success:
{
  "foo": "bar"
}

error:
$ echo '{"foo":{"bar":}}'| jq
parse error: Unmatched '}' at line 1, column 15
```
1

cat file.json | jq

daemeon · 2018-10-01 23:05:27 517
Use jq to validate and pretty-print json output

The `jq` tool can also be used do validate json files and pretty print output: ` jq < file.json` Available on several platforms, including newer debian-based systems via `#sudo apt install jq`, mac via `brew install jq`, and from source https://stedolan.github.io/jq/download/ This alternative to the original avoids the useless use of cat Show Sample Output
This is sample output - yours may be different.
```
success:
{
  "foo": "bar"
}

error:
$ jq < file.json
parse error: Unmatched '}' at line 1, column 15
```
1

jq < file.json

malathion · 2018-10-03 18:46:46 451
Get number of diggs for a news URL
This is sample output - yours may be different.
0

curl -s "http://services.digg.com/stories?link=$NEWSURL&appkey=http://www.whatever.com&type=json" | python -m simplejson.tool | grep diggs

jyro · 2009-08-24 08:49:20 4
1 2 >

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands

Check These Out

Are the two lines anagrams?

This works by reading in two lines of input, turning each into a list of one-character matches that are sorted and compared.

Create a mirror of a local folder, on a remote server

Create a exact mirror of the local folder "/root/files", on remote server 'remote_server' using SSH command (listening on port 22) (all files & folders on destination server/folder will be deleted)

diff two svn repos ignoring spaces,tabs and svnfiles

creeate file named after actual date

Create a file with actual date as filename

a function to create a box of '=' characters around a given string.

First argument: string to put a box around. Second argument: character to use for box (default is '=') Same as command #4948, but shorter, and without the utility function.

list files recursively by size

Change the From: address on the fly for email sent from the command-line

It's very common to have cron jobs that send emails as their output, but the From: address is whatever account the cron job is running under, which is often not the address you want replies to go to. Here's a way to change the From: address right on the command line. What's happening here is that the "--" separates the options to the mail client from options for the sendmail backend. So the -f and -F get passed through to sendmail and interpreted there. This works on even on a system where postfix is the active mailer - looks like postfix supports the same options. I think it's possible to customize the From: address using mutt as a command line mailer also, but most servers don't have mutt preinstalled.

List docker volumes by container

Ergo browsing 'pacman' queries (Arch)

Alternative1 (grep support): pacman -Ss python | paste - - | grep --color=always -e '/python' | less -R Alternative2 (eye-candy, no grep): pacman --color=always -Ss "python" | paste - - | less -R in ~/.bashrc: pkg-grep() { pacman -Ss "$1" | paste - - | grep --color=always -e "${2:-$1}" | less -R ; } pkg-search() { pacman --color=always -Ss "python" | paste - - | less -R; }

Join lines

Even shorter. Stolen from comment posted by eightmillion.

Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for:

» all commands
» commands with 3 up-votes (commandlinefu3)
» commands with 10 up-votes (commandlinefu10)
» commands tagged json

Commands tagged json (45) the last day the last week the last month all time sorted by date votes

What's this?

Check These Out

Stay in the loop…

Commands tagged json (45)

sorted by