Receiving the following message from TTN (abbreviated): {"payload_fields": {"Latitude":0,"Longitude":0}} How get I transform them to a location item? With JSONPATH:$.payload_fields.Latitude or JSONPATH:$.payload_fields.Longitude I can get the individual values. But how should the transform lo…

Well, very strangely, I got it working on the very first try :upside_down_face: That was nearly too easy. Although I would really like to see a support for creating the scripts in the GUI (as my goal is to move all or most of the configuration from my text files to the GUI). Thanks for your help, …

Have you tried it with $.[Latitude,Longitude] - should return [0, 0] Hope that helps - not sure about the location type item though.

Unfortunately this does not work: JSONPATH:$.payload_fields.[Latitude,Longitude] Executing the JSONPATH-transformation failed: An error occurred while transforming JSON expression.

The JSONPATH transformation service does not deal very well with arrays. It can only return a single string. That might look like “[x,y]” but I don’t think that will help as I think Location types look for “x,y” format. You could chain on another transformation to strip the brackets, but you might…

OK, I will try to read through the docs to understand how to build a javascript transformation.

Oh, next problem, when trying to install the javascript transformation add-on :frowning: Failed installing 'openhab-transformation-javascript': Error: Error downloading mvn:org.openhab.addons.bundles/org.openhab.transform.javascript/3.0.1

Looks relevant - [image] Something up with remote repository? Just cleared my cache and started openhab and getting stuck downloading any bindings etc. My end or openhab end? not had any issues previously (and i clear the cache alot slight_smile ) 2021-04-12…

maven has kar files if you need in meantime. https://search.maven.org/artifact/org.openhab.distro/openhab-addons/2.5.12/kar just change search for 3.x

Ah, just bad luck then :slight_smile: Well, I’ll wait till tomorrow, then. I need to understand how to use the javascript transformation anyway first :wink:

So, the add-on did automatically install this night. Now I need to see how to use it. I will report, whatever the outcome will be :slight_smile:

is there any documentation on howto use the javascript transformation in the GUI? Do I need to create a script in the GUI? In the channel configuration page, what do I need to insert for the transformation to call the javascript transformation? Probably something similar to “JSONPATH:…”? EDIT: See…

[MQTT][JSONPATH] Howto transform mqtt message to location

Setup, Configuration and Use Beginners

rossko57 (Rossko57) April 12, 2021, 4:28pm 7

Looks relevant -