Recent Searches

No recent searches

    Popular Articles

      Articles

      View all

        Topics

        View all

          Tickets

          View all
            no results

            Sorry! nothing found for

            Irth Solutions Ticket API

            Modified on Thu, Sep 24 at 5:06 PM

            Irth Solutions Ticket API


            UtiliSphere Ticket API Integration

            Insights / UtiliSphere Platform · Ticket API (SOAP)

            Contents

            • Overview
            • Roles & Responsibilities
            • Technical Details
            • Credentials
            • Query Method Filter Options
            • Status Codes
            • Fields Included in the IRTHNet Standard API
            • Sample Query — IRTHNet Standard
            • Sample Query — IRTHNet SuperStandard

            Overview

            UtiliSphere offers the ability to pull ticket data from UtiliSphere using a SOAP API integration.

            Using the Ticket API

            If you subscribe to the UtiliSphere Ticket API, you can pull your own ticket data from UtiliSphere. Subscribing customers are responsible for building the integration to UtiliSphere and the business processes needed to store and manage the retrieved data.

            As a UtiliSphere Ticket API subscriber, each customer receives a unique Authentication Code to access their company-specific data, along with the URL used to retrieve ticket data.

            API credentials are issued per customer. The Authentication Code and endpoint shown later in this document (Credentials) are examples only — every subscriber receives their own unique code.

            Roles & Responsibilities

            Customer Responsibility

            Customers subscribing to the UtiliSphere Ticket API are responsible for engaging their internal Information Technology team to coordinate the integration to UtiliSphere. Irth Solutions does not provide the integration into a customer's environment, nor does it store data once retrieved.

            Irth Solutions Responsibility

            • Irth Solutions provides the company-specific credentials needed to access one-call center ticket data.
            • Irth Solutions provides standard one-call center ticket data to accommodate all customers on the platform, based on information provided by the one-call center.
            • The IRTHNet Standard API format contains basic information and is used by most clients. Requested changes may require a custom format and will be discussed based on the information needed.

            Technical Details

            • The Ticket API is a SOAP request that returns JSON. A sample request and response can be found at the QueryData operation endpoint (see Credentials).
            • Dates and times submitted are in Eastern Standard Time.
            • When filtering by CreateDate, the API pulls data for the full calendar date provided (00:00:00–23:59:00). For example, a date of 1/21/2022 returns tickets received from 12:00 AM to 11:59 PM that day.
            • UtiliSphere limits the number of tickets retrieved in a single call to 1,000, to protect system performance for all customers.

            We strongly suggest filtering on CreateDate or LastActionDateTime using the Time_Between operation to capture tickets within smaller time intervals.

            • Companies with high ticket volumes should pull data in smaller intervals using the Time_Between operator with a filter such as CreateDate or LastActionDateTime.
            • Irth Solutions does not allow full historical data dumps via the Ticket API. Speak with your Irth Solutions sales representative to discuss options.
            • Current production data is available online for 60 days.
            • Ticket data older than 60 days must be pulled from the Data Warehouse. Records move from the production database to the Data Warehouse every 2 hours, so querying the Data Warehouse alone will not include tickets received within the past two hours.
            • To pull data from the Warehouse, set "UseWarehouse": true in the query request.

            Credentials

            Example values only. Each customer is issued its own Authentication Code — do not reuse the value below across customers.

            Production Data Webservice

            http://www.irth.com/IRTHNet/ WebServices/IrthnetWOIntegration.asmx

            Sandbox Data Webservice

            https://sandbox.irth.com/Irthnet/ WebServices/IrthnetWOIntegration.asmx

            Authentication Code

            [Customer AuthCode]  (unique per 

            customer)

            Result Format

            IRTHNet Standard

            Result Format

            IRTHNet SuperStandard

            Query Method Filter Options

            Field

            Definition

            Operation

            Value

            TakenDateTime

            When the one call center took the ticket from the caller.  This information must be provided on the one call center ticket.

            TIME_BETWEEN

            2019/02/07 00:00:00-

            2019/02/07 23:59:00

            CreateDate

            The time when UtiliSphere receives the ticket from the one call center.

            TIME_BETWEEN

            2019/02/07 00:00:00-

            2019/02/07 23:59:00

            LastResponseDate

            The Date and Time of when the last response was entered on a ticket

            TIME_BETWEEN

            2019/02/07 00:00:00-

            2019/02/07 23:59:00

            LastActionDateTime

            The Date and Time when an action was taken on the ticket.  For Example, Response Added, Note Entered, etc.

            TIME_BETWEEN

            2019/02/07 00:00:00-

            2019/02/07 23:59:00

            OneCall

            The UtiliSphere One Call Center Code.  This can be found in Administration under Registrations.

            EQUALS

            UtiliSphere One Call Center Code (Administration/Registr

            ations)

            LastResponse

            The Name of the Last Response entered on the ticket.  Response Names can be found in Administration 

            EQUALS

            Name of Response in 

            UtiliSphere 

            (Administration/Responses)

            Field

            Definition

            Operation

            Value

             

            under Responses.

             

             

            OneCallTicketID

            The Ticket ID provided by the one call center

            EQUALS

            The One Call Center Ticket 

            Number

            Status Codes

            Code

            Status

            Description

            200

            Authentication Failed

            The API authentication key does not match

            201

            No Items Found

            No items are found to the query initiated

            202

            System Error

            A system error has occurred

            203

            Invalid Query Data

            The selected query is invalid

             

            Fields Included in the IRTHNet Standard API

            Field

            Definition

            Type

            Sample Value

            UtiliSphereID

            Unique Identifier for the ticket in UtiliSphere

            String

            278302465

            AssignedTo

            Who the ticket is assigned to

            String

            Test Person

            Folder

            Folder Name

            String

            Area A

            DueDateTime

            Due Date from OCC Ticket

            DateTime

            2022-01-19T14:25:00

            Status

            Status of Ticket

            String

            One Of:  Pending Research, 

            Assigned, In Ticket Folder, Closed

            TicketID

            OCC Ticket ID

            String

            278302465

            Sequence

            Sequence Number provided by OCC

            String

            1959

            ReceivedTime

            Received Time provided on One Call Center Ticket

            DateTime

            2022-01-19T10:26:04

            TakenTime

            Taken Date Time provided on the One Call Center Ticket

            DateTime

            2022-01-19T10:25:00

            StartTime

            Start Time Provided on the One Call Center Ticket

            DateTime

            2022-01-19T10:30:00

            EndTime

            End Time Provided by One Call Center Ticket

            DateTime

            2022-01-19T10:26:04

            LegalTime

            Legal Time Provided by One Call Center Ticket

            DateTime

            2022-01-19T10:26:04

            ResponseDueTime

            Response Due Time Provided by One Call Center ticket

            DateTime

            2022-01-19T10:26:04

            MeetingTime

            Meeting Time Provided by One Call Center Ticket

            DateTime

            2022-01-19T10:26:04

            CreationTime

            Time Ticket Received in UtiliSphere

            DateTime

            2022-01-19T10:26:04

            MapRef

            Map Reference provided by One Call Center Ticket

            string

            ABC

            MeetingRequested

            Meeting Requested Provided by One Call Center Ticket

            string

            1 or 0, 1 = Yes

            Explosives

            Explosives Provided by One Call Center ticket

            string

            1 or 0, 1 = Yes

            ContactTime

            Contact Time Provided by One Call Center Ticket

            string

            2022-01-19T10:26:04

            Center

            UtiliSphere One Call Center Code

            string

            TESS

            Code

            Registration Code from One Call Center ticket

            string

            ABC

            TicketType

            Ticket Type provided by One Call Center Ticket

            string

            Dig Up

             

            Field

            Definition

            Type

            Sample Value

            ExcavatorName

            Excavator Name provided on One Call Center Ticket

            string

            TAYLOR ELECTRIC

            ExcavatorState

            Excavator State Provided on One Call Center Ticket

            string

            TX

            ExcavatorCity

            Excavator City provided on One Call Center Ticket

            string

            MERKEL

            ExcavatorZipCode

            Excavator Zip Code provided on One Call Center Ticket

            string

            79536

            Subdivision

            Provided on One Call Center Ticket

            string

            SUBDIVISION

            DoneFor

            Provided on One Call Center Ticket

            string

            CITY OF DUBLIN

            WorkType

            Provided on One Call Center Ticket

            string

            Digup – Cut Cable Line

            State

            Provided on One Call Center Ticket

            string

            TX

            County

            Provided on One Call Center Ticket

            string

            TAYLOR

            Place

            Provided on One Call Center Ticket

            string

            ABILENE

            Street

            Provided on One Call Center Ticket

            string

            LARNED

            StreetType

            Provided on One Call Center Ticket

            string

            AVE

            DirectionPrefix

            Provided on One Call Center Ticket

            string

            N

            DirectionSufix

            Provided on One Call Center Ticket

            string

            S

            Address

            Provided on One Call Center Ticket

            string

            1169

            FullAddress

            Provided on One Call Center Ticket

            string

            1169 N LARNED AVE W

            NorthLat

            Provided on One Call Center Ticket

            string

            32.3356246948242

            WestLon

            Provided on One Call Center Ticket

            string

            -99.6998206107906

            SouthLat

            Provided on One Call Center Ticket

            string

            32.3351936340332

            EastLon

            Provided on One Call Center Ticket

            string

            -99.6991554229561

            GeocodeNorthLat

            Geocoded North Lat

            string

            32.342444

            GeocodeWestLon

            Geocoded West Lon

            string

            -99.699488

            GeocodeSouthLat

            Geocoded South Lat

            string

            32.32804

             

            Field

            Definition

            Type

            Sample Value

            GeocodeEastLon

            Geocoded East Lon

            string

            -99.69809

            ContactName

            Provided on One Call Center Ticket

            string

            KLINT DOAN

            ContactPhone

            Provided on One Call Center Ticket

            string

            3256659968

            AltContactPhone

            Provided on One Call Center Ticket

            string

            3256659968

            ContactFax

            Provided on One Call Center Ticket

            string

            3256659968

            ContactEmail

            Provided on One Call Center Ticket

            string

            jefferson.wesson@taylorelect ric.coop

            FacilityType

            UtiliSphere Option, must be turned on

            string

            Per UtiliSphere 

            Administration Configuration

            FirstResponse

            First Response Entered on Ticket

            string

            Cleared No Conflict

            FirstResponseLocatorName

            Name of First Person Responded to Ticket

            string

            Person, Samantha

            FirstResponseLocateTime

            Date and Time of First Response entered

            DateTime

            2022-01-19T10:27:00

            LastResponse

            Last Response Entered on Ticket

            string

            Cleared No Conflict

            LastResponseLocatorName

            Name of Person Last Responded to Ticket

            string

            Person, Samantha

            LastResponseLocateTime

            Date and Time of Response Entered on Ticket

            DateTime

            2022-01-19T10:27:00

            ReferenceTicketID

            Provided on One Call Center Ticket

            string

            278302333

            TicketVersion

            Provided on One Call Center Ticket

            string

            0

            ExcavatorAddress

            Provided on One Call Center Ticket

            string

            226 CR 287

            AdditionalExcavatorAddress

            Provided on One Call Center Ticket

            string

             

            TotalUnitsOfWork

            Total Units Of Work if entered on Ticket Response Screen

            string

            0.01

            LocationOfWork

            Provided on One Call Center Ticket

            string

            From the intersection of FM 

            1750 head north on Larned to 1169 on the west side of the road we will be changing out pole in the back yard and putting in urd off of that pole to shop locate 30 foot round white flags and poles.GPS: 32.335304 -99.699668 GPS: 

            32.335456 -99.699320\r\n

             

            Field

            Definition

            Type

            Sample Value

            Remarks

            Provided on One Call Center Ticket

            string

            DigUp-2184470044, Cut 

            Cable Line, Crew on site, 

            Customer service unknown, Line is visible, Previous markings are NOT visible, 

            Damaged by: TAYLOR 

            ELECTRIC, Damaged with: 

            TRENCHER, THE PHONE LINE WAS NOT MARKED. Nature of work provided as: URD 

            ELECTRIC\r\n

            Attachments

            Attachments added to Ticket

            string

            See Below

            WorkLogs

            Work Log Tracking

            string

            See Below

            Audits

            Ticket Audit Actions

            string

            See Below

            SmartScore

            Smart Scores if Subscribed

            string

            See Below

            TicketText

            Provided on One Call Center Ticket

            string

            Ticket Text Provided by One Call Center

             

            Sample Query — IRTHNet Standard

            Request

            Response

            This is the data returned, shown in a readable format. A sample of the raw XML is available on request.

             

                        "TakenTime": "2025-04-29T10:20:00",

                        "StartTime": "2025-05-01T10:21:00",

                           "ResponseDueTime": "2025-05-01T10:21:00",

                        "CreationTime": "2025-04-29T10:23:50",

                        "MeetingRequested": "0",

                        "Explosives": "0",

                        "Center": "OUPS",

                        "Code": "xxxx",

                        "TicketType": "Regular",

                        "ExcavatorName": "NEW RIVER ELECTRICAL CORP",

                        "ExcavatorState": "OH",

                        "ExcavatorCity": "WESTERVILLE",

                        "ExcavatorZipCode": "43081",

                        "Subdivision": "DARBY STATION 4-2",

                        "DoneFor": "AEP BOP0000001",                "WorkType": "ELECTRIC LINE INSTALLATION",

                        "State": "OH",

                        "County": "UNION",

                        "Place": "Plain City",

                        "Street": "AEROTRAIN",

                        "StreetType": "CT",

                        "Address": "1923",

                        "FullAddress": "1923 AEROTRAIN CT N",

                        "NorthLat": "40.112372",

                        "WestLon": "-83.245092",

                        "SouthLat": "40.108925",

                        "EastLon": "-83.240295",

                        "GeocodeNorthLat": "40.20454",

                        "GeocodeWestLon": "-83.392667",

                        "GeocodeSouthLat": "40.10747",

                        "GeocodeEastLon": "-83.17066",

                        "ContactName": "MICHAEL MILLER",                "ContactPhone": "6147531953",

                        "AltContactPhone": "6145429068",

                           "ContactEmail": "MMILLER@NREC.NET",

                        "FirstResponse": "Ongoing Job/ In Progress",

                           "FirstResponseLocateTime": "2025-05-01T08:11:00",

                        "LastResponse": "Marked/Locate Complete",

                           "LastResponseLocatorName": "Christopher Vance ( XXXX (OH) )",

                           "LastResponseLocateTime": "2025-05-01T13:58:38",

                        "ReferenceTicketID": "",

                        "TicketVersion": "0",

                        "ExcavatorAddress": "6005 WESTERVILLE ROAD",

                        "TotalUnitsOfWork": "0.00",

                        "LocationOfWork": "PLEASE MARK ENTIRE PROPETRY AND POWER SOURCE INCLUDING ADJACENT PORPERTIES 

            INSTALLING NEW ELECTIRC SERVICE PLEASE FLAG EVERY 5 FEET\r\n",

                        "Remarks": " \r\n",

                        "Attachments": [],

                        "WorkLogs": [],

                        "Audits": [{

                           "Note": "",

                           "AuditID": 3534085936,

                           "CreateDateTime": "2025-04-29T10:23:50.45",

                           "ShortDescription": "Received",                   "LongDescription": "Ticket received for registration code XXXX"             }, {

                           "Note": "",

             

                           "AuditID": 3534085937,

                           "CreateDateTime": "2025-04-29T10:23:50.453",

                           "ShortDescription": "Place Synonym Used",

                              "LongDescription": "Place synonym was used when the ticket was received. *PLAIN* was changed to *Plain City*"             }, {

                           "Note": "",

                           "AuditID": 3534085938,

                           "CreateDateTime": "2025-04-29T10:23:50.453",

                           "ShortDescription": "Map Feature Lookup",

                              "LongDescription": "Auto Response Rule not Applied. Number of features that intersect the Occ 

            Dig Area: 47;"

                        }, {

                           "AuditID": 3534085939,

                           "CreateDateTime": "2025-04-29T10:23:50.457",

                           "ShortDescription": "Ticket Score Calculated",

                           "LongDescription": "AL Renew calculated. Score value: 0"             }, {

                           "AuditID": 3534085941,

                           "CreateDateTime": "2025-04-29T10:23:50.46",

                           "ShortDescription": "Ticket Score Calculated",

                           "LongDescription": "GA Large Projects Meeting calculated. Score value: 0"             }, {

                           "AuditID": 3534085942,

                           "CreateDateTime": "2025-04-29T10:23:50.463",

                           "ShortDescription": "Ticket Score Calculated",

                           "LongDescription": "Large Project GA No Meeting calculated. Score value: 0"

                        }, {

                           "AuditID": 3534085943,

                           "CreateDateTime": "2025-04-29T10:23:50.467",

                           "ShortDescription": "Ticket Score Calculated",

                           "LongDescription": "TX Update calculated. Score value: 0"             }, {

                           "Note": "",

                           "AuditID": 3534085945,

                           "CreateDateTime": "2025-04-29T10:23:50.467",

                           "ShortDescription": "Auto Process",

                              "LongDescription": "Additional Footprint 20 feet was applied for Map Feature; \r\n"             }, {

                           "Note": "Auto Processed per All Tickets",

                           "ExcvPosRespNote": "",

                           "AuditID": 3534085949,

                           "CreateDateTime": "2025-04-29T10:23:50.47",

                           "ShortDescription": "Put in Folder",

                           "LongDescription": "Put in XXXX (OH) by auto process"

                        }, {

                           "Note": "Assigned on folder placement",

                           "ExcvPosRespNote": "",

                           "AuditID": 3534085952,

                           "CreateDateTime": "2025-04-29T10:23:50.477",

                           "ShortDescription": "Assigned",                   "LongDescription": "Assigned to XXXX (OH) by auto process"             }, {

                           "AuditID": 3534085956,

                           "CreateDateTime": "2025-04-29T10:23:50.487",

                           "ShortDescription": "Insights AI Risk Score",

             

                           "LongDescription": "Insights AI Incident Likelihood Rank: 11.93163<br 

            />Insights AI Incident Likelihood Percentile: 21.78218<br />Insights AI Incident Impact Rank: 6.468259<br />Insights AI Risk Factors: equipment_used_hoe: +; area_decile: +; members_list: +; excavator_company_name: 

            -; transmit_date_time_hour_of_day: +; request_type: -; equipment_used_track: +; startwork_date_time_day_of_month: -; transmit_date_time_month_of_year: -; start_minus_transmit_days: +; startwork_date_time_season: -; transmit_date_time_day_of_year: +; startwork_date_time_hour_of_day: +; transmit_date_time_day_of_month: -; transmit_date_time_season: -; transmit_date_time_day_of_week: -; startwork_date_time_month_of_year: +; startwork_date_time_day_of_week: -; zip_density: -; <br />"

                        }, {

                           "AuditID": 3534085966,

                           "CreateDateTime": "2025-04-29T10:23:50.513",

                           "ShortDescription": "Insights AI Clearing Score",

                              "LongDescription": "Insights AI Clear Rank: 11.24263<br />Insights AI Clear Percentile: 10<br 

            />Insights AI Clear Prediction Factors: excavator_company_name: -; percent_clearing_1000: -; percent_clearing_20: -; work_type_electr: -; number_clearing_1000: -; number_clearing_20: +; <br />"

                        }, {

                           "Note": "",

                           "AuditID": 3534090856,

                           "CreateDateTime": "2025-04-29T10:24:17.59",

                           "ShortDescription": "Ticket Queued",

                           "LongDescription": "Ticket queued for delivery"

                        }, {

                           "AuditID": 3534091551,

                           "CreateDateTime": "2025-04-29T10:24:22.293",

                           "ShortDescription": "Ticket Delivered",

                           "LongDescription": "Ticket successfully sent to 811.oh.chtr@tickets.811tickets.com"

                        }, {

                           "Note": "",

                           "ExcvPosRespNote": "",

                           "AuditID": 3541012226,

                           "CreateDateTime": "2025-05-01T08:12:45.463",

                           "ShortDescription": "Responded",

                           "LongDescription": "Ongoing Job/ In Progress (Ongoing): added by contract locator XXXX (OH), located by Christopher Vance. Locate Time: {2025-05-01 08:11:00}"

                        }, {

                           "Note": "",

                           "ExcvPosRespNote": "",

                           "AuditID": 3541255872,

                           "CreateDateTime": "2025-05-01T09:11:51.403",

                           "ShortDescription": "Responded",

                           "LongDescription": "Not Complete- Unable to contact Excavator : added by contract locator 

            XXXX (OH), located by Christopher Vance. Locate Time: {2025-05-01 09:11:27}"             }, {

                           "Note": "",

                           "ExcvPosRespNote": "",

                           "AuditID": 3541255879,

                           "CreateDateTime": "2025-05-01T09:11:51.49",

                           "ShortDescription": "Responded",

                           "LongDescription": "Not Complete- Unable to contact Excavator : added by contract locator 

            XXXX (OH), located by Christopher Vance. Locate Time: {2025-05-01 09:11:28}"             }, {

                           "Note": "",

                           "ExcvPosRespNote": "",

                           "AuditID": 3542861012,

                           "CreateDateTime": "2025-05-01T14:02:16.95",

                           "ShortDescription": "Responded",

             

                           "LongDescription": "Marked/Locate Complete: added by contract locator XXXX (OH), located by 

            Christopher Vance. Locate Time: {2025-05-01 13:58:38}"

                        }],

                        "SmartScore": [{

                           "Name": "GA Large Projects Meeting"

                        }, {

                           "Name": "Large Project GA No Meeting"

                        }, {

                           "Name": "TX Update"

                        }, {

                           "Name": "AL Renew"

                        }],

                        "TicketText": "xxxx   00361 OUPSb 04/29/25 10:22:05 B511901216-00B ROUT NEW POLY LREQ\n\ nTicket : B511901216 Rev: 00B Taken: 04/29/25 10:20 AM Channel: WEB\n\nState: OH     Cnty: UNION       Place: PLAIN CITY\nState: OH  Cnty: UNION       Place: JEROME TWP\nSubdivsn: DARBY STATION 4-2\n\nAddress : 1923  Street: AEROTRAIN CT N\nRail/Hwy:         Milemarker(s):\nWhere   : PLEASE MARK ENTIRE PROPETRY AND POWER SOURCE INCLUDING ADJACENT\n        : PORPERTIES INSTALLING NEW ELECTIRC SERVICE PLEASE FLAG EVERY 5 FEET\n\ nWorkType: ELECTRIC LINE INSTALLATION\nDone for: AEP BOP0000001\nDone by : NREC\nWhitelined: N  Blasting: N\ nMeans of Excavation: TRACK HOE\n\nWork date: 05/01/25 10:21 AM\nStart by : 05/13/25 10:21 AM  Response Due: 

            05/01/25 10:21 AM\n\nBest Fit: 40.112372/-83.244439 40.111162/-83.240295\n        : 40.110135/-83.245092 40.108925/-83.240949\n\nComments:\n\nCaller     : MICHAEL MILLER                     Phone: 614-753-1953\ nCompany : NEW RIVER ELECTRICAL CORP                 Type: CONT\nCo addr : 6005 WESTERVILLE ROAD\nCity    : WESTERVILLE                     St: OH  Zip: 43081\nAlt Tel#: 614-753-1953\nAlt cont: BILLY COMBS 

            Phone: 614-542-9068\nEmail: MMILLER@NREC.NET\n\nMembers:\nAEPP1  =AEP OHIO - COLUMBUS(UTILIQUEST  MEC       =MADISON ENERGY COOPERATIVE\nOBFP      =AT&T - OHIO                        XXXX   =CHARTER COMM(SPECTRUM/TIME WAR\ n\nView map at:\nhttps://newtin.oups.org/newtinweb/map_tkt.nap?TRG=486x8pFfFfDj5jFbFYE"          }, {

                        "UtiliSphereID": "450711320",

                        "Folder": "XXXX (OH)",

                        "DueDateTime": "2025-05-01T10:21:00",

                        "Status": "Assigned",

                        "TicketID": "B511901216",

                        "Sequence": "193",

                        "ReceivedTime": "2025-05-07T08:11:12",

                        "TakenTime": "2025-05-07T08:10:00",

                        "StartTime": "2025-05-01T10:21:00",

                        "CreationTime": "2025-05-07T08:12:10",

                        "MeetingRequested": "0",

                        "Explosives": "0",

                        "Center": "OUPS",

                        "Code": "XXXX",

                        "TicketType": "On Job",

                        "ExcavatorName": "NEW RIVER ELECTRICAL CORP",

                        "ExcavatorState": "OH",

                        "ExcavatorCity": "WESTERVILLE",

                        "ExcavatorZipCode": "43081",

                        "Subdivision": "DARBY STATION 4-2",

                        "DoneFor": "AEP BOP0000001",                "WorkType": "ELECTRIC LINE INSTALLATION",

                        "State": "OH",

                        "County": "UNION",

                        "Place": "Plain City",

                        "Street": "AEROTRAIN",

                        "StreetType": "CT",

                        "Address": "1923",

                        "FullAddress": "1923 AEROTRAIN CT N",

                        "NorthLat": "40.112372",

             

                        "WestLon": "-83.245093",

                        "SouthLat": "40.108925",

                        "EastLon": "-83.240295",

                        "GeocodeNorthLat": "40.20454",

                        "GeocodeWestLon": "-83.392667",

                        "GeocodeSouthLat": "40.10747",

                        "GeocodeEastLon": "-83.17066",

                        "ContactName": "MICHAEL MILLER",                "ContactPhone": "6147531953",

                        "AltContactPhone": "6145429068",

                           "ContactEmail": "MMILLER@NREC.NET",

                        "ReferenceTicketID": "",

                        "TicketVersion": "1",

                        "ExcavatorAddress": "6005 WESTERVILLE ROAD",

                        "LocationOfWork": "PLEASE MARK ENTIRE PROPETRY AND POWER SOURCE INCLUDING ADJACENT PORPERTIES 

            INSTALLING NEW ELECTIRC SERVICE PLEASE FLAG EVERY 5 FEET\r\n",

                        "Remarks": "REASON FOR REPEAT: INCOMPLETE AREA MARKED REPEAT COMMENTS: ADJACENT SERVICE NOT 

            MARKED * REPEAT MESSAGE, 05/07/2025 08:15 AM, DAKOTA (ORIGINAL DATE: 04/29/2025 10:20 AM) \r\n",

                        "Attachments": [],

                        "WorkLogs": [],

                        "Audits": [{

                           "Note": "",

                           "AuditID": 3556720461,

                           "CreateDateTime": "2025-05-07T08:12:10.29",

                           "ShortDescription": "Received",                   "LongDescription": "Ticket received for registration code XXXX"             }, {

                           "Note": "",

                           "AuditID": 3556720462,

                           "CreateDateTime": "2025-05-07T08:12:10.29",

                           "ShortDescription": "Place Synonym Used",

                              "LongDescription": "Place synonym was used when the ticket was received. *PLAIN* was changed to *Plain City*"             }, {

                           "Note": "",

                           "AuditID": 3556720463,

                           "CreateDateTime": "2025-05-07T08:12:10.29",

                           "ShortDescription": "Map Feature Lookup",

                              "LongDescription": "Auto Response Rule not Applied. Number of features that intersect the Occ 

            Dig Area: 47;"

                        }, {

                           "AuditID": 3556720464,

                           "CreateDateTime": "2025-05-07T08:12:10.293",

                           "ShortDescription": "Ticket Score Calculated",

                           "LongDescription": "AL Renew calculated. Score value: 0"             }, {

                           "AuditID": 3556720465,

                           "CreateDateTime": "2025-05-07T08:12:10.307",

                           "ShortDescription": "Ticket Score Calculated",

                           "LongDescription": "GA Large Projects Meeting calculated. Score value: 0"             }, {

                           "AuditID": 3556720466,

                           "CreateDateTime": "2025-05-07T08:12:10.313",

                           "ShortDescription": "Ticket Score Calculated",

                           "LongDescription": "Large Project GA No Meeting calculated. Score value: 0"

                        }, {

                           "Note": "",

             

                           "AuditID": 3556720467,

                           "CreateDateTime": "2025-05-07T08:12:10.313",

                           "ShortDescription": "Auto Process",

                              "LongDescription": "Additional Footprint 10 feet was applied for Map Feature; \r\n"             }, {

                           "Note": "Auto Processed per All Tickets",

                           "ExcvPosRespNote": "",

                           "AuditID": 3556720469,

                           "CreateDateTime": "2025-05-07T08:12:10.32",

                           "ShortDescription": "Put in Folder",

                           "LongDescription": "Put in XXXX (OH) by auto process"

                        }, {

                           "Note": "Assigned on folder placement",

                           "ExcvPosRespNote": "",

                           "AuditID": 3556720474,

                           "CreateDateTime": "2025-05-07T08:12:10.333",

                           "ShortDescription": "Assigned",                   "LongDescription": "Assigned to XXXX (OH) by auto process"             }, {

                           "AuditID": 3556720475,

                           "CreateDateTime": "2025-05-07T08:12:10.36",

                           "ShortDescription": "Insights AI Risk Score",

                           "LongDescription": "Insights AI Incident Likelihood Rank: 12.00599<br 

            />Insights AI Incident Likelihood Percentile: 20.79208<br />Insights AI Incident Impact Rank: 62.43727<br />Insights AI Risk Factors: transmit_date_time_month_of_year: -; startwork_date_time_hour_of_day: -; equipment_used_track: +; members_list: -; transmit_date_time_day_of_month: +; excavator_company_name: +; request_type: +; equipment_used_hoe: +; startwork_date_time_season: -; transmit_date_time_day_of_year: -; transmit_date_time_day_of_week: +; remarks_keywords_servic: -; startwork_date_time_day_of_month: -; startwork_date_time_day_of_week: +; startwork_date_time_month_of_year: -; area_decile: +; transmit_date_time_season: -; start_minus_transmit_days: -; transmit_date_time_hour_of_day: -; zip_density: 

            -; <br />"

                        }, {

                           "AuditID": 3556720479,

                           "CreateDateTime": "2025-05-07T08:12:10.407",

                           "ShortDescription": "Insights AI Clearing Score",

                           "LongDescription": "Insights AI Clear Rank: 22.68711<br />Insights AI Clear Percentile: 16<br />Insights AI Clear Prediction Factors: work_type_electr: -; number_clearing_20: -; number_clearing_100: +; percent_clearing_100: -; percent_clearing_1000: -; excavator_company_name: -; request_type: -; percent_clearing_20: -; work_type_line: -; <br />"

                        }, {

                           "Note": "",

                           "AuditID": 3556721067,

                           "CreateDateTime": "2025-05-07T08:12:15.58",

                           "ShortDescription": "Ticket Queued",

                           "LongDescription": "Ticket queued for delivery"

                        }, {

                           "AuditID": 3556721240,

                           "CreateDateTime": "2025-05-07T08:12:17.57",

                           "ShortDescription": "Ticket Delivered",

                           "LongDescription": "Ticket successfully sent to 811.oh.chtr@tickets.811tickets.com"

                        }],

                        "SmartScore": [{

                           "Name": "GA Large Projects Meeting"

                        }, {

                           "Name": "Large Project GA No Meeting"

                        }, {

                           "Name": "AL Renew"

                        }],

                         "TicketText": "xxxx    00193 OUPSa 05/07/25 08:11:12 B511901216-01A INSF REPT POLY ONJB\n\nTicket 

            : B511901216 Rev: 01A Taken: 05/07/25 08:10 AM Channel: WEB\nOld Tkt: B511901216          Taken: 04/29/25 10:21 AM\n\nState: OH  Cnty: UNION       Place: PLAIN CITY\nState: OH  Cnty: UNION       Place: JEROME TWP\ nSubdivsn: DARBY STATION 4-2\n\nAddress : 1923  Street: AEROTRAIN CT N\nRail/Hwy:       Milemarker(s):\nWhere : PLEASE MARK ENTIRE PROPETRY AND POWER SOURCE INCLUDING ADJACENT\n        : PORPERTIES INSTALLING NEW ELECTIRC SERVICE PLEASE FLAG EVERY 5 FEET\n\nWorkType: ELECTRIC LINE INSTALLATION\nDone for: AEP BOP0000001\ nDone by : NREC\nWhitelined: N  Blasting: N\nMeans of Excavation: TRACK HOE\n\nWork date: 05/01/25 10:21 AM\ n\nBest Fit: 40.112372/-83.244440 40.111162/-83.240295\n        : 40.110135/-83.245093 40.108925/-83.240948\ n\nComments: REASON FOR REPEAT: INCOMPLETE AREA MARKED\n        : REPEAT COMMENTS: ADJACENT SERVICE NOT MARKED\n        : * REPEAT MESSAGE, 05/07/2025 08:15 AM, DAKOTA (ORIGINAL DATE:\n        : 04/29/2025 10:20 

            AM)\n\nCaller  : MICHAEL MILLER                  Phone: 614-753-1953\nCompany : NEW RIVER ELECTRICAL CORP Type: CONT\nCo addr : 6005 WESTERVILLE ROAD\nCity    : WESTERVILLE                     St: OH  Zip: 43081\ nAlt Tel#: 614-753-1953\nAlt cont: BILLY COMBS                      Phone: 614-542-9068\nEmail: 

            MMILLER@NREC.NET\n\nMembers:\nAEPP1  =AEP OHIO - COLUMBUS(UTILIQUEST  MEC     =MADISON ENERGY COOPERATIVE\ nOBFP    =AT&T - OHIO                      XXXX   =CHARTER COMM(SPECTRUM/TIME WAR\n\nView map at:\nhttps://newtin.oups.org/newtinweb/map_tkt.nap?TRG=689u2v9l9l5ryr4m2l8"

                     }]

                  }

               }]] > < /QueryDataResult> <

               /QueryDataResponse> <

               /soap:Body> <

               /soap:Envelope>

            Sample Query — IRTHNet SuperStandard

            Request

            Response

            This is the data returned, shown in a readable format. A sample of the raw XML is available on request.

             

                           "Reference_Ticket_Number": "",

                        "Sequence_Number": 361,

                        "Received_DateTime": "2025-04-29T10:22:05",

                        "Work_Start_DateTime": "2025-05-01T10:21:00",

                           "Response_Due_DateTime": "2025-05-01T10:21:00",                "Taken_DateTime": "2025-04-29T10:20:00",

                        "Meet_Requested": "No",

                        "Work_Done_For": "AEP BOP0000001",

                        "Work_Type": "ELECTRIC LINE INSTALLATION",

                        "Explosives": "No",                "Due_DateTime": "2025-05-01T10:21:00",

                        "Corner_Lot": "No",

                        "Front": "No",

                        "Rear": "No",

                        "Overhead": "No",

                        "Tunneling_Or_Boring": "No",

                        "White_Lined": "No",

                        "Access_Open": "No",

                        "Address_Posted": "No",

                        "Offset_Markings": "No",

                           "Location_Of_Work": "PLEASE MARK ENTIRE PROPETRY AND POWER SOURCE INCLUDING ADJACENT PORPERTIES 

            INSTALLING NEW ELECTIRC SERVICE PLEASE FLAG EVERY 5 FEET\r\n",

                        "Remarks": " \r\n",

                        "Ticket_Category": "Regular",

                        "NonCompliant_Excv": "No",

                        "Subdivision": "DARBY STATION 4-2",

                        "Ticket_Text": "xxxx   00361 OUPSb 04/29/25 10:22:05 B511901216-00B ROUT NEW POLY LREQ\n\nTicket : B511901216 Rev: 00B Taken: 04/29/25 10:20 AM Channel: WEB\n\nState: OH     Cnty: UNION       Place: PLAIN CITY\nState: OH  Cnty: UNION       Place: JEROME TWP\nSubdivsn: DARBY STATION 4-2\n\nAddress : 1923  Street: 

            AEROTRAIN CT N\nRail/Hwy:         Milemarker(s):\nWhere   : PLEASE MARK ENTIRE PROPETRY AND POWER SOURCE INCLUDING ADJACENT\n        : PORPERTIES INSTALLING NEW ELECTIRC SERVICE PLEASE FLAG EVERY 5 FEET\n\ nWorkType: ELECTRIC LINE INSTALLATION\nDone for: AEP BOP0000001\nDone by : NREC\nWhitelined: N  Blasting: N\ nMeans of Excavation: TRACK HOE\n\nWork date: 05/01/25 10:21 AM\nStart by : 05/13/25 10:21 AM  Response Due: 

            05/01/25 10:21 AM\n\nBest Fit: 40.112372/-83.244439 40.111162/-83.240295\n        : 40.110135/-83.245092 40.108925/-83.240949\n\nComments:\n\nCaller     : MICHAEL MILLER                     Phone: 614-753-1953\ nCompany : NEW RIVER ELECTRICAL CORP                 Type: CONT\nCo addr : 6005 WESTERVILLE ROAD\nCity    : WESTERVILLE                     St: OH  Zip: 43081\nAlt Tel#: 614-753-1953\nAlt cont: BILLY COMBS 

            Phone: 614-542-9068\nEmail: MMILLER@NREC.NET\n\nMembers:\nAEPP1  =AEP OHIO - COLUMBUS(UTILIQUEST  MEC       =MADISON ENERGY COOPERATIVE\nOBFP      =AT&T - OHIO                        XXXX   =CHARTER COMM(SPECTRUM/TIME WAR\ n\nView map at:\nhttps://newtin.oups.org/newtinweb/map_tkt.nap?TRG=486x8pFfFfDj5jFbFYE",             "Excavator": [{

                           "Ticket_ID": 406017082,

                           "Company": "NEW RIVER ELECTRICAL CORP",

                           "Address": "6005 WESTERVILLE ROAD",

                           "City": "WESTERVILLE",

                           "State": "OH",

                           "Zip": "43081",

                           "Contact": [{

                              "Ticket_ID": 406017082,

                              "Name": "MICHAEL MILLER",

                              "Primary_Phone": "6147531953",

                              "Alt_Phone": "6147531953",

                              "Email": "MMILLER@NREC.NET",

                                 "Alt_Contact_Name": "BILLY COMBS",

                                 "Alt_Contact_Phone": "6145429068"

                           }]

                        }],

             

                        "Dig_Site": [{

                           "Digsite_ID": 406339552,

                           "Ticket_ID": 406017082,

                           "Bounding_Box": [{

                              "Digsite_ID": 406339552,

                              "North_Lat": 40.112372,

                              "West_Lon": -83.245092,

                              "South_Lat": 40.108925,

                              "East_Lon": -83.240295,

                                 "Geocoded_North_Lat": 40.20454,

                                 "Geocoded_West_Lon": -83.392667,

                                 "Geocoded_South_Lat": 40.10747,

                                 "Geocoded_East_Lon": -83.17066,

                                 "Geocoded_Center_Lat": 40.156005,

                                 "Geocoded_Center_Lon": -83.281663500000008

                           }],

                           "AddressInfo": [{

                                 "Digsite_Item_ID": 417937062,

                              "Digsite_ID": 406339552,

                              "State": "OH",

                              "County": "UNION",

                              "Place": "Plain City",

                              "Cross_Street": [],

                              "Near_Street": [],

                              "Street": [{

                                    "Digsite_Item_ID": 417937062,

                                    "From_Address": "1923",

                                 "Street_Name": "AEROTRAIN",

                                 "Street_Type": "CT",

                                    "Direction_Suffix": "N"

                              }]

                           }],

                           "Grids": [{

                              "Digsite_ID": 406339552,

                              "Grid": []

                           }]

                        }],

                        "Response_Info": [{                   "Ticket_Locate_Info_ID": 449113574,

                           "Ticket_ID": 406017082,

                           "Response": [{

                                 "Ticket_Locate_Info_ID": 449113574,

                                 "Ticket_Response_History_ID": 504711786,

                              "Response_Name": "Ongoing Job/ In Progress",

                                 "Locate_DateTime": "5/1/2025 8:11:00 AM",

                              "Note": "",

                              "From_Status": "Assigned",

                              "To_Status": "Assigned",

                              "Units_Of_Work": "0.00",

                                 "Excv_Pos_Resp_Note": "",

                                 "Response_Contractor": "xxx (OH)",

                              "Locator_Name": "Christopher Vance ( xxxx (OH) )",

                                 "Secondary_Review_Required": "False",

                                 "Secondary_Review_Note": "",

                                 "Send_Excv_Pos_Resp": "True",

                                 "Create_DateTime": "2025-05-01T08:12:45.467",

                              "Closed": "No",

             

                                 "Custom_Response": [],

                              "Asset": []

                           }, {

                                 "Ticket_Locate_Info_ID": 449113574,

                                 "Ticket_Response_History_ID": 504731467,

                              "Response_Name": "Not Complete- Unable to contact Excavator ",

                                 "Locate_DateTime": "5/1/2025 9:11:27 AM",

                              "Note": "",

                              "From_Status": "Assigned",

                              "To_Status": "Closed",

                              "Units_Of_Work": "0.00",

                                 "Excv_Pos_Resp_Note": "",

                                 "Response_Contractor": "xxxx (OH)",

                              "Locator_Name": "Christopher Vance ( xxxx (OH) )",

                                 "Secondary_Review_Required": "False",

                                 "Secondary_Review_Note": "",

                                 "Send_Excv_Pos_Resp": "True",

                                 "Create_DateTime": "2025-05-01T09:11:51.403",

                              "Closed": "Yes",

                                 "Custom_Response": [],

                              "Asset": []

                           }, {

                                 "Ticket_Locate_Info_ID": 449113574,

                                 "Ticket_Response_History_ID": 504731469,

                              "Response_Name": "Not Complete- Unable to contact Excavator ",

                                 "Locate_DateTime": "5/1/2025 9:11:28 AM",

                              "Note": "",

                              "From_Status": "Closed",                      "To_Status": "Closed",

                              "Units_Of_Work": "0.00",

                                 "Excv_Pos_Resp_Note": "",

                                 "Response_Contractor": "XXXX (OH)",

                              "Locator_Name": "Christopher Vance ( XXXX (OH) )",

                                 "Secondary_Review_Required": "False",

                                 "Secondary_Review_Note": "",

                                 "Send_Excv_Pos_Resp": "True",

                                 "Create_DateTime": "2025-05-01T09:11:51.49",

                              "Closed": "Yes",

                                 "Custom_Response": [],

                              "Asset": []

                           }, {

                                 "Ticket_Locate_Info_ID": 449113574,

                                 "Ticket_Response_History_ID": 504861944,

                              "Response_Name": "Marked/Locate Complete",

                                 "Locate_DateTime": "5/1/2025 1:58:38 PM",

                              "Note": "",

                              "From_Status": "Closed",                      "To_Status": "Closed",

                              "Units_Of_Work": "0.00",

                                 "Excv_Pos_Resp_Note": "",

                                 "Response_Contractor": "XXXX (OH)",

                              "Locator_Name": "Christopher Vance ( XXXX (OH) )",

                                 "Secondary_Review_Required": "False",

                                 "Secondary_Review_Note": "",

                                 "Send_Excv_Pos_Resp": "True",

                                 "Create_DateTime": "2025-05-01T14:02:16.95",

                              "Closed": "Yes",

             

                                 "Custom_Response": [],

                              "Asset": []

                           }]

                        }],

                        "Audits": [{

                           "AuditID": 3534085936,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Received",                   "Long_Description": "Ticket received for registration code XXXX",

                           "Create_DateTime": "2025-04-29T10:23:50.45"

                        }, {

                           "AuditID": 3534085937,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Place Synonym Used",

                              "Long_Description": "Place synonym was used when the ticket was received. *PLAIN* was changed to *Plain City*",

                           "Create_DateTime": "2025-04-29T10:23:50.453"

                        }, {

                           "AuditID": 3534085938,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Map Feature Lookup",

                              "Long_Description": "Auto Response Rule not Applied. Number of features that intersect the Occ Dig Area: 47;",

                           "Create_DateTime": "2025-04-29T10:23:50.453"

                        }, {

                           "AuditID": 3534085939,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Ticket Score Calculated",

                           "Long_Description": "AL Renew calculated. Score value: 0",

                           "Create_DateTime": "2025-04-29T10:23:50.457"

                        }, {

                           "AuditID": 3534085941,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Ticket Score Calculated",

                           "Long_Description": "GA Large Projects Meeting calculated. Score value: 0",

                           "Create_DateTime": "2025-04-29T10:23:50.46"

                        }, {

                           "AuditID": 3534085942,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Ticket Score Calculated",

                           "Long_Description": "Large Project GA No Meeting calculated. Score value: 0",

                           "Create_DateTime": "2025-04-29T10:23:50.463"

                        }, {

                           "AuditID": 3534085943,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Ticket Score Calculated",

                           "Long_Description": "TX Update calculated. Score value: 0",

                           "Create_DateTime": "2025-04-29T10:23:50.467"

                        }, {

                           "AuditID": 3534085945,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Auto Process",

                           "Long_Description": "Additional Footprint 20 feet was applied for Map Feature; \r\n",

                           "Create_DateTime": "2025-04-29T10:23:50.467"

                        }, {

                           "AuditID": 3534085949,

                           "Ticket_ID": 406017082,

             

                           "Short_Description": "Put in Folder",

                           "Long_Description": "Put in XXXX (OH) by auto process",

                           "Create_DateTime": "2025-04-29T10:23:50.47"

                        }, {

                           "AuditID": 3534085952,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Assigned",

                           "Long_Description": "Assigned to XXXX (OH) by auto process",

                           "Create_DateTime": "2025-04-29T10:23:50.477"

                        }, {

                           "AuditID": 3534085956,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Insights AI Risk Score",

                           "Long_Description": "Insights AI Incident Likelihood Rank: 11.93163<br 

            />Insights AI Incident Likelihood Percentile: 21.78218<br />Insights AI Incident Impact Rank: 6.468259<br />Insights AI Risk Factors: equipment_used_hoe: +; area_decile: +; members_list: +; excavator_company_name: 

            -; transmit_date_time_hour_of_day: +; request_type: -; equipment_used_track: +; startwork_date_time_day_of_month: -; transmit_date_time_month_of_year: -; start_minus_transmit_days: +; startwork_date_time_season: -; transmit_date_time_day_of_year: +; startwork_date_time_hour_of_day: +; transmit_date_time_day_of_month: -; transmit_date_time_season: -; transmit_date_time_day_of_week: -; startwork_date_time_month_of_year: +; startwork_date_time_day_of_week: -; zip_density: -; <br />",                "Create_DateTime": "2025-04-29T10:23:50.487"

                        }, {

                           "AuditID": 3534085966,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Insights AI Clearing Score",                "Long_Description": "Insights AI Clear Rank: 11.24263<br />Insights AI Clear Percentile: 10<br />Insights AI Clear Prediction Factors: excavator_company_name: -; percent_clearing_1000: -; percent_clearing_20: -; work_type_electr: -; number_clearing_1000: -; number_clearing_20: +; <br />",

                           "Create_DateTime": "2025-04-29T10:23:50.513"

                        }, {

                           "AuditID": 3534090856,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Ticket Queued",

                           "Long_Description": "Ticket queued for delivery",

                           "Create_DateTime": "2025-04-29T10:24:17.59"

                        }, {

                           "AuditID": 3534091551,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Ticket Delivered",

                           "Long_Description": "Ticket successfully sent to 811.oh.chtr@tickets.811tickets.com",

                           "Create_DateTime": "2025-04-29T10:24:22.293"

                        }, {

                           "AuditID": 3541012226,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Responded",

                           "Long_Description": "Ongoing Job/ In Progress (Ongoing): added by contract locator XXXX (OH), located by Christopher Vance. Locate Time: {2025-05-01 08:11:00}",                   "Create_DateTime": "2025-05-01T08:12:45.463"

                        }, {

                           "AuditID": 3541255872,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Responded",

                           "Long_Description": "Not Complete- Unable to contact Excavator : added by contract locator 

            XXXX (OH), located by Christopher Vance. Locate Time: {2025-05-01 09:11:27}",

                           "Create_DateTime": "2025-05-01T09:11:51.403"

                        }, {

             

                           "AuditID": 3541255879,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Responded",

                           "Long_Description": "Not Complete- Unable to contact Excavator : added by contract locator 

            XXXX (OH), located by Christopher Vance. Locate Time: {2025-05-01 09:11:28}",

                           "Create_DateTime": "2025-05-01T09:11:51.49"

                        }, {

                           "AuditID": 3542861012,

                           "Ticket_ID": 406017082,

                           "Short_Description": "Responded",

                              "Long_Description": "Marked/Locate Complete: added by contract locator XXXX (OH), located by 

            Christopher Vance. Locate Time: {2025-05-01 13:58:38}",

                           "Create_DateTime": "2025-05-01T14:02:16.95"

                        }],

                        "Assignment_Info": [{

                           "Ticket_ID": 406017082,

                              "Ticket_Locate_Info_ID": 449113574,

                              "Assignment_History": [{

                                 "Ticket_Locate_Info_ID": 449113574,

                                 "Assigned_To_Contractor": "XXXX (OH)",

                                 "Assignment_Note": "Assigned on folder placement",

                                 "Create_DateTime": "2025-04-29T10:23:50.473"

                           }]

                        }],

                        "Folder_Info": [{

                              "Ticket_Locate_Info_ID": 449113574,

                           "Ticket_ID": 406017082,

                           "Folder_History": [{

                                 "Ticket_Locate_Info_ID": 449113574,

                              "Ticket_Folder": "XXXX (OH)",

                              "Folder_Note": "Auto Processed per All Tickets",

                                 "Create_DateTime": "2025-04-29T10:23:50.467"

                           }]

                        }],

                        "Attachments": [],

                        "WorkLogs": [],

                        "SmartScore": [{

                           "Name": "GA Large Projects Meeting"

                        }, {

                           "Name": "Large Project GA No Meeting"

                        }, {

                           "Name": "TX Update"

                        }, {

                           "Name": "AL Renew"

                        }]

                     }, {

                           "Ticket_Locate_Info_ID": 450711320,

                        "Ticket_ID": 407499097,

                        "One_Call_Center": "OUPS",

                        "CDC": "XXXX",

                        "Ticket_Number": "B511901216",

                        "Version_Number": 1,

                        "Ticket_Type": "On Job",

                           "Reference_Ticket_Number": "",

                        "Sequence_Number": 193,

                        "Received_DateTime": "2025-05-07T08:11:12",

                        "Work_Start_DateTime": "2025-05-01T10:21:00",

             

                        "Taken_DateTime": "2025-05-07T08:10:00",

                        "Meet_Requested": "No",

                        "Work_Done_For": "AEP BOP0000001",

                        "Work_Type": "ELECTRIC LINE INSTALLATION",

                        "Explosives": "No",                "Due_DateTime": "2025-05-01T10:21:00",

                        "Corner_Lot": "No",

                        "Front": "No",

                        "Rear": "No",

                        "Overhead": "No",

                        "Tunneling_Or_Boring": "No",

                        "White_Lined": "No",

                        "Access_Open": "No",

                        "Address_Posted": "No",

                        "Offset_Markings": "No",

                           "Location_Of_Work": "PLEASE MARK ENTIRE PROPETRY AND POWER SOURCE INCLUDING ADJACENT PORPERTIES 

            INSTALLING NEW ELECTIRC SERVICE PLEASE FLAG EVERY 5 FEET\r\n",

                        "Remarks": "REASON FOR REPEAT: INCOMPLETE AREA MARKED REPEAT COMMENTS: ADJACENT SERVICE NOT 

            MARKED * REPEAT MESSAGE, 05/07/2025 08:15 AM, DAKOTA (ORIGINAL DATE: 04/29/2025 10:20 AM) \r\n",

                        "Ticket_Category": "Emergency",

                        "NonCompliant_Excv": "No",

                        "Subdivision": "DARBY STATION 4-2",

                        "Ticket_Text": "XXXX   00193 OUPSa 05/07/25 08:11:12 B511901216-01A INSF REPT POLY ONJB\n\ nTicket : B511901216 Rev: 01A Taken: 05/07/25 08:10 AM Channel: WEB\nOld Tkt: B511901216          Taken: 04/29/25 10:21 AM\n\nState: OH  Cnty: UNION       Place: PLAIN CITY\nState: OH  Cnty: UNION       Place: JEROME TWP\nSubdivsn: DARBY STATION 4-2\n\nAddress : 1923  Street: AEROTRAIN CT N\nRail/Hwy:      

            Milemarker(s):\nWhere   : PLEASE MARK ENTIRE PROPETRY AND POWER SOURCE INCLUDING ADJACENT\n        : PORPERTIES INSTALLING NEW ELECTIRC SERVICE PLEASE FLAG EVERY 5 FEET\n\nWorkType: ELECTRIC LINE INSTALLATION\ nDone for: AEP BOP0000001\nDone by : NREC\nWhitelined: N  Blasting: N\nMeans of Excavation: TRACK HOE\n\ nWork date: 05/01/25 10:21 AM\n\nBest Fit: 40.112372/-83.244440 40.111162/-83.240295\n        : 40.110135/83.245093 40.108925/-83.240948\n\nComments: REASON FOR REPEAT: INCOMPLETE AREA MARKED\n        : REPEAT COMMENTS: ADJACENT SERVICE NOT MARKED\n        : * REPEAT MESSAGE, 05/07/2025 08:15 AM, DAKOTA (ORIGINAL DATE:\n        : 04/29/2025 10:20 AM)\n\nCaller  : MICHAEL MILLER                  Phone: 614-753-1953\ nCompany : NEW RIVER ELECTRICAL CORP                 Type: CONT\nCo addr : 6005 WESTERVILLE ROAD\nCity    : WESTERVILLE                     St: OH  Zip: 43081\nAlt Tel#: 614-753-1953\nAlt cont: BILLY COMBS 

            Phone: 614-542-9068\nEmail: MMILLER@NREC.NET\n\nMembers:\nAEPP1  =AEP OHIO - COLUMBUS(UTILIQUEST  MEC       =MADISON ENERGY COOPERATIVE\nOBFP      =AT&T - OHIO                        XXXX   =CHARTER COMM(SPECTRUM/TIME WAR\ n\nView map at:\nhttps://newtin.oups.org/newtinweb/map_tkt.nap?TRG=689u2v9l9l5ryr4m2l8",             "Excavator": [{

                           "Ticket_ID": 407499097,

                           "Company": "NEW RIVER ELECTRICAL CORP",

                           "Address": "6005 WESTERVILLE ROAD",

                           "City": "WESTERVILLE",

                           "State": "OH",

                           "Zip": "43081",

                           "Contact": [{

                              "Ticket_ID": 407499097,

                              "Name": "MICHAEL MILLER",

                              "Primary_Phone": "6147531953",

                              "Alt_Phone": "6147531953",

                              "Email": "MMILLER@NREC.NET",

                                 "Alt_Contact_Name": "BILLY COMBS",

                                 "Alt_Contact_Phone": "6145429068"

                           }]

                        }],

                        "Dig_Site": [{

                           "Digsite_ID": 407818809,

             

                           "Ticket_ID": 407499097,

                           "Bounding_Box": [{

                              "Digsite_ID": 407818809,

                              "North_Lat": 40.112372,

                              "West_Lon": -83.245093,

                              "South_Lat": 40.108925,

                              "East_Lon": -83.240295,

                                 "Geocoded_North_Lat": 40.20454,

                                 "Geocoded_West_Lon": -83.392667,

                                 "Geocoded_South_Lat": 40.10747,

                                 "Geocoded_East_Lon": -83.17066,

                                 "Geocoded_Center_Lat": 40.156005,

                                 "Geocoded_Center_Lon": -83.281663500000008

                           }],

                           "AddressInfo": [{

                                 "Digsite_Item_ID": 419451772,

                              "Digsite_ID": 407818809,

                              "State": "OH",

                              "County": "UNION",

                              "Place": "Plain City",

                              "Cross_Street": [],

                              "Near_Street": [],

                              "Street": [{

                                    "Digsite_Item_ID": 419451772,

                                    "From_Address": "1923",

                                 "Street_Name": "AEROTRAIN",

                                 "Street_Type": "CT",

                                    "Direction_Suffix": "N"

                              }]

                           }],

                           "Grids": [{

                              "Digsite_ID": 407818809,

                              "Grid": []

                           }]

                        }],

                        "Response_Info": [{                   "Ticket_Locate_Info_ID": 450711320,

                           "Ticket_ID": 407499097,

                           "Response": []

                        }],

                        "Audits": [{

                           "AuditID": 3556720461,

                           "Ticket_ID": 407499097,

                           "Short_Description": "Received",                   "Long_Description": "Ticket received for registration code XXXX",

                           "Create_DateTime": "2025-05-07T08:12:10.29"

                        }, {

                           "AuditID": 3556720462,

                           "Ticket_ID": 407499097,

                           "Short_Description": "Place Synonym Used",

                              "Long_Description": "Place synonym was used when the ticket was received. *PLAIN* was changed to *Plain City*",

                           "Create_DateTime": "2025-05-07T08:12:10.29"

                        }, {

                           "AuditID": 3556720463,

                           "Ticket_ID": 407499097,

                           "Short_Description": "Map Feature Lookup",

             

                              "Long_Description": "Auto Response Rule not Applied. Number of features that intersect the Occ Dig Area: 47;",

                           "Create_DateTime": "2025-05-07T08:12:10.29"

                        }, {

                           "AuditID": 3556720464,

                           "Ticket_ID": 407499097,

                           "Short_Description": "Ticket Score Calculated",

                           "Long_Description": "AL Renew calculated. Score value: 0",

                           "Create_DateTime": "2025-05-07T08:12:10.293"

                        }, {

                           "AuditID": 3556720465,

                           "Ticket_ID": 407499097,

                           "Short_Description": "Ticket Score Calculated",

                           "Long_Description": "GA Large Projects Meeting calculated. Score value: 0",

                           "Create_DateTime": "2025-05-07T08:12:10.307"

                        }, {

                           "AuditID": 3556720466,

                           "Ticket_ID": 407499097,

                           "Short_Description": "Ticket Score Calculated",

                           "Long_Description": "Large Project GA No Meeting calculated. Score value: 0",

                           "Create_DateTime": "2025-05-07T08:12:10.313"

                        }, {

                           "AuditID": 3556720467,

                           "Ticket_ID": 407499097,

                           "Short_Description": "Auto Process",

                           "Long_Description": "Additional Footprint 10 feet was applied for Map Feature; \r\n",

                           "Create_DateTime": "2025-05-07T08:12:10.313"

                        }, {

                           "AuditID": 3556720469,

                           "Ticket_ID": 407499097,

                           "Short_Description": "Put in Folder",

                           "Long_Description": "Put in XXXX (OH) by auto process",

                           "Create_DateTime": "2025-05-07T08:12:10.32"

                        }, {

                           "AuditID": 3556720474,

                           "Ticket_ID": 407499097,

                           "Short_Description": "Assigned",

                           "Long_Description": "Assigned to XXXX (OH) by auto process",

                           "Create_DateTime": "2025-05-07T08:12:10.333"

                        }, {

                           "AuditID": 3556720475,

                           "Ticket_ID": 407499097,

                           "Short_Description": "Insights AI Risk Score",

                           "Long_Description": "Insights AI Incident Likelihood Rank: 12.00599<br 

            />Insights AI Incident Likelihood Percentile: 20.79208<br />Insights AI Incident Impact Rank: 62.43727<br />Insights AI Risk Factors: transmit_date_time_month_of_year: -; startwork_date_time_hour_of_day: -; equipment_used_track: +; members_list: -; transmit_date_time_day_of_month: +; excavator_company_name: +; request_type: +; equipment_used_hoe: +; startwork_date_time_season: -; transmit_date_time_day_of_year: -; transmit_date_time_day_of_week: +; remarks_keywords_servic: -; startwork_date_time_day_of_month: -; startwork_date_time_day_of_week: +; startwork_date_time_month_of_year: -; area_decile: +; transmit_date_time_season: -; start_minus_transmit_days: -; transmit_date_time_hour_of_day: -; zip_density: 

            -; <br />",

                           "Create_DateTime": "2025-05-07T08:12:10.36"

                        }, {

                           "AuditID": 3556720479,

                           "Ticket_ID": 407499097,

                           "Short_Description": "Insights AI Clearing Score",

            Key Benefits/Use Cases:

            • [Use Case 1]: [Brief scenario, benefit, expected business outcome or results]
            • [Use Case 2]: [Brief scenario, benefit, expected business outcome or results ]
            • [Use Case 3]: [Brief scenario, benefit, expected business outcome or results ]


            How It Works:

            Follow these steps to setup or enable:

            1. [Step 1]: [Description]
            2. [Step 2]: [Description]
            3. [Step 3]: [Description]

            [Include images where needed.]


            • [Link to related feature documentation]
            • [Link to UTS 2.0 UI documentation if applicable]
            • [Link to Irth Training credential programs if available]


            FAQ/Troubleshooting:

            Q: [Questions?]

            A: [Answer]

            Q: [Questions?]

            A: [Answer]

            Q: [Questions?]

            A: [Answer]

            Questions?  Contact us!




            Attachments (1)

            pdf

            CS_UtiliSphere Ticket API Integration.pdf
            616 KB

            Was this article helpful?

            That’s Great!

            Thank you for your feedback

            Sorry! We couldn't be helpful

            Thank you for your feedback

            Let us know how can we improve this article!

            Select at least one of the reasons
            CAPTCHA verification is required.

            Feedback sent

            We appreciate your effort and will try to fix the article

            Preview
            0 of 0