Hi. I receive data from a gps and want to write it to a sql database. How do i get rid of the longitude, latitude, altitude, accuracy, provider etc in the object data. I only want to write the actual values to sql. The following is the data i get from the gps: object latitude: -34.1304 longitud…

Remove header from gps object data

E1cid 8 October 2022 07:55 4

In a chnage node
set msg.payload
to JSONata J: $$.payload.*

This will return an array of values
e.g
[-34.130000, 22.09785, -32.4, etc....]

Change an object to an array

Topic		Replies	Views
Retrieve values from payload object General	8	151	20 June 2023
Ist it possible to (and if yes how can I) directly import the content of 1 array / object in a XML? General	33	2059	7 March 2019
Node-red + postgres General	8	2466	8 May 2020
How do I change a JSON Object Key General	2	3024	13 April 2019
How to extract exact data from payload General	4	322	10 March 2023

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Remove header from gps object data

Related topics