Only the First Record is Inserted from an XML Service

87
0
05-23-2022 04:23 PM
lvargas
New Contributor III

Hello,

Exist a Web Service in https that returns data (vehicle tracking) in a XML format, this is the input for GeoEvent and are the output its a hosted feature (Relational Data Store of ArcGIS Enterprise).

The process is working, but the issue is that only the first XML record (vehicle) is inserted in the hosted service, the others (vehicles) are ignored.

Is there any consideration that is being omitted? recommendations, or do you know if it is a limitation of the XML or somting int the structure or definition?

Web Service with the elements in XML format.

URL: https://server.domain.com/..etc

<space>
<Response>
<Status>
<code>100</code>
<description>OK</description>
</Status>
<Plate id="AA-1234" img="4.png" MobileID="21398">
<hst id="9382">
<DateTimeGPS>2022/05/23 07:21:31</DateTimeGPS>
<DateTimeServer>2022/05/23 07:21:31</DateTimeServer>
<Latitude>9.9563701119108146</Latitude>
<Longitude>-84.1027151938647</Longitude>
<Speed>11</Speed>
<Heading>Este</Heading>
<Altitud>1118</Altitud>
<Location>CRI</Location>
<Satellites>11</Satellites>
<IOState> </IOState>
<EventID>18</EventID>
<Event>Report AAA</Event>
<PDI>CRI</PDI>
<ZONES>SJ</ZONES>
<FIRMWARE>44d</FIRMWARE>
<Ignition>1</Ignition>
<LastOn>2022/05/23 05:31:32</LastOn>
<LastOff>2022/05/21 22:13:21</LastOff>
<Odometer>201502.48</Odometer>
</hst>
</Plate>
<Plate id="BB-1344" img="4.png" MobileID="21348">
<hst id="4382">
<DateTimeGPS>2022/05/23 07:21:31</DateTimeGPS>
<DateTimeServer>2022/05/23 07:21:31</DateTimeServer>
<Latitude>9.7563701119108146</Latitude>
<Longitude>-84.4027151938647</Longitude>
<Speed>11</Speed>
<Heading>Este</Heading>
<Altitud>1134</Altitud>
<Location>CRI</Location>
<Satellites>11</Satellites>
<IOState> </IOState>
<EventID>18</EventID>
<Event>Report AAA</Event>
<PDI>CRI</PDI>
<ZONES>SJ</ZONES>
<FIRMWARE>44d</FIRMWARE>
<Ignition>1</Ignition>
<LastOn>2022/05/23 05:31:32</LastOn>
<LastOff>2022/05/21 22:13:21</LastOff>
<Odometer>201502.48</Odometer>
</hst>
</Plate>

<Plate id="CC-6743" img="Incial.png" MobileID="97190">
...
</Plate>
<Plate id="DD-1243" img="4.png" MobileID="86895">
...
</Plate>
<Plate id="EE-6755" img="4.png" MobileID="27689">
...

<Response>
<space>

Environment.
Its ArcGIS Enterprise 10.9.1 (federated with relational Data Store) and ArcGIS GeoEvent 10.8.1; the environment is distributed in several virtual machines, with certificates signed by a commercial CA, and using Windows Server 2019 Standard.

Definition of the Input (WS XML Service).

input-def.png

Input (WS with XML).

Input-01.png

Input-02.png

Definition of the Ouput (Update feature ArcGIS Enterprise Hosted).

Output-def.png

Output (Update feature ArcGIS Enterprise Hosted)

Output.png

Service.

Service.png

 

FieldMapper.

FM-01.png

FM-02.png

Result (Hosted Feature in AGE).

GeoEvent.png

Regards.

0 Kudos
0 Replies