
<br>{
  "boat_id": 16,
  "gps": {
    "lat": 0.0,
    "lng": 0.0
  },
  "devices": [
    {
      "device_id": 537,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": -10.0
    },
    {
      "device_id": 538,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 35.0
    },
    {
      "device_id": 539,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 13.7
    },
    {
      "device_id": 540,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 23.0
    },
    {
      "device_id": 541,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 35.0
    },
    {
      "device_id": 542,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 75.0
    },
    {
      "device_id": 543,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 55.0
    },
    {
      "device_id": 544,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 68.0
    },
    {
      "device_id": 548,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 82.0
    },
    {
      "device_id": 559,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 1.0
    },
    {
      "device_id": 560,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 1.0
    },
    {
      "device_id": 562,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 0.0
    },
    {
      "device_id": 533,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 1.0
    },
    {
      "device_id": 535,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 0.0
    },
    {
      "device_id": 531,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 1.0
    },
    {
      "device_id": 532,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 0.0
    },
    {
      "device_id": 536,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 0.0
    },
    {
      "device_id": 147,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 1.4
    },
    {
      "device_id": 426,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 21.5
    },
    {
      "device_id": 545,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 27.0
    },
    {
      "device_id": 546,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 580.0
    },
    {
      "device_id": 547,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": -85.0
    },
    {
      "device_id": 561,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": -20.0
    }
  ]
}<br>{"success":true,"errors":[],"token":"11a090bfad"}Array
(
    [url] => https://boatauto:gTQx9Ym7fMByn6aC7auZ@aacdata.com/webhooks/events
    [content_type] => application/json; charset=utf-8
    [http_code] => 200
    [header_size] => 575
    [request_size] => 2718
    [filetime] => -1
    [ssl_verify_result] => 0
    [redirect_count] => 0
    [total_time] => 0.200668
    [namelookup_time] => 0.000274
    [connect_time] => 0.052131
    [pretransfer_time] => 0.110993
    [size_upload] => 2518
    [size_download] => 49
    [speed_download] => 244
    [speed_upload] => 12548
    [download_content_length] => 49
    [upload_content_length] => 2518
    [starttransfer_time] => 0.200635
    [redirect_time] => 0
    [redirect_url] => 
    [primary_ip] => 34.203.63.194
    [certinfo] => Array
        (
        )

    [primary_port] => 443
    [local_ip] => 75.103.66.12
    [local_port] => 52564
)
<br>sql = INSERT INTO  `boatauto_test`.`NewDevices` (
`boatid` ,
`macid` ,
`deviceid1` ,
`deviceid2` ,
`deviceid3` ,
`deviceid4` ,
`deviceid5` ,
`deviceid6` ,
`deviceid7` ,
`deviceid8` ,
`deviceid9` ,
`value1` ,
`value2` ,
`value3` ,
`volts` ,
`button` ,
`pump1` ,
`pump2` ,
`pump3` ,
`ipaddress` ,
`signalst` ,
`baro` ,
`freq` ,
`rebootfreq` , 
`env` ,
`datatopost` ,
`server_outputA` ,
`server_outputW` 
)
VALUES (
CONVERT(, UNSIGNED) , , CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, ,   ,   ,   ,  ,  ,  ,  ,  
,  , , ,  , 'A', '{
  "boat_id": 16,
  "gps": {
    "lat": 0.0,
    "lng": 0.0
  },
  "devices": [
    {
      "device_id": 537,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": -10.0
    },
    {
      "device_id": 538,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 35.0
    },
    {
      "device_id": 539,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 13.7
    },
    {
      "device_id": 540,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 23.0
    },
    {
      "device_id": 541,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 35.0
    },
    {
      "device_id": 542,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 75.0
    },
    {
      "device_id": 543,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 55.0
    },
    {
      "device_id": 544,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 68.0
    },
    {
      "device_id": 548,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 82.0
    },
    {
      "device_id": 559,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 1.0
    },
    {
      "device_id": 560,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 1.0
    },
    {
      "device_id": 562,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 0.0
    },
    {
      "device_id": 533,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 1.0
    },
    {
      "device_id": 535,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 0.0
    },
    {
      "device_id": 531,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 1.0
    },
    {
      "device_id": 532,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 0.0
    },
    {
      "device_id": 536,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 0.0
    },
    {
      "device_id": 147,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 1.4
    },
    {
      "device_id": 426,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 21.5
    },
    {
      "device_id": 545,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 27.0
    },
    {
      "device_id": 546,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": 580.0
    },
    {
      "device_id": 547,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": -85.0
    },
    {
      "device_id": 561,
      "event_date": "2018-05-30T13:01:10-07:00",
      "value": -20.0
    }
  ]
}', '{"success":true,"errors":[],"token":"11a090bfad"}', ' '
)