store JSON result into a Json Array

[con...@ecotronicbr.com]

Hello,

I'm using a CAPI that returns json object and I'ma trying to store this ins a json array. I'm using P_to_array(json_object, key) function.

The description of P_status is:

2014-10-15T04:49:24+0000 - Task "Busca dados SIGE" (id: 1[0] - status: ABORTED): Error while processing {P_to_array(P_result.value,"RG")}
java.lang.ClassCastException: org.runmyprocess.json.JSONArray cannot be cast to org.runmyprocess.json.JSONObject

Can help me?

[Murali]

Hi,

As per the exception message what i understood was, the input P_result.value is JSONArray and the function P_to_array is expecting the JSONObject.

I believe you must use P_result instead P_result.value, because the CAPI return the JSONObject as per that you mentioned.

A sample code that could work for your scenario is :

<#assign json_object = {"RG":[{"title":"John"},{"title":"Mathew"}]}> ${P_to_array(json_object,"RG")}

Refer to below code examples for additional guidelines.

http://docs.runmyprocess.com/API_Reference/FM/Utilities.html#P_to_array.

Please feel free to revert for any additional help.

Regards,

Murali