1

I am using Json data source for an API which has nested result. Below is the example.

[
{
“CompanyId”: 142,
“IssuerName”: “Bangkok Bank Public Company Limited”,
“Data”: [
{
“Date”: “2020-09-01”,
“MarketCap”: 198519660976.0,
“Currency”: “THB”,
“MarketCapUSD”: 6384743696.9362955
},
{
“Date”: “2020-09-02”,
“MarketCap”: 201382925317.0,
“Currency”: “THB”,
“MarketCapUSD”: 6476831346.411339
},
{
“Date”: “2020-09-03”,
“MarketCap”: 199474082423.0,
“Currency”: “THB”,
“MarketCapUSD”: 6415439580.094644
},
{
“Date”: “2020-09-08”,
“MarketCap”: 202337346764.0,
“Currency”: “THB”,
“MarketCapUSD”: 6507527229.569686
},
{
“Date”: “2020-09-09”,
“MarketCap”: 205200611105.0,
“Currency”: “THB”,
“MarketCapUSD”: 6599614879.044728
},
{
“Date”: “2020-09-10”,
“MarketCap”: 200428503870.0,
“Currency”: “THB”,
“MarketCapUSD”: 6446135463.252991
}
]
}
]

I need result from “Data” node of the Json. I tried below query, but it is giving me error as Couldn’t find path Data in response.

url: https://refdata.visiblealpha.com/refdata/marketcapital?companyid=142&enddate=2020-09-10&startdate=2020-09-01
headers: {"Content-Type":"application/json","Authorization":"Bearer SomeToken"}
path: Data
2

It fails because Data is nested twice in the API response. For this API you might write your own query runner since the default JSON data source won’t work.

3

Can you please point me to some document which has example for running own query runner?

4

In case you didn’t find this while searching the forum: