Parse property from json file


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Parse property from json file
# 1  
Old 12-24-2019
Parse property from json file

Hello All,


Greetings..


I have a json file that I need to pase its URLs and other values.
The match should start with "notifications" and output URLs and settings values.


I tried with python or awk but hardly could get URLs only. Or whole URLs from full json file. Could not match with property notifications.



I prefer awk, sed, grep, perl. For macOS using bash shell.




Code:
"notifications":{"https://www.test.com:80,*":{"last_modified":"13219862418447583","setting":1},"https://www.example.com:443,*":{"last_modified":"13219862407099344","setting":1},"https://123abc.io:443,*":{"last_modified":"13219957709135648","setting":2},"https://www.facebook.com:443,*":{"last_modified":"13219934734073706","setting":2},"http://www.youtube.com:443,*":{"last_modified":"13219862410929224","setting":1}}

The output would be something like below (full URL/ short URL & settings)


Last edited by Scrutinizer; 12-24-2019 at 02:35 PM.. Reason: quote tags -> code tags
# 2  
Old 12-25-2019
I tried using grep that gives me all URLs that is present in json file.


How could I stop matching to property notifications and its values?
"notifications":{{ ...... }}


Code:
grep '"notifications"' sample2.txt | grep -Eo '(https?)://[-A-Za-z0-9\+&@#/%?=~_|!.;]*[-A-Za-z0-9\+&@#/%=~_|]'

I am thinking to output all values between "notifications" and "}}" then look for URLs and settings values. Is that correct approach?
# 3  
Old 12-25-2019
FYI, many of us "everyday JSON slingers" here do not process JSON files and JSON API output with grep, awk and sed, etc.

We process JSON with JSON processing tools.

Some use Javascript, PHP and Python (like me) and the built-in JSON processing or libs available, others here use "sed-like" jq.

Code:
https://stedolan.github.io/jq/

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash script - cygwin (powershell?) pull from GitHub API Parse JSON

All, Have a weird issue where i need to generate a report from GitHub monthly detailing user accounts and the last time they logged in. I'm using a windows box to do this (work issued) and would like to know if anyone has any experience scripting for GitAPI using windows / cygwin / powershell?... (9 Replies)
Discussion started by: ChocoTaco
9 Replies

2. Shell Programming and Scripting

URL extraction from JSON file

I'm trying to export URLs from within a JSON file which in turn resulted from export of Mozilla-Firefox bookmarks. Its single line file with below given values from awk $ awk 'END { print NR }' bookmarks.json 1 $ awk 'END { print NF }' bookmarks.json 2706 $ awk -F, 'END { print NF }'... (6 Replies)
Discussion started by: busyboy
6 Replies

3. Shell Programming and Scripting

Property file processing in unix

Hi genius, Following is the problem. We have one templete file(input file) where some variables will be used Example: word1 word2 &{word3} word4 ${word5} word6 And also we have one property file where we define these variables Example: word3= something Word5= something Need to read... (5 Replies)
Discussion started by: gjarms
5 Replies

4. Shell Programming and Scripting

reading and updating property file

I have to do a read operation for a field in property file, which looks like follows: 123|xyz|datetime|count '|' is delimiter. Finally I managed to read the contents of property file using statement like cut -d"|" -f1 $PROPERTIES_FILE | tr '\n' ' ' <-- Reading first column But now I... (2 Replies)
Discussion started by: rakeshranjanscs
2 Replies

5. Shell Programming and Scripting

Reading a property file through shell script???

Hi! i need a script that can read a property file. i.e., A script to read a "property" from property file. Read the property value and based on value of property, decide whether to start the some dataload activity or not. Its urngent. Can anyone help me out???:( (7 Replies)
Discussion started by: sukhdip
7 Replies

6. Shell Programming and Scripting

Report a missing property and property value mis match script.

Hi All, I have 2 properties files - one is a master templete and other one is a node specific properties file, I need to comapre these 2 properties files and make sure the node Specific properties file contains all the properties in the master temple properties file else report the missing... (5 Replies)
Discussion started by: jayka
5 Replies

7. Shell Programming and Scripting

change word in a property file

Hi, I have a property file called "inspector.properties". In this property file stands the following: inspect=ON Now I want to have a shell script that when you run it, changes the ON in OFF in this property file. Is this possible with sed? Can anybody help me with this? Tnx very much. (5 Replies)
Discussion started by: thebladerunner
5 Replies

8. Shell Programming and Scripting

perl use property file for variables

if I have a file that contains variables. How do I assign them in a script. file p=c e=g Thanks (3 Replies)
Discussion started by: 3junior
3 Replies

9. Shell Programming and Scripting

source a property file in script give error

I have sourced a property file in my script like this to load some variables in the script Then i am able to echo all the property file values inside script but the script is not able to recognize other unix commands #!/bin/bash . build.properties mkdir build i am getting error ... (3 Replies)
Discussion started by: codeman007
3 Replies
Login or Register to Ask a Question