Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Parse property from json file
Top Forums UNIX for Beginners Questions & Answers Parse property from json file Post 303042435 by 7adi on Tuesday 24th of December 2019 10:22:34 AM
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)

Code:
https://www.test.com, setting:1
https://www.example.com, setting:1
https://www.abc123.io, setting:2
https://www.facebook.com, setting:2
http://www.youtube.com, setting:1

Last edited by Scrutinizer; 12-24-2019 at 02:35 PM.. Reason: quote tags -> code tags
 

9 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

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

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

7. 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

8. 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

9. 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

LEARN ABOUT MOJAVE

json

json(n) 							       JSON								   json(n)

__________________________________________________________________________________________________________________________________________________

NAME

       json - JSON parser

SYNOPSIS

       package require Tcl  8.4

       package require json  ?1.1?

       ::json::json2dict txt

_________________________________________________________________

DESCRIPTION

       The json package provides a simple Tcl-only library for parsing the JSON http://www.json.org/ data exchange format as specified in RFC 4627
       http://www.ietf.org/rfc/rfc4627.txt.  There is some ambiguity in parsing JSON because JSON has type information that is not  maintained	by
       the Tcl conversion.  The json package returns data as a Tcl dict.  Either the dict package or Tcl 8.5 is required for use.

COMMANDS

       ::json::json2dict txt
	      Parse JSON formatted text txt into a Tcl dict and return the value.

EXAMPLES

       An example of a JSON array converted to Tcl.  A JSON array is returned as a single item with multiple elements.

       [
	   {
	      "precision": "zip",
	      "Latitude":  37.7668,
	      "Longitude": -122.3959,
	      "Address":   "",
	      "City":	   "SAN FRANCISCO",
	      "State":	   "CA",
	      "Zip":	   "94107",
	      "Country":   "US"
	   },
	   {
	      "precision": "zip",
	      "Latitude":  37.371991,
	      "Longitude": -122.026020,
	      "Address":   "",
	      "City":	   "SUNNYVALE",
	      "State":	   "CA",
	      "Zip":	   "94085",
	      "Country":   "US"
	   }
       ]
       =>
       {Country US Latitude 37.7668 precision zip State CA City {SAN FRANCISCO} Address {} Zip 94107 Longitude -122.3959} {Country US Latitude 37.371991 precision zip State CA City SUNNYVALE Address {} Zip 94085 Longitude -122.026020}

       An example of a JSON object converted to Tcl.  A JSON object is returned as a multi-element list (a dict).

       {
	   "Image": {
	       "Width":  800,
	       "Height": 600,
	       "Title":  "View from 15th Floor",
	       "Thumbnail": {
		   "Url":    "http://www.example.com/image/481989943",
		   "Height": 125,
		   "Width":  "100"
	       },
	       "IDs": [116, 943, 234, 38793]
	   }
       }
       =>
       Image {IDs {116 943 234 38793} Thumbnail {Width 100 Height 125 Url http://www.example.com/image/481989943} Width 800 Height 600 Title {View from 15th Floor}}

BUGS, IDEAS, FEEDBACK
       This  document, and the package it describes, will undoubtedly contain bugs and other problems.	Please report such in the category json of
       the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you  may  have  for
       either package and/or documentation.

KEYWORDS

       data exchange, exchange format, javascript, json

CATEGORY

       CGI programming

COPYRIGHT

       Copyright (c) 2006 ActiveState Software Inc., 2009 Thomas Maeder, Glue Software Engineering AG

json									1.1								   json(n)
All times are GMT -4. The time now is 05:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy