11. get_tuple : テーブルデータの取得(行単位の取得)

GET /api/get_tuple

テーブルデータを取得(行単位の取得)する API.

リクエスト例

GET /api/get_tuple?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 -- 取得開始行

  • fetch_size -- 取得行数

  • setid -- セットID

レスポンス例

HTTP/1.1 200 OK
Content-Type: application/json; charset="utf-8"

{
  "resultList":[
    ["SeqNo","RecNo","銘柄コード","日付","始値","高値","安値","終値","売買高","信用売残","信用買残"],
    ["1","1","1,319","2000/01/04","324","324","320","322","62,000","121,000","82,000"],
    ["2","2","1,332","2000/01/04","158","165","157","157","296,000","183,000","4,485,000"],
    ["3","3","1,352","2000/01/04","115","115","115","115","1,000","(null)","271,000"],
  ],
  "resultMSG": "get_tuple SUCCESS ResultCode=5 ElapsedTime=0.001sec"
}
Response Data:

resultList -- 文字列に変換した行配列データ(先頭行はカラム名配列)