Hello Jasper Community,
im trying to connect to a REST datasource via the JSON file Dataadapter.
I can create the json file with the curl command curl -o example.json -u user https://mycompany.com/apipath
and use it without problems in a DataAdapter (in both radio button positions "Use the report JSON expression when filling the report" and "Create data source using this expression")
and can create a report. So I assume that the output format of the data source is correct.
I did, however, not succeed to connect to the datasource directly:
While using https://mycompany.com/apipath as File/URI and the user name and password in the options, I can successfully test with the first radio buttion option.
However, with the "Create data source using this expression" I get the response
com.fasterxml.jackson.core.JsonParseException: Unexpected character ('<' (code 60)): expected a valid value (JSON String, Number, Array, Object or token 'null', 'true' or 'false')
at [Source: (net.sf.jasperreports.data.DataFileStream); line: 1, column: 2
I tried to use the data adapter with the first (apparently working) option for a report, but got the same error message as above.
Any help is greatly appreciated!
Best regards,
Dieke