Solved REST Webservice : using Json in post/get methods

Hi,

I'm trying to create two Rest webservice methods, one "post" method using json in input, one "get" method getting a json in output.
I did follow the webservice tutorial with XML in output and it works perfectly but I couldn't do the same with Json.

I have a very simple json format :(attachment : json_metadata.PNG)

1. post Method : load the json entry into a temporary table (attachment : json_post.PNG)
-> Nothing happened -> Error message in XML
2. get Method: get data from the temporary table and retun them in json format (attachment : json_get.PNG)
-> I get the following error :
javax.xml.ws.WebServiceException: java.lang.RuntimeException: [was class com.ctc.wstx.exc.WstxUnexpectedCharException] Unexpected character '{' (code 123) in prolog; expected '<'

Am I missing something?

Hi,

For Stambia JSON Web Services you have to use the http endpoint version 2.
For this you just have to use a different url to execute the deliveries:
http://<hostname>:42200/rest/StambiaDeliveryService/2/<deliveryName>

This new endpoint is available for Runtime version S17.2.15 or higher

Do you have the correct behavior when using this url ?

Hi,

Is there a documentation on the different endpoints?

When I'm using the endpoint 2, here's what I got :
1. Post Method :
I'm using Postman (chrome extension to test webservices).
To the URL : http://servbdd3:42200/rest/StambiaDeliveryService/2/postPersonneInfos, I join the JSON file :
But it only inserts NULL value in all columns of my target table...

2. Get method : I don't have errors anymore, but a blank page instead..

Hi,

Unfortunately there is no documentation yet for the different endpoint.

1. For the post method how do you join the JSON file ? You have to put it in the body of the POST request

2. Did you checked if the file loaded by your mapping exists and is not empty after the execution ?
Moreover, make sure it is the same file that you defined as output of your webservice
E.g. If you changed the 'Output File Name' of the Template in your Mapping, the json file will not be stored at the same place at where it is defined on the Metadata.
So the file will not be found for sending the output response.

1. Post method :
Yes I put the json file in the body (please see the attachment).

2. Get method :
I'm not sure if the JSON metadata is well set, could you please have a look in the json_metadata.PNG?
When I execute the URL : http://servbdd3:42200/rest/StambiaDeliveryService/2/getPersonneInfos?id=1
The ws is called but nothing happened : I still have the blank page and json is not modified.. still in the same folder as it's configured in the metadata.

Hi,

Can you please send a request to the support team ?
We'll treat this in a ticket and update this topic when we have the solution.

Thanks

Hi,

After investigating through the support, we found the following solutions:

POST method:
The JSON object that was sent in the body did not have the same structure has the JSON Metadata set as input.
This was the reason why null values where inserted.

GET method
The web service returned a blank page because the Mapping used to create the JSON Response file was not set correctly.
The repetition keys were not mapped so no file was generated.
As a consequence the response was empty.

As a complement, we remind that for calling Stambia JSON Web Services, the endpoint version 2 or higher is required.
If you are waiting for JSON data and getting an XML response, make sure you are using the correct URL.

Thanks!
I understand better how to implement Webservices through Stambia, however I'm not sure to get well how endpoint works.

I did the same POST method as I did with Json but this time using XML in input.
It's only working when I use the endpoint 2.. So I'm a bit confused.

The Runtime provides several endpoints. They are listed in the Runtime's startup log sequence:
Each Endpoint provides its own way to expose deliveries (Soap, Rest, Xml, Json...).
Working with Json responses requires "HTTP Rest Endpoint v2" (the one with "/2/" in the URL).
I hope it clarifies a little - we will prepare more doc / articles on this subject.

Hello ,

What are The repetition keys ?