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配列データ(先頭行はカラム名配列)