B4J Question JRDC2 return Json

[elitevenkat]

hi, I want to get the resultset as a json response. is it possible?

 

[josejad]

Type DBResult (Tag As Object, Columns As Map, Rows As List)

You get a DBResult, You can create a map with the column name and the values, and then create a json with jsonGenerator

 

[aeric]

Sub ReturnJSON(map As Map, resp As ServletResponse)
    resp.ContentType = "application/json"
    resp.Write(Map2Json(map))
End Sub

[B4X] User Login App + [B4J] MySQL API Server (Key + Token)

Update: I recommend you to also take a look at my latest Web API Template if you want to develop B4X client apps connecting to MySQL/SQLite backend web server using JSON format API. Finally I would like to share my B4J API server written in B4J. Compare to my previous PHP API, this API server...

www.b4x.com

 

[elitevenkat]

Thanks @aeric

 

[aeric]

Here is another sample:

JQuiz - API Server for B4XQuiz

This is the full source code for B4XQuiz server. SQL script to generate database in post #2 For B4XQuiz client app, please check: https://www.b4x.com/android/forum/threads/b4jquiz-desktop-app.124202/ Update It is now easier to create Web API Server using B4X Template Check...

www.b4x.com