Get

Method

GET

URI

/api/metadata

Headers

Content-Type	application/json
Authorization   Bearer <short-access-token>

Body

{
    "filter": {
      "attributes": [
        {
            "column": "id",
            "alias": "metadataId"
        },
        "name",
        {
            "column": "tableName",
            "alias": "metaTableName"
        },
        "fields",
        "createdAt"
      ],
      "where": {
        "operator": "=",
        "args": ["id", 102]
      }
    },
    "context": {}
}

Result

{
  "count": 1,
  "rows": [
    {
        "metadataId": 102,
        "name": "Table 1",
        "metaTableName": "5df11e6e-c9e3-4e29-a499-0fdbce0bd101",
        "fields": [
          {
            "id": 1,
            "name": "id",
            "allowNull": false,
            "autoIncrement": true,
            "primaryKey": true,
            "type": "integer",
            "extend": {
              "isSystem": true,
              "caption": "ID",
              "order": 0
            }
          },
          {
            "id": 2,
            "name": "createdAt",
            "allowNull": false,
            "type": "datetime",
            "extend": {
              "isSystem": true,
              "caption": "Created At",
              "order": 1000
            }
          },
          {
            "id": 3,
            "name": "updatedAt",
            "allowNull": false,
            "type": "datetime",
            "extend": {
              "isSystem": true,
              "caption": "Updated At",
              "order": 1001
            }
          }
        ],
        "createdAt": "2020-04-03T10:23:09.031Z"
    }
  ]
}

Examples

var myHeaders = new Headers();
myHeaders.append("Authorization", "Bearer <short-access-token>");
myHeaders.append("Content-Type", "application/json");
myHeaders.append("X-HTTP-Method-Override", "GET");

var raw = JSON.stringify({
  "filter": {
    "attributes": [
      {
        "column": "id",
        "alias": "metadataId"
      },
      "name",
      {
        "column": "tableName",
        "alias": "metaTableName"
      },
      "fields",
      "createdAt"
    ],
    "where": {
      "operator": "=",
      "args": ["id", 131]
    }
  },
  "context": {}
});

var requestOptions = {
  method: 'POST',
  headers: myHeaders,
  body: raw,
  redirect: 'follow'
};

fetch("https://backend.spacemonopoly3d.com/api/metadata", requestOptions)
  .then(response => response.text())
  .then(result => console.log(result))
  .catch(error => console.log('error', error));
var request = require('request');
var options = {
  'method': 'POST',
  'url': 'https://backend.spacemonopoly3d.com/api/metadata',
  'headers': {
    'Authorization': 'Bearer <short-access-token>',
    'Content-Type': 'application/json',
    'X-HTTP-Method-Override': 'GET'
  },
  body: JSON.stringify({
    "filter": {
      "attributes": [
        {
          "column": "id",
          "alias": "metadataId"
        },
        "name",
        {
          "column": "tableName",
          "alias": "metaTableName"
        },
        "fields",
        "createdAt"
      ],
      "where": {
        "operator": "=",
        "args": ["id", 131]
      }
    },
    "context": {}
  })

};
request(options, function (error, response) { 
  if (error) throw new Error(error);
  console.log(response.body);
});

<?php
require_once 'HTTP/Request2.php';
$request = new HTTP_Request2();
$request->setUrl('https://backend.spacemonopoly3d.com/api/metadata');
$request->setMethod(HTTP_Request2::METHOD_POST);
$request->setConfig(array(
  'follow_redirects' => TRUE
));
$request->setHeader(array(
  'Authorization' => 'Bearer <short-access-token>',
  'Content-Type' => 'application/json',
  'X-HTTP-Method-Override' => 'GET'
));
$request->setBody(json_encode(array(
  "filter" => array(
    "attributes" => [
      array(
        "column" => "id",
        "alias" => "metadataId"
      ),
      "name",
      array(
        "column" => "tableName",
        "alias" => "metaTableName"
      ),
      "fields",
      "createdAt"
    ],
    "where" => array(
      "operator" => "=",
      "args" => ["id", 131]
    )
  ),
  "context" => array()
)));
try {
  $response = $request->send();
  if ($response->getStatus() == 200) {
    echo $response->getBody();
  }
  else {
    echo 'Unexpected HTTP status: ' . $response->getStatus() . ' ' .
    $response->getReasonPhrase();
  }
}
catch(HTTP_Request2_Exception $e) {
  echo 'Error: ' . $e->getMessage();
}