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 4

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 1

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 0
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 1
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 2
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 1
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 1
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 0
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 0
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 0
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 1
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 1
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 0
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
```
2

jq < file.json

malathion · 2018-10-03 18:46:46 0
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 0
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 0
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 0
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 0
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 0
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 0
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 0
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 0
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 0
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 0
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 0
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

How much RAM is Apache using?

Display the amount of memory used by all the httpd processes. Great in case you are being Slashdoted!

list block devices

Shows all block devices in a tree with descruptions of what they are.

List the URLs of tabs of the frontmost Chrome window in OS X

This also works with Safari if you just change the application name. Replace $ window 1 with $ windows to list the URLs of tabs in all windows instead of only the frontmost window. This also includes titles: $ osascript -e{'set o to""','tell app"google chrome"','repeat with t in tabs of window 1','set o to o&url of t&"\n"&" "&title of t&"\n"',end,end}|sed \$d .

Copy the sound content of a video to an mp3 file

-vn removes tha video content, the copy option tells ffmpeg to use the same codec for generating the output

Convert control codes to visible Unicode Control Pictures

Converts control codes and spaces (ASCII code ≤ 32) to visible Unicode Control Pictures, U+2400 ? U+2420. Skips \n characters, which is probably a good thing.

Get me yesterday's date, even if today is 1-Mar-2008 and yesterday was 29-Feb-2008

Fool date by setting the timezone out by 24 hours and you get yesterday's date. Try TZ=XYZ-24 to get tomorrow's date. I live in TZ=GMT0BST so you might need to shift the number 24 by the hours in your timezone.

Convert CSV to JSON

Replace 'csv_file.csv' with your filename.

Get AWS temporary credentials ready to export based on a MFA virtual appliance

You might want to secure your AWS operations requiring to use a MFA token. But then to use API or tools, you need to pass credentials generated with a MFA token. This commands asks you for the MFA code and retrieves these credentials using AWS Cli. To print the exports, you can use: `awk '{ print "export AWS_ACCESS_KEY_ID=\"" $1 "\"\n" "export AWS_SECRET_ACCESS_KEY=\"" $2 "\"\n" "export AWS_SESSION_TOKEN=\"" $3 "\"" }'` You must adapt the command line to include: * $MFA_IDis ARN of the virtual MFA or serial number of the physical one * TTL for the credentials

Random quote from Borat -- no html parsing

Turns out smacie.com has a text file containing every single one of the borat quotes, each one on a newline. This makes it very convenient, as this can be done without any sed-parsing, and uses less bandwitdth! Note that borate quotes are quite offensive, much more so than "fortunes-off"!

Lists all usernames in alphabetical order

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