Having dealt with a lot of JSONs in AVOS I have following experience:
- AVOS is very poor when it comes to JSON handling.
- You need to convert the JSON to XML to work with these JSONs. You can use pre-built AVOS functions or can write your own Java interface in AVOS to do that.
- Pre-built AVOS function to convert JSON to XML and XML to JSON has few known issues. So if you have few simple operations then go with pre-built function else write your own Java interface.
- abx:jsonToXml($myJson) is function to convert JSON to XML (where $myJson is your payload).
- abx:xmlToJson($myXml) is function to convert XML to JSON (where $myXml is you XML you want to convert to JSON)
The ActiveVOS distribution of Process Server makes it possible to interwork with JSON but hasn't been evolved to handle integration use cases.
The Cloud Application Service's Process Server has been evolved and specifically designed to handle application integration, eventing and data APIs use cases. You'll find that working with JSON and XML is simple. Have a look at the overviews here: Cloud Application Integration.