Help need for JSONPATH transformation

Setup, Configuration and Use Scripts & Rules
1

Hello all,

I have ajson file which looks like this

{
  "VCALENDAR": [
    {
      "VERSION": "2.0",
      "PRODID": "-//Sabre//Sabre VObject 4.5.1//EN",
      "CALSCALE": "GREGORIAN",
      "METHOD": "PUBLISH",
      "X-WR-CALNAME": "Abfallwirtschaft",
      "X-WR-CALDESC": "Abfallwirtschaft",
      "X-WR-TIMEZONE": "Europe/Berlin",
      "TZID": "Europe/Berlin",
      "VTIMEZONE": [
        {
          "TZID": "Europe/Berlin",
          "STANDARD": [
            {
              "TZNAME": "CET",
              "TZOFFSETFROM": "+0200",
              "TZOFFSETTO": "+0100"
            }
          ]
        }
      ],
      "VEVENT": [
        {
          "UID": "sabre-vobject-23bd316a-190a-4acc-8fb5-c5f36e5fd1de",
          "DTSTAMP": "20230121T111519Z",
          "SUMMARY": "Restmüll 02-wöchentl.",
          "DTSTART;TZID=Europe/Berlin": "20230202T063000",
          "DTEND;TZID=Europe/Berlin": "20230202T080000",
          "DESCRIPTION": "02-wöchentl.",
          "TRANSP": "TRANSPARENT",
          "VALARM": [
            {
              "TRIGGER": "-PT11H30M",
              "DESCRIPTION": "Restmüll",
              "ACTION": "DISPLAY"
            }
          ]
        },
{
          "UID": "sabre-vobject-23bd316a-190a-4acc-8fb5-c5f36e5fd1de",
          "DTSTAMP": "20230121T111519Z",
          "SUMMARY": "Restmüll 02-wöchentl.",
          "DTSTART;TZID=Europe/Berlin": "20230202T063000",
          "DTEND;TZID=Europe/Berlin": "20230202T080000",
          "DESCRIPTION": "02-wöchentl.",
          "TRANSP": "TRANSPARENT",
          "VALARM": [
            {
              "TRIGGER": "-PT11H30M",
              "DESCRIPTION": "Restmüll",
              "ACTION": "DISPLAY"
            }
          ]
        }
]}]}

I tried it to read it via



var response = actions.HTTP.sendHttpGetRequest("http://smarthome.fritz.box:8008/static/muell.json")
//	console.log("json" +response)
	var varWaTi1 = actions.Transformation.transform("JSONPATH", "$.VCALENDAR.VEVENT[0]", response)
      	console.log("json" +varWaTi1)

But I don’t get only one element back its always evrything. Can zou help me again please :slight_smile:

2

VCALENDAR is itself an array too.

$.VCALENDAR[0].VEVENT[0]

When in doubt, use one of the many JSONPATH testers out on the web.