in reply to Re: Parsing Output
in thread Parsing Output

Hello, thank you for taking your time and providing a feedback on my issue. However, I tried your script but I got an error for the Data::Dump module, so I tried to install it using cpan and then it gave me an error response that it did not know what Data::Dump was. So I haven't been able to run your script.

On another note, from my output response I'd like to be able to parse it and get certain information from it in a format as the example below.

example:
ESPAP3, 2022-02-15T04:00:00-06:00, 53.50833, 218936297, 3.7125 ...
ESPAP3, 2022-02-15T05:00:00-06:00, 55.79167, 228622837, 3.4875 ...

and so forth, for each record. Would this be possible to achieve?

Replies are listed 'Best First'.
Re^3: Parsing Output
by hippo (Archbishop) on Feb 23, 2022 at 13:48 UTC
    then it gave me an error response that it did not know what Data::Dump was.

    Sure it knows:

    $ cpan -D Data::Dump Reading '/home/redacted/.cpan/Metadata' Database was generated on Wed, 23 Feb 2022 09:55:53 GMT Data::Dump ---------------------------------------------------------------------- +--- (no description) G/GA/GARU/Data-Dump-1.25.tar.gz (no installation file) Installed: not installed CPAN: 1.25 Not up to date Breno G. de Oliveira (GARU) garu@cpan.org

    Why describe the error messages when you could simply paste them?


    🦛

      Hi again. So I was able to install the module and I added the code to my script and got a few errors but also the same output as yours. Please find my code and output below. Is there something I must fix?
      #!/usr/bin/perl -w use strict; use warnings; use JSON; use LWP::UserAgent; require HTTP::Cookies; my $netloc = "xxx.xx.xx.xx:80"; my $realm = "Realm"; my $user = "username"; my $pass = "password"; my $auth_token = "token code"; my $ua = new LWP::UserAgent; $ua->agent('Mozilla/5.0'); my $cookie_jar = HTTP::Cookies->new( file => 'cookies_lwp.txt', autosa +ve => 1, ignore_discard => 1 ); $ua->cookie_jar($cookie_jar); $ENV{PERL_LWP_SSL_VERIFY_HOSTNAME}=0; $ua->default_header( "Authorization" => "Bearer $auth_token"); $ua->default_header( "Accept" =>"application/json" ); $ua->default_header( "Content-Type" => "application/json"); $ua->credentials( $netloc, $realm, $user, $pass); $ua->ssl_opts( verify_hostname => 0, SSL_verify_mode => 0x00); my $request = new HTTP::Request('GET','https://xxx.xx.xx.xx/api/v2/dev +ices/00:04:56:22:51:32/performance/?start_time=2022-02-15T10:00:00&st +op_time=2022-02-16T10:00:00'); my $response = $ua->request($request); if ($response->is_success) { my $output = $response->decoded_content; #print $output."\n"; #Code from perlmonks use JSON::PP; my $data = join '', $output; my $hashref = JSON::PP->new->decode($data); use Data::Dump 'dd'; dd $hashref; } else { print STDERR $response->status_line, "\n"; }
      Output:
      Subroutine main::encode_json redefined at /usr/local/share/perl5/Expor +ter.pm line 66. at ./wifi-api-get.pl line 33. Subroutine main::decode_json redefined at /usr/local/share/perl5/Expor +ter.pm line 66. at ./wifi-api-get.pl line 33. Prototype mismatch: sub main::decode_json ($) vs none at /usr/local/sh +are/perl5/Exporter.pm line 66. at ./wifi-api-get.pl line 33. Subroutine main::from_json redefined at /usr/local/share/perl5/Exporte +r.pm line 66. at ./wifi-api-get.pl line 33. Prototype mismatch: sub main::from_json ($@) vs ($) at /usr/local/shar +e/perl5/Exporter.pm line 66. at ./wifi-api-get.pl line 33. Subroutine main::to_json redefined at /usr/local/share/perl5/Exporter. +pm line 66. at ./wifi-api-get.pl line 33. Prototype mismatch: sub main::to_json ($@) vs ($) at /usr/local/share/ +perl5/Exporter.pm line 66. at ./wifi-api-get.pl line 33. { data => [ { mac => "00:04:56:22:51:32", managed_account => "", mode => "ap", name => "Espat AP3", network => "Belize City ePMP", online_duration => 3600, 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, }, sm_count => 45, sm_drops => 1, timestamp => "2022-02-15T04:00:00-06:00", tower => "Espat Twr", type => "epmp", uptime => 3600, }, { mac => "00:04:56:22:51:32", managed_account => "", mode => "ap", name => "Espat AP3", network => "Belize City ePMP", online_duration => 3600, 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, }, . . . . rest of the output similar to your output.

        You've used both JSON and JSON::PP in your code; don't do that. The former is a "smart" module that will pick the faster available backend between the pure perl version and JSON::XS if available. Since the first import has already pulled in the subs named when the second use is encountered perl is warning you that you're redefining things it already knows about.

        The cake is a lie.
        The cake is a lie.
        The cake is a lie.

      Ok, I tried it again just now and it gave me a different error. Seems connection to the internet has been blocked by the network admin. The server is on a private LAN.. so once I get the access again I'll try installing the module again. I'll keep you posted, and thanks again for taking time in helping me. I appreciate it very much.
Re^3: Parsing Output
by tybalt89 (Monsignor) on Feb 23, 2022 at 19:50 UTC
    #!/usr/bin/perl use strict; # https://perlmonks.org/?node_id=11141548 use warnings; use JSON::PP; my $data = join '', <DATA>; 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: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} +]}

    Outputs:

    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

    You didn't specify exactly what fields you wanted, so I just took a guess, hope this helps...