FileMaker Data API を実行 のリクエストのメモ

2022年03月19日 土曜日 09時00分

FileMaker Data API を実行 のリクエストのメモ。

リクエスト

Let ( [

~query0 = 
JSONSetElement ( "" ;
  [ GetFieldName ( テーブル::Region ) ; "Europe" ; JSONString ] ;
  [ GetFieldName ( テーブル::Sales Channel ) ; "Online" ; JSONString ]
) ;

~sort0 =
JSONSetElement ( "" ;
  [ "fieldName" ; GetFieldName ( テーブル::Region ) ; JSONString ] ;
  [ "sortOrder" ; "ascend" ; JSONString ]
) ;

~request =
JSONSetElement ( "" ;
  [ "action" ; "read" ; JSONString ] ;
  [ "version" ; "v2" ; JSONString ] ;
  [ "layouts" ; "レイアウト 1" ; JSONString ] ;
  [ "query.[0]" ; ~query0 ; JSONObject ] ;
  [ "sort.[0]" ; ~sort0 ; JSONObject ] ;
  [ "offset" ; 1 ; JSONNumber ] ;
  [ "limit" ; 3 ; JSONNumber ]
)

] ;

~request

) /*let*/

レスポンス

{
  "response": {
    "dataInfo": {
      "database": "5m Sales Records",
      "layout": "レイアウト 1",
      "table": "テーブル",
      "totalRecordCount": 5000000,
      "foundCount": 648225,
      "returnedCount": 3
    },
    "data": [
      {
        "fieldData": {
          "Region": "Europe",
          "Country": "Poland",
          "Item Type": "Beverages",
          "Sales Channel": "Online",
          "Order Priority": "L",
          "Order Date": "4/18/2010",
          "Order ID": "380507028",
          "Ship Date": "5/26/2010",
          "Units Sold": "9340",
          "Unit Price": "47.45",
          "Unit Cost": "31.79",
          "Total Revenue": "443183.00",
          "Total Cost": "296918.60",
          "Total Profit": "146264.40"
        },
        "portalData": {},
        "recordId": "2",
        "modId": "0"
      },
      {
        "fieldData": {
          "Region": "Europe",
          "Country": "Belarus",
          "Item Type": "Snacks",
          "Sales Channel": "Online",
          "Order Priority": "C",
          "Order Date": "1/19/2014",
          "Order ID": "954955518",
          "Ship Date": "2/27/2014",
          "Units Sold": "1414",
          "Unit Price": "152.58",
          "Unit Cost": "97.44",
          "Total Revenue": "215748.12",
          "Total Cost": "137780.16",
          "Total Profit": "77967.96"
        },
        "portalData": {},
        "recordId": "4",
        "modId": "0"
      },
      {
        "fieldData": {
          "Region": "Europe",
          "Country": "Montenegro",
          "Item Type": "Personal Care",
          "Sales Channel": "Online",
          "Order Priority": "H",
          "Order Date": "11/24/2012",
          "Order ID": "598814380",
          "Ship Date": "12/25/2012",
          "Units Sold": "1337",
          "Unit Price": "81.73",
          "Unit Cost": "56.67",
          "Total Revenue": "109273.01",
          "Total Cost": "75767.79",
          "Total Profit": "33505.22"
        },
        "portalData": {},
        "recordId": "7",
        "modId": "0"
      }
    ]
  },
  "messages": [
    {
      "code": "0",
      "message": "OK"
    }
  ]
}