- 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
