Get Unsolved Transformer Discrepancies API

This API fetches and delivers service points without confident transformer group suggestions to a customer's data lake/business system. It can be used for the following use cases:

GIS operators receive daily update of connectivity data. Some connections may be automatically updated, some may be further validated automatically by utility back-office systems or manually by utility.

Get bulk request and response examples

Used to request a large data file in the format of your choice (Parquet, Orc, Json, CSV) for downloading when the request can take several minutes to complete.

Data product ID. 5ca21de2-d55b-47f4-92f7-ae847c2a7011
Data latency. Three minutes or greater, depending on query parameters.
Maximum result size. Millions.
Data availability. Last 13 months.

Request

Copy

POST /dpss/api/v1/subscriptions/{{subscriptionId}}/batch-request HTTP/1.1
Host: k8s.itrontotal.com
Authorization: Bearer 
Itron-CorrelationId: {{CoorelationId}}
DataSubscriberId: {{subscriberId}}

{
    "filetype": "csv",
    "Tokens": {
        "StartReceivedDatetime": "2024-08-22T00:00:00Z",
        "EndReceivedDatetime": "",
        "StartReportDatetime": "2024-08-22T00:00:00Z",
        "EndReportDatetime": "",
        "GisCorrelationPercent": ""
    },
    "isOhsRequest": false
}

Response

Copy

ReceivedTime,ReportTime,ServicePointId,SPLatitude,SPLongitude,TransformerGroupId,TransformerId,PotentialXfmrId1,PotentialXfmrId2,GISXfmrLatitude,GISXfmrLongitude,GISXfmrDistance,PtntlXfmrID1Latitude,PtntlXfmrID1Longitude,PtntlXfmrID1Distance,PtntlXfmrID2Latitude,PtntlXfmrID2Longitude,PtntlXfmrID2Distance,GisCorrelationPercent
2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,9000372474,-11.5773477,-58.03992627,808,4929542183-90777887,3726565589-96320947,4461594638-36098270,36.3782585,-12.63036974,29.2087385,87.07818951,65.28242318,54.37316291,27.70119657,-43.01775787,61.83678621,50
2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,9000502815,46.80101392,116.3092734,253,2594744147-91918635,7618221900-48881528,2495291441-40556829,-30.8231922,141.5208343,1.511984665,-24.47969653,47.71119606,16.42696,-26.84040583,-40.50017522,85.58438875,11
2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,9000053282,75.67532295,155.7855714,523,2594744147-91918635,9266764062-4656300,4369153393-78363068,6.941620475,129.4548652,8.334218535,22.298034,18.16426306,80.56459874,72.85830791,94.19844211,11.28565879,14
2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,9000585414,-50.18033628,159.8658806,355,2662535221-10734063,8868494392-81521828,5368919975-65957600,-33.13484488,-168.0712717,6.088452073,7.7117688,50.41051805,19.149225,45.01547234,160.293897,28.31821982,90
2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,9000594308,-78.9127481,81.14868215,457,2949637457-92808645,5640546931-34700053,8349776649-16677151,77.44648233,173.6965121,86.90774269,-80.64639968,-110.9068228,89.10412327,73.17583517,-65.68312566,69.35663497,22
2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,9000580263,35.86173678,-100.8996206,988,2435841314-92195447,2007308472-51477093,2092012054-90341548,51.96643651,134.2578255,62.87300521,-28.56476097,-102.9805586,60.74105659,58.50916043,-116.5435258,99.21591282,77
2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,9000372477,-27.64172683,173.0188031,251,4495046038-10795431,9021996485-672527,3396758937-69426337,-7.158276197,116.2529439,22.39248868,73.54273109,-63.54000914,8.1252902,43.3960908,-126.1881257,24.38944096,88
2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,9000007738,-57.32820153,-116.6051763,478,2604141857-10581404,6687427729-866753,4413247337-32769447,-5.495977072,-110.9608402,22.34145066,73.74097492,180.214021,80.44147725,-89.99209314,107.9483003,21.69215477,64
2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,9000389087,-68.13067311,-17.84550697,950,2768938379-10477102,2702490583-27435113,2337646981-66066928,45.03527264,-78.60461136,20.56604796,-12.47921509,179.445255,28.84973066,66.4907874,26.67366377,24.98675472,23
2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,9000530026,-36.59234706,3.964409068,251,2302540356-10169202,2896900215-5619799,5782608639-54466261,81.91586372,62.50511246,84.13165718,-80.21943106,93.50884356,46.9618632,13.94865615,46.29693541,40.80348789,15
2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,9000098919,-8.312749942,-174.4905132,594,3393042722-93886808,6265415335-88968208,9358812126-85837913,28.4287756,-0.107821556,35.41616869,-64.24037189,26.83225902,95.82156149,26.44789633,53.5773301,67.55086987,87
2023-09-13T00:29:55.55Z,2023-09-13T00:29:55.55Z,9001805366,60.98893037,-8.199811013,673,3393042722-93886808,3680942160-53563492,8688980529-1174821,-39.66445477,-47.99549093,94.24311449,70.15704754,-96.51466624,92.17170038,36.94600376,-4.040664563,16.14652869,65

Parameters

Table 32
Name	Description	Operators	Required	Type	Format	Default	Range	Origination
StartReportDatetime	API returns all meter connectivity recommendations from this date/time Range End	Greater than or equal to	No	Datetime	YYYY-MM-DDTHH:MM:SSZ	2020-01-01T00:00:00.0Z	(Current UTC Date - 13 mo.) to (Current UTC Date	Edge app
EndReportDatetime	API returns all meter connectivity recommendations from Range Start through this date/time	Less than or equal to	No	Datetime	YYYY-MM-DDTHH:MM:SSZ	9999-12-31T00:00:00.0Z	(Current UTC Date - 13 mo.) to (Current UTC Date	Edge app
StartReceivedDatetime	Min ReceivedTime data	Greater than or equal to	No	Datetime	YYYY-MM-DDTHH:MM:SSZ	2020-01-01T00:00:00.0Z	(Current UTC Date) to (Current UTC Date - 13 months)	App Platform
EndReceivedDatetime	Max ReceivedTime data	Less than or equal to	No	Datetime	YYYY-MM-DDTHH:MM:SSZ	9999-12-31T00:00:00.0Z	(Current UTC Date) to (Current UTC Date - 13 months)	App Platform
GisCorrelationPercent	Percentage match between transformer group service points to corresponding GIS transformer	Greater than or equal to	No	Decimal	N.NNN	0	0-100%	App Platform

Data values

Table 33
Name	Description	Type	Units	Range	Format	Nullable	Origination
ReceivedTime	When the data was received by the App Platform	Datetime	N/A	N/A	YYYY-MM-DDTHH:MM:SSZ	No	App Platform
ReportTime	Date the associated children were connected to this group	Datetime	N/A	N/A	YYYY-MM-DDTHH:MM:SSZ	No	Edge app
ServicePointId	Service Point ID as of EventDate	String	N/A	N/A	N/A	No	CIS MDMS GIS
SPLatitude	Lattitude of utility service point asset provided by GIS	Decimal	Degrees	-90 to 90	N.NN	Yes	App Platform
SPLongitude	Longitude of utility service point asset provided by GIS	Decimal	Degrees	-180 to 180	N.NN	Yes	App Platform
TransformerGroupId	Txfmr identifier created by DI	String	N/A	N/A	N/A	No	CIS MDMS GIS
TransformerId	Parent txfmr of SP from GIS import	String	N/A	N/A	N/A	Yes	CIS MDMS GIS
PotentialXfmrId1	Txfmr ID that could be parent of SP	String	N/A	N/A	N/A	No	App Platform
PotentialXfmrId2	Additional Txfmr ID that could be parent of SP	String	N/A	N/A	N/A	Yes	App Platform
GISXfmrLatitude	Lattitude of utility txfmr asset provided by GIS	Decimal	Degrees	-90 to 90	N.NN	Yes	App Platform
GISXfmrLongitude	Longitude of utility txfmr asset provided by GIS	Decimal	Degrees	-180 to 180	N.NN	Yes	App Platform
GISXfmrDistance	Distance, in meters, from GIS txfmr to SP	Real	Meters	N/A	N.NN	No	App Platform
PtntlXfmrId1Latitude	Lattitude of tranformer suggestion 1	Decimal	Degrees	-90 to 90	N.NN	Yes	App Platform
PtntlXfmrId1Longitude	Longitude of tranformer suggestion 1	Decimal	Degrees	-180 to 180	N.NN	Yes	App Platform
PtntlXfmrId1Distance	Distance, in meters, from transformer suggestion 1 to SP	Real	Meters	N/A	N.NN	No	App Platform
PtntlXfmrId2Latitude	Lattitude of tranformer suggestion 2	Decimal	Degrees	-90 to 90	N.NN	Yes	App Platform
PtntlXfmrId2Longitude	Longitude of tranformer suggestion 2	Decimal	Degrees	-180 to 180	N.NN	Yes	App Platform
PtntlXfmrId2Distance	Distance, in meters, from transformer suggestion 2 to SP	Real	Meters	N/A	N.NN	No	App Platform
GisCorrelationPercent	Percentage match between service points in Transformer Group to the closest corresponding transformer in GIS	Decimal	Percent	0-100%	N.NNN	Yes	App Platform