Share My Creation [B4J] MySQL API Server (Key + Token) and [B4X] User Login Apps

Updates:
For latest version of B4J Web API Server, working with cross platform B4X client apps and web front-end, please check Web API Template supporting MySQL and SQLite backend

1609578113098.png


Finally I would like to share my B4J API server written in B4J.
Compare to my previous PHP API, this API server implements user access token to authorize user to consume the API.

SQL.zip - SQL script to create necessary database and tables in MySQL server.
jAPI.zip - Source code for server app (B4J).
B4A.zip - Source code for client app using default template (B4A)
B4X.zip - Source code for client app using B4XPages template (B4A, B4i and B4J)

Live server: https://api.puterise.com:17179

12 Jan 2021: Attached B4J client sample. This is a beta version. Some bugs and features will be fixed in the future.
13 Jan 2021: Attached B4X client sample. This is a beta version. Some bugs and features will be fixed in the future. B4J.zip removed.
 

Attachments

  • SQL.zip
    705 bytes · Views: 1,348
  • jAPI.zip
    459.8 KB · Views: 1,446
  • B4A.zip
    51.2 KB · Views: 1,387
  • B4X.zip
    406.5 KB · Views: 1,341
Last edited:

pixet

Member
Licensed User
Longtime User
There are no errors reported,
the only message displayed "[{" result ": - 1," message ":" Error-Not-Activated "}]"
The table: "tbl_users_log" contains in the field log_type = "[Not Actived] email", the table "tbl_error" is empty.
If I try to log in, it replies that the user is not active.
How can I force user activation?
Thank you
 

aeric

Expert
Licensed User
Longtime User
There are no errors reported,
the only message displayed "[{" result ": - 1," message ":" Error-Not-Activated "}]"
The table: "tbl_users_log" contains in the field log_type = "[Not Actived] email", the table "tbl_error" is empty.
If I try to log in, it replies that the user is not active.
How can I force user activation?
Thank you
Activation email. You can also append the user activation code from user table to the URL.

For example:

API documentation:
 

aeric

Expert
Licensed User
Longtime User
I have just published a beta version. It is not fully tested but should works for sqlite db for Web API server backend. MySQL database is not yet tested.
The client has been tested for B4A and B4J. B4i is not tested.


 

aeric

Expert
Licensed User
Longtime User
I have just published a beta version. It is not fully tested but should works for sqlite db for Web API server backend. MySQL database is not yet tested.
The client has been tested for B4A and B4J. B4i is not tested.


The server template is now fully functional with MySQL and SQLite databases. All functions are tested with B4A and B4J. If you encounter issue in B4i, please let me know.
 
Top