REST Api

More will be added before the stable release of 1.0.0, but at the moment Devflow has a few GET api endpoints for consuming data. When you installed the system, an API key was automatically generated for you. You an find the key under the General settings in the backend.

Get All Rows

curl http://example.com/v1/user/?key=01JB37JJTRE0F8983T7B6QSECZ

SELECT * FROM {prefix}user;

Order By

curl http://example.com/v1/user/?by=user_id&order=desc&key=01JB37JJTRE0F8983T7B6QSECZ

SELECT * FROM {prefix}user ORDER BY user_id DESC;

Limit

curl http://example.com/v1/user/?limit=5&key=01JB37JJTRE0F8983T7B6QSECZ

SELECT * FROM {prefix}user LIMIT 5;

Get By Column/Field

curl http://example.com/v1/user/user_login/BxToVo/?key=01JB37JJTRE0F8983T7B6QSECZ

SELECT * FROM {prefix}user WHERE user_login = 'BxToVo';