Enroll employees and dependents, and request ID cards

        var contracts = new List<JsonNode>();
        await foreach (var c in api.GetAllAsync($"/groups/{GroupId}/divisions/{DivisionId}/contracts"))
            contracts.Add(c!);
        var contract = contracts.OrderBy(c => c["coverage_Start"]!.GetValue<string>(), StringComparer.Ordinal).Last(); // the latest contract
        var coverageStart = DatePart(contract["coverage_Start"]);
        var coverageEnd = DatePart(contract["coverage_End"]);
        if (coverageEnd.Length == 0)
            throw new InvalidOperationException("The contract has no coverage_End. add-enrollment needs an end_Date; set one for this sample.");
        var groupPlans = (await api.GetAsync($"/groups/{GroupId}/divisions/{DivisionId}/contracts/{coverageStart}/plans")).Data!.AsArray();
        var planId = groupPlans[0]!["plan_ID"]!.GetValue<string>();
        Console.WriteLine($"Contract {coverageStart} to {coverageEnd} plan {planId}");
        

        var relationships = (await api.GetAsync("/relationships")).Data!.AsArray();
        var insuredCode = relationships.First(r => r!["subscriber"]?.GetValue<string>() == "1")!["relate_Code"]!.GetValue<string>();
        var spouseCode = relationships.First(r => r!["spouse"]?.GetValue<string>() == "1")!["relate_Code"]!.GetValue<string>();
        Console.WriteLine($"Insured relationship: {insuredCode} spouse relationship: {spouseCode}");
        

        if (await ExistsAsync(api, $"/subscribers/{SubscriberId}"))
        {
            Console.WriteLine($"Subscriber {SubscriberId} already exists; skipping create");
        }
        else
        {
            var subscriber = (await api.PostAsync("/subscribers", new
            {
                subscriber_ID = SubscriberId,
                first_Name = "Sample",
                last_Name = "Member",
                address = "123 Example St",
                city = "Exampleville",
                state = "TX",
                zip_Code = "00000",
            })).Data!;
            Console.WriteLine($"Created subscriber {subscriber["subscriber_ID"]}");
        }
        

        var members = (await api.GetAsync($"/subscribers/{SubscriberId}/members")).Data?.AsArray()
            .Select(m => m!).ToList() ?? new List<JsonNode>();
        var existing = members.Select(m => m["relationship"]?.GetValue<string>()).ToHashSet();
        var people = new[]
        {
            (FirstName: "Sample", Relationship: insuredCode), // the insured: create first
            (FirstName: "Sample Spouse", Relationship: spouseCode),
        };
        foreach (var person in people)
        {
            if (existing.Contains(person.Relationship))
                continue;
            var member = (await api.PostAsync($"/subscribers/{SubscriberId}/members", new
            {
                subscriber_ID = SubscriberId,
                first_Name = person.FirstName,
                last_Name = "Member",
                relationship = person.Relationship,
                // Required booleans.
                adult_Dependent = false,
                continue_Coverage = false,
                initial_Volume_Salary_Pct = false,
                other_Insurance = false,
                smoker = false,
                use_Member_Plan_Year = false,
            })).Data!;
            members.Add(member);
            Console.WriteLine($"Created member {member["member_Seq"]} {member["first_Name"]}");
        }
        var insuredSeq = members.First(m => m["relationship"]?.GetValue<string>() == insuredCode)["member_Seq"]!.GetValue<string>();
        

        if (await FindEnrollmentAsync(api, coverageStart) is not null)
        {
            Console.WriteLine($"Already enrolled in {GroupId} {DivisionId} {coverageStart}");
        }
        else
        {
            var response = await api.PostAsync($"/subscribers/{SubscriberId}/add-enrollment", new
            {
                requesting_User_ID = requestingUserId,
                addMembers = true,
                subEnrollment = new
                {
                    subscriber_ID = SubscriberId,
                    group_ID = GroupId,
                    division_ID = DivisionId,
                    group_Coverage_Start = $"{coverageStart}T00:00:00",
                    start_Date = $"{coverageStart}T00:00:00",
                    end_Date = $"{coverageEnd}T00:00:00",
                },
            });
            Console.WriteLine($"add-enrollment returned {(int)response.Status}"); // 202 Accepted, no body
        }
        

        JsonNode? enrollment = null;
        for (var attempt = 0; attempt < 5 && enrollment is null; attempt++)
        {
            enrollment = await FindEnrollmentAsync(api, coverageStart);
            if (enrollment is null)
                await Task.Delay(TimeSpan.FromSeconds(2));
        }
        if (enrollment is null)
            throw new InvalidOperationException("The enrollment did not appear. Check the subscriber in VBASoftware.");
        var startDate = DatePart(enrollment["start_Date"]);
        Console.WriteLine($"Enrollment {enrollment["group_ID"]} {enrollment["division_ID"]} {startDate} to {DatePart(enrollment["end_Date"])}");
        

        var enrolledPlans = (await api.GetAsync(plansPath)).Data?.AsArray() ?? new JsonArray();
        if (enrolledPlans.Any(p => p!["plan_ID"]!.GetValue<string>() == planId))
        {
            Console.WriteLine($"Plan {planId} already on the enrollment");
        }
        else
        {
            await api.PostAsync(plansPath, new
            {
                subscriber_ID = SubscriberId,
                group_ID = GroupId,
                division_ID = DivisionId,
                group_Coverage_Start = $"{coverageStart}T00:00:00",
                start_Date = $"{startDate}T00:00:00",
                plan_ID = planId,
                plan_Start = $"{startDate}T00:00:00",
                plan_End = $"{coverageEnd}T00:00:00",
                use_Volume_Scale = false,
            });
            Console.WriteLine($"Added plan {planId}");
        }
        

        foreach (var plan in (await api.GetAsync(plansPath)).Data?.AsArray() ?? new JsonArray())
            Console.WriteLine($"Enrolled plan {plan!["plan_ID"]} {DatePart(plan["plan_Start"])} to {DatePart(plan["plan_End"])}");
        

        var requestTypes = (await api.GetAsync("/id-card-request-types")).Data!.AsArray();
        var card = (await api.PostAsync("/id-card-requests", new
        {
            idCardRequest_Key = 0, // 0 on create; VBAPI assigns the key
            renewal = false,
            subscriber_ID = SubscriberId,
            member_Seq = insuredSeq,
            group_ID = GroupId,
            division_ID = DivisionId,
            request_Type = requestTypes[0]!["request_Type"]!.GetValue<string>(),
            request_Status = "REQ",
            request_Date = $"{DateTime.Today:yyyy-MM-dd}T00:00:00",
            as_Of_Date = $"{startDate}T00:00:00",
            request_Quantity = 1,
            physical_Card_Requested = true,
        })).Data!;
        var cardKey = card["idCardRequest_Key"]!.GetValue<int>();
        Console.WriteLine($"ID card request {cardKey}");
        

        var savedCard = (await api.GetAsync($"/id-card-requests/{cardKey}")).Data!;
        Console.WriteLine($"ID card request {savedCard["idCardRequest_Key"]} status: {savedCard["request_Status"]}");
        

        var families = ReadCsv(CensusFile()).GroupBy(row => row["subscriber_id"]).ToList();
        var subscribers = families.Select(family =>
        {
            var insured = family.First(r => r["relationship"] == "insured");
            return new
            {
                subscriber_ID = family.Key,
                first_Name = insured["first_name"],
                last_Name = insured["last_name"],
                address = insured["address"],
                city = insured["city"],
                state = insured["state"],
                zip_Code = insured["zip_code"],
            };
        }).ToList();
        var response = await api.PutAsync("/subscribers-batch", subscribers); // 207 Multi-Status
        var failedIds = new HashSet<string?>();
        foreach (var item in response.Data?.AsArray() ?? new JsonArray())
        {
            if (item!["status"]!.GetValue<int>() < 400)
                continue;
            var key = Key(item);
            failedIds.Add(key.GetValueOrDefault("Subscriber_ID"));
            Console.WriteLine($"Subscriber failed: {key.GetValueOrDefault("Subscriber_ID")} {item["status"]} {item["body"]}");
        }
        

        foreach (var family in families)
        {
            if (failedIds.Contains(family.Key))
                continue; // fix the subscriber row first, then re-run; the batch updates rows that exist
            var members = family.Select(row => new
            {
                subscriber_ID = family.Key,
                member_Seq = row["member_seq"], // send it so a re-run updates instead of adding a member
                first_Name = row["first_name"],
                last_Name = row["last_name"],
                relationship = codes.GetValueOrDefault(row["relationship"], row["relationship"]),
                adult_Dependent = false,
                continue_Coverage = false,
                initial_Volume_Salary_Pct = false,
                other_Insurance = false,
                smoker = false,
                use_Member_Plan_Year = false,
            }).ToList();
            var memberResponse = await api.PutAsync($"/subscribers/{family.Key}/members-batch", members);
            foreach (var item in memberResponse.Data?.AsArray() ?? new JsonArray())
                Console.WriteLine($"{family.Key} {Key(item!).GetValueOrDefault("Member_Seq")} {item!["status"]} {item["body"]}"); // 201 Created, 200 Updated
        }
        

$env:VBAPI_BASE_URL    = "https://vbapi.vbasoftware.com/vbasoftware"
$env:VBAPI_API_KEY     = "your-api-key"
$env:VBAPI_CLIENT_ID   = "your-client-id"
$env:VBAPI_CLIENT_CODE = "your-client-code"
$env:VBAPI_DATABASE    = "YOUR_DATABASE"
$env:VBAPI_USERNAME    = "your-api-username"
$env:VBAPI_PASSWORD    = "your-api-password"
$env:VBAPI_USER_AGENT  = "YourCompany-Integration/1.0"