[ { "jobno": "97", "workorderno": [ "14691" ], "description": "Test Job", "status": "New", "startdate": "2025-04-23 16:27:10", "estcompletiondate": "2025-05-07 16:27:10", "contactperson": "Jane Doe", "contactphone": "8001112345", "note": null, "servicewriter": "App Tester", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "96", "workorderno": [ "14690" ], "description": "Test Job", "status": "New", "startdate": "2025-04-23 15:58:19", "estcompletiondate": "2025-05-07 15:58:19", "contactperson": "John Doe", "contactphone": "8001112345", "note": null, "servicewriter": "App Tester2", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "95", "workorderno": [ "14550" ], "description": "House", "status": "New", "startdate": "2025-03-21 12:20:59", "estcompletiondate": "2025-04-04 12:20:59", "contactperson": "Forrest ", "contactphone": "8038448240", "note": null, "servicewriter": null, "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "94", "workorderno": [], "description": "New Android Job", "status": "New", "startdate": "2025-03-19 16:58:23", "estcompletiondate": "2025-04-02 16:58:23", "contactperson": "Paul Amick", "contactphone": "8036220358", "note": null, "servicewriter": "", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "93", "workorderno": [ "14622" ], "description": "Main Street Site", "status": "New", "startdate": "2025-03-13 13:18:07", "estcompletiondate": "2025-03-27 13:18:07", "contactperson": "Tommy Davis", "contactphone": "18005553344", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "93", "workorderno": [ "14493" ], "description": "Main Street Site", "status": "New", "startdate": "2025-03-13 13:18:07", "estcompletiondate": "2025-03-27 13:18:07", "contactperson": "Tommy Davis", "contactphone": "18005553344", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "93", "workorderno": [ "14495" ], "description": "Main Street Site", "status": "New", "startdate": "2025-03-13 13:18:07", "estcompletiondate": "2025-03-27 13:18:07", "contactperson": "Tommy Davis", "contactphone": "18005553344", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "93", "workorderno": [ "14504" ], "description": "Main Street Site", "status": "New", "startdate": "2025-03-13 13:18:07", "estcompletiondate": "2025-03-27 13:18:07", "contactperson": "Tommy Davis", "contactphone": "18005553344", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "93", "workorderno": [ "14505" ], "description": "Main Street Site", "status": "New", "startdate": "2025-03-13 13:18:07", "estcompletiondate": "2025-03-27 13:18:07", "contactperson": "Tommy Davis", "contactphone": "18005553344", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "93", "workorderno": [ "14528" ], "description": "Main Street Site", "status": "New", "startdate": "2025-03-13 13:18:07", "estcompletiondate": "2025-03-27 13:18:07", "contactperson": "Tommy Davis", "contactphone": "18005553344", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "93", "workorderno": [ "14532" ], "description": "Main Street Site", "status": "New", "startdate": "2025-03-13 13:18:07", "estcompletiondate": "2025-03-27 13:18:07", "contactperson": "Tommy Davis", "contactphone": "18005553344", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "86", "workorderno": [ "14494" ], "description": "Amico", "status": "New", "startdate": "2025-03-12 20:50:43", "estcompletiondate": "2025-03-26 20:50:43", "contactperson": "Datacom", "contactphone": "8036226609", "note": null, "servicewriter": "Si A", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "2" }, { "jobno": "86", "workorderno": [ "14496" ], "description": "Amico", "status": "New", "startdate": "2025-03-12 20:50:43", "estcompletiondate": "2025-03-26 20:50:43", "contactperson": "Datacom", "contactphone": "8036226609", "note": null, "servicewriter": "Si A", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "2" }, { "jobno": "85", "workorderno": [ "14476" ], "description": "Downtown Hotel", "status": "New", "startdate": "2025-03-11 20:36:04", "estcompletiondate": "2025-03-25 20:36:04", "contactperson": "Chris Smith", "contactphone": "803-445-6698", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "11" }, { "jobno": "85", "workorderno": [ "14477" ], "description": "Downtown Hotel", "status": "New", "startdate": "2025-03-11 20:36:04", "estcompletiondate": "2025-03-25 20:36:04", "contactperson": "Chris Smith", "contactphone": "803-445-6698", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "11" }, { "jobno": "85", "workorderno": [ "14478" ], "description": "Downtown Hotel", "status": "New", "startdate": "2025-03-11 20:36:04", "estcompletiondate": "2025-03-25 20:36:04", "contactperson": "Chris Smith", "contactphone": "803-445-6698", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "11" }, { "jobno": "85", "workorderno": [ "14479" ], "description": "Downtown Hotel", "status": "New", "startdate": "2025-03-11 20:36:04", "estcompletiondate": "2025-03-25 20:36:04", "contactperson": "Chris Smith", "contactphone": "803-445-6698", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "11" }, { "jobno": "85", "workorderno": [ "14480" ], "description": "Downtown Hotel", "status": "New", "startdate": "2025-03-11 20:36:04", "estcompletiondate": "2025-03-25 20:36:04", "contactperson": "Chris Smith", "contactphone": "803-445-6698", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "11" }, { "jobno": "85", "workorderno": [ "14481" ], "description": "Downtown Hotel", "status": "New", "startdate": "2025-03-11 20:36:04", "estcompletiondate": "2025-03-25 20:36:04", "contactperson": "Chris Smith", "contactphone": "803-445-6698", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "11" }, { "jobno": "85", "workorderno": [ "14484" ], "description": "Downtown Hotel", "status": "New", "startdate": "2025-03-11 20:36:04", "estcompletiondate": "2025-03-25 20:36:04", "contactperson": "Chris Smith", "contactphone": "803-445-6698", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "11" }, { "jobno": "85", "workorderno": [ "14485" ], "description": "Downtown Hotel", "status": "New", "startdate": "2025-03-11 20:36:04", "estcompletiondate": "2025-03-25 20:36:04", "contactperson": "Chris Smith", "contactphone": "803-445-6698", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "11" }, { "jobno": "85", "workorderno": [ "14486" ], "description": "Downtown Hotel", "status": "New", "startdate": "2025-03-11 20:36:04", "estcompletiondate": "2025-03-25 20:36:04", "contactperson": "Chris Smith", "contactphone": "803-445-6698", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "11" }, { "jobno": "85", "workorderno": [ "14487" ], "description": "Downtown Hotel", "status": "New", "startdate": "2025-03-11 20:36:04", "estcompletiondate": "2025-03-25 20:36:04", "contactperson": "Chris Smith", "contactphone": "803-445-6698", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "11" }, { "jobno": "85", "workorderno": [ "14488" ], "description": "Downtown Hotel", "status": "New", "startdate": "2025-03-11 20:36:04", "estcompletiondate": "2025-03-25 20:36:04", "contactperson": "Chris Smith", "contactphone": "803-445-6698", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "11" }, { "jobno": "84", "workorderno": [ "14439" ], "description": "Atlanta Library", "status": "New", "startdate": "2025-03-04 16:15:52", "estcompletiondate": "2025-03-18 17:15:52", "contactperson": "1st Choice Glass", "contactphone": "8004438852", "note": null, "servicewriter": "", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "5" }, { "jobno": "84", "workorderno": [ "14440" ], "description": "Atlanta Library", "status": "New", "startdate": "2025-03-04 16:15:52", "estcompletiondate": "2025-03-18 17:15:52", "contactperson": "1st Choice Glass", "contactphone": "8004438852", "note": null, "servicewriter": "", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "5" }, { "jobno": "84", "workorderno": [ "14441" ], "description": "Atlanta Library", "status": "New", "startdate": "2025-03-04 16:15:52", "estcompletiondate": "2025-03-18 17:15:52", "contactperson": "1st Choice Glass", "contactphone": "8004438852", "note": null, "servicewriter": "", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "5" }, { "jobno": "84", "workorderno": [ "14442" ], "description": "Atlanta Library", "status": "New", "startdate": "2025-03-04 16:15:52", "estcompletiondate": "2025-03-18 17:15:52", "contactperson": "1st Choice Glass", "contactphone": "8004438852", "note": null, "servicewriter": "", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "5" }, { "jobno": "84", "workorderno": [ "14443" ], "description": "Atlanta Library", "status": "New", "startdate": "2025-03-04 16:15:52", "estcompletiondate": "2025-03-18 17:15:52", "contactperson": "1st Choice Glass", "contactphone": "8004438852", "note": null, "servicewriter": "", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "5" }, { "jobno": "83", "workorderno": [ "14437" ], "description": "High Rise Office Building", "status": "New", "startdate": "2025-03-03 16:01:28", "estcompletiondate": "2025-03-17 17:01:28", "contactperson": "Mark Casey", "contactphone": "8004127869", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "4" }, { "jobno": "83", "workorderno": [ "14445" ], "description": "High Rise Office Building", "status": "New", "startdate": "2025-03-03 16:01:28", "estcompletiondate": "2025-03-17 17:01:28", "contactperson": "Mark Casey", "contactphone": "8004127869", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "4" }, { "jobno": "83", "workorderno": [ "14446" ], "description": "High Rise Office Building", "status": "New", "startdate": "2025-03-03 16:01:28", "estcompletiondate": "2025-03-17 17:01:28", "contactperson": "Mark Casey", "contactphone": "8004127869", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "4" }, { "jobno": "83", "workorderno": [ "14451" ], "description": "High Rise Office Building", "status": "New", "startdate": "2025-03-03 16:01:28", "estcompletiondate": "2025-03-17 17:01:28", "contactperson": "Mark Casey", "contactphone": "8004127869", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "4" }, { "jobno": "81", "workorderno": [ "14411" ], "description": "Condo Roof Repair", "status": "New", "startdate": "2025-03-01 18:36:07", "estcompletiondate": "2025-03-15 19:36:07", "contactperson": "John Hampton", "contactphone": "8037303507", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "10" }, { "jobno": "81", "workorderno": [ "14413" ], "description": "Condo Roof Repair", "status": "New", "startdate": "2025-03-01 18:36:07", "estcompletiondate": "2025-03-15 19:36:07", "contactperson": "John Hampton", "contactphone": "8037303507", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "10" }, { "jobno": "81", "workorderno": [ "14414" ], "description": "Condo Roof Repair", "status": "New", "startdate": "2025-03-01 18:36:07", "estcompletiondate": "2025-03-15 19:36:07", "contactperson": "John Hampton", "contactphone": "8037303507", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "10" }, { "jobno": "81", "workorderno": [ "14415" ], "description": "Condo Roof Repair", "status": "New", "startdate": "2025-03-01 18:36:07", "estcompletiondate": "2025-03-15 19:36:07", "contactperson": "John Hampton", "contactphone": "8037303507", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "10" }, { "jobno": "81", "workorderno": [ "14416" ], "description": "Condo Roof Repair", "status": "New", "startdate": "2025-03-01 18:36:07", "estcompletiondate": "2025-03-15 19:36:07", "contactperson": "John Hampton", "contactphone": "8037303507", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "10" }, { "jobno": "81", "workorderno": [ "14418" ], "description": "Condo Roof Repair", "status": "New", "startdate": "2025-03-01 18:36:07", "estcompletiondate": "2025-03-15 19:36:07", "contactperson": "John Hampton", "contactphone": "8037303507", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "10" }, { "jobno": "81", "workorderno": [ "14419" ], "description": "Condo Roof Repair", "status": "New", "startdate": "2025-03-01 18:36:07", "estcompletiondate": "2025-03-15 19:36:07", "contactperson": "John Hampton", "contactphone": "8037303507", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "10" }, { "jobno": "81", "workorderno": [ "14423" ], "description": "Condo Roof Repair", "status": "New", "startdate": "2025-03-01 18:36:07", "estcompletiondate": "2025-03-15 19:36:07", "contactperson": "John Hampton", "contactphone": "8037303507", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "10" }, { "jobno": "81", "workorderno": [ "14424" ], "description": "Condo Roof Repair", "status": "New", "startdate": "2025-03-01 18:36:07", "estcompletiondate": "2025-03-15 19:36:07", "contactperson": "John Hampton", "contactphone": "8037303507", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "10" }, { "jobno": "81", "workorderno": [ "14425" ], "description": "Condo Roof Repair", "status": "New", "startdate": "2025-03-01 18:36:07", "estcompletiondate": "2025-03-15 19:36:07", "contactperson": "John Hampton", "contactphone": "8037303507", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "10" }, { "jobno": "80", "workorderno": [ "14409" ], "description": "Nanas House", "status": "New", "startdate": "2025-03-01 13:56:00", "estcompletiondate": "2025-03-15 14:56:00", "contactperson": "Judy Poston", "contactphone": "8034608199", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "2" }, { "jobno": "80", "workorderno": [ "14410" ], "description": "Nanas House", "status": "New", "startdate": "2025-03-01 13:56:00", "estcompletiondate": "2025-03-15 14:56:00", "contactperson": "Judy Poston", "contactphone": "8034608199", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "2" }, { "jobno": "79", "workorderno": [ "14396" ], "description": "Home", "status": "New", "startdate": "2025-02-28 15:46:34", "estcompletiondate": "2025-03-14 16:46:34", "contactperson": "Paul Amick", "contactphone": "8036220358", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "3" }, { "jobno": "79", "workorderno": [ "14395" ], "description": "Home", "status": "New", "startdate": "2025-02-28 15:46:34", "estcompletiondate": "2025-03-14 16:46:34", "contactperson": "Paul Amick", "contactphone": "8036220358", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "3" }, { "jobno": "79", "workorderno": [ "14386" ], "description": "Home", "status": "New", "startdate": "2025-02-28 15:46:34", "estcompletiondate": "2025-03-14 16:46:34", "contactperson": "Paul Amick", "contactphone": "8036220358", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "3" }, { "jobno": "78", "workorderno": [], "description": "First Job", "status": "New", "startdate": "2025-02-28 15:27:03", "estcompletiondate": "2025-03-14 16:27:03", "contactperson": null, "contactphone": null, "note": null, "servicewriter": "pwamick", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "77", "workorderno": [ "14368" ], "description": "Hotel Site", "status": "New", "startdate": "2025-02-28 12:13:46", "estcompletiondate": "2025-03-14 13:13:46", "contactperson": "Greg Smith", "contactphone": "803-222-5600", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "2" }, { "jobno": "77", "workorderno": [ "14385" ], "description": "Hotel Site", "status": "New", "startdate": "2025-02-28 12:13:46", "estcompletiondate": "2025-03-14 13:13:46", "contactperson": "Greg Smith", "contactphone": "803-222-5600", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "2" }, { "jobno": "76", "workorderno": [ "14360" ], "description": "1209 Princeton Street", "status": "New", "startdate": "2025-02-27 16:31:21", "estcompletiondate": "2025-03-13 17:31:21", "contactperson": "Maggie Amick", "contactphone": "803-622-0358", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "3" }, { "jobno": "76", "workorderno": [ "14361" ], "description": "1209 Princeton Street", "status": "New", "startdate": "2025-02-27 16:31:21", "estcompletiondate": "2025-03-13 17:31:21", "contactperson": "Maggie Amick", "contactphone": "803-622-0358", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "3" }, { "jobno": "76", "workorderno": [ "14362" ], "description": "1209 Princeton Street", "status": "New", "startdate": "2025-02-27 16:31:21", "estcompletiondate": "2025-03-13 17:31:21", "contactperson": "Maggie Amick", "contactphone": "803-622-0358", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "3" }, { "jobno": "75", "workorderno": [], "description": "Full Details With Notes", "status": "New", "startdate": "2025-02-27 14:17:54", "estcompletiondate": "2025-03-13 15:17:54", "contactperson": "Gary Play", "contactphone": "800-346-2399", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "69", "workorderno": [], "description": "Testing Notes Again With Full Details", "status": "New", "startdate": "2025-02-27 10:55:37", "estcompletiondate": "2025-03-13 11:55:37", "contactperson": "Hank Aaron", "contactphone": "111-444-7777", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "63", "workorderno": [ "14357" ], "description": "Full Details Job Test", "status": "New", "startdate": "2025-02-27 09:53:00", "estcompletiondate": "2025-03-13 10:53:00", "contactperson": "Grant Stone", "contactphone": "800-456-1278", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "59", "workorderno": [], "description": "Entered Date Php Update Test", "status": "New", "startdate": "2025-02-27 09:14:32", "estcompletiondate": "2025-03-13 10:14:32", "contactperson": null, "contactphone": null, "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "56", "workorderno": [], "description": "Another Date Test 2", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-12-25 12:48:00", "contactperson": null, "contactphone": null, "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "55", "workorderno": [], "description": "Another Date Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-12-25 12:46:00", "contactperson": null, "contactphone": null, "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "54", "workorderno": [], "description": "Date Created Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-12-25 12:44:00", "contactperson": null, "contactphone": null, "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "53", "workorderno": [], "description": "New Date Format Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-12-25 12:36:00", "contactperson": "Billy Brown", "contactphone": "803-772-4456", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "52", "workorderno": [], "description": "Full Details Date Formatter Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-12-25 12:04:00", "contactperson": null, "contactphone": null, "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "51", "workorderno": [], "description": "Another Full Details Job Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-12-25 11:36:00", "contactperson": "Hank Pollard", "contactphone": "789-234-3400", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "50", "workorderno": [], "description": "Full Details Job", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-12-25 11:23:00", "contactperson": "Ted Smith", "contactphone": "803-675-4533", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "49", "workorderno": [], "description": "New No Work Orders Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-12-25 10:50:00", "contactperson": "Billy Bob", "contactphone": "803-777-9999", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "48", "workorderno": [], "description": "No Workorder Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-12-25 10:32:00", "contactperson": null, "contactphone": null, "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "47", "workorderno": [], "description": "Main Street", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-12-25 09:43:00", "contactperson": "Greg Steel", "contactphone": "800-222-4500", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "46", "workorderno": [ "14324" ], "description": "Downtown", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 06:05:00", "contactperson": "Paul Amick", "contactphone": "1116667777", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "45", "workorderno": [], "description": "Contact Test Again", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 05:11:00", "contactperson": "Frank Tank", "contactphone": "803-476-4327", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "44", "workorderno": [], "description": "New", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 04:47:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "43", "workorderno": [], "description": "Another Contact Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 04:21:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "42", "workorderno": [], "description": "Contact Info Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 04:17:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "41", "workorderno": [ "14258" ], "description": "Refresh Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 04:00:00", "contactperson": "Hank Green", "contactphone": "111-222-3333", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "3" }, { "jobno": "41", "workorderno": [ "14259" ], "description": "Refresh Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 04:00:00", "contactperson": "Hank Green", "contactphone": "111-222-3333", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "3" }, { "jobno": "41", "workorderno": [ "14260" ], "description": "Refresh Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 04:00:00", "contactperson": "Hank Green", "contactphone": "111-222-3333", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "3" }, { "jobno": "40", "workorderno": [ "14238" ], "description": "Testing Updated Stored Procedure", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 03:45:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "40", "workorderno": [ "14239" ], "description": "Testing Updated Stored Procedure", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 03:45:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "40", "workorderno": [ "14240" ], "description": "Testing Updated Stored Procedure", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 03:45:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "40", "workorderno": [ "14250" ], "description": "Testing Updated Stored Procedure", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 03:45:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "40", "workorderno": [ "14251" ], "description": "Testing Updated Stored Procedure", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 03:45:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "40", "workorderno": [ "14252" ], "description": "Testing Updated Stored Procedure", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 03:45:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "40", "workorderno": [ "14253" ], "description": "Testing Updated Stored Procedure", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 03:45:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "39", "workorderno": [ "14237" ], "description": "Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 03:23:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "38", "workorderno": [ "14134" ], "description": "Office Building", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 12:41:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "37", "workorderno": [ "14127" ], "description": "Testing Work Order Count", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 11:11:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "3" }, { "jobno": "37", "workorderno": [ "14128" ], "description": "Testing Work Order Count", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 11:11:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "3" }, { "jobno": "37", "workorderno": [ "14129" ], "description": "Testing Work Order Count", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-11-25 11:11:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "3" }, { "jobno": "36", "workorderno": [ "14110" ], "description": "Marriott Hotel", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-10-25 08:49:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "36", "workorderno": [ "14112" ], "description": "Marriott Hotel", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-10-25 08:49:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "36", "workorderno": [ "14113" ], "description": "Marriott Hotel", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-10-25 08:49:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "36", "workorderno": [ "14114" ], "description": "Marriott Hotel", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-10-25 08:49:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "36", "workorderno": [ "14118" ], "description": "Marriott Hotel", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-10-25 08:49:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "36", "workorderno": [ "14119" ], "description": "Marriott Hotel", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-10-25 08:49:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "36", "workorderno": [ "14122" ], "description": "Marriott Hotel", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-10-25 08:49:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "7" }, { "jobno": "35", "workorderno": [ "14101" ], "description": "Detailed Job Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-10-25 07:37:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "2" }, { "jobno": "35", "workorderno": [ "14102" ], "description": "Detailed Job Test", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0003-10-25 07:37:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "2" }, { "jobno": "34", "workorderno": [ "14099" ], "description": "New 8", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0000-00-00 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "33", "workorderno": [ "14098" ], "description": "New 7", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0000-00-00 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "32", "workorderno": [ "14079" ], "description": "New 6", "status": "New", "startdate": "0000-00-00 00:00:00", "estcompletiondate": "0000-00-00 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "31", "workorderno": [ "14321" ], "description": "New", "status": "New", "startdate": "2024-02-01 00:00:00", "estcompletiondate": "2024-03-15 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "30", "workorderno": [], "description": "Test", "status": "New", "startdate": "2024-02-01 00:00:00", "estcompletiondate": "2024-03-15 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "29", "workorderno": [], "description": "Randall job", "status": "New", "startdate": "2024-02-01 00:00:00", "estcompletiondate": "2024-03-15 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Randall", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "28", "workorderno": [ "14302" ], "description": "Downtown", "status": "New", "startdate": "2024-02-01 00:00:00", "estcompletiondate": "2024-03-15 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Stephen", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "27", "workorderno": [], "description": "Stephen's building", "status": "New", "startdate": "2024-02-01 00:00:00", "estcompletiondate": "2024-03-15 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Stephen", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "26", "workorderno": [], "description": "High rise", "status": "New", "startdate": "2024-02-01 00:00:00", "estcompletiondate": "2024-03-15 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Kathy Smith", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": null }, { "jobno": "20", "workorderno": [ "14301" ], "description": "New", "status": "New", "startdate": "2024-02-01 00:00:00", "estcompletiondate": "2024-03-15 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Stephen", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "15", "workorderno": [ "14283" ], "description": "Kathy new", "status": "New", "startdate": "2024-02-01 00:00:00", "estcompletiondate": "2024-03-15 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Kathy Smith", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "14", "workorderno": [ "13943" ], "description": "New", "status": "New", "startdate": "2024-02-01 00:00:00", "estcompletiondate": "2024-03-15 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Kathy Smith", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "1" }, { "jobno": "13", "workorderno": [ "14261" ], "description": "Home", "status": "New", "startdate": "2024-02-01 00:00:00", "estcompletiondate": "2024-03-15 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Paul Amick", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "4" }, { "jobno": "13", "workorderno": [ "14262" ], "description": "Home", "status": "New", "startdate": "2024-02-01 00:00:00", "estcompletiondate": "2024-03-15 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Paul Amick", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "4" }, { "jobno": "13", "workorderno": [ "14264" ], "description": "Home", "status": "New", "startdate": "2024-02-01 00:00:00", "estcompletiondate": "2024-03-15 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Paul Amick", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "4" }, { "jobno": "13", "workorderno": [ "14265" ], "description": "Home", "status": "New", "startdate": "2024-02-01 00:00:00", "estcompletiondate": "2024-03-15 00:00:00", "contactperson": "", "contactphone": "", "note": null, "servicewriter": "Paul Amick", "billing_id": null, "billing_firstname": null, "billing_midinit": null, "billing_lastname": null, "billing_address1": null, "billing_address2": null, "billing_city": null, "billing_state": null, "billing_postalcode": null, "billing_county": null, "billing_phone1": null, "billing_phone2": null, "billing_contactperson": null, "billing_note": null, "service_id": null, "service_firstname": null, "service_midinit": null, "service_lastname": null, "service_address1": null, "service_address2": null, "service_city": null, "service_state": null, "service_postalcode": null, "service_county": null, "service_phone1": null, "service_phone2": null, "service_contactperson": null, "service_note": null, "customerid": "", "serviceid": "", "surveys": "4" }, { "jobno": "12", "workorderno": [ "13917" ], "description": "Job 12 updated description from iOS", "status": "", "startdate": null, "estcompletiondate": null, "contactperson": "S102Contact", "contactphone": "933-333-3333", "note": "", "servicewriter": "Kathy Smith", "billing_id": "Job1002", "billing_firstname": "J102First", "billing_midinit": "MidInit", "billing_lastname": "J102Last", "billing_address1": "J102Addr1", "billing_address2": "J1002ddr2", "billing_city": "J102City", "billing_state": "SGA", "billing_postalcode": "00102", "billing_county": null, "billing_phone1": "333-333-3333", "billing_phone2": null, "billing_contactperson": "J102Contact", "billing_note": null, "service_id": "S1002", "service_firstname": "S102First", "service_midinit": "MidInit", "service_lastname": "S102Last", "service_address1": "SJ102Addr1", "service_address2": "S1002ddr2", "service_city": "S102City", "service_state": "HI", "service_postalcode": "90102", "service_county": null, "service_phone1": "933-333-3333", "service_phone2": null, "service_contactperson": "S102Contact", "service_note": null, "customerid": "Job1002", "serviceid": "S1002", "surveys": "4" }, { "jobno": "12", "workorderno": [ "13918" ], "description": "Job 12 updated description from iOS", "status": "", "startdate": null, "estcompletiondate": null, "contactperson": "S102Contact", "contactphone": "933-333-3333", "note": "", "servicewriter": "Kathy Smith", "billing_id": "Job1002", "billing_firstname": "J102First", "billing_midinit": "MidInit", "billing_lastname": "J102Last", "billing_address1": "J102Addr1", "billing_address2": "J1002ddr2", "billing_city": "J102City", "billing_state": "SGA", "billing_postalcode": "00102", "billing_county": null, "billing_phone1": "333-333-3333", "billing_phone2": null, "billing_contactperson": "J102Contact", "billing_note": null, "service_id": "S1002", "service_firstname": "S102First", "service_midinit": "MidInit", "service_lastname": "S102Last", "service_address1": "SJ102Addr1", "service_address2": "S1002ddr2", "service_city": "S102City", "service_state": "HI", "service_postalcode": "90102", "service_county": null, "service_phone1": "933-333-3333", "service_phone2": null, "service_contactperson": "S102Contact", "service_note": null, "customerid": "Job1002", "serviceid": "S1002", "surveys": "4" }, { "jobno": "12", "workorderno": [ "13919" ], "description": "Job 12 updated description from iOS", "status": "", "startdate": null, "estcompletiondate": null, "contactperson": "S102Contact", "contactphone": "933-333-3333", "note": "", "servicewriter": "Kathy Smith", "billing_id": "Job1002", "billing_firstname": "J102First", "billing_midinit": "MidInit", "billing_lastname": "J102Last", "billing_address1": "J102Addr1", "billing_address2": "J1002ddr2", "billing_city": "J102City", "billing_state": "SGA", "billing_postalcode": "00102", "billing_county": null, "billing_phone1": "333-333-3333", "billing_phone2": null, "billing_contactperson": "J102Contact", "billing_note": null, "service_id": "S1002", "service_firstname": "S102First", "service_midinit": "MidInit", "service_lastname": "S102Last", "service_address1": "SJ102Addr1", "service_address2": "S1002ddr2", "service_city": "S102City", "service_state": "HI", "service_postalcode": "90102", "service_county": null, "service_phone1": "933-333-3333", "service_phone2": null, "service_contactperson": "S102Contact", "service_note": null, "customerid": "Job1002", "serviceid": "S1002", "surveys": "4" }, { "jobno": "12", "workorderno": [ "13924" ], "description": "Job 12 updated description from iOS", "status": "", "startdate": null, "estcompletiondate": null, "contactperson": "S102Contact", "contactphone": "933-333-3333", "note": "", "servicewriter": "Kathy Smith", "billing_id": "Job1002", "billing_firstname": "J102First", "billing_midinit": "MidInit", "billing_lastname": "J102Last", "billing_address1": "J102Addr1", "billing_address2": "J1002ddr2", "billing_city": "J102City", "billing_state": "SGA", "billing_postalcode": "00102", "billing_county": null, "billing_phone1": "333-333-3333", "billing_phone2": null, "billing_contactperson": "J102Contact", "billing_note": null, "service_id": "S1002", "service_firstname": "S102First", "service_midinit": "MidInit", "service_lastname": "S102Last", "service_address1": "SJ102Addr1", "service_address2": "S1002ddr2", "service_city": "S102City", "service_state": "HI", "service_postalcode": "90102", "service_county": null, "service_phone1": "933-333-3333", "service_phone2": null, "service_contactperson": "S102Contact", "service_note": null, "customerid": "Job1002", "serviceid": "S1002", "surveys": "4" }, { "jobno": "11", "workorderno": [ "13894" ], "description": "Bull street project main building", "status": "", "startdate": null, "estcompletiondate": null, "contactperson": "Jimmy Jones", "contactphone": "222-222-2222", "note": "", "servicewriter": "Kathy Smith", "billing_id": "Job1001", "billing_firstname": "J101First", "billing_midinit": "MidInit", "billing_lastname": "J101Last", "billing_address1": "J101Addr1", "billing_address2": "J101Addr2", "billing_city": "J101City", "billing_state": "NC", "billing_postalcode": "00101", "billing_county": null, "billing_phone1": "222-222-2222", "billing_phone2": null, "billing_contactperson": "J101Contact", "billing_note": null, "service_id": "S1001", "service_firstname": "S101First", "service_midinit": "MidInit", "service_lastname": "S101Last", "service_address1": "S101Addr1", "service_address2": "S101Addr2", "service_city": "S101City", "service_state": "AL", "service_postalcode": "90101", "service_county": null, "service_phone1": "922-222-2222", "service_phone2": null, "service_contactperson": "S101Contact", "service_note": null, "customerid": "Job1001", "serviceid": "S1001", "surveys": "4" }, { "jobno": "11", "workorderno": [ "13895" ], "description": "Bull street project main building", "status": "", "startdate": null, "estcompletiondate": null, "contactperson": "Jimmy Jones", "contactphone": "222-222-2222", "note": "", "servicewriter": "Kathy Smith", "billing_id": "Job1001", "billing_firstname": "J101First", "billing_midinit": "MidInit", "billing_lastname": "J101Last", "billing_address1": "J101Addr1", "billing_address2": "J101Addr2", "billing_city": "J101City", "billing_state": "NC", "billing_postalcode": "00101", "billing_county": null, "billing_phone1": "222-222-2222", "billing_phone2": null, "billing_contactperson": "J101Contact", "billing_note": null, "service_id": "S1001", "service_firstname": "S101First", "service_midinit": "MidInit", "service_lastname": "S101Last", "service_address1": "S101Addr1", "service_address2": "S101Addr2", "service_city": "S101City", "service_state": "AL", "service_postalcode": "90101", "service_county": null, "service_phone1": "922-222-2222", "service_phone2": null, "service_contactperson": "S101Contact", "service_note": null, "customerid": "Job1001", "serviceid": "S1001", "surveys": "4" }, { "jobno": "11", "workorderno": [ "14257" ], "description": "Bull street project main building", "status": "", "startdate": null, "estcompletiondate": null, "contactperson": "Jimmy Jones", "contactphone": "222-222-2222", "note": "", "servicewriter": "Kathy Smith", "billing_id": "Job1001", "billing_firstname": "J101First", "billing_midinit": "MidInit", "billing_lastname": "J101Last", "billing_address1": "J101Addr1", "billing_address2": "J101Addr2", "billing_city": "J101City", "billing_state": "NC", "billing_postalcode": "00101", "billing_county": null, "billing_phone1": "222-222-2222", "billing_phone2": null, "billing_contactperson": "J101Contact", "billing_note": null, "service_id": "S1001", "service_firstname": "S101First", "service_midinit": "MidInit", "service_lastname": "S101Last", "service_address1": "S101Addr1", "service_address2": "S101Addr2", "service_city": "S101City", "service_state": "AL", "service_postalcode": "90101", "service_county": null, "service_phone1": "922-222-2222", "service_phone2": null, "service_contactperson": "S101Contact", "service_note": null, "customerid": "Job1001", "serviceid": "S1001", "surveys": "4" }, { "jobno": "11", "workorderno": [ "14298" ], "description": "Bull street project main building", "status": "", "startdate": null, "estcompletiondate": null, "contactperson": "Jimmy Jones", "contactphone": "222-222-2222", "note": "", "servicewriter": "Kathy Smith", "billing_id": "Job1001", "billing_firstname": "J101First", "billing_midinit": "MidInit", "billing_lastname": "J101Last", "billing_address1": "J101Addr1", "billing_address2": "J101Addr2", "billing_city": "J101City", "billing_state": "NC", "billing_postalcode": "00101", "billing_county": null, "billing_phone1": "222-222-2222", "billing_phone2": null, "billing_contactperson": "J101Contact", "billing_note": null, "service_id": "S1001", "service_firstname": "S101First", "service_midinit": "MidInit", "service_lastname": "S101Last", "service_address1": "S101Addr1", "service_address2": "S101Addr2", "service_city": "S101City", "service_state": "AL", "service_postalcode": "90101", "service_county": null, "service_phone1": "922-222-2222", "service_phone2": null, "service_contactperson": "S101Contact", "service_note": null, "customerid": "Job1001", "serviceid": "S1001", "surveys": "4" } ]