Hi, trying to use JSON data instead of parsing them with PHP and storing them into mySQL, but I am stuck with getting "Fields have different lengths". Below is my data. Can someone help me get this data into table like form? I am able to get "id", state", but not anything under "stats". I believe…

smanjunath211 23 January 2022 04:58 3

Topic		Replies	Views
Help needed with JSONata syntax for replacement of key field General	7	1011	27 January 2021
Json show records on table General	7	504	19 September 2020
Possible issue with mySQL date column and JSONATA $spread() function General database	13	661	27 March 2022
Help Parsing Data with JSONata General	13	2420	11 March 2019
How to transpose data of a json file into a sql table General	3	787	28 August 2019

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.

Educating my self - some guidance asked

Related topics