Need help formatting the service to HA for setting the date. Only getting the error: Expected “:”, got “}”
Node:
[ { "id": "b10b1e1e.bb47f", "type": "api-call-service", "z": "a318c51d.29a138", "name": "Restavfall", "server": "ec6b4330.077a3", "version": 1, "debugenabled": false, "service_domain": "input_datetime", "service": "set_datetime", "entityId": "input_datetime.hra_restavfall", "data": "{\t \"entity_id\": \"input_datetime.hra_restavfall\",\t \"data\": { \"date\": {{ payload }}\t}", "dataType": "jsonata", "mergecontext": "", "output_location": "", "output_location_type": "none", "mustacheAltTags": false, "x": 920, "y": 1940, "wires": [ [] ] }, { "id": "ec6b4330.077a3", "type": "server", "name": "Home Assistant", "legacy": false, "addon": true, "rejectUnauthorizedCerts": true, "ha_boolean": "y|yes|true|on|home|open", "connectionDelay": true, "cacheJson": true } ]
Flow:
[
{
"id": "b26ea565.129378",
"type": "inject",
"z": "a318c51d.29a138",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "[{\"name\":\"Restavfall\",\"date\":\"2021-12-17\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-05-04\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-05-20\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-06-04\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-06-18\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-07-02\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-07-16\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-07-30\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-08-13\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-08-27\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-09-10\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-09-24\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-10-08\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-10-22\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-11-05\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-11-19\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-04-20\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Restavfall\",\"date\":\"2021-12-03\",\"fractionId\":9999,\"fractionGuid\":\"b4bbf08d-30f0-4024-9f53-e42229ec48a6\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-04-20\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-06-18\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-11-05\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-11-19\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-12-03\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-09-24\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-09-10\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-08-27\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-08-13\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-07-30\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-07-16\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-07-02\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-10-22\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-10-08\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-05-20\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-12-17\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-05-04\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Matavfall\",\"date\":\"2021-06-04\",\"fractionId\":2110,\"fractionGuid\":\"ccdd09f5-3510-43bb-9bb4-2b192230d354\",\"route\":30403,\"routeName\":\"0304\",\"frequency\":2,\"startDay\":4},{\"name\":\"Papir, papp og kartong\",\"date\":\"2021-12-17\",\"fractionId\":2400,\"fractionGuid\":\"8998844f-406e-458c-b8da-8e8249f5c321\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Papir, papp og kartong\",\"date\":\"2021-11-19\",\"fractionId\":2400,\"fractionGuid\":\"8998844f-406e-458c-b8da-8e8249f5c321\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Papir, papp og kartong\",\"date\":\"2021-10-22\",\"fractionId\":2400,\"fractionGuid\":\"8998844f-406e-458c-b8da-8e8249f5c321\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Papir, papp og kartong\",\"date\":\"2021-05-04\",\"fractionId\":2400,\"fractionGuid\":\"8998844f-406e-458c-b8da-8e8249f5c321\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Papir, papp og kartong\",\"date\":\"2021-09-24\",\"fractionId\":2400,\"fractionGuid\":\"8998844f-406e-458c-b8da-8e8249f5c321\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Papir, papp og kartong\",\"date\":\"2021-08-27\",\"fractionId\":2400,\"fractionGuid\":\"8998844f-406e-458c-b8da-8e8249f5c321\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Papir, papp og kartong\",\"date\":\"2021-07-30\",\"fractionId\":2400,\"fractionGuid\":\"8998844f-406e-458c-b8da-8e8249f5c321\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Papir, papp og kartong\",\"date\":\"2021-07-02\",\"fractionId\":2400,\"fractionGuid\":\"8998844f-406e-458c-b8da-8e8249f5c321\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Papir, papp og kartong\",\"date\":\"2021-06-04\",\"fractionId\":2400,\"fractionGuid\":\"8998844f-406e-458c-b8da-8e8249f5c321\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Glass- og metallemballasje\",\"date\":\"2021-07-30\",\"fractionId\":2612,\"fractionGuid\":\"2627574c-db98-4d6b-94fd-dfb47a64007d\",\"route\":161408,\"routeName\":\"1614\",\"frequency\":8,\"startDay\":4},{\"name\":\"Glass- og metallemballasje\",\"date\":\"2021-11-19\",\"fractionId\":2612,\"fractionGuid\":\"2627574c-db98-4d6b-94fd-dfb47a64007d\",\"route\":161408,\"routeName\":\"1614\",\"frequency\":8,\"startDay\":4},{\"name\":\"Glass- og metallemballasje\",\"date\":\"2021-09-24\",\"fractionId\":2612,\"fractionGuid\":\"2627574c-db98-4d6b-94fd-dfb47a64007d\",\"route\":161408,\"routeName\":\"1614\",\"frequency\":8,\"startDay\":4},{\"name\":\"Glass- og metallemballasje\",\"date\":\"2021-06-04\",\"fractionId\":2612,\"fractionGuid\":\"2627574c-db98-4d6b-94fd-dfb47a64007d\",\"route\":161408,\"routeName\":\"1614\",\"frequency\":8,\"startDay\":4},{\"name\":\"Plast\",\"date\":\"2021-10-22\",\"fractionId\":3200,\"fractionGuid\":\"03fc89dd-accb-4b4f-a6b0-667438975720\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Plast\",\"date\":\"2021-09-24\",\"fractionId\":3200,\"fractionGuid\":\"03fc89dd-accb-4b4f-a6b0-667438975720\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Plast\",\"date\":\"2021-08-27\",\"fractionId\":3200,\"fractionGuid\":\"03fc89dd-accb-4b4f-a6b0-667438975720\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Plast\",\"date\":\"2021-07-30\",\"fractionId\":3200,\"fractionGuid\":\"03fc89dd-accb-4b4f-a6b0-667438975720\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Plast\",\"date\":\"2021-07-02\",\"fractionId\":3200,\"fractionGuid\":\"03fc89dd-accb-4b4f-a6b0-667438975720\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Plast\",\"date\":\"2021-06-04\",\"fractionId\":3200,\"fractionGuid\":\"03fc89dd-accb-4b4f-a6b0-667438975720\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Plast\",\"date\":\"2021-05-04\",\"fractionId\":3200,\"fractionGuid\":\"03fc89dd-accb-4b4f-a6b0-667438975720\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Plast\",\"date\":\"2021-12-17\",\"fractionId\":3200,\"fractionGuid\":\"03fc89dd-accb-4b4f-a6b0-667438975720\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4},{\"name\":\"Plast\",\"date\":\"2021-11-19\",\"fractionId\":3200,\"fractionGuid\":\"03fc89dd-accb-4b4f-a6b0-667438975720\",\"route\":100402,\"routeName\":\"1004\",\"frequency\":4,\"startDay\":4}]",
"payloadType": "json",
"x": 290,
"y": 1940,
"wires": [
[
"73188c9.19ebf74"
]
]
},
{
"id": "73188c9.19ebf74",
"type": "change",
"z": "a318c51d.29a138",
"name": "topic = Restavfall",
"rules": [
{
"t": "set",
"p": "topic",
"pt": "msg",
"to": "Restavfall",
"tot": "str"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 470,
"y": 1940,
"wires": [
[
"cc42ae3.94b225"
]
]
},
{
"id": "cc42ae3.94b225",
"type": "function",
"z": "a318c51d.29a138",
"name": "",
"func": "var now = new Date();\n\nvar data = msg.payload;\nif(!data || !Array.isArray(data) || !data.length) {\n node.warn(\"no data\");\n return null; //halt flow\n}\n\n//filter the data to today or later AND where name == topic\nvar filtered = data.filter(e => new Date(e.date) >= now && e.name == msg.topic )\n\n//a compare function\nfunction compare( a, b ) {\n if ( a.date < b.date ) return -1;\n if ( a.date > b.date ) return 1;\n return 0;\n}\n//sort data using the compare function\nvar dataSorted = filtered.sort(compare);\n\n//grab the top (earliest) entry - put it in payload\nmsg.payload = dataSorted[0];\n\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"x": 680,
"y": 1940,
"wires": [
[
"64fdab26.eb51b4",
"306e99af.fcfc56",
"b10b1e1e.bb47f"
]
]
},
{
"id": "b10b1e1e.bb47f",
"type": "api-call-service",
"z": "a318c51d.29a138",
"name": "Restavfall",
"server": "ec6b4330.077a3",
"version": 1,
"debugenabled": false,
"service_domain": "input_datetime",
"service": "set_datetime",
"entityId": "input_datetime.hra_restavfall",
"data": "{\t \"entity_id\": \"input_datetime.hra_restavfall\",\t \"data\": { \"date\": {{ payload }}\t}",
"dataType": "jsonata",
"mergecontext": "",
"output_location": "",
"output_location_type": "none",
"mustacheAltTags": false,
"x": 920,
"y": 1940,
"wires": [
[]
]
},
{
"id": "ec6b4330.077a3",
"type": "server",
"name": "Home Assistant",
"legacy": false,
"addon": true,
"rejectUnauthorizedCerts": true,
"ha_boolean": "y|yes|true|on|home|open",
"connectionDelay": true,
"cacheJson": true
}
]