Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: JSON Output format
Top Forums Shell Programming and Scripting JSON Output format Post 303034685 by stomp on Thursday 2nd of May 2019 09:31:15 AM
Old 05-02-2019
Quote:
Does this support sub level printing also?
Seems that this is easily possible too:

Code:
jq -r <data.json '.[] | [ (.id|tostring), .description, .path, .last_activity_at, .namespace.name ] |join(" | ") '

#output 

9 | short desc | test | 2019-02-25T10:25:29.771Z | ABCD-PDFF-PLATFORM-TEST-V1
6 |  | test | 2019-02-21T07:44:14.083Z | ABCD1
4 | Who | applabonboarding | 2019-02-19T13:17:22.321Z | ABCD

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

capturing output from top and format output

Hi all, I'd like to capture the output from the 'top' command to monitor my CPU and Mem utilisation.Currently my command isecho date `top -b -n1 | grep -e Cpu -e Mem` I get the output in 3 separate lines.Tue Feb 24 15:00:03 Cpu(s): 3.4% us, 8.5% sy .. .. Mem: 1011480k total, 226928k used, ....... (4 Replies)
Discussion started by: new2ss
4 Replies

2. Shell Programming and Scripting

Help in Getting specified output format

Hi all, I have input text file of this format objectclass:endeavor pid:12345 postalAddress:379 PROSPECT ST street:STE B l:TORRINGTON st:CT postalCode:067905238 telephoneNumber:9999999999... (2 Replies)
Discussion started by: pintoo
2 Replies

3. UNIX for Advanced & Expert Users

format df -k output

i am running df -k command on aix machine. i got the output like this. i need to store into file and send that file into microsoft excel.i need to allign properly. Filesystem 512 blocks Free % Used Iused %Iused Mounted on /dev/hd4 262144 126488 52% ... (9 Replies)
Discussion started by: wintercoat
9 Replies

4. Shell Programming and Scripting

Dynamic output file generation using a input text file with predefined output format

Hi, I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format. Example: File.txt AP|{SSHA}VEEg42CNCghUnGhCVg== APVG3|{SSHA}XK|"password" AP3|{SSHA}XK|"This is test" .... etc --------- test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies

5. Shell Programming and Scripting

perl code-sequence of json format

Hi All , Below is the perl code. from below code want to confirm one thing that wahtever the sequence of data we are passing through json format which contains 3 tuples of different sequences Eg: ParentID,SystemID,SendingTime,Time,ClientLocation,ClientID, ... (1 Reply)
Discussion started by: aish11
1 Replies

6. UNIX for Dummies Questions & Answers

How to format the output of df -h?

Hi, I need to format the output of the command "df -h": $ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/rootvg-lv01 271G 13G 245G 6% / tmpfs 16G 0 16G 0% /dev/shm /dev/sda1 97M 50M 43M 55% /boot /dev/mapper/d1vg-lv01 124G 105G 13G 90% /d0 I used awk: df -h |... (6 Replies)
Discussion started by: seafan
6 Replies

7. Shell Programming and Scripting

FORMAT output

Input File Symmetrix ID : 000192601507 Masking View Name : TS00P22_13E_1 Last updated at : 05:10:18 AM on Tue Mar 22,2011 Initiator Group Name : 10000000c960b9cd Host Initiators { WWN : 10000000c960b9cd WWN : 10000000c960b9dd } Port... (1 Reply)
Discussion started by: greycells
1 Replies

8. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

9. UNIX for Beginners Questions & Answers

Printing df -h output in json format

Hi All, i am trying to print the df -h ouput in json format. using below script. #!/usr/bin/env bash df -h > /tmp/sdf nawk '{print " "$1" "$2" "$3" "$4" "$5" "$6" "}' /tmp/sdf > /tmp/sdf1 nawk 'NR==1 { for (i=1; i<=NF; i++) { f = i }}{ print $(f), $(f), $(f), $(f), ... (2 Replies)
Discussion started by: sravani25
2 Replies

10. UNIX for Beginners Questions & Answers

How to convert any shell command output to JSON format?

Hi All, I am new to shell scripting, Need your help in creating a shell script which converts any unix command output to JSON format output. example: sample df -h command ouput : Filesystem size used avail capacity Mounted /dev/dsk/c1t0d0s0 8.1G 4.0G 4.0G 50% /... (13 Replies)
Discussion started by: balu1234
13 Replies

LEARN ABOUT FREEBSD

ppmtopgm

ppmtopgm(1)                                                   General Commands Manual                                                  ppmtopgm(1)

NAME

       ppmtopgm - convert a portable pixmap into a portable graymap

SYNOPSIS

       ppmtopgm [ppmfile]

DESCRIPTION

       Reads  a  portable  pixmap  as  input.  Produces a portable graymap as output.  The output is a "black and white" rendering of the original
       image, as in a black and white photograph.  The quantization formula used is .299 r + .587 g + .114 b.

       Note that although there is a pgmtoppm program, it is not necessary for simple conversions from pgm to ppm , because any  ppm  program  can
       read  pgm  (and  pbm  ) files automatically.  pgmtoppm is for colorizing a pgm file.  Also, see ppmtorgb3 for a different way of converting
       color to gray.  And ppmdist generates a grayscale image from a color image, but in a way that makes it easy to differentiate  the  original
       colors, not necessarily a way that looks like a black and white photograph.

QUOTE

       Cold-hearted orb that rules the night
       Removes the colors from our sight
       Red is gray, and yellow white
       But we decide which is right
       And which is a quantization error.

SEE ALSO

       pgmtoppm(1),ppmtorgb3(1),rgb3toppm(1),ppmdist(1),ppm(5),pgm(5)

AUTHOR

       Copyright (C) 1989 by Jef Poskanzer.

                                                                   10 April 2000                                                       ppmtopgm(1)
All times are GMT -4. The time now is 09:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy