If you are building complex table queries for use in the API, then you may find it easier to build the tables you want in SuperWEB2, and then use the option to download your table as an Open Data API Query.
Simply build the table that you want and then select Open Data API Query from the Download Table drop-down menu:
SuperWEB2 will download a text file containing the JSON query you will need to request the same table from the Open Data API.
- Create your table in SuperWEB2 and select the Open Data API Query (.json) download format:
- Click Go.
SuperWEB2 downloads a text file containing the JSON for your query:
- You can now POST this JSON query to the
Limitations of Open Data API Query Downloads
Please note that some features are not supported by the JSON download option.
The following items will not be included in the downloaded JSON query:
- User Defined Fields
- Any settings applied in SuperWEB2 (such as percentages or zero suppression)
Disable Open Data API Query Downloads
The Open Data API download option will be available to all users by default, but if you wish you can disable this by changing the
download.enableOpenDataApiQuery property in the configuration.properties file.