skip to Main Content

mysql how to query nested json element?

so here is the schema for the JSON : { "ts": 1677330162, "uuid": "75e4917d-69cd-49e1-963f-380ea031a88b", "moderators": [ { "userId": "000001", "timeAdded": 1677332262, "permissions": { "all": true, "tag": true, "mail": true, "posts": true, "access": true, "config": true, "analytics": true } } ],…

VIEW QUESTION

API JSON javascript extract data loop array

I've succeeded at connecting and getting JSON data from API using this method: <script type="text/javascript"> fetch('https://api.web_address.com/vi/locations/10', { method: 'GET', headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer my_bearer_token' }, }) .then(response => { if (response.ok) { return response.json() } else { return…

VIEW QUESTION
Back To Top
Search