MONEO apakštabulu datu pieprasījums ar API

 

Lai ielasītu MONEO apakštabulu datus, izmantojot API, rīkojies sekojoši:

 

{
    "filter": {
        "sernr": "!200001"
    },
    "row_count": "5",
    "fieldlist": ["sernr", "orddate", "comment", "items.itemcode"],
    "request":{
        "compuid":"53F98A26-041ECDF6-4CF71DCD-0474B2B3-B7C42FD6",
        "sessionid":"07287ea7-f0a574c6-13f34bf1-cf0bea2e-3bc87e0b"
    }
}

fieldlist sarakstā norāda apakštabulas laukus. (sintakse ir: tabulas_kods.lauka_kods, piemērā, apkaštabulas kods ir items  un lauka kods ir itemcode)

 

row_count norādītā vērtība atlasīts atbilstošu skaitu rindu no datiem, vērtība nav obligāti jānorāda.

 

Atbildē tiks saņemti apakštabulas lauku dati:

{
  "result": {
    "records": [
      {
        "sernr": 210001,
        "orddate": "2021-01-31",
        "comment": "",
        "sub_table": {
          "items": [
            {
              "itemcode": "I041-00013",
              "_sernr": 210001,
              "_rownr": 0
            },
            {
              "itemcode": "I041-00014",
              "_sernr": 210001,
              "_rownr": 1
            }
          ]
        }
      },
      {
        "sernr": 210002,
        "orddate": "2021-02-01",
        "comment": "",
        "sub_table": {
          "items": [
            {
              "itemcode": "I043-00003",
              "_sernr": 210002,
              "_rownr": 0
            },
            {
              "itemcode": "I041-00010",
              "_sernr": 210002,
              "_rownr": 1
            },
            {
              "itemcode": "I041-00008",
              "_sernr": 210002,
              "_rownr": 2
            }
          ]
        }
      },
      {
        "sernr": 210003,
        "orddate": "2021-02-01",
        "comment": "",
        "sub_table": {
          "items": []
        }
      },
      {
        "sernr": 210004,
        "orddate": "2021-02-01",
        "comment": "",
        "sub_table": {
          "items": []
        }
      },
      {
        "sernr": 210005,
        "orddate": "2021-02-01",
        "comment": "",
        "sub_table": {
          "items": []
        }
      },
      {
        "sernr": 210006,
        "orddate": "2021-02-01",
        "comment": "",
        "sub_table": {
          "items": []
        }
      },
      {
        "sernr": 210007,
        "orddate": "2021-02-01",
        "comment": "",
        "sub_table": {
          "items": []
        }
      }
    ]
  }
}