How to set parameter in json datasource at jasper report server?

[hknakata]

How to set parameter in json datasource at jasper report server?

I have a json url, https://jsonplaceholder.typicode.com/posts

want to pass a parameter user id to filtering, https://jsonplaceholder.typicode.com/posts?userId=1

 

[narcism]

Starting with Jaspersoft Studio 6.4.0 and JasperReports Server 6.4.0 you can set URL parameters in the JSON Data Adapter or by setting specific properties at the parameter level. More info in the HTTP Data Adapter Sample: http://jasperreports.sourceforge.net/sample.reference/httpdataadapter/index.html

[hknakata]

@narcism thank you for the prompt reply. I know how to set in data adapter via Jasper Studio. However, I don't know how to set in the server. When I create a "json datasource type" data source, it only has three options (url, langauge type, and query) and nothing about parameter.

 

 

[hknakata]

I found we cannot set in web admin console directly.

However, we can deploy it after we set in Jaspersoft Studio.

Here are some steps for reference.

1.Create data adaptor, and set with URL parameter

2. Edit source of report

3. Replace following lines

 

Old

<property name="com.jaspersoft.studio.data.defaultdataadapter" value="myAdapter.xml"/>

New

<property name="net.sf.jasperreports.data.adapter" value="myAdapter.xml"/>

 

4. Deploy the report