Update BO from smartphone Android

fjcortes

I have created a REST that sends product information to the smartphone, and I read it in android without any problem, now, how do I update the data in AwareIM?, can someone please help me?

Jaymer

It’s pretty easy, but the key is what your JSON structure is gonna look like to be passed in with a POST - or is it a smaller amount of data that will come in on the URL?

fjcortes

Hi Jaymer,
That's the problem I don't know how AwareIM receives it, if you could send me an example of how it receives it in a URL address, because since the phone has no fixed IP I don't know how to send it by that means

Thank you in advance for your help.

Jaymer

Well can you take a sec to describe the data structure that you need to submit.
Is it just three Fields. An array of 5 to 10 rows, etc.?
I’m trying to get a feel for what data you need to submit. Then we can think about the physical data structure.

fjcortes

Thank you for your quick response, the fields that I want to send to the server, would be 3 in the case of updating a "Products" object, and then an Array to send an object "Invoices" and another arrangement for the subject "InvoiceDetail".

Jaymer

OK, let’s just talk about the first one.
To send 3 fields, you would do the same as in the CRM example.
It basically sends one field. So build a string in a process & sending via the rest service. just send it URL encoded would be quite easy.
The same way any webpage gets values passed to it in the URL.
you make a string
ProductID=AA1122&QtyOH=23 etc
and it will get joined to the base URL.

And then you basically do exactly the same thing as in the CRM example.
There was a process that read the submitted value, and did a find.
You’re going to make a BO that has your 3 fields and your process will do a find to the product table, and assign your values.

Jaymer

OK, for an array.
Consider this JSON package:

{ "response": [
{"Qkey": "2000798-1"},
{"Qkey": "2000798-2","Qans1": "111"},
{"Qkey": "2000798-4","Qans1": "222"},
{"Qkey": "2000798-5","Qans1": "333","Qans2": "serial_number"},
{"Qkey": "2000798-6","Qans1": "444"},
{"Qkey": "2000798-7","Qans1": "555"},
{"Qkey": "2000798-8","Qans1": "666"}
] }

This needed the following Aware structure to receive it:
"header level"

"detail lines"

So this service doesn't send a reply.
Just stores the data from the JSON, and then a process posts it to the DB.
I didn't have any "header" data in the JSON, but thats where your Invoice Header fields would go.
I always use CodeBeautify.com to validate & test JSON.
Plus its easier to use PostMan to send JSON tests to Aware. You'll see a 200 response if all OK, or a 500.
Aware will crap out if you mistype a field name, so better to get it working in PostMan, THEN worry about the phone.

--> JaymerTip JSON Example, REST processing a JSON response

fjcortes

Thanks Jaymer I will do the tests with the BS CRM and I will be telling you

fjcortes

Well, ready step 1, update product inventory, works perfectly back and forth, thanks again Jaymer excellent publication.
Today I will be in charge of trying to send the father and child files.

fjcortes

Hi Jaymer, you are definitely a teacher, now, I have no idea how I should compose the URL with to send the information to AwareIM and how it would be the process to read the information provided. Sorry for such inconvenience.

Jaymer

Just so that I am clear, exactly what are you programming with on the phone?
What language or development environment?

Have you installed postman on your PC yet?
This is an in valuable tool for testing APIs.

What is the current URL you are using for inventory update?

fjcortes

ok, for the app development I am using windev mobile, which uses its language and accepts the inclusion of java language.
The cloud platform is AwareIM, in this platform I created the REST APIs to send the inventory, customers auxiliary tables from the cloud to the smartphone, the URL for sending the products, just create a BO with the attributes I need in the phone and a procedure that loads it before exposing them.
url: http: // localhost: 8080 / AwareIM / REST / pdv / products. and this produces this response

I have not installed the postman tool, windev has tools and commands that serialize and deserialize json and xml.

fjcortes

To send inventory information from the smartphone to the cloud use the instructions you sent me.

Jaymer

Ok
You asked 2 things.
How to send, and
How to process.

You send to a similar url
http: // localhost: 8080 / AwareIM / REST / pdv / send1. (For example)

But u need JSON in the body of the POST.
That’s why you use postman, because you can mock up the JSON and send without messing with Code/phone.
After you get something basic working, then you can worry about WinDev and trying it from the phone

Use my structure above in the JSON Example post.
Make your BOs and aware puts the data in them automatically when you POST to the service.
Then you can worry about a process.

fjcortes

I'm downloading postman, to try to understand this part, then I'll tell you how it goes.

fjcortes

Hi Jaymer,
Again, I tried to use postman, but I think I don't understand how this tool works or I lack knowledge in the subject.
On the other hand I created the structures and tried to send this information through this URL:
http: // localhost: 8080 / AwareIM / REST / pdv / sendme? PostedNY = 1 & response = {"response": [{"Qkey": "2000798-1"}, {"Qkey": "2000798-2", " Qans1 ":" 111 "}, {" Qkey ":" 2000798-4 "," Qans1 ":% 20" 222 "},% 20 {" Qkey ":" 2000798-5 "," Qans1 ":" 333 " , "Qans2": "serial_number"}, {"Qkey": "2000798-6", "Qans1": "444"}, {"Qkey": "2000798-7", "Qans1": "555"}, {"Qkey": "2000798-8", "Qans1": "666"}]} & theTime = "2019-10-08 12:00:00"

but it sends me an ERROR 400 when I put it in the browser, in postman it sends me a 500 error.
I think I will try to send the invoices one by one for a simple url.

Thank you for your invaluable help.

Jaymer

You can’t send it through the URL like that.

Read this
https://stackoverflow.com/questions/38971943/how-to-send-json-object-from-postman-to-restful-webservices

The question is not important, but the two replies show you how.
That should tell you how to get your JSON structure into postman.
Then you click post or send, and it will go to aware and you should get a response.
You should work back-and-forth like that until your JSON data is getting posted into the database.
After that, you can now go backwards to the phone part, or go forward to the aware processing part

fjcortes

Bingo!!
Following these instructions, it works on the structures, I created a procedure that receives the header structure as input and returns a BO with code 00 if it received data or code 01 if the structure is empty.
But .. I realized that the values of the attributes do not save them, I only create each of the records and the attributes leave them with a NULL value.
I did all this through postman

Jaymer

possibly related to your BOs - thats why up above I gave you pics of how the BOs needed to be to receive that JSON.

send me the exact JSON from Postman.
Send me pics of your header BO, and child BO (if you have it yet)

Its quite possible for Aware to receive the request, and apparently send you an OK response, but not write the data to the db if your BO structure is not perfect.
this is all the big "trick" to implementing REST. Aware implemented a "Discover" feature in 8.3, but it only works to an online service. So if you were calling a "real" service (ie. not just your custom phone app) THEN Aware could build the BOs to properly receive the JSON. But for now, a simple error in your BOs can make the data not get saved.

fjcortes

ok, since it is clear how the POST is done to AwareIM for uploading parent and child files. I had been delayed by the names of the attributes, because I did not take into account the capital letters, but once I made the corrections I charge and fill all the attributes correctly as seen in the image.

now thanks to postman, I can use the java code to load from the cell phone
thank you very much Jaymer, for so much patience and the knowledge provided