$app_insert = $dbh->prepare("INSERT INTO bitium_apps(id, app_slug, app_Name, team_id, provider_id, provider_slug, provider_saml, config_saml, config_login, config_url, created_date, status, key_vault, mfa_code, configuration_install) VALUES (?, ?, ?, \"$response\", ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?") or die $dbh->errstr; use JSON; my $json=new JSON; my $unjson=$json->allow_nonref->decode($api_results); for my $row (@$unjson) { my @insert; #### for my $var (qw/.id .slug .name .provider.id .provider.name .provider.capabilities.has_saml .configuration.saml .configuration.login .configuration.url .created_at .status .key_vault .requires_mfa_code .configuration.install_type /){ #### $base=$base->{$subpart}; } #### push @insert,$base->{$terminal}; } # var #### $app_insert->execute(@insert[0,1,2,4 .. 15]) or die $app_insert->errstr; } # row