#!/usr/bin/perl use strict; # https://perlmonks.org/?node_id=11141548 use warnings; use JSON::PP; my $data = join '', ; my $hashref = JSON::PP->new->decode($data); #use Data::Dump 'dd'; dd $hashref; for my $data ( @{ $hashref->{data} } ) { print join ', ', $data->{name}, $data->{timestamp}, $data->{radio}{dl_frame_utilization}, $data->{radio}{dl_kbits}, $data->{radio}{dl_pkts}, ; print "\n"; } __DATA__ {"paging":{"offset":0,"limit":100,"total":25},"data":[{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02-15T04:00:00-06:00","radio":{"dl_frame_utilization":53.50833,"dl_kbits":218936297,"dl_pkts":24533891,"dl_retransmits_pct":3.7125,"dl_throughput":60611.05917,"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","type":"epmp","timestamp":"2022-02-15T05:00:00-06:00","radio":{"dl_frame_utilization":55.79167,"dl_kbits":228622837,"dl_pkts":25268171,"dl_retransmits_pct":3.4875,"dl_throughput":63241.6925,"ul_kbits":11064503,"ul_pkts":10404746,"ul_retransmits_pct":1.6548,"ul_throughput":3060.63917},"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-15T06:00:00-06:00","radio":{"dl_frame_utilization":57.58333,"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":228485690,"dl_pkts":24464710,"dl_retransmits_pct":4.07417,"dl_throughput":63211.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":29231592,"dl_retransmits_pct":4.19,"dl_throughput":74891.63583,"ul_kbits":15477123,"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":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp":"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":13769154,"ul_retransmits_pct":1.8935,"ul_throughput":4649.08167},"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-15T10:00:00-06:00","radio":{"dl_frame_utilization":58.70833,"dl_kbits":239591107,"dl_pkts":25503558,"dl_retransmits_pct":3.27417,"dl_throughput":66325.50667,"ul_kbits":11737909,"ul_pkts":12055338,"ul_retransmits_pct":1.7943,"ul_throughput":3249.29},"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","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","type":"epmp","timestamp":"2022-02-15T12:00:00-06:00","radio":{"dl_frame_utilization":60.96667,"dl_kbits":250838133,"dl_pkts":26973868,"dl_retransmits_pct":3.33417,"dl_throughput":69391.92,"ul_kbits":13262809,"ul_pkts":13460633,"ul_retransmits_pct":1.7437,"ul_throughput":3669.04417},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":4,"managed_account":"","online_duration":3600,"uptime":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":319827700,"dl_pkts":34334577,"dl_retransmits_pct":2.98333,"dl_throughput":88461.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":35193281,"dl_retransmits_pct":3.0575,"dl_throughput":90371.21083,"ul_kbits":26966297,"ul_pkts":22515634,"ul_retransmits_pct":2.1412,"ul_throughput":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_utilization":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},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":4,"managed_account":"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02-15T17:00:00-06:00","radio":{"dl_frame_utilization":56.83333,"dl_kbits":258417074,"dl_pkts":27833706,"dl_retransmits_pct":2.93667,"dl_throughput":71535.6275,"ul_kbits":22211683,"ul_pkts":14625319,"ul_retransmits_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,"managed_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_pkts":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: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-15T19:00:00-06:00","radio":{"dl_frame_utilization":27.24167,"dl_kbits":120543656,"dl_pkts":13037188,"dl_retransmits_pct":2.56833,"dl_throughput":33365.85417,"ul_kbits":9618636,"ul_pkts":5176035,"ul_retransmits_pct":1.1299,"ul_throughput":2662.29917},"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-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_retransmits_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,"managed_account":"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02-15T21:00:00-06:00","radio":{"dl_frame_utilization":14.825,"dl_kbits":57400859,"dl_pkts":6403063,"dl_retransmits_pct":2.41167,"dl_throughput":15881.745,"ul_kbits":6620987,"ul_pkts":2642339,"ul_retransmits_pct":0.8676,"ul_throughput":1831.29833},"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-15T22:00:00-06:00","radio":{"dl_frame_utilization":10.68333,"dl_kbits":34960258,"dl_pkts":4146049,"dl_retransmits_pct":3.375,"dl_throughput":9678.53,"ul_kbits":5463953,"ul_pkts":1916776,"ul_retransmits_pct":0.8151,"ul_throughput":1512.78583},"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-15T23:00:00-06:00","radio":{"dl_frame_utilization":10.73333,"dl_kbits":26089752,"dl_pkts":3410266,"dl_retransmits_pct":3.58833,"dl_throughput":7222.38833,"ul_kbits":7461182,"ul_pkts":2175629,"ul_retransmits_pct":0.7684,"ul_throughput":2065.60083},"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-16T00:00:00-06:00","radio":{"dl_frame_utilization":12.975,"dl_kbits":33266867,"dl_pkts":4152622,"dl_retransmits_pct":4.33583,"dl_throughput":9210.01417,"ul_kbits":7581406,"ul_pkts":2440010,"ul_retransmits_pct":0.801,"ul_throughput":2098.44167},"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-16T01:00:00-06:00","radio":{"dl_frame_utilization":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":"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-16T02:00:00-06:00","radio":{"dl_frame_utilization":49.34167,"dl_kbits":209812527,"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":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-16T03:00:00-06:00","radio":{"dl_frame_utilization":52.00833,"dl_kbits":222219506,"dl_pkts":24983513,"dl_retransmits_pct":3.02583,"dl_throughput":61488.975,"ul_kbits":12229903,"ul_pkts":9952773,"ul_retransmits_pct":2.0038,"ul_throughput":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_utilization":56.96667,"dl_kbits":239952199,"dl_pkts":27802637,"dl_retransmits_pct":3.02083,"dl_throughput":66419.54,"ul_kbits":14663893,"ul_pkts":11988746,"ul_retransmits_pct":1.7661,"ul_throughput":4058.82583},"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}]} #### ESPAP3, 2022-02-15T04:00:00-06:00, 53.50833, 218936297, 24533891 ESPAP3, 2022-02-15T05:00:00-06:00, 55.79167, 228622837, 25268171 ESPAP3, 2022-02-15T06:00:00-06:00, 57.58333, 223937159, 23815786 ESPAP3, 2022-02-15T07:00:00-06:00, 58.84167, 228485690, 24464710 ESPAP3, 2022-02-15T08:00:00-06:00, 67.775, 270520179, 29231592 ESPAP3, 2022-02-15T09:00:00-06:00, 69.24167, 264290580, 28611603 ESPAP3, 2022-02-15T10:00:00-06:00, 58.70833, 239591107, 25503558 ESPAP3, 2022-02-15T11:00:00-06:00, 60.13333, 261326558, 27486494 ESPAP3, 2022-02-15T12:00:00-06:00, 60.96667, 250838133, 26973868 ESPAP3, 2022-02-15T13:00:00-06:00, 66.61667, 280139966, 30571916 ESPAP3, 2022-02-15T14:00:00-06:00, 73.70833, 319827700, 34334577 ESPAP3, 2022-02-15T15:00:00-06:00, 75.51667, 326402388, 35193281 ESPAP3, 2022-02-15T16:00:00-06:00, 74.14545, 300839263, 32604826 ESPAP3, 2022-02-15T17:00:00-06:00, 56.83333, 258417074, 27833706 ESPAP3, 2022-02-15T18:00:00-06:00, 40.575, 172161552, 18441382 ESPAP3, 2022-02-15T19:00:00-06:00, 27.24167, 120543656, 13037188 ESPAP3, 2022-02-15T20:00:00-06:00, 19.675, 84770133, 9138076 ESPAP3, 2022-02-15T21:00:00-06:00, 14.825, 57400859, 6403063 ESPAP3, 2022-02-15T22:00:00-06:00, 10.68333, 34960258, 4146049 ESPAP3, 2022-02-15T23:00:00-06:00, 10.73333, 26089752, 3410266 ESPAP3, 2022-02-16T00:00:00-06:00, 12.975, 33266867, 4152622 ESPAP3, 2022-02-16T01:00:00-06:00, 23.325, 84318817, 9462660 ESPAP3, 2022-02-16T02:00:00-06:00, 49.34167, 209812527, 22210943 ESPAP3, 2022-02-16T03:00:00-06:00, 52.00833, 222219506, 24983513 ESPAP3, 2022-02-16T04:00:00-06:00, 56.96667, 239952199, 27802637