- Created by Orshi Egressy-Molnár, last modified on 24-07-2023
Imports data from USACE webservice.
Example input:
Expand source
{ "begin": "2023-06-30T07:00:00+0000[UTC]", "end": "2023-07-07T07:00:00+0000[UTC]", "interval": "PT0S", "interval-offset": 0, "name": "BAHK2-BARKLEY.Elev-Pool.Inst.1Hour.0.man-rev", "office-id": "LRN", "page": "MTY4ODEwODQwMDAwMHx8MTY5fHw1MDA=", "page-size": 500, "time-zone": "US/Central", "total": 169, "units": "ft", "value-columns": [ { "name": "date-time", "ordinal": 1, "datatype": "java.sql.Timestamp" }, { "name": "value", "ordinal": 2, "datatype": "java.lang.Double" }, { "name": "quality-code", "ordinal": 3, "datatype": "int" } ], "values": [ [ 1688108400000, 359.4, 0 ], [ 1688112000000, 359.4, 0 ], [ 1688115600000, 359.45, 0 ], [ 1688119200000, 359.45, 0 ], [ 1688122800000, 359.4, 0 ], [ 1688126400000, 359.4, 0 ], [ 1688130000000, 359.45, 0 ], [ 1688133600000, 359.4, 0 ], [ 1688137200000, 359.34999999999997, 0 ], [ 1688140800000, 359.24999999999994, 0 ], [ 1688144400000, 359.29999999999995, 0 ], [ 1688148000000, 359.29999999999995, 0 ], [ 1688151600000, 359.24999999999994, 0 ], [ 1688155200000, 359.29999999999995, 0 ], [ 1688158800000, 359.24999999999994, 0 ], [ 1688162400000, 359.24999999999994, 0 ], [ 1688166000000, 359.24999999999994, 0 ], [ 1688169600000, 359.24999999999994, 0 ], [ 1688173200000, 359.2, 0 ], [ 1688176800000, 359.2, 0 ], [ 1688180400000, 359.2, 0 ], [ 1688184000000, 359.2, 0 ], [ 1688187600000, 359.2, 0 ], [ 1688191200000, 359.29999999999995, 0 ], [ 1688194800000, 359.29999999999995, 0 ], [ 1688198400000, 359.29999999999995, 0 ], [ 1688202000000, 359.34999999999997, 0 ], [ 1688205600000, 359.34999999999997, 0 ], [ 1688209200000, 359.29999999999995, 0 ], [ 1688212800000, 359.4, 0 ], [ 1688216400000, 359.34999999999997, 0 ], [ 1688220000000, 359.34999999999997, 0 ], [ 1688223600000, 359.29999999999995, 0 ], [ 1688227200000, 359.24999999999994, 0 ], [ 1688230800000, 359.24999999999994, 0 ], [ 1688234400000, 359.15, 0 ], [ 1688238000000, 359.15, 0 ], [ 1688241600000, 359.2, 0 ], [ 1688245200000, 359.29999999999995, 0 ], [ 1688248800000, 359.24999999999994, 0 ], [ 1688252400000, 359.24999999999994, 0 ], [ 1688256000000, 359.24999999999994, 0 ], [ 1688259600000, 359.2, 0 ], [ 1688263200000, 359.2, 0 ], [ 1688266800000, 359.2, 0 ], [ 1688270400000, 359.15, 0 ], [ 1688274000000, 359.15, 0 ], [ 1688277600000, 359.2, 0 ], [ 1688281200000, 359.24999999999994, 0 ], [ 1688284800000, 359.24999999999994, 0 ], [ 1688288400000, 359.34999999999997, 0 ], [ 1688292000000, 359.34999999999997, 0 ], [ 1688295600000, 359.34999999999997, 0 ], [ 1688299200000, 359.29999999999995, 0 ], [ 1688302800000, 359.34999999999997, 0 ], [ 1688306400000, 359.2, 0 ], [ 1688310000000, 359.24999999999994, 0 ], [ 1688313600000, 359.24999999999994, 0 ], [ 1688317200000, 359.15, 0 ], [ 1688320800000, 359.09999999999997, 0 ], [ 1688324400000, 359.04999999999995, 0 ], [ 1688328000000, 359.15, 0 ], [ 1688331600000, 359.09999999999997, 0 ], [ 1688335200000, 359.09999999999997, 0 ], [ 1688338800000, 359.04999999999995, 0 ], [ 1688342400000, 358.99999999999994, 0 ], [ 1688346000000, 358.99999999999994, 0 ], [ 1688349600000, 358.99999999999994, 0 ], [ 1688353200000, 359.15, 0 ], [ 1688356800000, 359.15, 0 ], [ 1688360400000, 359.15, 0 ], [ 1688364000000, 359.2, 0 ], [ 1688367600000, 359.2, 0 ], [ 1688371200000, 359.2, 0 ], [ 1688374800000, 359.2, 0 ], [ 1688378400000, 359.2, 0 ], [ 1688382000000, 359.2, 0 ], [ 1688385600000, 359.15, 0 ], [ 1688389200000, 359.15, 0 ], [ 1688392800000, 359.15, 0 ], [ 1688396400000, 359.15, 0 ], [ 1688400000000, 359.15, 0 ], [ 1688403600000, 359.15, 0 ], [ 1688407200000, 359.15, 0 ], [ 1688410800000, 359.04999999999995, 0 ], [ 1688414400000, 359.04999999999995, 0 ], [ 1688418000000, 359.04999999999995, 0 ], [ 1688421600000, 359.04999999999995, 0 ], [ 1688425200000, 359.04999999999995, 0 ], [ 1688428800000, 359.09999999999997, 0 ], [ 1688432400000, 359.09999999999997, 0 ], [ 1688436000000, 359.09999999999997, 0 ], [ 1688439600000, 359.2, 0 ], [ 1688443200000, 359.2, 0 ], [ 1688446800000, 359.2, 0 ], [ 1688450400000, 359.2, 0 ], [ 1688454000000, 359.2, 0 ], [ 1688457600000, 359.29999999999995, 0 ], [ 1688461200000, 359.29999999999995, 0 ], [ 1688464800000, 359.34999999999997, 0 ], [ 1688468400000, 359.34999999999997, 0 ], [ 1688472000000, 359.4, 0 ], [ 1688475600000, 359.4, 0 ], [ 1688479200000, 359.34999999999997, 0 ], [ 1688482800000, 359.34999999999997, 0 ], [ 1688486400000, 359.34999999999997, 0 ], [ 1688490000000, 359.34999999999997, 0 ], [ 1688493600000, 359.34999999999997, 0 ], [ 1688497200000, 359.34999999999997, 0 ], [ 1688500800000, 359.34999999999997, 0 ], [ 1688504400000, 359.29999999999995, 0 ], [ 1688508000000, 359.29999999999995, 0 ], [ 1688511600000, 359.29999999999995, 0 ], [ 1688515200000, 359.2, 0 ], [ 1688518800000, 359.2, 0 ], [ 1688522400000, 359.24999999999994, 0 ], [ 1688526000000, 359.24999999999994, 0 ], [ 1688529600000, 359.29999999999995, 0 ], [ 1688533200000, 359.29999999999995, 0 ], [ 1688536800000, 359.4, 0 ], [ 1688540400000, 359.34999999999997, 0 ], [ 1688544000000, 359.34999999999997, 0 ], [ 1688547600000, 359.34999999999997, 0 ], [ 1688551200000, 359.34999999999997, 0 ], [ 1688554800000, 359.34999999999997, 0 ], [ 1688558400000, 359.34999999999997, 0 ], [ 1688562000000, 359.34999999999997, 0 ], [ 1688565600000, 359.34999999999997, 0 ], [ 1688569200000, 359.34999999999997, 0 ], [ 1688572800000, 359.34999999999997, 0 ], [ 1688576400000, 359.34999999999997, 0 ], [ 1688580000000, 359.34999999999997, 0 ], [ 1688583600000, 359.34999999999997, 0 ], [ 1688587200000, 359.34999999999997, 0 ], [ 1688590800000, 359.34999999999997, 0 ], [ 1688594400000, 359.34999999999997, 0 ], [ 1688598000000, 359.29999999999995, 0 ], [ 1688601600000, 359.24999999999994, 0 ], [ 1688605200000, 359.24999999999994, 0 ], [ 1688608800000, 359.24999999999994, 0 ], [ 1688612400000, 359.24999999999994, 0 ], [ 1688616000000, 359.24999999999994, 0 ], [ 1688619600000, 359.29999999999995, 0 ], [ 1688623200000, 359.29999999999995, 0 ], [ 1688626800000, 359.34999999999997, 0 ], [ 1688630400000, 359.34999999999997, 0 ], [ 1688634000000, 359.34999999999997, 0 ], [ 1688637600000, 359.34999999999997, 0 ], [ 1688641200000, 359.34999999999997, 0 ], [ 1688644800000, 359.29999999999995, 0 ], [ 1688648400000, 359.29999999999995, 0 ], [ 1688652000000, 359.29999999999995, 0 ], [ 1688655600000, 359.29999999999995, 0 ], [ 1688659200000, 359.24999999999994, 0 ], [ 1688662800000, 359.24999999999994, 0 ], [ 1688666400000, 359.2, 0 ], [ 1688670000000, 359.2, 0 ], [ 1688673600000, 359.15, 0 ], [ 1688677200000, 359.15, 0 ], [ 1688680800000, 359.15, 0 ], [ 1688684400000, 359.09999999999997, 0 ], [ 1688688000000, 359.15, 0 ], [ 1688691600000, 359.15, 0 ], [ 1688695200000, 359.15, 0 ], [ 1688698800000, 359.2, 0 ], [ 1688702400000, 359.24999999999994, 0 ], [ 1688706000000, 359.24999999999994, 0 ], [ 1688709600000, 359.24999999999994, 0 ], [ 1688713200000, 359.29999999999995, 0 ] ] }
Config example:
<?xml version="1.0" encoding="UTF-8"?> <!-- edited with XMLSpy v2006 rel. 3 sp1 (http://www.altova.com) by Computer Services (WL | Delft Hydraulics) --> <timeSeriesImportRun xmlns="http://www.wldelft.nl/fews" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.wldelft.nl/fews http://fews.wldelft.nl/schemas/version1.0/timeSeriesImportRun.xsd"> <import> <general> <importType>CWMS</importType> <serverUrl>https://cwms-data.usace.army.mil/cwms-data/timeseries</serverUrl> <user>user</user> <password>password</password> <relativeViewPeriod unit="day" start="-7" end="9" startOverrulable="true"/> <idMapId>CWMS</idMapId> </general> <properties> <string key="Office" value="lrn"/> </properties> <timeSeriesSet> <moduleInstanceId>CWMS</moduleInstanceId> <valueType>scalar</valueType> <parameterId>parameterA</parameterId> <locationId>LocB</locationId> <locationId>LocA</locationId> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="hour" multiplier="1"/> <readWriteMode>add originals</readWriteMode> </timeSeriesSet> </import> </timeSeriesImportRun>
- No labels