$api_results=`curl -H "Authorization: token 5FEFAQ1W4" https://www.bom/api/v2/organizations/company/admin/groups/"$groid"/installations?page=1`; 
  use JSON;
  my $json=new JSON; 
  my $unjson=$json->allow_nonref->decode($api_results); 
  $app_insert = $dbh->prepare("INSERT IGNORE INTO apps(id, app_slug, app_Name, provider_id, provider_slug, provider_saml, config_saml, config_login, config_url, created_date, status, key_vault, mfa_code) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?") or die $dbh->errstr;
  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.install_type 
                    .created .keyvault .requires_mfa_code
                   /){ 
      push @insert,$row->{$var}; 
      }  # var 
    $app_insert->execute(@api) or die $app_insert->errstr;
    } # row