Access required for downloading JSON?

[ArkieCoder]

Hi,
I need to know exactly what table-level access I need to our APEX database in order to be able to download a JSON file from an app.

My config.json looks like this:

{
  "connections" : {
    "sample" : "user/pass@server:port/sid",
    "dev" : {
      "connectionDetails" : "USER/[email protected]:PORT/ORCL",
      "filters" : ["apex_application_pages"],
      "filterGroups" : ["updated"]
    },
    "prod" : "giffy/[email protected]:11522/xe"
  },
  "filters" : ["^(.(?!page_id$))*_id$"],
  "filterGroups" : {
    "updateInfo" : [".+\\..+_updated_.*"]
  }
}

When I run the apex-diff app, I get the following output on the screen:

$ node apex-diff/app.js dev 338
undefined:41
,"apex_application_page_proc":[
^

SyntaxError: Unexpected token , in JSON at position 6602
    at JSON.parse ()
    at Object. (/apex-diff/app.js:255:28)
    at Module._compile (module.js:653:30)
    at Object.Module._extensions..js (module.js:664:10)
    at Module.load (module.js:566:32)
    at tryModuleLoad (module.js:506:12)
    at Function.Module._load (module.js:498:3)
    at Function.Module.runMain (module.js:694:10)
    at startup (bootstrap_node.js:204:16)
    at bootstrap_node.js:625:3

I'm the guy who is running this inside a Docker container (see issue #23)

Here's the gist containing the JSON file that is created. It seems like it doesn't really contain anything useful -
https://gist.github.com/ArkieCoder/c8b7c023d2610397ff0ef366da327d04

[ArkieCoder]

Also, output of sql -V is SQLcl: Release 18.2.0.0 Production

Output of node --version is v8.12.0

[ArkieCoder]

Based on my experimentation, at least read access on these views / tables are required for apex-diff to work:

-- apex-diff script --
apex_dictionary
apex_application_page_ir_rpt
apex_application_all_auth
all_tab_columns

-- generated script --
apex_application_all_auth
apex_application_auth
apex_application_authorization
apex_application_bc_entries
apex_application_breadcrumbs
apex_application_build_options
apex_application_caching
apex_application_computations
apex_application_items
apex_application_lists
apex_application_list_entries
apex_application_locked_pages
apex_application_lovs
apex_application_lov_entries
apex_application_nav_bar
apex_application_pages
apex_application_page_branches
apex_application_page_buttons
apex_application_page_comp
apex_application_page_da
apex_application_page_da_acts
apex_application_page_db_items
apex_application_page_flash5
apex_application_page_flash5_s
apex_application_page_groups
apex_application_page_ir
apex_application_page_ir_cat
apex_application_page_ir_cgrps
apex_application_page_ir_col
apex_application_page_ir_comp
apex_application_page_ir_cond
apex_application_page_ir_grpby
apex_application_page_ir_pivot
apex_application_page_ir_pvagg
apex_application_page_ir_pvsrt
apex_application_page_ir_rpt
apex_application_page_items
apex_application_page_map
apex_application_page_proc
apex_application_page_regions
apex_application_page_reg_cols
apex_application_page_rpt
apex_application_page_rpt_cols
apex_application_page_trees
apex_application_page_val
apex_application_parent_tabs
apex_application_processes
apex_application_shortcuts
apex_application_static_files
apex_application_substitutions
apex_application_supp_objects
apex_application_supp_obj_bopt
apex_application_supp_obj_chck
apex_application_supp_obj_scr
apex_application_tabs
apex_application_templates
apex_application_temp_bc
apex_application_temp_button
apex_application_temp_calendar
apex_application_temp_label
apex_application_temp_list
apex_application_temp_page
apex_application_temp_popuplov
apex_application_temp_region
apex_application_temp_report
apex_application_themes
apex_application_theme_files
apex_application_theme_styles
apex_application_translations
apex_application_trans_dynamic
apex_application_trans_repos
apex_application_trees
apex_application_web_services
apex_appl_concatenated_files
apex_appl_developer_comments
apex_appl_load_tables
apex_appl_load_table_lookups
apex_appl_load_table_rules
apex_appl_page_calendars
apex_appl_plugins
apex_appl_plugin_attributes
apex_appl_plugin_attr_values
apex_appl_plugin_events
apex_appl_plugin_files
apex_appl_plugin_settings
apex_appl_template_options
apex_appl_template_opt_groups
apex_appl_temp_page_dp
apex_appl_temp_region_dp
apex_appl_theme_display_points
apex_appl_user_interfaces

[rimblas]

The application schema ("parse as") should already have access to all those APEX Dictionary Views.