Please see the Oracle APEX Interactive Report help for full instructions.

Retrieve JSON from the REST web services

Viewing JSON output from the REST web services in your browser is easier with a formatter plugin, such as JSON Formatter (https://github.com/callumlocke/json-formatter).

By default, our web services come paginated with 100 records at a time. To adjust the page size, adjust the "limit" url parameter. To adjust the starting point, adjust the "offset" url parameter. For example, to get 500 records starting with row 1000, use https://www.webapps.nwfsc.noaa.gov/apex/parr/midklamath_river_coho_ponds_pit_tag_data/data/page/?limit=500&offset=1000.

To filter in a query, include the parameter q=FilterObject, where FilterObject is a JSON object that represents the custom selection and sorting to be applied to the resource.

Pattern: https://HOST/apex/parr/ObjectAlias/Pattern?q=FilterObject

Example: https://www.webapps.nwfsc.noaa.gov/apex/parr/the_surface_based_data_collected_dtag_study_data1/data/page?q={"feet_to_whale":{"$lt":300}}

For detailed instructions, see the official Oracle documentation