12. get_tuple_asjson : テーブルデータの取得(JSON形式で取得)¶
- GET /api/get_tuple_asjson¶
テーブルデータの取得(JSON形式で取得)する API.
リクエスト例
GET /api/get_tuple_asjson?table_name=kabuTori&start_row=1&fetch_size=3&setid=1 HTTP/1.1 Content-Type: application/json; charset= "UTF-8" Authorization: (Loginトークン)
- Query Parameters:
table_name -- テーブル名
start_row -- 取得開始行(省略でデフォルト値,1)
fetch_size -- 取得行数(省略でデフォルト値,128)
setid -- セットID(省略した場合はカレントセット)
レスポンス例
HTTP/1.1 200 OK Content-Type: application/json; charset="utf-8" { "resultList":[ ["SeqNo": "1","RecNo": "1","銘柄コード": "1,319","日付": "2000/01/04","始値": "324","高値": "324","安値": "320","終値": "322","売買高": "62,000","信用売残": "121,000","信用買残": "82,000"], ["SeqNo": "2","RecNo": "2","銘柄コード": "1,332","日付": "2000/01/04","始値": "158","高値": "165","安値": "157","終値": "157","売買高": "296,000","信用売残": "183,000","信用買残": "4,485,000"], ["SeqNo": "3","RecNo": "3","銘柄コード": "1,352","日付": "2000/01/04","始値": "115","高値": "115","安値": "115","終値": "115","売買高": "1,000","信用売残": "(null)","信用買残": "271,000"], ], "resultMSG": "get_tuple_asjson SUCCESS ResultCode=5 ElapsedTime=0.001sec" }
- Response Data:
resultList -- 文字列に変換したJSON配列データ(先頭行はカラム名配列)