Hello,
I am looking to retrieve some information via the 'Read XML' activity.
The piece of the XML that I am working with is below:
<LocalProcessing>
<ArrivalCartageRef/>
<DeliveryCartageAdvised/>
<DeliveryCartageCompleted>2018-01-19T10:52:00</DeliveryCartageCompleted>
<DeliveryLabourCharge>0.0000</DeliveryLabourCharge>
<DeliveryLabourTime/>
<DeliveryRequiredBy/>
<DemurrageOnDeliveryCharge>0.0000</DemurrageOnDeliveryCharge>
<DemurrageOnDeliveryTime/>
<DemurrageOnPickupCharge>0.0000</DemurrageOnPickupCharge>
<DemurrageOnPickupTime/>
<EstimatedDelivery/>
<EstimatedPickup>2018-01-15T15:52:00</EstimatedPickup>
</LocalProcessing>
I am specifically interested in the 'Estimated Pickup' date, in bold above.
I can retrieve that information without issue using "//LocalProcessing/EstimatedPickup", however it pulls the whole of 2018-01-15T15:52:00 when I am only interested in 2018-01-15.
I can use an 'Assign Token Values' activity to clean it up, but was wondering if there was a better/cleaner way, or a way I could do that in the Read XML activity?
Thank you,
Darren