dmoroney

found the JSONQL language guide here... http://jasperreports.sourceforge.net/sample.reference/jsonqldatasource/index.html#jsonql

The JSS v7.1.0 User Guide->Data Adapters->Configuring a Parameter Using the Data Adapter Tab in the Dataset and Query Dialog isn't clear about how to add a parameter that uses JSON. I have a working Data Adapter with all of the needed URL parameters hard coded. I want to override the json_data={"operation":"list_operations"} URL parameter in the report design view with a new JSON Value as needed. The json_data Parameter Name would remain unchanged. Attempting to use the JSON as the Default Value Expression throws a compile-time error like "Expression expected instead value = {"operation":"list_operations"}; //$JR_EXPR_ID=0$"

It works. Create the JSON File adapter - File/URL: the web service URI including the trailing ? - Left URL Parameters tab empty - Entered the needed POST Parameters. A big thing here was to overtly set the desired output fields in the json_data payload - Entered the needed Http Headers - Select Use the report JSON expression when filling the report - Tested the Connection and got Successful - Save the adapter Create a New Report. Data Adaper is the JSON File adapter created earlier. Click Next and click OK to continue, and Finish - Open the DataSet and Query Editor. Select Language jsonql - Entered this expression 'objects["Server::.*"]fields' (without the ' quotes) as the Set record node (generate query) - Clicked on Read Fields and the Fields tab filled in - Clicked on the Data Preview tab and Refresh Preview Data. It's all there Thanks for the suggestion.

here's the process in mind Get Server Response currently recieves in the Fields tab v objects > Server::672 > Server::1719 code message I'd like for Get Server Response to receive or for some pre-processing thing to clean the JSON into v objects > Server > Server code message then I can right click on Server and Set as Root Path to appear as objects.Server. I'd click on the Data Preview tab to confirm the data I need before moving on to composing the report

the preferred result would be as follows. the "::key" expression would be filtered out somehow. Server would be set as the root path for the report loop { "objects": { "Server": { "code": 0, "message": "", "class": "Server", "key": "672", "fields": { "name": "some_server_name", "description": "some_server_description", } }, "Server": { "code": 0, "message": "", "class": "Server", "key": "1719", "fields": { "name": "some_server_name", "description": "some_server_description", } }, }, "code": 0, "message": "Found: 2" } the application doing this is iTop v2.x from Combodo. Hopefully, I don't have to be tied to the Webservice Datasource for that application. Other datasource suggestions are welcome.

set up the Data Adapter to do a GET JSON from a URI. works fine. Dataset and Query Dialog WebServiceQuery works fine. the problem is the web server returns { "objects": { "Server::672": { "code": 0, "message": "", "class": "Server", "key": "672", "fields": { "name": "some_server_name", "description": "some_server_description", } }, "Server::1719": { "code": 0, "message": "", "class": "Server", "key": "1719", "fields": { "name": "some_server_name", "description": "some_server_description", } }, }, "code": 0, "message": "Found: 2" } the problem here is that the 'string::integer" format in the response makes it impossible to set the root path under objects. is there a way in JSS to remove the '::integer' pattern so Server can be used for the root path?