REST

In most cases, REST API’s output is in the form of JSON. Oracle APEX’s REST Data Source utility has inbuilt functionalities to read this JSON and parse the values as separate columns. But in case if your JSON is a multidimensional array, the parsing needs to be done manually for getting custom column values.