Hello, Do you have any specific example of pulling the raw data into DB? Please check below how i am pulling raw data and let me know next step if possible. How i should import into csv and then excel if possible.

my $urlstringlog = $apiurllog . $sortor . $filter . $target . $appID .
+ $date2;

$strExcelFilename = "C:/" . "Analysis-Details-automatic-bk" . $date . 
+".xlsx";

do {

  # Run get the users
  run_api_call($urlstringlog);
  @responsetext = parse_json ($client->responseContent());
  push @responsetextall, @responsetext;
  $linkheader =  $client->responseHeader("link");
  if ($linkheader=~ m/next/) {
  (my $link1 = $linkheader) =~ s/ .*? (self)/$1/gx;
  (my $link2 = $link1) =~ s/self/$1/g;
   print "Post Pagination: $link10";
   $urlstringlog = $link2;
  }
  } while ($linkheader=~ m/next/);
     for my $i (0..$#responsetextall) {
  
     $responsetextall[$i] =~ s/]\[/,/g;
 
        for my $j (0..$#{$responsetextall[$i]}) {
             @responsests1 = $responsetextall[$i][$j]{tat};    
             $responseid = $responsetextall[$i][$j]{act}{id};
             $responsdisp = $responsetextall[$i][$j]{act}{Name};
             $responsalter = $responsetextall[$i][$j]{act}{Id};
             $responseclientipadd = $responsetextall[$i][$j]{cln}{ipAd
+};
             $responseappsdebug = $responsetextall[$i][$j]{deb}{Data};
+    
            
    for  my $m (0..$#responsests1) {
            for my $n (0..$#{$responsests1[$m]}) {
            $responseapps2id = $responsests1[$m][$n]{id};
            $responseapps2 = $responsests1[$m][$n]{ty};
            $responseapps1 = $responsests1[$m][$n]{Name};
                    
                if ( $responseapps2 eq 'AppInstance' ){
                 
                 @responseapps3 = $responsests1[$m][$n]{displayName};
                $responseapps5 = $responseapps3[0];
                 print "Its Matches Appinstances";
                 $responseapps4 = $responsests1[$m][$n]{Name};
                             
                                    
                        if ( $responseapps2 eq 'AppUser'){
                            
                            $responseapps3id = $responsests1[$m][$n]{a
+Id};
                        }
        
             
                }
                                
                      
      push @responseapps3id,$responseapps3id;    
      push @responseapps5 , $responseapps4;
      push @responseapps7, $responseapps7;
                
                
                        }
                        
                    
                        
                        }
                        
                        push @responsalter, $responsalter;
                          push @responseclientipadd,$responseclientipa
+dd;
                           
                    }
                
             }

[download]

In reply to Re^4: Splitting the records into multiple worksheets by chandantul
in thread Splitting the records into multiple worksheets by chandantul

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.