When querying REST APIs, you might come across an error message like this. If you enable the "debug" option at the PocketQuery macro, you will get something like this:

Error Details
Type: ClassCastException

Message: java.util.LinkedHashMap cannot be cast to java.util.List

This basically means that your Query is working fine, but the result cannot be displayed as a table - which is the default for PocketQuery. Most likely, your result is nested and naturally multiple levels cannot be displayed using a simple table.

How to solve this:

  • Use a Converter to bring your data into the right format. A Converter is a piece of Javascript code that transforms your result. For a brief introduction please have a look at our Quick Start Guide for REST Queries, for a comprehensive explanation refer to the converter section within the documentation. Maybe use this in combination with a custom template.

  • (JSON Path is deprecated) Check the JSON path of your Query. It should lead to the data of your interest within the JSON result. If there is an array at that location, it is possible to display it using the default converter and default template.