JSON Problem
Verfasst: 1. Apr 2020 17:15
Hallo,.
ich möchte aus dem JSON eines http-Request eine Information rausziehen, bekomme dabei aber immer eine "Invalid path" Exception.
Wenn ich das JSON und den Path auf http://jsonpath.com/ teste, erhalte ich das gewünschte Ergebnis.
Mein Item:
Mein JSON (bisschen lang, sorry) :
Das Log:
Ich hoffe, jemand hat eine Idee.
Viele Grüße
ich möchte aus dem JSON eines http-Request eine Information rausziehen, bekomme dabei aber immer eine "Invalid path" Exception.
Wenn ich das JSON und den Path auf http://jsonpath.com/ teste, erhalte ich das gewünschte Ergebnis.
Mein Item:
Code: Alles auswählen
String RadioState "Value: [%s]" { http="<[http://192.168.2.222:8085/raumserver/data/getRendererState:1000:JSONPATH($.data.0.rooms.0.PowerState)]" }
Code: Alles auswählen
{"requestUrl":"/raumserver/data/getRendererState","action":"getRendererState","error":false,"msg":"","data":[{"Mute":0,"InstanceID":0,"RoomStates":"","RoomVolumes":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9=40","Volume":"40","CurrentTrackMetaData":"<?xml version=\"1.0\"?>\n<DIDL-Lite xmlns=\"urn:schemas-upnp-org:metadata-1-0/DIDL-Lite/\" xmlns:raumfeld=\"urn:schemas-raumfeld-com:meta-data/raumfeld\" xmlns:upnp=\"urn:schemas-upnp-org:metadata-1-0/upnp/\" xmlns:dc=\"http://purl.org/dc/elements/1.1/\" xmlns:dlna=\"urn:schemas-dlna-org:metadata-1-0/\" xmlns:pv=\"http://www.pv.com/pvns/\" lang=\"en\"><item parentID=\"0/Favorites/MyFavorites\" id=\"0/Favorites/MyFavorites/97\" restricted=\"1\" refID=\"0/RadioTime/Search/s-s8954\"><raumfeld:name>Station</raumfeld:name><upnp:class>object.item.audioItem.audioBroadcast.radio</upnp:class><raumfeld:section>RadioTime</raumfeld:section><raumfeld:durability>120</raumfeld:durability><dc:title>radio ffn</dc:title><upnp:albumArtURI dlna:profileID=\"JPEG_TN\">http://d1i6vahw24eb07.cloudfront.net/s8954q.png</upnp:albumArtURI><raumfeld:ebrowse>http://opml.radiotime.com/Tune.ashx?partnerId=7aJ9pvV5&formats=wma%2Cmp3%2Cogg&serial=54%3A4a%3A16%3A7f%3Ad3%3Ac5&id=s8954&c=ebrowse</raumfeld:ebrowse><res bitrate=\"192\" protocolInfo=\"http-get:*:audio/x-mpegurl:*\">http://opml.radiotime.com/Tune.ashx?id=e110020815&sid=s8954&formats=wma,mp3,ogg&partnerId=7aJ9pvV5&serial=54:4a:16:7f:d3:c5</res></item></DIDL-Lite>\n","CurrentRecordQualityMode":"NOT_IMPLEMENTED","AbsoluteTimePosition":"00:00:00","SecondsUntilSleep":"0","CurrentTrack":"4","AVTransportURIMetaData":"<?xml version=\"1.0\"?>\n<DIDL-Lite xmlns=\"urn:schemas-upnp-org:metadata-1-0/DIDL-Lite/\" xmlns:upnp=\"urn:schemas-upnp-org:metadata-1-0/upnp/\" xmlns:dc=\"http://purl.org/dc/elements/1.1/\" xmlns:dlna=\"urn:schemas-dlna-org:metadata-1-0/\" xmlns:pv=\"http://www.pv.com/pvns/\"><item restricted=\"1\"/></DIDL-Lite>\n","PossiblePlaybackStorageMedia":"NETWORK","TransportPlaySpeed":"1","CurrentTrackDuration":"00:00:00","PossibleRecordQualityModes":"NOT_IMPLEMENTED","Bitrate":"192","PossibleRecordStorageMedia":"NONE","AVTransportURI":"dlna-playcontainer://uuid%3A545be55b-1d97-4872-94f0-99c7893bd97a?sid=urn%3Aupnp-org%3AserviceId%3AContentDirectory&cid=0%2FFavorites%2FMyFavorites&md=0&fii=0","RelativeTimePosition":"00:00:00","RelativeCounterPosition":"1","CurrentPlayMode":"NORMAL","TransportState":"STOPPED","AbsoluteCounterPosition":"1","CurrentTransportActions":"","ContentType":"MP3","NumberOfTracks":"4","SleepTimerActive":"0","TransportStatus":"OK","CurrentTrackURI":"http://stream.ffn.de/ffn/mp3-192/stream.mp3?ref=tunein","RoomMutes":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9=0","rooms":[{"roomUDN":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9","Volume":"40","Mute":"0","name":"Kueche","PowerState":"MANUAL_STANDBY","online":true,"udn":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9","powerState":"MANUAL_STANDBY","renderer":[{"udn":"uuid:97883760-3c5e-4d85-9fd6-fa0c860fc243","name":"Speaker Kueche"}]}],"udn":"uuid:de4c540c-f389-4937-ae87-a573ed4e5e6c","mediaItem":{"class":"object.item.audioItem.audioBroadcast.radio","section":"RadioTime","name":"Station","durability":"120","childCount":null,"parentID":"0/Favorites/MyFavorites","id":"0/Favorites/MyFavorites/97","restricted":"1","refID":"0/RadioTime/Search/s-s8954","title":"radio ffn","description":null,"artist":null,"albumArtURI":"http://d1i6vahw24eb07.cloudfront.net/s8954q.png","genre":null,"album":null,"date":null,"creator":null,"originalTrackNumber":null,"bitrate":"192","protocolInfo":"http-get:*:audio/x-mpegurl:*","signalStrength":null,"ebrowse":"http://opml.radiotime.com/Tune.ashx?partnerId=7aJ9pvV5&formats=wma%2Cmp3%2Cogg&serial=54%3A4a%3A16%3A7f%3Ad3%3Ac5&id=s8954&c=ebrowse"},"friendlyName":"Kueche","host":"192.168.2.103","manufacturer":"Lautsprecher Teufel GmbH","modelNumber":"1"},{"InstanceID":0,"AVTransportURIMetaData":"","CurrentTrackDuration":"NOT_IMPLEMENTED","PowerState":"MANUAL_STANDBY","AVTransportURI":"","CurrentPlayMode":"NORMAL","TransportState":"NO_MEDIA_PRESENT","OwnsAudioResource":"0","CurrentTransportActions":"","TransportStatus":"OK","LowDB":"0.000000","Mute":"0","MidDB":"0.000000","Volume":"40","HighDB":"0.000000","rooms":[{"name":"Kueche","udn":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9","powerState":"MANUAL_STANDBY","renderer":[{"udn":"uuid:97883760-3c5e-4d85-9fd6-fa0c860fc243","name":"Speaker Kueche"}]}],"udn":"uuid:97883760-3c5e-4d85-9fd6-fa0c860fc243","mediaItem":null,"friendlyName":"Speaker Kueche","host":"192.168.2.103","manufacturer":"Lautsprecher Teufel GmbH","modelNumber":"1"}]}
Code: Alles auswählen
2020-04-01 16:27:53.478 [WARN ] [ab.binding.http.internal.HttpBinding] - Transformation 'JSONPATH($.data.0.rooms.0.PowerState)' threw an exception. [response={"requestUrl":"/raumserver/data/getRendererState","action":"getRendererState","error":false,"msg":"","data":[{"Mute":0,"InstanceID":0,"RoomStates":"","RoomVolumes":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9=40","Volume":"40","CurrentTrackMetaData":"<?xml version=\"1.0\"?>\n<DIDL-Lite xmlns=\"urn:schemas-upnp-org:metadata-1-0/DIDL-Lite/\" xmlns:raumfeld=\"urn:schemas-raumfeld-com:meta-data/raumfeld\" xmlns:upnp=\"urn:schemas-upnp-org:metadata-1-0/upnp/\" xmlns:dc=\"http://purl.org/dc/elements/1.1/\" xmlns:dlna=\"urn:schemas-dlna-org:metadata-1-0/\" xmlns:pv=\"http://www.pv.com/pvns/\" lang=\"en\"><item parentID=\"0/Favorites/MyFavorites\" id=\"0/Favorites/MyFavorites/97\" restricted=\"1\" refID=\"0/RadioTime/Search/s-s8954\"><raumfeld:name>Station</raumfeld:name><upnp:class>object.item.audioItem.audioBroadcast.radio</upnp:class><raumfeld:section>RadioTime</raumfeld:section><raumfeld:durability>120</raumfeld:durability><dc:title>radio ffn</dc:title><upnp:albumArtURI dlna:profileID=\"JPEG_TN\">http://d1i6vahw24eb07.cloudfront.net/s8954q.png</upnp:albumArtURI><raumfeld:ebrowse>http://opml.radiotime.com/Tune.ashx?partnerId=7aJ9pvV5&formats=wma%2Cmp3%2Cogg&serial=54%3A4a%3A16%3A7f%3Ad3%3Ac5&id=s8954&c=ebrowse</raumfeld:ebrowse><res bitrate=\"192\" protocolInfo=\"http-get:*:audio/x-mpegurl:*\">http://opml.radiotime.com/Tune.ashx?id=e110020815&sid=s8954&formats=wma,mp3,ogg&partnerId=7aJ9pvV5&serial=54:4a:16:7f:d3:c5</res></item></DIDL-Lite>\n","CurrentRecordQualityMode":"NOT_IMPLEMENTED","AbsoluteTimePosition":"00:00:00","SecondsUntilSleep":"0","CurrentTrack":"4","AVTransportURIMetaData":"<?xml version=\"1.0\"?>\n<DIDL-Lite xmlns=\"urn:schemas-upnp-org:metadata-1-0/DIDL-Lite/\" xmlns:upnp=\"urn:schemas-upnp-org:metadata-1-0/upnp/\" xmlns:dc=\"http://purl.org/dc/elements/1.1/\" xmlns:dlna=\"urn:schemas-dlna-org:metadata-1-0/\" xmlns:pv=\"http://www.pv.com/pvns/\"><item restricted=\"1\"/></DIDL-Lite>\n","PossiblePlaybackStorageMedia":"NETWORK","TransportPlaySpeed":"1","CurrentTrackDuration":"00:00:00","PossibleRecordQualityModes":"NOT_IMPLEMENTED","Bitrate":"192","PossibleRecordStorageMedia":"NONE","AVTransportURI":"dlna-playcontainer://uuid%3A545be55b-1d97-4872-94f0-99c7893bd97a?sid=urn%3Aupnp-org%3AserviceId%3AContentDirectory&cid=0%2FFavorites%2FMyFavorites&md=0&fii=0","RelativeTimePosition":"00:00:00","RelativeCounterPosition":"1","CurrentPlayMode":"NORMAL","TransportState":"STOPPED","AbsoluteCounterPosition":"1","CurrentTransportActions":"","ContentType":"MP3","NumberOfTracks":"4","SleepTimerActive":"0","TransportStatus":"OK","CurrentTrackURI":"http://stream.ffn.de/ffn/mp3-192/stream.mp3?ref=tunein","RoomMutes":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9=0","rooms":[{"roomUDN":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9","Volume":"40","Mute":"0","name":"Kueche","PowerState":"MANUAL_STANDBY","online":true,"udn":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9","powerState":"MANUAL_STANDBY","renderer":[{"udn":"uuid:97883760-3c5e-4d85-9fd6-fa0c860fc243","name":"Speaker Kueche"}]}],"udn":"uuid:de4c540c-f389-4937-ae87-a573ed4e5e6c","mediaItem":{"class":"object.item.audioItem.audioBroadcast.radio","section":"RadioTime","name":"Station","durability":"120","childCount":null,"parentID":"0/Favorites/MyFavorites","id":"0/Favorites/MyFavorites/97","restricted":"1","refID":"0/RadioTime/Search/s-s8954","title":"radio ffn","description":null,"artist":null,"albumArtURI":"http://d1i6vahw24eb07.cloudfront.net/s8954q.png","genre":null,"album":null,"date":null,"creator":null,"originalTrackNumber":null,"bitrate":"192","protocolInfo":"http-get:*:audio/x-mpegurl:*","signalStrength":null,"ebrowse":"http://opml.radiotime.com/Tune.ashx?partnerId=7aJ9pvV5&formats=wma%2Cmp3%2Cogg&serial=54%3A4a%3A16%3A7f%3Ad3%3Ac5&id=s8954&c=ebrowse"},"friendlyName":"Kueche","host":"192.168.2.103","manufacturer":"Lautsprecher Teufel GmbH","modelNumber":"1"},{"InstanceID":0,"AVTransportURIMetaData":"","CurrentTrackDuration":"NOT_IMPLEMENTED","PowerState":"MANUAL_STANDBY","AVTransportURI":"","CurrentPlayMode":"NORMAL","TransportState":"NO_MEDIA_PRESENT","OwnsAudioResource":"0","CurrentTransportActions":"","TransportStatus":"OK","LowDB":"0.000000","Mute":"0","MidDB":"0.000000","Volume":"40","HighDB":"0.000000","rooms":[{"name":"Kueche","udn":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9","powerState":"MANUAL_STANDBY","renderer":[{"udn":"uuid:97883760-3c5e-4d85-9fd6-fa0c860fc243","name":"Speaker Kueche"}]}],"udn":"uuid:97883760-3c5e-4d85-9fd6-fa0c860fc243","mediaItem":null,"friendlyName":"Speaker Kueche","host":"192.168.2.103","manufacturer":"Lautsprecher Teufel GmbH","modelNumber":"1"}]}]
org.openhab.core.transform.TransformationException: Invalid path '$.data.0.rooms.0.PowerState' in '{"requestUrl":"/raumserver/data/getRendererState","action":"getRendererState","error":false,"msg":"","data":[{"Mute":0,"InstanceID":0,"RoomStates":"","RoomVolumes":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9=40","Volume":"40","CurrentTrackMetaData":"<?xml version=\"1.0\"?>\n<DIDL-Lite xmlns=\"urn:schemas-upnp-org:metadata-1-0/DIDL-Lite/\" xmlns:raumfeld=\"urn:schemas-raumfeld-com:meta-data/raumfeld\" xmlns:upnp=\"urn:schemas-upnp-org:metadata-1-0/upnp/\" xmlns:dc=\"http://purl.org/dc/elements/1.1/\" xmlns:dlna=\"urn:schemas-dlna-org:metadata-1-0/\" xmlns:pv=\"http://www.pv.com/pvns/\" lang=\"en\"><item parentID=\"0/Favorites/MyFavorites\" id=\"0/Favorites/MyFavorites/97\" restricted=\"1\" refID=\"0/RadioTime/Search/s-s8954\"><raumfeld:name>Station</raumfeld:name><upnp:class>object.item.audioItem.audioBroadcast.radio</upnp:class><raumfeld:section>RadioTime</raumfeld:section><raumfeld:durability>120</raumfeld:durability><dc:title>radio ffn</dc:title><upnp:albumArtURI dlna:profileID=\"JPEG_TN\">http://d1i6vahw24eb07.cloudfront.net/s8954q.png</upnp:albumArtURI><raumfeld:ebrowse>http://opml.radiotime.com/Tune.ashx?partnerId=7aJ9pvV5&formats=wma%2Cmp3%2Cogg&serial=54%3A4a%3A16%3A7f%3Ad3%3Ac5&id=s8954&c=ebrowse</raumfeld:ebrowse><res bitrate=\"192\" protocolInfo=\"http-get:*:audio/x-mpegurl:*\">http://opml.radiotime.com/Tune.ashx?id=e110020815&sid=s8954&formats=wma,mp3,ogg&partnerId=7aJ9pvV5&serial=54:4a:16:7f:d3:c5</res></item></DIDL-Lite>\n","CurrentRecordQualityMode":"NOT_IMPLEMENTED","AbsoluteTimePosition":"00:00:00","SecondsUntilSleep":"0","CurrentTrack":"4","AVTransportURIMetaData":"<?xml version=\"1.0\"?>\n<DIDL-Lite xmlns=\"urn:schemas-upnp-org:metadata-1-0/DIDL-Lite/\" xmlns:upnp=\"urn:schemas-upnp-org:metadata-1-0/upnp/\" xmlns:dc=\"http://purl.org/dc/elements/1.1/\" xmlns:dlna=\"urn:schemas-dlna-org:metadata-1-0/\" xmlns:pv=\"http://www.pv.com/pvns/\"><item restricted=\"1\"/></DIDL-Lite>\n","PossiblePlaybackStorageMedia":"NETWORK","TransportPlaySpeed":"1","CurrentTrackDuration":"00:00:00","PossibleRecordQualityModes":"NOT_IMPLEMENTED","Bitrate":"192","PossibleRecordStorageMedia":"NONE","AVTransportURI":"dlna-playcontainer://uuid%3A545be55b-1d97-4872-94f0-99c7893bd97a?sid=urn%3Aupnp-org%3AserviceId%3AContentDirectory&cid=0%2FFavorites%2FMyFavorites&md=0&fii=0","RelativeTimePosition":"00:00:00","RelativeCounterPosition":"1","CurrentPlayMode":"NORMAL","TransportState":"STOPPED","AbsoluteCounterPosition":"1","CurrentTransportActions":"","ContentType":"MP3","NumberOfTracks":"4","SleepTimerActive":"0","TransportStatus":"OK","CurrentTrackURI":"http://stream.ffn.de/ffn/mp3-192/stream.mp3?ref=tunein","RoomMutes":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9=0","rooms":[{"roomUDN":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9","Volume":"40","Mute":"0","name":"Kueche","PowerState":"MANUAL_STANDBY","online":true,"udn":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9","powerState":"MANUAL_STANDBY","renderer":[{"udn":"uuid:97883760-3c5e-4d85-9fd6-fa0c860fc243","name":"Speaker Kueche"}]}],"udn":"uuid:de4c540c-f389-4937-ae87-a573ed4e5e6c","mediaItem":{"class":"object.item.audioItem.audioBroadcast.radio","section":"RadioTime","name":"Station","durability":"120","childCount":null,"parentID":"0/Favorites/MyFavorites","id":"0/Favorites/MyFavorites/97","restricted":"1","refID":"0/RadioTime/Search/s-s8954","title":"radio ffn","description":null,"artist":null,"albumArtURI":"http://d1i6vahw24eb07.cloudfront.net/s8954q.png","genre":null,"album":null,"date":null,"creator":null,"originalTrackNumber":null,"bitrate":"192","protocolInfo":"http-get:*:audio/x-mpegurl:*","signalStrength":null,"ebrowse":"http://opml.radiotime.com/Tune.ashx?partnerId=7aJ9pvV5&formats=wma%2Cmp3%2Cogg&serial=54%3A4a%3A16%3A7f%3Ad3%3Ac5&id=s8954&c=ebrowse"},"friendlyName":"Kueche","host":"192.168.2.103","manufacturer":"Lautsprecher Teufel GmbH","modelNumber":"1"},{"InstanceID":0,"AVTransportURIMetaData":"","CurrentTrackDuration":"NOT_IMPLEMENTED","PowerState":"MANUAL_STANDBY","AVTransportURI":"","CurrentPlayMode":"NORMAL","TransportState":"NO_MEDIA_PRESENT","OwnsAudioResource":"0","CurrentTransportActions":"","TransportStatus":"OK","LowDB":"0.000000","Mute":"0","MidDB":"0.000000","Volume":"40","HighDB":"0.000000","rooms":[{"name":"Kueche","udn":"uuid:fb59a372-ad4a-4817-9f08-cb3060a9f1b9","powerState":"MANUAL_STANDBY","renderer":[{"udn":"uuid:97883760-3c5e-4d85-9fd6-fa0c860fc243","name":"Speaker Kueche"}]}],"udn":"uuid:97883760-3c5e-4d85-9fd6-fa0c860fc243","mediaItem":null,"friendlyName":"Speaker Kueche","host":"192.168.2.103","manufacturer":"Lautsprecher Teufel GmbH","modelNumber":"1"}]}'
at org.openhab.core.transform.TransformationHelper$TransformationServiceDelegate.transform(TransformationHelper.java:71) ~[bundleFile:?]
at org.openhab.binding.http.internal.HttpBinding.execute(HttpBinding.java:218) [bundleFile:?]
at org.openhab.core.binding.AbstractActiveBinding$BindingActiveService.execute(AbstractActiveBinding.java:146) [bundleFile:?]
at org.openhab.core.service.AbstractActiveService$RefreshThread.run(AbstractActiveService.java:169) [bundleFile:?]
Viele Grüße