[Export specific Organisation via REST v2 API]

HI
Working with Postman.
Need correct construct for the export of specific organisation (BasePack). That export must be used as import on NEWorganisation.
Organisation paths:

• /organizations/organization_1/organizations/NEW
• /organizations/organization_1/organizations/BasePack

Body for Export01  -  export work BUT import result = ' Import failed. Import of the root to an organization is not allowed.'

{
"roles": ["ROLE_USER","ROLE_ADMINISTRATOR"
        ,"ROLE_MANAGER|BasePack","ROLE_OWNER|BasePack","ROLE_MEMBER|BasePack"],
"users": ["superuser","zelda|BasePack"
        ,"kruger|BasePack","joco|BasePack"
        ,"jasperadmin|BasePack","joeuser|BasePack"],
"uris": ["/organizations/organization_1/organizations/BasePack"],
"parameters": ["repository-permissions"]
}

Body for Export02  -  As soon as I add the organization option I get the following error:  

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><errorDescriptor><errorCode>serialization.error</errorCode><message>Cannot deserialize instance of `java.lang.String` out of START_ARRAY token</message><parameters><parameter>organization</parameter></parameters></errorDescriptor>

{
"roles": ["ROLE_USER","ROLE_ADMINISTRATOR"
        ,"ROLE_MANAGER|BasePack","ROLE_OWNER|BasePack","ROLE_MEMBER|BasePack"],
"users": ["superuser","zelda|BasePack"
        ,"kruger|BasePack","joco|BasePack"
        ,"jasperadmin|BasePack","joeuser|BasePack"],
"uris":["/"],
"organization":["/organizations/organization_1/organizations/BasePack"],
"parameters": ["repository-permissions"]
}

 

[file location when using export/import service]

HI
Need to 'launch the import operation' after successful 'export output'

JasperReport Server is NOT local-host.

REST-API calls used

• {{url}}/jasperserver-pro/rest_v2/export/{{exportID}}/Export.zip
• {{url}}/jasperserver-pro/rest_v2/import?organization={{orgID}}&mergeOrganization=true

How do I reference the export.zip file?

Thank you

 

[Reference to Data Adapter in JasperReport Server not working]

The folloiwng worked:
Report Path:- /organizations/organization_1/organizations/BasePack/Reports
DataAdapter Path: /organizations/organization_1/organizations/BasePack/DataAdapter
DataAdapter uploaded file resource as xml file BUT did not add the file extention to the name or the Resouce ID.
 

Properties in .jrxml file

    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="repo:/DataAdapter/tubestatus.xml"/>
    <property name="net.sf.jasperreports.data.adapter" value="repo:/DataAdapter/tubestatus"/>

 

 

[How to pass dynamic parameter value to data adapter URL in jasper]

HI
have a look at this, there is note at bottom it may help
https://community.jaspersoft.com/questions/1107291/traversing-json-output-rest-api-datasource

I am currenly also trying to get my report to work with dynamic URL

[Reference to Data Adapter in JasperReport Server not working]

Made use of the following example.

https://community.jaspersoft.com/wiki/using-data-adapters-fill-reports-json-data-remote-url

 

Got everything to work when deployed to same folder as per the above example.

BUT When I separate the DataAdapters and the Reports into different folders.

I keep getting ‘Resource not found at: DataAdapters/tubestatus.xml {for example}

 

DataAdapters Path: /organizations/organization_1/organizations/BasePack/DataAdapters

Report path: /organizations/organization_1/organizations/BasePack/Reports

 

Properties in jrxml

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

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

 

I have also tried the following reference options for "net.sf.jasperreports.data.adapter" but to no avail.

organizationsorganization_1organizationsBasePackDataAdapterstubestatus.xml

organization_1organizationsBasePackDataAdapterstubestatus.xml

organizationsBasePackDataAdapterstubestatus.xml

BasePackDataAdapterstubestatus.xml

..organization_1organizationsBasePackDataAdapterstubestatus.xml

..organizationsBasePackDataAdapterstubestatus.xml

..organizationsorganization_1organizationsBasePackDataAdapterstubestatus.xml

..BasePackDataAdapterstubestatus.xml

 

What am I doing wrong?

[JSS Localisation XML/Json file as Data source]

New user of JRS and JSS.
My Jasper Studio Report call a web service which can return XML/Json file.

Our client/organisation can select a default language and will be able to make their own changes their own language file

Will have multiple organisations/sub-organisations on one reportserver

I have attached both a xml and json file

• Response contain the Values need to display
• ResponseSchema contain the lables/column headings I need to use

Expected Results

TitlesExpired	TitlesDescription	TitlesAbbreviation
false	Madam	Mrs
false	Missus	Ms
false	Mister	Mr
false	Sir	Sir

Results:

• XML
  • can display the values in table BUT then the headers is not correct
  • tied to using 2 tables one for values one for the headers
    • wanted to make use of expression for the headers "IF($F{DisplayName}.toString()=="TitlesExpired",$F{TransName}.toString(),$F{ColumnName}.toString())"
• Json (make use of jsonql)
  • Do not how to return both objects in report dataset and query dialog.