scottincryptoJSON Proof of Concept Working
Updated 2021-08-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
›
⌄
with jdata as (
select '{
"vault_data":
[
{
"contract": "0xa258c4606ca8206d8aa700ce2143d7db854d168c",
"underlying_asset": "WETH",
"underlying_contract": "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"
},
{
"contract": "0x986b4aff588a109c09b50a03f42e4110e29d353f",
"underlying_asset": "Curve ETH/sETH",
"underlying_contract": "0xa3d87fffce63b53e0d54faa1cc983b7eb0b74a9c"
}
]
}'
as jdata
)
select
value:contract::string as contract,
value:underlying_asset::string as underlying_asset,
value:underlying_contract::string as underlying_contract
from jdata, lateral flatten (input => parse_json(jdata):vault_data)
Run a query to Download Data