GET api/Utility/GetUtilities

No documentation available.

Response Information

No documentation available.

Response body formats

application/json, text/json

Sample:
[
  {
    "$id": "1",
    "UtilityId": 1,
    "UtilityName": "sample string 2",
    "StateId": 1,
    "IsActive": true,
    "ResidentialSales": [
      {
        "$id": "2",
        "SaleId": 1,
        "SaleDate": "2025-04-10T20:18:38.6795526-07:00",
        "SaleFirstName": "sample string 2",
        "SaleLastName": "sample string 3",
        "SalePhoneNumber": "sample string 4",
        "SupplierId": 1,
        "StateId": 1,
        "UtilityId": 1,
        "SaleType": "sample string 5",
        "SaleAccountNumber": "sample string 6",
        "SaleServiceAddress": "sample string 7",
        "SaleServiceCity": "sample string 8",
        "SaleServiceState": "sample string 9",
        "SaleServiceZipcode": "sample string 10",
        "SaleBillingAddress": "sample string 11",
        "SaleBillingCity": "sample string 12",
        "SaleBillingState": "sample string 13",
        "SaleBillingZipcode": "sample string 14",
        "SalePersonOnPhone": "sample string 15",
        "SaleProgramCode": "sample string 16",
        "SaleTermPlan": "sample string 17",
        "SaleRate": "sample string 18",
        "SaleRepId": "sample string 19",
        "SaleTPVNumber": "sample string 20",
        "SaleFronter": "sample string 21",
        "SaleCloser": "sample string 22",
        "SalePunchedBy": 1,
        "SaleRemarks": "sample string 23",
        "SaleDrivingLisence": "sample string 24",
        "SaleDrivingExipry": "2025-04-10T20:18:38.6795526-07:00",
        "SaleEmail": "sample string 25",
        "SaleSocialSecurity": "sample string 26",
        "SaleDateofBirth": "2025-04-10T20:18:38.6795526-07:00",
        "SaleAlternatePhone": "sample string 27",
        "SaleHouseOrAppartment": "sample string 28",
        "SaleOrderID": "sample string 29",
        "SaleAgentEmail": "sample string 30",
        "SaleRecordLocator": "sample string 31",
        "UserId": "sample string 32",
        "State": {
          "$id": "3",
          "StateId": 1,
          "StateName": "sample string 2",
          "IsActive": true,
          "ResidentialSales": [
            {
              "$ref": "2"
            },
            {
              "$ref": "2"
            },
            {
              "$ref": "2"
            }
          ],
          "Utilities": [
            {
              "$ref": "1"
            },
            {
              "$ref": "1"
            },
            {
              "$ref": "1"
            }
          ]
        },
        "Supplier": {
          "$id": "4",
          "SupplierId": 1,
          "SupplierName": "sample string 2",
          "RateScreenshot": "sample string 3",
          "IsActive": true,
          "CommercialSales": [
            {
              "$id": "5",
              "SaleId": 1,
              "SalePunchedBy": 1,
              "SaleDealerName": "sample string 2",
              "SaleAgentId": "sample string 3",
              "SaleAgentPhoneNumber": "sample string 4",
              "SaleAgentEmail": "sample string 5",
              "SaleCompanyName": "sample string 6",
              "SaleDBA": "sample string 7",
              "SaleMeterESID": "sample string 8",
              "SaleFirstName": "sample string 9",
              "SaleLastName": "sample string 10",
              "SalePhoneNumber": "sample string 11",
              "SaleAlternatePhone": "sample string 12",
              "SaleCustomerEmail": "sample string 13",
              "SaleServiceAddress": "sample string 14",
              "SaleCity": "sample string 15",
              "SaleSate": "sample string 16",
              "SaleZipcode": "sample string 17",
              "SaleBestTime": "sample string 18",
              "SaleContractLength": "sample string 19",
              "SaleEnrollmentType": "sample string 20",
              "SaleComments": "sample string 21",
              "SaleDate": "2025-04-10T20:18:38.6795526-07:00",
              "SaleCustomLength": "sample string 22",
              "SupplierId": 1,
              "UserId": "sample string 23",
              "Supplier": {
                "$ref": "4"
              },
              "User": {
                "$id": "6",
                "Id": "sample string 1",
                "FullName": "sample string 2",
                "PhotoPath": "sample string 3",
                "Department": "sample string 4",
                "Gender": "sample string 5",
                "TeamId": 6,
                "HireDate": "2025-04-10T20:18:38.6795526-07:00",
                "Salary": 8.1,
                "TotalSales": 9,
                "IsActive": true,
                "Email": "sample string 11",
                "EmailConfirmed": true,
                "PasswordHash": "sample string 13",
                "SecurityStamp": "sample string 14",
                "PhoneNumber": "sample string 15",
                "PhoneNumberConfirmed": true,
                "TwoFactorEnabled": true,
                "LockoutEndDateUtc": "2025-04-10T20:18:38.6795526-07:00",
                "LockoutEnabled": true,
                "AccessFailedCount": 19,
                "UserName": "sample string 20",
                "Address": "sample string 21",
                "Country": "sample string 22",
                "Designation": "sample string 23",
                "SaleTarget": 24,
                "Comments": [
                  {
                    "$id": "7",
                    "Id": 1,
                    "Date": "2025-04-10T20:18:38.6795526-07:00",
                    "Comment1": "sample string 2",
                    "SubmittedBy": "sample string 3",
                    "CustomerInfoId": 1,
                    "CustomerInfo": {
                      "$id": "8",
                      "Id": 1,
                      "Date": "2025-04-10T20:18:38.6795526-07:00",
                      "FirstName": "sample string 2",
                      "LastName": "sample string 3",
                      "PhoneNumber": "sample string 4",
                      "LookingFor": "sample string 5",
                      "AccountNumber": "sample string 6",
                      "FullAddress": "sample string 7",
                      "CallType": "sample string 8",
                      "PreviousProvider": "sample string 9",
                      "State": "sample string 10",
                      "Remarks": "sample string 11",
                      "DrivingLisence": "sample string 12",
                      "DrivingExipry": "2025-04-10T20:18:38.6795526-07:00",
                      "Email": "sample string 13",
                      "SocialSecurity": "sample string 14",
                      "DateofBirth": "2025-04-10T20:18:38.6795526-07:00",
                      "HouseOrAppartment": "sample string 15",
                      "TransferTo": "sample string 16",
                      "SerialNumber": "sample string 17",
                      "UserId": "sample string 18",
                      "CallBackDate": "2025-04-10T20:18:38.6795526-07:00",
                      "IsCompleted": true,
                      "BankName": "sample string 19",
                      "RoutingNo": "sample string 20",
                      "AccountNo": "sample string 21",
                      "ChequeNo": "sample string 22",
                      "PaymentMethod": "sample string 23",
                      "CardNo": "sample string 24",
                      "ExpirationDate": "sample string 25",
                      "CVC": "sample string 26",
                      "Comments": [
                        {
                          "$ref": "7"
                        },
                        {
                          "$ref": "7"
                        },
                        {
                          "$ref": "7"
                        }
                      ],
                      "User": {
                        "$ref": "6"
                      }
                    },
                    "User": {
                      "$ref": "6"
                    }
                  },
                  {
                    "$ref": "7"
                  },
                  {
                    "$ref": "7"
                  }
                ],
                "CommercialSales": [
                  {
                    "$ref": "5"
                  },
                  {
                    "$ref": "5"
                  },
                  {
                    "$ref": "5"
                  }
                ],
                "Customers": [
                  {
                    "$id": "9",
                    "Id": 1,
                    "CustomerName": "sample string 2",
                    "PhoneNumber": "sample string 3",
                    "Email": "sample string 4",
                    "CustomerAddress": "sample string 5",
                    "DrivingLisence": "sample string 6",
                    "DrivingLisenceExpiry": "2025-04-10T20:18:38.6795526-07:00",
                    "SocialSecurity": "sample string 7",
                    "DateOfBirth": "2025-04-10T20:18:38.6795526-07:00",
                    "FollowUpPhone": "sample string 8",
                    "ShippingAddress": "sample string 9",
                    "PremisesType": "sample string 10",
                    "CustomerDescription": "sample string 11",
                    "UserId": "sample string 12",
                    "BalanceAmount": 1.1,
                    "AdvanceAmount": 1.1,
                    "IsActive": true,
                    "Gender": "sample string 13",
                    "TransferedBy": "sample string 14",
                    "User": {
                      "$ref": "6"
                    },
                    "User1": {
                      "$ref": "6"
                    },
                    "CustomerCardDetails": [
                      {
                        "$id": "10",
                        "Id": 1,
                        "CardType": "sample string 2",
                        "NameOnCard": "sample string 3",
                        "CardNumber": "sample string 4",
                        "ExpiryMonthYear": "sample string 5",
                        "IssueMothYear": "sample string 6",
                        "CardCVV": "sample string 7",
                        "CustomerId": 1,
                        "Customer": {
                          "$ref": "9"
                        },
                        "Orders": [
                          {
                            "$id": "11",
                            "Id": 1,
                            "Date": "2025-04-10T20:18:38.6795526-07:00",
                            "OrderNumber": "sample string 2",
                            "OrderStatus": "sample string 3",
                            "FilePath": "sample string 4",
                            "PaymentRecieved": true,
                            "TotalAmount": 1.1,
                            "Discount": 1.1,
                            "ShippedDate": "2025-04-10T20:18:38.6795526-07:00",
                            "ShippingAddress": "sample string 5",
                            "ShipCity": "sample string 6",
                            "ShipRegion": "sample string 7",
                            "ShipPostalCode": "sample string 8",
                            "ShipCountry": "sample string 9",
                            "CustomerId": 1,
                            "ShipperId": 1,
                            "OrderDescription": "sample string 10",
                            "UserId": "sample string 11",
                            "IsFileUploaded": true,
                            "InvoiceSent": true,
                            "NetAmount": 1.1,
                            "CardDetailId": 1,
                            "PaidAmount": 1.1,
                            "IsCompleted": true,
                            "TrackingId": "sample string 12",
                            "ShippingDescription": "sample string 13",
                            "MacAddress": "sample string 14",
                            "ShippingInvoice": "sample string 15",
                            "CompletedDate": "2025-04-10T20:18:38.6795526-07:00",
                            "IsActive": true,
                            "NextBillingDate": "2025-04-10T20:18:38.6795526-07:00",
                            "ShipperId2": "sample string 16",
                            "IsShipped": true,
                            "ShippingDate": "2025-04-10T20:18:38.6795526-07:00",
                            "Contract": "sample string 17",
                            "OrderTime": "sample string 18",
                            "ShippmentCost": 1.1,
                            "PaymentMethod": "sample string 19",
                            "CardType": "sample string 20",
                            "TransferedBy": "sample string 21",
                            "BillPaid": true,
                            "ChequeNo": "sample string 22",
                            "AccountNo": "sample string 23",
                            "RoutingNo": "sample string 24",
                            "AccountType": "sample string 25",
                            "BankName": "sample string 26",
                            "CardNo": "sample string 27",
                            "ExpirationDate": "sample string 28",
                            "CardCVC": "sample string 29",
                            "AppDetails": [
                              {
                                "$id": "12",
                                "Id": 1,
                                "AppId": 1,
                                "OrderId": 1,
                                "Description": "sample string 2",
                                "Email": "sample string 3",
                                "Password": "sample string 4",
                                "Pin": "sample string 5",
                                "App": {
                                  "$id": "13",
                                  "Id": 1,
                                  "AppName": "sample string 2",
                                  "AppDescription": "sample string 3",
                                  "IsActive": true,
                                  "AppDetails": [
                                    {
                                      "$ref": "12"
                                    },
                                    {
                                      "$ref": "12"
                                    },
                                    {
                                      "$ref": "12"
                                    }
                                  ]
                                },
                                "Order": {
                                  "$ref": "11"
                                }
                              },
                              {
                                "$ref": "12"
                              },
                              {
                                "$ref": "12"
                              }
                            ],
                            "Customer": {
                              "$ref": "9"
                            },
                            "CustomerCardDetail": {
                              "$ref": "10"
                            },
                            "User": {
                              "$ref": "6"
                            },
                            "User1": {
                              "$ref": "6"
                            },
                            "User2": {
                              "$ref": "6"
                            },
                            "OrderDetails": [
                              {
                                "$id": "14",
                                "Id": 1,
                                "OrderId": 1,
                                "ProductId": 1,
                                "Quantity": 1,
                                "UnitPrice": 1.1,
                                "IsActive": true,
                                "Product": {
                                  "$id": "15",
                                  "Id": 1,
                                  "ProductName": "sample string 2",
                                  "PurchasePrice": 1.1,
                                  "SalePrice": 1.1,
                                  "IsMonthlyBillActive": true,
                                  "ReorderLevel": 1,
                                  "UnitsInStock": 1,
                                  "UnitsOnOrder": 1,
                                  "SupplierId": 1,
                                  "ProductDescription": "sample string 3",
                                  "UserId": "sample string 4",
                                  "ImageId": 1,
                                  "IsActive": true,
                                  "Commission": 1.1,
                                  "IsBox": true,
                                  "IsScreen": true,
                                  "OrderDetails": [
                                    {
                                      "$ref": "14"
                                    },
                                    {
                                      "$ref": "14"
                                    },
                                    {
                                      "$ref": "14"
                                    }
                                  ],
                                  "ProcessBillings": [
                                    {
                                      "$id": "16",
                                      "Id": 1,
                                      "ProductId": 1,
                                      "CustomerId": 1,
                                      "BillingMonthYear": "sample string 2",
                                      "InvoiceSent": true,
                                      "BillDueDate": "2025-04-10T20:18:38.6795526-07:00",
                                      "BillAmount": 1.1,
                                      "BillDescription": "sample string 3",
                                      "IsGenerated": true,
                                      "UserId": "sample string 4",
                                      "Customer": {
                                        "$ref": "9"
                                      },
                                      "Product": {
                                        "$ref": "15"
                                      },
                                      "User": {
                                        "$ref": "6"
                                      }
                                    },
                                    {
                                      "$ref": "16"
                                    },
                                    {
                                      "$ref": "16"
                                    }
                                  ],
                                  "ProductImage": {
                                    "$id": "17",
                                    "Id": 1,
                                    "ImageName": "sample string 2",
                                    "FilePath": "sample string 3",
                                    "Products": [
                                      {
                                        "$ref": "15"
                                      },
                                      {
                                        "$ref": "15"
                                      },
                                      {
                                        "$ref": "15"
                                      }
                                    ]
                                  },
                                  "ProductSupplier": {
                                    "$id": "18",
                                    "Id": 1,
                                    "SupplierName": "sample string 2",
                                    "ContactPersonName": "sample string 3",
                                    "PhoneNumber": "sample string 4",
                                    "Address": "sample string 5",
                                    "Email": "sample string 6",
                                    "IsActive": true,
                                    "Products": [
                                      {
                                        "$ref": "15"
                                      },
                                      {
                                        "$ref": "15"
                                      },
                                      {
                                        "$ref": "15"
                                      }
                                    ]
                                  },
                                  "User": {
                                    "$ref": "6"
                                  }
                                },
                                "Order": {
                                  "$ref": "11"
                                }
                              },
                              {
                                "$ref": "14"
                              },
                              {
                                "$ref": "14"
                              }
                            ],
                            "OrderPayments": [
                              {
                                "$id": "19",
                                "Id": 1,
                                "TrackingId": "sample string 2",
                                "ChequeNo": "sample string 3",
                                "AccountNo": "sample string 4",
                                "RoutingNo": "sample string 5",
                                "AccountType": "sample string 6",
                                "BankName": "sample string 7",
                                "Status": "sample string 8",
                                "Amount": 1.1,
                                "OrderId": 1,
                                "CustomerId": 1,
                                "ImagePath": "sample string 9",
                                "IsActive": true,
                                "AddedDate": "2025-04-10T20:18:38.6795526-07:00",
                                "DepositedDate": "2025-04-10T20:18:38.6795526-07:00",
                                "ClearanceDate": "2025-04-10T20:18:38.6795526-07:00",
                                "Comments": "sample string 10",
                                "BatchNo": "sample string 11",
                                "PaymentMethod": "sample string 12",
                                "CustomerName": "sample string 13",
                                "PhoneNumber": "sample string 14",
                                "Address": "sample string 15",
                                "Customer": {
                                  "$ref": "9"
                                },
                                "Order": {
                                  "$ref": "11"
                                }
                              },
                              {
                                "$ref": "19"
                              },
                              {
                                "$ref": "19"
                              }
                            ],
                            "PhysicalAddresses": [
                              {
                                "$id": "20",
                                "ID": 1,
                                "PhysicalAddress1": "sample string 2",
                                "OrderID": 1,
                                "EthernetAddress": "sample string 3",
                                "ActivationCode": "sample string 4",
                                "Order": {
                                  "$ref": "11"
                                }
                              },
                              {
                                "$ref": "20"
                              },
                              {
                                "$ref": "20"
                              }
                            ],
                            "ReturnedBoxes": [
                              {
                                "$id": "21",
                                "Id": 1,
                                "CustomerName": "sample string 2",
                                "OrderNumber": "sample string 3",
                                "ReturnedQuantity": 1,
                                "PhoneNumber": "sample string 4",
                                "Date": "2025-04-10T20:18:38.6795526-07:00",
                                "IsActive": true,
                                "ReturnedStatus": "sample string 5",
                                "ReturnedAmount": 1.1,
                                "TrackingId": "sample string 6",
                                "OrderId": 1,
                                "Address": "sample string 7",
                                "AmountPaid": true,
                                "ReturnedPhysicalAddresses": [
                                  {
                                    "$id": "22",
                                    "Id": 1,
                                    "PhysicalAddress": "sample string 2",
                                    "ReturnedId": 1,
                                    "ReturnedBox": {
                                      "$ref": "21"
                                    }
                                  },
                                  {
                                    "$ref": "22"
                                  },
                                  {
                                    "$ref": "22"
                                  }
                                ],
                                "Order": {
                                  "$ref": "11"
                                }
                              },
                              {
                                "$ref": "21"
                              },
                              {
                                "$ref": "21"
                              }
                            ]
                          },
                          {
                            "$ref": "11"
                          },
                          {
                            "$ref": "11"
                          }
                        ]
                      },
                      {
                        "$ref": "10"
                      },
                      {
                        "$ref": "10"
                      }
                    ],
                    "CustomerFiles": [
                      {
                        "$id": "23",
                        "Id": 1,
                        "FileName": "sample string 2",
                        "DateUploaded": "2025-04-10T20:18:38.6795526-07:00",
                        "FilePath": "sample string 3",
                        "CustomerId": 1,
                        "Customer": {
                          "$ref": "9"
                        }
                      },
                      {
                        "$ref": "23"
                      },
                      {
                        "$ref": "23"
                      }
                    ],
                    "OrderPayments": [
                      {
                        "$ref": "19"
                      },
                      {
                        "$ref": "19"
                      },
                      {
                        "$ref": "19"
                      }
                    ],
                    "ProcessBillings": [
                      {
                        "$ref": "16"
                      },
                      {
                        "$ref": "16"
                      },
                      {
                        "$ref": "16"
                      }
                    ],
                    "CustomerPayments": [
                      {
                        "$id": "24",
                        "Id": 1,
                        "CustomerId": 1,
                        "PaymentAmount": 1.1,
                        "PaymentDate": "2025-04-10T20:18:38.6795526-07:00",
                        "PaymentDescription": "sample string 2",
                        "UserId": "sample string 3",
                        "Status": "sample string 4",
                        "OrderId": 1,
                        "Customer": {
                          "$ref": "9"
                        },
                        "User": {
                          "$ref": "6"
                        }
                      },
                      {
                        "$ref": "24"
                      },
                      {
                        "$ref": "24"
                      }
                    ],
                    "Orders": [
                      {
                        "$ref": "11"
                      },
                      {
                        "$ref": "11"
                      },
                      {
                        "$ref": "11"
                      }
                    ]
                  },
                  {
                    "$ref": "9"
                  },
                  {
                    "$ref": "9"
                  }
                ],
                "Customers1": [
                  {
                    "$ref": "9"
                  },
                  {
                    "$ref": "9"
                  },
                  {
                    "$ref": "9"
                  }
                ],
                "CustomerInfoes": [
                  {
                    "$ref": "8"
                  },
                  {
                    "$ref": "8"
                  },
                  {
                    "$ref": "8"
                  }
                ],
                "NotePads": [
                  {
                    "$id": "25",
                    "Id": 1,
                    "NotePadText": "sample string 2",
                    "UserId": "sample string 3",
                    "User": {
                      "$ref": "6"
                    }
                  },
                  {
                    "$ref": "25"
                  },
                  {
                    "$ref": "25"
                  }
                ],
                "ProcessBillings": [
                  {
                    "$ref": "16"
                  },
                  {
                    "$ref": "16"
                  },
                  {
                    "$ref": "16"
                  }
                ],
                "Processors": [
                  {
                    "$id": "26",
                    "Id": 1,
                    "Date": "2025-04-10T20:18:38.6795526-07:00",
                    "Provider": "sample string 2",
                    "DeviceName": "sample string 3",
                    "DeviceSize": "sample string 4",
                    "DeviceColor": "sample string 5",
                    "OrderNo": "sample string 6",
                    "TrackingNo": "sample string 7",
                    "ExpectedDelivery": "2025-04-10T20:18:38.6795526-07:00",
                    "Status": "sample string 8",
                    "IsActive": true,
                    "TMobileId": 1,
                    "UserId": "sample string 9",
                    "TMobile": {
                      "$id": "27",
                      "Id": 1,
                      "CurrentProvider": "sample string 2",
                      "AccountNo": "sample string 3",
                      "Pin": "sample string 4",
                      "CurrentServices": "sample string 5",
                      "CustomerName": "sample string 6",
                      "PhoneNumber": "sample string 7",
                      "LandLine": "sample string 8",
                      "Address": "sample string 9",
                      "DateOfBirth": "2025-04-10T20:18:38.6795526-07:00",
                      "SocialSecurity": "sample string 10",
                      "SSNIssued": "sample string 11",
                      "Email": "sample string 12",
                      "LivingStatus": "sample string 13",
                      "Occupation": "sample string 14",
                      "DrivingLisence": "sample string 15",
                      "DrivingExpiry": "sample string 16",
                      "StateId": "sample string 17",
                      "StateIdExpiry": "sample string 18",
                      "StateIssued": "sample string 19",
                      "MedicalId": "sample string 20",
                      "CardType": "sample string 21",
                      "CardNo": "sample string 22",
                      "CardExpiry": "sample string 23",
                      "CardCVC": "sample string 24",
                      "AddressOnCard": "sample string 25",
                      "CardHolderName": "sample string 26",
                      "BestTimeToCall": "sample string 27",
                      "UserId": "sample string 28",
                      "TransferTo": "sample string 29",
                      "Comments": "sample string 30",
                      "Status": "sample string 31",
                      "IsActive": true,
                      "Commission": 1.1,
                      "CustomerReturnTracking": "sample string 32",
                      "ShippingAddress": "sample string 33",
                      "RecieverName": "sample string 34",
                      "ExpectedReturnDate": "sample string 35",
                      "Date": "2025-04-10T20:18:38.6795526-07:00",
                      "ShipperAddress": "sample string 36",
                      "Processors": [
                        {
                          "$ref": "26"
                        },
                        {
                          "$ref": "26"
                        },
                        {
                          "$ref": "26"
                        }
                      ],
                      "User": {
                        "$ref": "6"
                      },
                      "User1": {
                        "$ref": "6"
                      }
                    },
                    "User": {
                      "$ref": "6"
                    }
                  },
                  {
                    "$ref": "26"
                  },
                  {
                    "$ref": "26"
                  }
                ],
                "Products": [
                  {
                    "$ref": "15"
                  },
                  {
                    "$ref": "15"
                  },
                  {
                    "$ref": "15"
                  }
                ],
                "QuicklyPunches": [
                  {
                    "$id": "28",
                    "SaleId": 1,
                    "SalePhoneNumber": "sample string 2",
                    "SalePunchedBy": 1,
                    "SaleDate": "2025-04-10T20:18:38.6795526-07:00",
                    "SaleTotal": 1,
                    "UserId": "sample string 3",
                    "User": {
                      "$ref": "6"
                    }
                  },
                  {
                    "$ref": "28"
                  },
                  {
                    "$ref": "28"
                  }
                ],
                "ResidentialSales": [
                  {
                    "$ref": "2"
                  },
                  {
                    "$ref": "2"
                  },
                  {
                    "$ref": "2"
                  }
                ],
                "Spectra": [
                  {
                    "$id": "29",
                    "Id": 1,
                    "FullName": "sample string 2",
                    "LandLine": "sample string 3",
                    "Mobile": "sample string 4",
                    "Address": "sample string 5",
                    "DateOfBirth": "2025-04-10T20:18:38.6795526-07:00",
                    "SocialSecurity": "sample string 6",
                    "BankName": "sample string 7",
                    "RoutingNo": "sample string 8",
                    "AccountNo": "sample string 9",
                    "ChequeNo": "sample string 10",
                    "BillAccountNo": "sample string 11",
                    "SecurityCode": "sample string 12",
                    "PaymentMethod": "sample string 13",
                    "CardNo": "sample string 14",
                    "ExpirationDate": "sample string 15",
                    "CVC": "sample string 16",
                    "Status": "sample string 17",
                    "Amount": 1.1,
                    "UserId": "sample string 18",
                    "TransferedBy": "sample string 19",
                    "Date": "2025-04-10T20:18:38.6795526-07:00",
                    "IsActive": true,
                    "OrderNumber": "sample string 20",
                    "OrderTime": "sample string 21",
                    "Comments": "sample string 22",
                    "Commission": 1.1,
                    "User": {
                      "$ref": "6"
                    },
                    "User1": {
                      "$ref": "6"
                    }
                  },
                  {
                    "$ref": "29"
                  },
                  {
                    "$ref": "29"
                  }
                ],
                "Spectra1": [
                  {
                    "$ref": "29"
                  },
                  {
                    "$ref": "29"
                  },
                  {
                    "$ref": "29"
                  }
                ],
                "TelecomSales": [
                  {
                    "$id": "30",
                    "Id": 1,
                    "PhoneNumber": "sample string 2",
                    "FullName": "sample string 3",
                    "State": "sample string 4",
                    "ServiceName": "sample string 5",
                    "SaleType": "sample string 6",
                    "TermPlan": "sample string 7",
                    "ServiceAddress": "sample string 8",
                    "BillingAddress": "sample string 9",
                    "PersonOnPhone": "sample string 10",
                    "DrivingLisence": "sample string 11",
                    "DrivingLisenceExpiry": "2025-04-10T20:18:38.6795526-07:00",
                    "CustomerEmail": "sample string 12",
                    "SocialSecurity": "sample string 13",
                    "DateOfBirth": "2025-04-10T20:18:38.6795526-07:00",
                    "FollowUpPhone": "sample string 14",
                    "PremisesType": "sample string 15",
                    "OrderId": "sample string 16",
                    "UserEmail": "sample string 17",
                    "BundleType": "sample string 18",
                    "ModeOfPayment": "sample string 19",
                    "CardHolderName": "sample string 20",
                    "CardNumber": "sample string 21",
                    "CardIssueDate": "sample string 22",
                    "CardExpiryDate": "sample string 23",
                    "CardCVV": "sample string 24",
                    "BankName": "sample string 25",
                    "MonthlyPrice": "sample string 26",
                    "RepId": "sample string 27",
                    "Fronter": "sample string 28",
                    "UserId": "sample string 29",
                    "Description": "sample string 30",
                    "Date": "2025-04-10T20:18:38.6795526-07:00",
                    "SupplierId": 1,
                    "Supplier": {
                      "$ref": "4"
                    },
                    "User": {
                      "$ref": "6"
                    }
                  },
                  {
                    "$ref": "30"
                  },
                  {
                    "$ref": "30"
                  }
                ],
                "TMobiles": [
                  {
                    "$ref": "27"
                  },
                  {
                    "$ref": "27"
                  },
                  {
                    "$ref": "27"
                  }
                ],
                "TMobiles1": [
                  {
                    "$ref": "27"
                  },
                  {
                    "$ref": "27"
                  },
                  {
                    "$ref": "27"
                  }
                ],
                "UserClaims": [
                  {
                    "$id": "31",
                    "Id": 1,
                    "UserId": "sample string 2",
                    "ClaimType": "sample string 3",
                    "ClaimValue": "sample string 4",
                    "User": {
                      "$ref": "6"
                    }
                  },
                  {
                    "$ref": "31"
                  },
                  {
                    "$ref": "31"
                  }
                ],
                "UserLogins": [
                  {
                    "$id": "32",
                    "LoginProvider": "sample string 1",
                    "ProviderKey": "sample string 2",
                    "UserId": "sample string 3",
                    "User": {
                      "$ref": "6"
                    }
                  },
                  {
                    "$ref": "32"
                  },
                  {
                    "$ref": "32"
                  }
                ],
                "Roles": [
                  {
                    "$id": "33",
                    "Id": "sample string 1",
                    "Name": "sample string 2",
                    "Users": [
                      {
                        "$ref": "6"
                      },
                      {
                        "$ref": "6"
                      },
                      {
                        "$ref": "6"
                      }
                    ]
                  },
                  {
                    "$ref": "33"
                  },
                  {
                    "$ref": "33"
                  }
                ],
                "UserGroupAssocs": [
                  {
                    "$id": "34",
                    "Id": 1,
                    "GroupId": 1,
                    "UserId": "sample string 2",
                    "IsActive": true,
                    "User": {
                      "$ref": "6"
                    },
                    "UserGroup": {
                      "$id": "35",
                      "Id": 1,
                      "Name": "sample string 2",
                      "IsActive": true,
                      "DateCreated": "2025-04-10T20:18:38.6795526-07:00",
                      "UserGroupAssocs": [
                        {
                          "$ref": "34"
                        },
                        {
                          "$ref": "34"
                        },
                        {
                          "$ref": "34"
                        }
                      ],
                      "Tasks": [
                        {
                          "$id": "36",
                          "ID": 1,
                          "DateCreated": "2025-04-10T20:18:38.6795526-07:00",
                          "DateCompleted": "2025-04-10T20:18:38.6795526-07:00",
                          "AssignedBy": "sample string 2",
                          "AssignedTo": "sample string 3",
                          "TaskTitle": "sample string 4",
                          "TaskDescription": "sample string 5",
                          "IsActive": true,
                          "StatusId": 1,
                          "GroupId": 1,
                          "TaskStatu": {
                            "$id": "37",
                            "ID": 1,
                            "Title": "sample string 2",
                            "ColorCode": "sample string 3",
                            "IsActive": true,
                            "Tasks": [
                              {
                                "$ref": "36"
                              },
                              {
                                "$ref": "36"
                              },
                              {
                                "$ref": "36"
                              }
                            ]
                          },
                          "User": {
                            "$ref": "6"
                          },
                          "User1": {
                            "$ref": "6"
                          },
                          "UserGroup": {
                            "$ref": "35"
                          }
                        },
                        {
                          "$ref": "36"
                        },
                        {
                          "$ref": "36"
                        }
                      ]
                    }
                  },
                  {
                    "$ref": "34"
                  },
                  {
                    "$ref": "34"
                  }
                ],
                "Tasks": [
                  {
                    "$ref": "36"
                  },
                  {
                    "$ref": "36"
                  },
                  {
                    "$ref": "36"
                  }
                ],
                "Tasks1": [
                  {
                    "$ref": "36"
                  },
                  {
                    "$ref": "36"
                  },
                  {
                    "$ref": "36"
                  }
                ],
                "CustomerPayments": [
                  {
                    "$ref": "24"
                  },
                  {
                    "$ref": "24"
                  },
                  {
                    "$ref": "24"
                  }
                ],
                "Orders": [
                  {
                    "$ref": "11"
                  },
                  {
                    "$ref": "11"
                  },
                  {
                    "$ref": "11"
                  }
                ],
                "Orders1": [
                  {
                    "$ref": "11"
                  },
                  {
                    "$ref": "11"
                  },
                  {
                    "$ref": "11"
                  }
                ],
                "Orders2": [
                  {
                    "$ref": "11"
                  },
                  {
                    "$ref": "11"
                  },
                  {
                    "$ref": "11"
                  }
                ],
                "Attendances": [
                  {
                    "$id": "38",
                    "Id": 1,
                    "Date": "2025-04-10T20:18:38.6795526-07:00",
                    "TimeIn": "2025-04-10T20:18:38.6795526-07:00",
                    "TimeOut": "2025-04-10T20:18:38.6795526-07:00",
                    "TimeSpent": 1.0,
                    "UserId": "sample string 2",
                    "IsActive": true,
                    "Status": "sample string 3",
                    "UserId2": "sample string 4",
                    "HoursMinutes": "sample string 5",
                    "DailyStatus": "sample string 6",
                    "User": {
                      "$ref": "6"
                    },
                    "User1": {
                      "$ref": "6"
                    }
                  },
                  {
                    "$ref": "38"
                  },
                  {
                    "$ref": "38"
                  }
                ],
                "Attendances1": [
                  {
                    "$ref": "38"
                  },
                  {
                    "$ref": "38"
                  },
                  {
                    "$ref": "38"
                  }
                ]
              }
            },
            {
              "$ref": "5"
            },
            {
              "$ref": "5"
            }
          ],
          "ResidentialSales": [
            {
              "$ref": "2"
            },
            {
              "$ref": "2"
            },
            {
              "$ref": "2"
            }
          ],
          "TelecomSales": [
            {
              "$ref": "30"
            },
            {
              "$ref": "30"
            },
            {
              "$ref": "30"
            }
          ]
        },
        "User": {
          "$ref": "6"
        },
        "Utility": {
          "$ref": "1"
        }
      },
      {
        "$ref": "2"
      },
      {
        "$ref": "2"
      }
    ],
    "State": {
      "$ref": "3"
    },
    "UtilityBills": [
      {
        "$id": "39",
        "Id": 1,
        "DateUploaded": "2025-04-10T20:18:38.6795526-07:00",
        "FileName": "sample string 2",
        "FilePath": "sample string 3",
        "UtilityId": 1,
        "Utility": {
          "$ref": "1"
        }
      },
      {
        "$ref": "39"
      },
      {
        "$ref": "39"
      }
    ]
  },
  {
    "$ref": "1"
  },
  {
    "$ref": "1"
  }
]