Document storage API

Document Storage API

RESTful API

Data is stored into a webdo.com user account CLOUD storage.
Storage location: Applications/<app folder>/<folder>/data/<data location/table>.

Can perform next operations:

                CREATE, READ, UPDATE, DELETE known as CRUD

It offers up to one GB of storage per table and allows very fast read access for virtually unlimited connections. Write operations minimum speed is 5/second.
Charges are per 10000 API requests, see your control panel billing information.

Requirements:

- register one application with WEBDO.COM

        - code
        - folder
        - additional info

-  user authorization ( check WEBDO.COM Open Authorization )

All operations requires an authorization header like:

Authorization: Bearer <token>

CREATE:

Headers:

Authorization: Bearer <token>

Method: POST

URL: https://q-ube.com:45567/dbs/

Data:

         { "appkey":<app key>,
           "basefolder":<application folder>,
           "folder":<folder name>,
           "table":<table name>,
           "data":[<records array>]
        }   

"records array" an JSON array of records to be inserted into the table.
Restricted fields: id (id field should be created and maintained by the API services)

"basefolder" can be "m" or "l", difference relates to where the data is stored on app key master drive or local on  authenticated user drive. It depends on your web application requirements to chose your data storage location.

Set an additional parameter to avoid returning the data back, useful for data set import when CREATE details are not required client side: data.dataimport = true

Response:

JSON object:

{
    msg:<message>,
    response:{
        allok:<true/false>,
        data:[ok data list],
        rejected:[rejected records],
        nores:[NO response list, file is in use - try again later !]
}

{   // sample one insert record ...
    "msg": "write data",
    "response":
    {
        "allok": true,
        "data":
        [
            {
                "start": "is working ...",
                "id": "aa5",
                "_xt": "2017-06-13T09:14:21.540Z",
                "_action": "create"
            }
        ],
        "rejected":
        [
        ],
        "nores":
        [
        ]
    }
}

UPDATE:

Same as CREATE, the difference is that each record in records array you need to update should have a defined <id> field and one additional field "_action" having value "update".
You CAN NOT update specific fields/information on one record, in order to update you should send the entire record.

DELETE:

Same as CREATE, the difference is that each record in records array you need to delete should have a defined <id> field and one additional field "_action" having value "delete".

CREATE, UPDATE, DELETE operations can be sent together into one <records array> respecting previous defined restrictions.

READ:

Headers:

Authorization: Bearer <token>

Method: POST

URL: https://q-ube.com:45567/getdbs/

Data:

         { "appkey":<app key>,
           "basefolder":<application folder>,
           "folder":<folder name>,
           "table":<table name>,
           "params":{<params object>}
        }  

params object:
- action: action

action is one of next ["query", "getlast", "getlastfrom", "getnew", "info"]

- simple (true/false ; used with action="info", use when information related table parts (shards) is not required; the response is faster (missing information relates to records number/shard).
- shards (used with action = "query", query only one shard - you may send a request for each shard being able to have a faster response using a parallel loading of requested data. (EX: use info to have a shards list, next query each shard for your data, for big data-sets will be 10 times faster).

SAMPLE:
params: {
        action:"getlast",
        last:100
}

will return last 100 records sorted descending by "id/creation date"

Response:

{

    request:{<request data>},
    records:[<records list>],
    errors:[<errors list>],
    total: <cont of records>,
    lastrecords: <last record id>

}

You may use the FireFox add-on RESTClient to test the services in place.