if($idps->isNotEmpty())
    {


   foreach($idps as $idp)
   {
       $federation_idp = $connection->table('federacao_idp')->where('idIdp',$idp->ididp)->first();

     $identityProvider =   IdentityProvider::insert([
           'id'=>$idp->ididp ,
           "entityid" => "$idp->entityid",
           "name" => "$idp->nome",
           "description" => "$idp->descricao",
           "domain" => "$idp->endpoint",
           "status" => "ACTIVE",
           "acession_data" => "$idp->dataadesao",
           "federation_id" => $federation_id=  $federation_idp ? $federation_idp->idFederacao : null,
           "created_at" => Carbon::now(),
           "updated_at" => Carbon::now()
       ]);


      if($identityProvider)
      {

            if($idp->modoliberacao ===  "L")
            {
                $access_mode = "ApprovalList";
            }
            else if($idp->modoliberacao === "A")
            {
                $access_mode = "Automatic";
            }
            else
            {
                $access_mode = "Attributes";

            }

          $authorized_idp_to_sp =  DB::table("authorized_idp_to_sp")->insertGetId([
              "access_mode" => $access_mode,
              "authorized" => "YES",
              "identity_provider_id"=>$idp->ididp ,
              "service_provider_id" => 2
          ]);
      }
        if($authorized_idp_to_sp)
        {
           $quota = ["key"=>"quota","value"=>$idp->quota,"authorized_id_to_sp_id"=>"$authorized_idp_to_sp"];
           $quota_default = ["key"=>"quota_default","value"=>$idp->quotadefault,"authorized_id_to_sp_id"=>"$authorized_idp_to_sp"];
            $extra_info =  app()->make(ExtraInfo::class)->insert([$quota,$quota_default]);

        }


   }

    }