What’s the trick to build a JSON string

Jaymer

Now that the new build is out, and the REST process will properly send a JSON string, is there a particular strategy or technique that makes building this potentially long string easy?

Rennur

One option would be to use a query widget type or settings to generate results in JSON, or use a FIND function (query) with a CONVERT_TO_JSON function. Then store the string parameter.

The other, Aware IM to convert XML to JSON then save it in an attribute?

Converting Java objects to JSON with Jackson

XML to JSON Converter

BenHayat

Jaymer wrote
Now that the new build is out, and the REST process will properly send a JSON string, is there a particular strategy or technique that makes building this potentially long string easy?

Generally speaking, JSON construction is part of the framework, i.e. AwareIM. In other systems you simply tell the system how your input/output format should be, like XML or JSON and the system does it.

tford

Now that the new build is out

Jaymer -- are you referring to build 2465?

Jaymer

yes, 2465 fixed this 1 issue with JSON strings

Jaymer

Well, since I'm using MS SQL SERVER, I can take advantage of "FOR JSON" on a SELECT statement and it makes pretty JSON for me.
Couldn't be happier.

jaymer...

UnionSystems

A trick we have used in AwareIM to get data into a JSON string is

Publish an AwareIM REST Service that outputs as JSON
Call that Service using the AwareIM’s URL_CONTENTS function to call the local REST request

Object.JSON_String = URL_CCONTENTS(‘http://localhost:8080/REST SERVICE ADDRESS’)

Rennur

Kendo UI offers JSON through spreadsheets. I think Aware has the spreadsheet feature.

Store Data as JSON
The Spreadsheet allows you to store and load data in a native JSON format.
https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/import-and-export-data/json

Could this be of any use, if so, how?

From the How-to guide (p41):
How to work with embedded spreadsheets

To use embedded spreadsheets in Aware IM you need to do the following:

Define an attribute of the Document type in some object

Support, if the spreadsheet stores the data in JSON format, could this document attribute be used as a parameter string in context?

aware_support

Here is one idea how you can get JSON representation of Aware IM records using the current Aware IM version. This is an idea only, we haven't tested if it works.

1) Define an Aware IM service that is implemented using REST
2) Define the reply of this service to return the object(s) you want converted into JSON
3) Define JSON as the format of the reply. Define name mapping and other JSON conversion parameters as required
4) The process that implements the service should find the instance(s) that you want to convert to JSON and put them in Context
5) Call the service using the URL_CONTENTS function where the URL specified in this function is the URL of the service exposed above
6) The URL_CONTENTS function should return JSON representation of the record(s)

If this doesn't work let us know why and we may fix the problems, so that this approach can be used for JSON conversion

Jaymer

Is anyone going to try Vlad's suggestion?
Since I got my JSON output figured out, I don't have time right now-I'm busy working on other REST issues.
If someone DOES decide to tackle this, please leave a msg here so we don't duplicate effort.

BobK

Isn't Vlad's suggestion the same as UnionSystems a few post up except with a some more details.

aware_support

Yes, it's the same. Sorry, UnionSystems, didn't see your post (but great minds think alike 🙂 )

Rennur

Cannot get steps 5 & 6 to work.

com.bas.shared.ruleparser.ParseException Unable to retrieve contents of the URL due to exception java.io.IOException Server returned HTTP response code: 500 for URL: http://localhost:8081/AwareIM/REST/CR/SI_REST_Service

Jaymer

I'm getting Rest 500's now also, per this thread.
https://forum.awareim.com/d/10473>

aware_support

Check out the output of Tomcat and the Aware IM Server for clues.

Rennur

Tomcat Log:

REST Servlet (GET) called
Connecting to server localhost at port 9002
Successfully created a connection to the server
Setting session timeout to 30000 seconds.

This process is on repeat until CPU usage reaches 100% and I have to manually kill server processes.

The Service is reachable via the Aware IM Rest URL, but it does not like the GET verb.
The same Tomcat log message appears when using POST & HEAD verbs, also consumes memory and CPU.

The OPTIONS verb returns a successful code 200 response instantly.

Here is the result of this using OPTIONS:

TIMELINE:

Preparing request to http://192.168.0.17:8081/AwareIM/REST/CR/SI_REST_Service
Using libcurl/7.51.0-DEV OpenSSL/1.0.2j zlib/1.2.8 libssh2/1.6.1_DEV
Enable automatic URL encoding
Enable SSL validation
Enable cookie sending with jar of 10 cookies
Connection 8 seems to be dead!
Closing connection 8
Trying 192.168.0.17...
TCP_NODELAY set
Connected to 192.168.0.17 (192.168.0.17) port 8081 (#9)

OPTIONS /AwareIM/REST/CR/SI_REST_Service HTTP/1.1
Host: 192.168.0.17:8081
User-Agent: insomnia/5.16.6
Accept: /

< HTTP/1.1 200
< Allow: GET, HEAD, POST, OPTIONS
< Content-Length: 0
< Date: Thu, 12 Jul 2018 05:16:01 GMT

Curl_http_done: called premature == 0
Connection #9 to host 192.168.0.17 left intact

=== end timeline ===

I have set up the process to initiate the service within Aware IM, but it's the same behaviour as above, for GET, POST and HEAD verbs.

aware_support

You are doing something wrong in the process that handles the service. OPTIONS verb is not handled by Aware IM.

GET and POST do work. The Tomcat printout indicates that everything is OK. What is not OK is that this print out is repeated. This means that you are doing something wrong.

By the way the business space that exposes the service must not be in the testing mode - it should be published.

Rennur

What should the process look like?

FIND Objects specified in Service Reply
FIND BO storing the JSON string
BO.JSON=URL_CONTENTS('REST URL ADDRESS')

Rennur

A trick we have used in AwareIM to get data into a JSON string is

Publish an AwareIM REST Service that outputs as JSON

Call that Service using the AwareIM’s URL_CONTENTS function to call the local REST request

CODE: SELECT ALL
Object.JSON_String = URL_CCONTENTS(‘http://localhost:8080/REST SERVICE ADDRESS’)

I've sent a BSV to support for testing. I'm probably doing something wrong.

Rennur

Confusion on my part. URL_CONTENTS sorted.