Accessing global tables from a scoped app

[JohnMMcLaughlin]

Hi,

I'm trying to expand my knowledge of the App Engine Studio and have come across an issue with the app I am working on.

The app is a basic Automated Data Importer, a user will be able to import data into ServiceNow using a record producer via the portal, they will select from a list of predefined import types, attach the spreadsheet and the predefined import type creates an entry in the Data Source table. 

I already have this working in a previous version I created in the Global scope but wanted to try and recreate as a scoped app.

The issue I am having is when configuing the record producer - Record Submission Table, I'm not able to select the sys_data_source table I can only select tables that I have created in the scope.

Is it possible to access the sys_data_source table from a scoped app and if so, how?

Thanks in advance,

John.

[JP - Kyndryl]

Hi John,

Navigate to sys_db_object.list,  retrieve the sys_data_source table,  and validate that under the Application Access tab  you can Create and Update from All application scopes.

Regards.

JP

[Flavio4]

Hi John and JP,

I believe I have a kind of similar problem, although my (San Diego) instance apparently provides only the "Studio" application instead of App Engine Studio.

Although tables such as "Incident" have the Create and Update from All application scopes in the Application Access tab, I cannot add/select/access them in the application I created in "Studio".

Is it a limit of the instance being configured only with "Studio" (vs. AES)? Or is there a way to use the Incident tables (and others)?

Thank you in advance
Flavio

[Filip Vojt__ek]

I know this is already an old question, but for reference for people searching for solution:

Please use dictionary attribute 'allow_public=true' on the table type field/column to allow tables from all scopes as described in documentation.

https://docs.servicenow.com/en-US/bundle/vancouver-platform-administration/page/administer/reference...

Please mark my solution as helpful if it helped to solve your issue.

[amol_joshi]

In the scoped app script include, call an event that runs a global script to delete the records returned by the scoped script include.