Ïîëó÷åíèå çàïèñåé èç òàáëèöû

Çàïðîñ

Àäðåñ:

POST {site}/api/data/read/

Ïàðàìåòðû çàïðîñà:

• access_id (string) - Èäåíòèôèêàòîð òåêóùåé ñåññèè
• table_id (integer) - ID òàáëèöû
• cals (boolean) - Âêëþ÷èòü èëè âûêëþ÷èòü âû÷èñëåíèÿ è ëîãèðîâàíèå
• fields (data.fields) - Àññîöèàòèâíûé ìàññèâ ïîëåé
• filter (data.filter) - Àññîöèàòèâíûé ìàññèâ, êëþ÷-ïàðàìåòðû ôèëüòðà
• sort (data.sort) - Àññîöèàòèâíûé ìàññèâ, êëþ÷-ïàðàìåòðû ñîðòèðîâêè
• start (integer) - Íîìåð ïåðâîé âîçâðàùàåìîé ñòðîêè
• limit (integer) - Êîëè÷åñòâî âîçâðàùàåìûõ ñòðîê

Ïðèìåð çàïðîñà:

{
  "access_id": "4f605564be855258b65a05d120de5241",
  "table_id": 74,
  "cals": true,
  "fields": {
    "row": []
  },
  "filter": {
    "row": {
      "status": {
        "term": "=",
        "value": 0,
        "union": "AND"
      },
      "add_time": {
        "term": "between",
        "value": "2021-02-01 09:00:00",
        "value2": "2021-03-15 23:00:00",
        "union": "AND"
      },
      "f807": {
        "term": "=",
        "value": 172,
        "union": "AND"
      }
    }
  },
  "sort": {
    "row": {
      "id": "DESC",
      "status": "ASC"
    }
  },
  "start": 0,
  "limit": 10
}

èëè

{
  "access_id": "4f605564be855258b65a05d120de5241",
  "table_id": 74,
  "cals": true,
  "fields": {
    "line": []
  },
  "filter": {
    "line": {
      "Ñòàòóñ çàïèñè": {
        "term": "=",
        "value": 0,
        "union": "AND"
      },
      "Âðåìÿ äîáàâëåíèÿ": {
        "term": "between",
        "value": "2021-02-01 09:00:00",
        "value2": "2021-03-15 23:00:00",
        "union": "AND"
      },
      "Ñ÷åò": {
        "term": "=",
        "value": 172,
        "union": "AND"
      }
    }
  },
  "sort": {
    "line": {
      "ID": "DESC",
      "Ñòàòóñ çàïèñè": "ASC"
    }
  },
  "start": 0,
  "limit": 10
}

Îòâåò

Ïàðàìåòðû îòâåòà:

• count_all (integer) - Îáùèå êîëè÷åñòâî ñòðîê, ñîîòâåòñòâóþùåå äàííîìó ôèëüòðó
• count (integer) - Êîëè÷åñòâî ïåðåäàííûõ ñòðîê
• data (data.row) - Ñòðîêè â òàáëèöå ñ ïîëÿìè è çíà÷åíèÿìè â àññîöèàòèâíîì ìàññèâå êëþ÷-ïàðàìåòð
• code (integer) - Êîä âîçâðàòà
• message (string) - Ðàñøèôðîâêà êîäà âîçðàòà

Ïðèìåð îòâåòà:

{
  "count_all": "6",
  "count": 6,
  "data": {
    "5757": {
      "row": {
        "id": "5757",
        "user_id": "1",
        "add_time": "2016-10-25 16:13:28",
        "status": "0",
        "f807": "172",
        "f809": "0",
        "f810": "18.00",
        "f811": "1",
        "f812": "18.00",
        "f1440": "",
        "f2021": "0.00",
        "f2041": "0.00",
        "f2051": "18.00",
        "f2331": "0",
        "f4181": "0",
        "f4191": "2016-07-22 00:00:00",
        "f4201": "21049.50",
        "f4211": "3.42"
      },
      "line": {
        "ID": "5757",
        "Êòî äîáàâèë": "1",
        "Âðåìÿ äîáàâëåíèÿ": "2016-10-25 16:13:28",
        "Ñòàòóñ çàïèñè": "0",
        "Ñ÷åò": "172",
        "Åä. èçì": "0",
        "Öåíà": "18.00",
        "Êîë-âî": "1",
        "Ñóììà": "18.00",
        "Îïèñàíèå": "",
        "Ñêèäêà": "0.00",
        "Ñóììà ñêèäêè": "0.00",
        "Èòîãî": "18.00",
        "Ïðàéñ-ëèñò": "0",
        "Êàòåãîðèÿ": "0",
        "Äàòà ñ÷åòà": "2016-07-22 00:00:00",
        "Îñòàòîê ê îïëàòå ñ÷åòà": "21049.50",
        "Îïëà÷åíî": "3.42"
      }
    }
    // , .....
  },
  "code": 0,
  "message": "Done"
}