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…

Welcome to the community. Could you please post code within code fences so that it is readable. Thanks.

[image] Problems with creating CSV or excel General Please use the below guide to post code in preformatted text, so that it is easy to copy your code. [howtopastecode]

{ "SrtReceivers": [ {}, { "id": "95.166.22.151:35166->0.0.0.0:20203", "state": "connected", "retryCount": 2, "stats": {} }, { "id": "95.166.22.151:57988->0.0.0.0:20204", "state": "connected", "retryCount": 2, "stats": { "time": 71488923, "window": { "flow": 8192, "congestion": 8192, "flight": 0 }, "…

{ "SrtReceivers": [ {}, { "id": "95.166.22.151:35166->0.0.0.0:20203", "state": "connected", "retryCount": 2, "stats": {} }, { "id": "95.166.22.151:57988->0.0.0.0:20204", "state": "connected", "retryCount": 2, "stats": { "time"…

{ "SrtReceivers": [ {}, { "id": "95.166.22.151:35166->0.0.0.0:20203", "state": "connected", "retryCount": 2, "stats": {} }, { "id": "95.166.22.151:57988->0.0.0.0:20204", "state": "connected", "retryCount": 2, "stats": { "time": 71488923, "window": { "flow": 8192, "congestion": 8192, "flight": 0 }, "…

[image] video2go: Can someone help me get this data into table like form? Your question is vague and offers no format of the output you require, or which object properties you want to view in a table. Here is an example that will get you started. for more info search angular ng-repeat. [{"…

Node-RED

Node-RED Forum

Educating my self - some guidance asked

General

smanjunath211 23 January 2022 04:58 3

Topic		Replies	Views
Help Parsing Data with JSONata General	13	2468	11 March 2019
Convert Array intoto JSON General	13	6769	2 June 2019
Json show records on table General	7	539	19 September 2020
Json Parsing how to extract the values, using best possible shortest code General function-node	17	351	16 March 2023
Beginner needs some json to mysql support General	6	747	16 February 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