Android Question Restful API service

khwarizmi · Jan 22, 2020

Hi all

How to use http post request to implement Restful API service?

DonManfred · Jan 22, 2020

Forum Search for HTTP POST

khwarizmi · Jan 22, 2020

thanks.

I tried to make a post job, but was not succeeded:

B4X:

Dim JSONList As List
JSONList.Initialize
Dim ZeileMap As Map
ZeileMap.Initialize
ZeileMap.put("first_name": "Ali")
ZeileMap.put("last_name": "Adil")
ZeileMap.put("country_code": "974")
ZeileMap.put("mobile": "5514215437")
ZeileMap.put("email": "katt33ah@gmail.com")
ZeileMap.put("created_user_id": 1)
ZeileMap.put("created_time": "2019-04-07T17:41:37.000")
ZeileMap.put("updated_user_id": Null)
ZeileMap.put("updated_time": Null)
ZeileMap.put("pw": "ggg")
ZeileMap.put("is_active": "Y")
JSONList.Add(ZeileMap)
  Dim JSONGenerator As JSONGenerator
   JSONGenerator.Initialize2(JSONList)
   Dim str As String=JSONGenerator.ToString
 Dim j As HttpJob
    j.Initialize("ghg",Me)
 j.PostString("http://192.168.1.12:3000/customers", Array As String("MyJSON", str))

and this is the JobDone:

B4X:

Sub JobDone(Job As HttpJob)
    If Job.Success Then
        Select Job.JobName
            Case "ghg"
                Dim res As String
                res = Job.GetString
                Log(res)
        End Select
    End If
End Sub

The response is : {"message":"ER_BAD_NULL_ERROR: Column 'first_name' cannot be null"} ,

DonManfred · Jan 22, 2020

try add a

j.GetRequest.SetContentType("application/json")

AFTER the j.poststring

khwarizmi · Jan 22, 2020

this is the response:

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Error</title>
</head>
<body>
<pre>SyntaxError: Unexpected token L in JSON at position 1    at JSON.parse (<anonymous&gt

at parse (C:\Users\Abuelhaytham\30\node_modules\body-parser\lib\types\json.js:89:19)    at C:\Users\Abuelhaytham\30\node_modules\body-parser\lib\read.js:121:18    at invokeCallback (C:\Users\Abuelhaytham\30\node_modules\raw-body\index.js:224:16)    at done (C:\Users\Abuelhaytham\30\node_modules\raw-body\index.js:213:7)    at IncomingMessage.onEnd (C:\Users\Abuelhaytham\30\node_modules\raw-body\index.js:273:7)    at IncomingMessage.emit (events.js:182:13)    at endReadableNT (_stream_readable.js:1091:14)    at process._tickCallback (internal/process/next_tick.js:174:19)</pre>
</body>
</html>

rraswisak · Jan 22, 2020

kattah said:
ZeileMap.put("first_name": "Ali")

use comma instead of colon, change this line to:

B4X:

ZeileMap.put("first_name", "Ali")

doing the same for others

khwarizmi · Jan 22, 2020

thanks, I changed it to the right form, but also I get an error Although it reads the JSON array correctly:

[{"first_name":"Ali","last_name":"Adil","country_code":"974","mobile":"5514215437","email":"katt33ah@gmail.com","created_user_id":1,"created_time":"2019-04-07T17:41:37.000","updated_user_id":null,"updated_time":null,"pw":"ggg","is_active":"Y"}]

the response is:
{"message":"ER_BAD_NULL_ERROR: Column 'first_name' cannot be null"}

Jorge M A · Jan 22, 2020

kattah said:
{"message":"ER_BAD_NULL_ERROR: Column 'first_name' cannot be null"}

This is a message related to your REST API. Nothing related to B4A.
Check your API documentation.

Related Video Tutorial here: https://www.b4x.com/etp.html?vimeography_gallery=1&vimeography_video=256583317

Jorge M A · Jan 22, 2020

Why you are sending as Array?

kattah said:

Just try with:

B4X:

j.PostString("http://192.168.1.12:3000/customers", str)

khwarizmi · Jan 23, 2020

Jorge M A said:
This is a message related to your REST API. Nothing related to B4A.
Check your API documentation.

I tested the same URL with the Postman and was succeeded.

Jorge M A said:
j.PostString("http://192.168.1.12:3000/customers", str)

Unfortunately, it did not work.

Erel · Jan 23, 2020

Maybe you need to set the content type.

kattah said:
tested the same URL with the Postman and was succeeded

You should post the exact way you did it with postman.

khwarizmi · Jan 23, 2020

I used Node.js to write the initial rest api mysql database code. and then tested it with the Postman. this is the resut in the Postman:

rraswisak · Jan 23, 2020

i see your code in post #3 - you throw updated_user_id and updated_time with Null value as parameter while you don't in postman above, maybe you can try to replace Null value with data you use in the postman, is it make changes ?

khwarizmi · Jan 23, 2020

rraswisak said:
i see your code in post #3 - you throw updated_user_id and updated_time with Null value as parameter while you don't in postman above, maybe you can try to replace Null value with data you use in the postman, is it make changes ?

thanks, In fact, in my last attempts I tried to give values to all fields.

aeric · Jan 23, 2020

In Postman, you submit json surrounded with curly brackets { } but you submit json using poststring with square brackets [ ].

khwarizmi · Jan 23, 2020

The JSON array formula in Postman begins with { and ends with } as in the picture.
I tried to modify the string and remove [ and ] but was not succeeded.
all my problem is to post the JSON array in the data, because I always get the error:

{"message":"ER_BAD_NULL_ERROR: Column 'first_name' cannot be null"}

Which indicates that the JSON array was not read .

aeric · Jan 23, 2020

kattah said:
The JSON array formula in Postman begins with { and ends with } as in the picture.
I tried to modify the string and remove [ and ] but was not succeeded.
all my problem is to post the JSON array in the data, because I always get the error:

{"message":"ER_BAD_NULL_ERROR: Column 'first_name' cannot be null"}

Which indicates that the JSON array was not read .

Not sure how you remove the [ and ]. Instead of parsing as List, you have to parse json from Map.

B4X:

    Dim ZeileMap As Map
    ZeileMap.Initialize
    ZeileMap.put("first_name", "Ali")
    ZeileMap.put("last_name", "Adil")
    ZeileMap.put("country_code", "974")
    ZeileMap.put("mobile", "5514215437")
    ZeileMap.put("email", "katt33ah@gmail.com")
    ZeileMap.put("created_user_id", 1)
    ZeileMap.put("created_time", "2019-04-07T17:41:37.000")
    ZeileMap.put("updated_user_id", Null)
    ZeileMap.put("updated_time", Null)
    ZeileMap.put("pw", "ggg")
    ZeileMap.put("is_active", "Y")
    Dim JSONGenerator As JSONGenerator
    JSONGenerator.Initialize(ZeileMap)
    Dim str As String = JSONGenerator.ToString
    Dim j As HttpJob
    j.Initialize("ghg",Me)
    'Log(str)
    j.PostString("http://192.168.1.12:3000/customers", str)

khwarizmi · Jan 23, 2020

I modified the code as you mentioned, and tried to add:

B4X:

str=str.Replace("[","")
    str=str.Replace("]","")

but the problem remained the same.

aeric · Jan 23, 2020

kattah said:
I modified the code as you mentioned, and tried to add:

B4X:

str=str.Replace("[","") str=str.Replace("]","")

but the problem remained the same.

My code will generate json string without [ and ] so you do not need to modify my code. Try use my code and see how is it going.

khwarizmi · Jan 23, 2020

I used your code as it was at the beginning, then tried to make the modification.

Android Question Restful API service

Active Member

Expert

Active Member

Expert

Active Member

Active Member

Active Member

Well-Known Member

Well-Known Member

Active Member

B4X founder

Active Member

Attachments

Active Member

Active Member

Expert

Active Member

Expert

Active Member

Expert

Active Member

Similar Threads