Sponsored Content
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)


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
Test::JSON(3pm) 					User Contributed Perl Documentation					   Test::JSON(3pm)

NAME
Test::JSON - Test JSON data VERSION
Version 0.11 SYNOPSIS
use Test::JSON; is_valid_json $json, '... json is well formed'; is_json $json, $expected_json, '... and it matches what we expected'; EXPORT
o is_valid_json o is_json DESCRIPTION
JavaScript Object Notation (JSON) is a lightweight data interchange format. Test::JSON makes it easy to verify that you have built valid JSON and that it matches your expected output. See <http://www.json.org/> for more information. TESTS
is_valid_json is_valid_json $json, '... json is well formed'; Test passes if the string passed is valid JSON. is_json is_json $json, $expected_json, '... and it matches what we expected'; Test passes if the two JSON strings are valid JSON and evaluate to the same data structure. Test::Differences is used to provide easy diagnostics of why the JSON structures did not match. For example: Failed test '... and identical JSON should match' in t/10testjson.t at line 14. +----+---------------------------+---------------------------+ | Elt|Got |Expected | +----+---------------------------+---------------------------+ | 0|{ |{ | | 1| bool => '1', | bool => '1', | | 2| description => bless( { | description => bless( { | | 3| value => undef | value => undef | | 4| }, 'JSON::NotString' ), | }, 'JSON::NotString' ), | | 5| id => '1', | id => '1', | * 6| name => 'foo' | name => 'fo' * | 7|} |} | +----+---------------------------+---------------------------+ AUTHOR
Curtis "Ovid" Poe, "<ovid@cpan.org>" BUGS
Please report any bugs or feature requests to "bug-test-json@rt.cpan.org", or through the web interface at <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Test-JSON>. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes. SEE ALSO
This test module uses JSON::Any and Test::Differences. ACKNOWLEDGEMENTS
The development of this module was sponsored by Kineticode, <http://www.kineticode.com/>, the leading provider of services for the Bricolage content management system, <http://www.bricolage.cc/>. Thanks to Makamaka Hannyaharamitu "makamaka@cpan.org" for a patch to make this work with JSON 2.0. Thanks to Stevan Little for suggesting a switch to JSON::Any. This makes it easier for this module to work with whatever JSON module you have installed. COPYRIGHT &; LICENSE Copyright 2005-2007 Curtis "Ovid" Poe, all rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.10.1 2009-08-09 Test::JSON(3pm)
All times are GMT -4. The time now is 12:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy