JSON Kingswaysoft document designer question

#json #editor #kingsway #designer

Hello,

I'm fairly new to JSON and (REST) api's.

My target is to learn how to get data from an api (REST) to a SQL table. I use JSON source editor provided by Kingswaysoft. In the document designer i'm doing something wrong.

Example REST API (source)
{
"change": true,
"end_date": "2023-01-01",
"quotes": {
"USDAED": {
"change": 0,
"change_pct": 0,
"end_rate": 3.672635,
"start_rate": 3.672635
},
"USDAFN": {
"change": 0,
"change_pct": 0,
"end_rate": 87.49408,
"start_rate": 87.49408
},
"USDALL": {
"change": 0,
"change_pct": 0,
"end_rate": 107.150283,
"start_rate": 107.150283
},
"USDAMD": {