Hi Everyone, I'm new to Node Red and I'm trying to use it to read out around 30 rows of data from an SQL server database and import that data into a google sheet. I'm stuck on converting the JSON string I'm getting from my SQL query into a JSON string the google sheet node will accept. The string…

Asuming you mean Javascript object Here are three examples [{"id":"8dc3265970cd0547","type":"inject","z":"b9860b4b9de8c8da","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"ID\":1,\"Description\":\"First\",…

[image] Marshy: The string from the SQL Are you sure it is a string? I would have expected it to be a JavaScript object.

Node-RED

Node-RED Forum

Remove the key part from a JSON string

General

Marshy 23 August 2023 10:37 4

Yes apologies it was a javascript object.
Thanks for your solution it works perfectly!
Just need to get my head around how each solution works.

Topic		Replies	Views
Node-RED v3.0.2 string to json General function-node	4	621	4 October 2022
How do I extract values from a JSON string? General function-node	15	4944	19 July 2022
Help converting string to key/value object General	6	3739	9 February 2021
Converting string payload into JSON General	8	22932	14 September 2019
How do i reference a value out of a JSON string General	16	1706	17 January 2021

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 the key part from a JSON string

Related topics