Nested Json Data source

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

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.

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

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