package webapp; use Dancer2; use Op; use Op1; use URI; use Net::OAuth2::Client; use HTML::Entities; use Data::Dumper; use parent 'Exporter'; our $accestoken = ""; our @access_token; sub client { Net::OAuth2::Profile::WebServer->new( client_id => 'xxxxxxxxxxxxxxxxxxx', client_secret => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxx', authorize_url => 'https://dev.oktapreview.com/oauth2/v1/authorize', access_token_url => 'https://dev.oktapreview.com/oauth2/v1/token', redirect_uri => uri_for ("/got/$site_id"), grant_type => 'authorization_code', ); } get '/got/:site_id' => sub { my $p = params->{code}; defined params->{code} or print "Error: Missing access code"; my $id = route_parameters->get('site_id'); my $site_id = params->{$id}; @access_token = client($site_id)->get_access_token($p); template 'query2' => { 'title' => 'webapp' }; }; post '/'=> sub { my $r2 = Op::result3({OKTAUsersList => param('OKTA-Users-List'), Email => param('Email')}); template result3 => { title => 'webapp', result3 => $r2 } }; true; #### package Op; use strict; use warnings; use Win32::Process; use Storable; use IO::Socket::SSL; use REST::Client; use JSON::Parse ':all'; use MIME::Base64; use Term::ReadKey; use Data::Dumper; use MIME::Lite; use Net::SMTP; use webapp qw/@access_token/; use Spreadsheet::XLSX; use Spreadsheet::ParseXLSX; use Excel::Writer::XLSX; sub api_call3 { $client->default_header( 'content-type' => 'application/json' ); $client->default_header( 'Accept' => 'application/json' ); $client->default_header( 'Authorization' => "Bearer $value2" ); $client->request(HTTP::Request->new('GET', "$_[0]")); } sub result3 { my ($args) = @_; my $oktadev = $args->{OKTAUsersList}; my $email = $args->{Email}; my @responsetext; my @responsalter; $strExcelFilename1 = "C:/PERL/" . "OKTADev-Profile-User-Details" . $date . ".xlsx"; my $apiurlapplog2 = "https://dev.oktapreview.com" ."/api/v1/users?"; my $response = api_call3($apiurlapplog2); print "Response:\n"; @responsetext = parse_json ($response->content); my $workbook = Excel::Writer::XLSX->new( $strExcelFilename1 ); for my $i (0..$#responsetext) { my $responseid = $responsetext[$i]{id}; my $responsests = $responsetext[$i]{status}; if ($responsests ne "DEPROVISIONED") { $worksheet->write(0, 0, 'OKTA-ID'); $worksheet->write(0, 1, 'FIRST NAME'); $worksheet->write(0, 2, 'LAST NAME'); $worksheet->write($r, 0, $responseid); $worksheet->write($r, 1, $responsetext[$i]{profile}{firstName}); $worksheet->write($r, 2, $responsetext[$i]{profile}{lastName}); $r += 1; } } }