$api_results=`curl -H "Authorization: token 5FEFAQ1W4" https://www.bom/api/v2/organizations/company/admin/groups/"$groid"/installations?page=1 > "$valid"; cat "$valid" | jq -r '(.[]|[.id, .slug, .name, .provider.id, .provider.name,.provider.capabilities.has_saml,.configuration.saml,.configuration.login, .configuration.install_type, .created, .keyvault, .requires_mfa_code) | \@csv` ;
   
##insert statement 
$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;

                           ##Insert execution
                           while (my @api = $api_results->fetchrow_array())
                           {
                           $app_insert->execute(@api) or die $app_insert->errstr;
                           }
                        print "Done inserting \n";
                        exit;
                         }