PerlMonger79 has asked for the wisdom of the Perl Monks concerning the following question:
However I'd like to further parse the output to get the specific values for name, timestamp, dl_throughput, etc. separated by commas. Can anyone please suggest how I can get this done or direct me to a sample script that would get this done. I appreciate any help given. Thank you.my $response = $ua->request($request); if ($response->is_success) { print $response->decoded_content; } else { print STDERR $response->status_line, "\n"; }
{"paging":{"offset":0,"limit":100,"total":25},"data":[{"name":"ESPAP3" +,"network":"ePMP","type":"epmp","timestamp":"2022-02-15T04:00:00-06:0 +0","radio":{"dl_frame_utilization":53.50833,"dl_kbits":218936297,"dl_ +pkts":24533891,"dl_retransmits_pct":3.7125,"dl_throughput":60611.0591 +7,"ul_kbits":11781720,"ul_pkts":10095078,"ul_retransmits_pct":1.7481, +"ul_throughput":3261.45},"tower":"Espat Twr","sm_count":47,"mac":"00: +04:56:22:51:32","mode":"ap","sm_drops":1,"managed_account":"","online +_duration":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","typ +e":"epmp","timestamp":"2022-02-15T05:00:00-06:00","radio":{"dl_frame_ +utilization":55.79167,"dl_kbits":228622837,"dl_pkts":25268171,"dl_ret +ransmits_pct":3.4875,"dl_throughput":63241.6925,"ul_kbits":11064503," +ul_pkts":10404746,"ul_retransmits_pct":1.6548,"ul_throughput":3060.63 +917},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mod +e":"ap","sm_drops":3,"managed_account":"","online_duration":3600,"upt +ime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp +":"2022-02-15T06:00:00-06:00","radio":{"dl_frame_utilization":57.5833 +3,"dl_kbits":223937159,"dl_pkts":23815786,"dl_retransmits_pct":3.9375 +,"dl_throughput":61984.47583,"ul_kbits":10983095,"ul_pkts":10825123," +ul_retransmits_pct":1.8673,"ul_throughput":3040.02167},"tower":"Espat + Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops": +3,"managed_account":"","online_duration":3600,"uptime":3600},{"name": +"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02-15T07:00 +:00-06:00","radio":{"dl_frame_utilization":58.84167,"dl_kbits":228485 +690,"dl_pkts":24464710,"dl_retransmits_pct":4.07417,"dl_throughput":6 +3211.23917,"ul_kbits":10887235,"ul_pkts":11051562,"ul_retransmits_pct +":1.894,"ul_throughput":3012.27583},"tower":"Espat Twr","sm_count":47 +,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":0,"managed_account" +:"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","network": +"ePMP","type":"epmp","timestamp":"2022-02-15T08:00:00-06:00","radio": +{"dl_frame_utilization":67.775,"dl_kbits":270520179,"dl_pkts":2923159 +2,"dl_retransmits_pct":4.19,"dl_throughput":74891.63583,"ul_kbits":15 +477123,"ul_pkts":13968153,"ul_retransmits_pct":1.8042,"ul_throughput" +:4285.24083},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51: +32","mode":"ap","sm_drops":2,"managed_account":"","online_duration":3 +600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","t +imestamp":"2022-02-15T09:00:00-06:00","radio":{"dl_frame_utilization" +:69.24167,"dl_kbits":264290580,"dl_pkts":28611603,"dl_retransmits_pct +":3.92667,"dl_throughput":73100.34333,"ul_kbits":16808560,"ul_pkts":1 +3769154,"ul_retransmits_pct":1.8935,"ul_throughput":4649.08167},"towe +r":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","s +m_drops":3,"managed_account":"","online_duration":3600,"uptime":3600} +,{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02 +-15T10:00:00-06:00","radio":{"dl_frame_utilization":58.70833,"dl_kbit +s":239591107,"dl_pkts":25503558,"dl_retransmits_pct":3.27417,"dl_thro +ughput":66325.50667,"ul_kbits":11737909,"ul_pkts":12055338,"ul_retran +smits_pct":1.7943,"ul_throughput":3249.29},"tower":"Espat Twr","sm_co +unt":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":1,"managed_a +ccount":"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","ne +twork":"ePMP","type":"epmp","timestamp":"2022-02-15T11:00:00-06:00"," +radio":{"dl_frame_utilization":60.13333,"dl_kbits":261326558,"dl_pkts +":27486494,"dl_retransmits_pct":3.88583,"dl_throughput":72350.99417," +ul_kbits":12646382,"ul_pkts":13759064,"ul_retransmits_pct":1.9393,"ul +_throughput":3501.27167},"tower":"Espat Twr","sm_count":47,"mac":"00: +04:56:22:51:32","mode":"ap","sm_drops":2,"managed_account":"","online +_duration":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","typ +e":"epmp","timestamp":"2022-02-15T12:00:00-06:00","radio":{"dl_frame_ +utilization":60.96667,"dl_kbits":250838133,"dl_pkts":26973868,"dl_ret +ransmits_pct":3.33417,"dl_throughput":69391.92,"ul_kbits":13262809,"u +l_pkts":13460633,"ul_retransmits_pct":1.7437,"ul_throughput":3669.044 +17},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode +":"ap","sm_drops":4,"managed_account":"","online_duration":3600,"upti +me":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp" +:"2022-02-15T13:00:00-06:00","radio":{"dl_frame_utilization":66.61667 +,"dl_kbits":280139966,"dl_pkts":30571916,"dl_retransmits_pct":3.14833 +,"dl_throughput":77542.95833,"ul_kbits":24334025,"ul_pkts":17020906," +ul_retransmits_pct":1.9275,"ul_throughput":6735.07083},"tower":"Espat + Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops": +3,"managed_account":"","online_duration":3600,"uptime":3600},{"name": +"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02-15T14:00 +:00-06:00","radio":{"dl_frame_utilization":73.70833,"dl_kbits":319827 +700,"dl_pkts":34334577,"dl_retransmits_pct":2.98333,"dl_throughput":8 +8461.8575,"ul_kbits":25273905,"ul_pkts":21591443,"ul_retransmits_pct" +:2.2535,"ul_throughput":6991.14417},"tower":"Espat Twr","sm_count":47 +,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":8,"managed_account" +:"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","network": +"ePMP","type":"epmp","timestamp":"2022-02-15T15:00:00-06:00","radio": +{"dl_frame_utilization":75.51667,"dl_kbits":326402388,"dl_pkts":35193 +281,"dl_retransmits_pct":3.0575,"dl_throughput":90371.21083,"ul_kbits +":26966297,"ul_pkts":22515634,"ul_retransmits_pct":2.1412,"ul_through +put":7466.1675},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22: +51:32","mode":"ap","sm_drops":8,"managed_account":"","online_duration +":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp" +,"timestamp":"2022-02-15T16:00:00-06:00","radio":{"dl_frame_utilizati +on":74.14545,"dl_kbits":300839263,"dl_pkts":32604826,"dl_retransmits_ +pct":2.58364,"dl_throughput":90848.48727,"ul_kbits":30157231,"ul_pkts +":21712953,"ul_retransmits_pct":2.0661,"ul_throughput":9106.83182},"t +ower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap" +,"sm_drops":4,"managed_account":"","online_duration":3600,"uptime":36 +00},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022 +-02-15T17:00:00-06:00","radio":{"dl_frame_utilization":56.83333,"dl_k +bits":258417074,"dl_pkts":27833706,"dl_retransmits_pct":2.93667,"dl_t +hroughput":71535.6275,"ul_kbits":22211683,"ul_pkts":14625319,"ul_retr +ansmits_pct":1.8357,"ul_throughput":6148.98083},"tower":"Espat Twr"," +sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":4,"mana +ged_account":"","online_duration":3600,"uptime":3600},{"name":"ESPAP3 +","network":"ePMP","type":"epmp","timestamp":"2022-02-15T18:00:00-06: +00","radio":{"dl_frame_utilization":40.575,"dl_kbits":172161552,"dl_p +kts":18441382,"dl_retransmits_pct":2.97,"dl_throughput":47646.78083," +ul_kbits":14526870,"ul_pkts":8192202,"ul_retransmits_pct":0.0175,"ul_ +throughput":4020.45417},"tower":"Espat Twr","sm_count":47,"mac":"00:0 +4:56:22:51:32","mode":"ap","sm_drops":0,"managed_account":"","online_ +duration":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type +":"epmp","timestamp":"2022-02-15T19:00:00-06:00","radio":{"dl_frame_u +tilization":27.24167,"dl_kbits":120543656,"dl_pkts":13037188,"dl_retr +ansmits_pct":2.56833,"dl_throughput":33365.85417,"ul_kbits":9618636," +ul_pkts":5176035,"ul_retransmits_pct":1.1299,"ul_throughput":2662.299 +17},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode +":"ap","sm_drops":0,"managed_account":"","online_duration":3600,"upti +me":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp" +:"2022-02-15T20:00:00-06:00","radio":{"dl_frame_utilization":19.675," +dl_kbits":84770133,"dl_pkts":9138076,"dl_retransmits_pct":1.69667,"dl +_throughput":23459.96083,"ul_kbits":7774048,"ul_pkts":3485288,"ul_ret +ransmits_pct":0.8403,"ul_throughput":2151.21167},"tower":"Espat Twr", +"sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":2,"man +aged_account":"","online_duration":3600,"uptime":3600},{"name":"ESPAP +3","network":"ePMP","type":"epmp","timestamp":"2022-02-15T21:00:00-06 +:00","radio":{"dl_frame_utilization":14.825,"dl_kbits":57400859,"dl_p +kts":6403063,"dl_retransmits_pct":2.41167,"dl_throughput":15881.745," +ul_kbits":6620987,"ul_pkts":2642339,"ul_retransmits_pct":0.8676,"ul_t +hroughput":1831.29833},"tower":"Espat Twr","sm_count":47,"mac":"00:04 +:56:22:51:32","mode":"ap","sm_drops":0,"managed_account":"","online_d +uration":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type" +:"epmp","timestamp":"2022-02-15T22:00:00-06:00","radio":{"dl_frame_ut +ilization":10.68333,"dl_kbits":34960258,"dl_pkts":4146049,"dl_retrans +mits_pct":3.375,"dl_throughput":9678.53,"ul_kbits":5463953,"ul_pkts": +1916776,"ul_retransmits_pct":0.8151,"ul_throughput":1512.78583},"towe +r":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","s +m_drops":0,"managed_account":"","online_duration":3600,"uptime":3600} +,{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02 +-15T23:00:00-06:00","radio":{"dl_frame_utilization":10.73333,"dl_kbit +s":26089752,"dl_pkts":3410266,"dl_retransmits_pct":3.58833,"dl_throug +hput":7222.38833,"ul_kbits":7461182,"ul_pkts":2175629,"ul_retransmits +_pct":0.7684,"ul_throughput":2065.60083},"tower":"Espat Twr","sm_coun +t":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":0,"managed_acc +ount":"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","netw +ork":"ePMP","type":"epmp","timestamp":"2022-02-16T00:00:00-06:00","ra +dio":{"dl_frame_utilization":12.975,"dl_kbits":33266867,"dl_pkts":415 +2622,"dl_retransmits_pct":4.33583,"dl_throughput":9210.01417,"ul_kbit +s":7581406,"ul_pkts":2440010,"ul_retransmits_pct":0.801,"ul_throughpu +t":2098.44167},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:5 +1:32","mode":"ap","sm_drops":0,"managed_account":"","online_duration" +:3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp", +"timestamp":"2022-02-16T01:00:00-06:00","radio":{"dl_frame_utilizatio +n":23.325,"dl_kbits":84318817,"dl_pkts":9462660,"dl_retransmits_pct": +4.0875,"dl_throughput":23342.555,"ul_kbits":9192208,"ul_pkts":3963593 +,"ul_retransmits_pct":1.3335,"ul_throughput":2544.4975},"tower":"Espa +t Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops" +:0,"managed_account":"","online_duration":3600,"uptime":3600},{"name" +:"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02-16T02:0 +0:00-06:00","radio":{"dl_frame_utilization":49.34167,"dl_kbits":20981 +2527,"dl_pkts":22210943,"dl_retransmits_pct":3.05833,"dl_throughput": +58082.78167,"ul_kbits":15423110,"ul_pkts":9336658,"ul_retransmits_pct +":1.6622,"ul_throughput":4269.34167},"tower":"Espat Twr","sm_count":4 +7,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":0,"managed_account +":"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","network" +:"ePMP","type":"epmp","timestamp":"2022-02-16T03:00:00-06:00","radio" +:{"dl_frame_utilization":52.00833,"dl_kbits":222219506,"dl_pkts":2498 +3513,"dl_retransmits_pct":3.02583,"dl_throughput":61488.975,"ul_kbits +":12229903,"ul_pkts":9952773,"ul_retransmits_pct":2.0038,"ul_throughp +ut":3384.43083},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22: +51:32","mode":"ap","sm_drops":3,"managed_account":"","online_duration +":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp" +,"timestamp":"2022-02-16T04:00:00-06:00","radio":{"dl_frame_utilizati +on":56.96667,"dl_kbits":239952199,"dl_pkts":27802637,"dl_retransmits_ +pct":3.02083,"dl_throughput":66419.54,"ul_kbits":14663893,"ul_pkts":1 +1988746,"ul_retransmits_pct":1.7661,"ul_throughput":4058.82583},"towe +r":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","s +m_drops":1,"managed_account":"","online_duration":3600,"uptime":3600} +]}
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Parsing Output
by 1nickt (Canon) on Feb 22, 2022 at 16:24 UTC | |
|
Re: Parsing Output
by Fletch (Bishop) on Feb 22, 2022 at 16:33 UTC | |
|
Re: Parsing Output
by tybalt89 (Monsignor) on Feb 22, 2022 at 18:42 UTC | |
by PerlMonger79 (Sexton) on Feb 23, 2022 at 13:31 UTC | |
by hippo (Archbishop) on Feb 23, 2022 at 13:48 UTC | |
by PerlMonger79 (Sexton) on Feb 23, 2022 at 15:13 UTC | |
by Fletch (Bishop) on Feb 23, 2022 at 15:17 UTC | |
by PerlMonger79 (Sexton) on Feb 23, 2022 at 14:45 UTC | |
by tybalt89 (Monsignor) on Feb 23, 2022 at 19:50 UTC | |
|
Re: Parsing Output
by marto (Cardinal) on Feb 22, 2022 at 17:52 UTC |