Service REST API

URL : inforvation.systems

• Login
• Mongodb
  • get
  • insert/update
  • delete
  • query
• Server Time
• Blob Storage
• User Management
• Map Reduce
• MongoDB Architechture

Login

• URL

POST : https://inforvation.systems/login

• Headers

{"Content-Type":"application/json"},
{"user":"USERNAME"},
{"pass":"PASSWORD"}

• Response Header

{"authorization":"JWT {TOKEN}"}

• Response Body

{
  "status": true,
  "key": {KEY}
}

• Example

var obj = new Object();
obj.user = "USERNAME";
obj.pass = "PASSWORD";

$.ajax({
  type: "POST",
  url:  "https://inforvation.systems/login",
  data: JSON.stringify(obj),
  contentType: "application/json; charset=utf-8",
  dataType: "json",
  success: function (data,textStatus,request) {      
    if (data.key) {
      var TOKEN = request.getResponseHeader('authorization');
      //get token form header (authorization) for request service API
    }
    else {
      //do something when false
    }
  },
  failure: function (errMsg) {
    alert(errMsg);
  }
});

mongodb-rest

get

• URL

GET : https://inforvation.systems/mongodb/{DB_NAME}/{COLLECTION_NAME}/data/{KEY}

• Headers

{"Content-Type":"application/json"},
{"Authorization":"JWT token"}

• Response Body

[{
    "_id": "_id1",
    "column_name1": "value1",
    "column_name2": "value2",
    "column_name3": "value3"
},{
    "_id": "_id2",
    "column_name1": "value1",
    "column_name2": "value2",
    "column_name3": "value3"
}]

• Example

$.ajax({
  type: "GET",
  url:  "https://inforvation.systems/cores/role_db/data/bomb",
  contentType: "application/json; charset=utf-8",
  dataType: "json",
   success: function (data) {
    //do someting
  },
  failure: function (errMsg) {
    alert(errMsg);
  }
});

insert/update

• insert new URL

POST : https://inforvation.systems/mongodb/{DB_NAME}/{COLLECTION_NAME}/data/

• insert exits or update URL

POST : https://inforvation.systems/mongodb/{DB_NAME}/{COLLECTION_NAME}/data/{KEY}

• Headers

{"Content-Type":"application/json"},
{"Authorization":"JWT token"}

• Body (update some column)

{"$set":{"column_name1":"value1"}}

• Body (insert/update all)

{
  "_id": "{KEY}",
  "column_name1": "value1",
  "column_name2": "value2",
  "column_name3": "value3"
}

• Response Body

{
  "ok": true,
  "key": {KEY}
}

• Example

var obj = new Object();
obj._id = {KEY}, //<-- ***important when insert exits or update***
obj.column_name2 = "value1";
obj.column_name3 = "value2";
obj.column_name4 = "value3";

$.ajax({
  type: "POST",
  url:  "https://inforvation.systems/cores/role_db/data/bomb",
  data: JSON.stringify(obj),
  contentType: "application/json; charset=utf-8",
  dataType: "json",
  success: function (data,textStatus,request) {      
    if (data.key) {
      //do something
    }
    else {
      //do something
    }
  },
  failure: function (errMsg) {
    alert(errMsg);
  }
});

delete

• URL

DELETE : https://inforvation.systems/mongodb/{DB_NAME}/{COLLECTION_NAME}/data/{KEY}

• Headers

{"Content-Type":"application/json"},
{"Authorization":"JWT token"}

• Response Body

{
  "ok": true,
  "key": {KEY}
}

• Example

$.ajax({
  type: "DELETE",
  url:  "https://inforvation.systems/cores/role_db/data/bomb",
  contentType: "application/json; charset=utf-8",
  dataType: "json",
  success: function (data) {      
    if (data.key) {
      //do something
    }
    else {
      //do something
    }
  },
  failure: function (errMsg) {
    alert(errMsg);
  }
});

query

• URL

POST : https://inforvation.systems/mongodb/{DB_NAME}/{COLLECTION_NAME}/query

• Headers

{"Content-Type":"application/json"},
{"Authorization":"JWT token"}

• Body

{
"query":{
  "column_name1":{"$eq":"value1"},
  "column_name2":{"$eq":"value2"},
  "column_name3":"value3",
  "column_name4": "value4"
},
"projection":{
  "column_name1":1,
  "column_name2":1
},
"limit":1
}

• Response Body

[{
    "_id": "_id1",
    "column_name1": "value1",
    "column_name2": "value2",
    "column_name3": "value3"
},{
    "_id": "_id2",
    "column_name1": "value1",
    "column_name2": "value2",
    "column_name3": "value3"
}]

• Example

var data = {
    "query":{
      "_id": "bomb"
    },
    "projection":{
        "column_name1":1,
        "column_name2":1
    },
    "limit":1
}

$.ajax({
  type: "POST",
  url:  "https://inforvation.systems/cores/role_db/query",
  contentType: "application/json; charset=utf-8",
  dataType: "json",
  data: JSON.stringify(data),
  success: function (data,textStatus,request) {     
    //do something
  },
  failure: function (errMsg) {
    alert(errMsg);
  }
});

Server Time

get server time

• URL

GET : https://inforvation.systems/servertime

• Headers

{"Content-Type":"application/json"},
{"Authorization":"JWT token"}

• Response Body

1515696948941

• Example

$.ajax({
  type: "GET",
  url:  "https://inforvation.systems/servertime",
  contentType: "application/json; charset=utf-8",
  dataType: "json",
   success: function (data) {
    //do someting
  },
  failure: function (errMsg) {
    alert(errMsg);
  }
});

Blob Storage

get image

• URL

GET : https://inforvation.systems/download/{STORAGE_ACCOUNT}/{CONTAINER_NAME}/{FILE_NAME}

• Headers

{"Content-Type":"application/json"},
{"Authorization":"JWT token"}

• Response Body

• Example

$.ajax({
  type: "GET",
  url:  "https://inforvation.systems/servertime",
  contentType: "application/json; charset=utf-8",
  dataType: "json",
   success: function (data) {
    //do someting
  },
  failure: function (errMsg) {
    alert(errMsg);
  }
});

Systems Architechture

License

kphongph@gmail.com, theerawutt53@gmail.com Computer Engineering Naresuan University