Thanks Joel, that works.
Here is the JSON if anyone would like it (sorry, can't figure out how to make all this code):
{
"dataSources":[
{
"xid":"DS_652957",
"name":"SQL",
"enabled":true,
"type":"SQL",
"alarmLevels":{
"POLL_ABORTED":"NONE",
"STATEMENT_EXCEPTION":"NONE",
"DATA_SOURCE_EXCEPTION":"NONE"
},
"purgeType":"YEARS",
"updatePeriodType":"MINUTES",
"connectionUrl":"jdbc:h2:/opt/mango/databases/mah2",
"driverClassname":"org.h2.Driver",
"password":"password-here",
"rowBasedQuery":true,
"selectStatement":"select 'count' as count, count(*) from datapoints",
"updatePeriods":5,
"username":"mango",
"purgeOverride":false,
"purgePeriod":1
}
],
"dataPoints":[
{
"xid":"DP_262803",
"name":"Point Count",
"enabled":true,
"loggingType":"ON_CHANGE",
"intervalLoggingPeriodType":"MINUTES",
"intervalLoggingType":"INSTANT",
"purgeType":"YEARS",
"pointLocator":{
"dataType":"NUMERIC",
"dateParameterFormat":"yyyy-MM-dd'T'HH:mm:ss",
"fieldName":"Count",
"parameters":[
],
"tableModifier":false,
"timeOverrideName":"",
"updateStatement":""
},
"eventDetectors":[
],
"plotType":"STEP",
"unit":"",
"chartColour":"",
"chartRenderer":null,
"dataSourceXid":"DS_652957",
"defaultCacheSize":1,
"deviceName":"MangoES",
"discardExtremeValues":false,
"discardHighLimit":0.0,
"discardLowLimit":0.0,
"intervalLoggingPeriod":15,
"intervalLoggingSampleWindowSize":0,
"overrideIntervalLoggingSamples":false,
"purgeOverride":false,
"purgePeriod":1,
"textRenderer":{
"type":"ANALOG",
"useUnitAsSuffix":false,
"unit":"",
"renderedUnit":"",
"suffix":" points",
"format":"####"
},
"tolerance":0.0
}
]
}