KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home Forums kdb+ Web interface, JSON Re: Web interface, JSON

  • davidcrossey

    Member
    September 12, 2023 at 12:00 am

    A quick solution could be utilise something like wget to download the json data instead.

    Server

    $ q -p 5000 -q 
    q)show data:([]a:1+til 10;b:10?`4) 
    a b 
    ------- 
    1 milg 
    2 igfb 
    3 kaod 
    4 bafc 
    5 kfho 
    6 jecp 
    7 kfmo 
    8 lkkl 
    9 kfif 
    10 fglg q
    )`:html/test.json 0: enlist .j.j data

    Client

    $ wget http://localhost:5000/test.json 
    --2023-09-12 10:46:40-- 
    http://localhost:5000/test.json Resolving localhost (localhost)... 
    127.0.0.1 Connecting to localhost (localhost)|127.0.0.1|:5000... connected. 
    HTTP request sent, awaiting response... 200 OK 
    Length: 193 [application/json] 
    Saving to: test.json test.json 100%[====================================================>] 193 --.-KB/s in 0s 2023-09-12 10:46:40 (61.1 MB/s)- test.json saved [193/193] 
    $ q -q 
    q)first .j.k each read0 `:test.json 
    a b 
    --------- 
    1 "milg" 
    2 "igfb" 
    3 "kaod" 
    4 "bafc" 
    5 "kfho" 
    6 "jecp" 
    7 "kfmo" 
    8 "lkkl" 
    9 "kfif" 
    10 "fglg"