Issues with a flow to create catalog items

[Olivier Detille]

Hi,

I'm new as a servicenow developer and I am looking for best practices answers. I am creating an application that first need to create new Catalog Items. To do that, I have a flow that tries to create new records in the sc_cat_item table.

First question : 

• Is that something legitimate ? 
• Would it be better to maybe create a new table just for my records ? If yes, will those records be visible in the Service Catalog ? 

Second question : When executing my flow, I get the "Scope does not have create access to table sc_cat_item". I have added the required cross scope privileges. That was not enough. I had to configure the table to allow create and update, as shown in the screenshot below

• Is that the right way to fix that error ? 
• Is that a configuration our customers would accept ? I have the feeling this is too much permission on "Global" tables.

Thanks in advance for you kind answers,

[Dr Atul G- LNG · Accepted solution]

Hi @Olivier Detille 

First question : 

• Is that something legitimate ?   --> Yes.
• Would it be better to maybe create a new table just for my records ? If yes, will those records be visible in the Service Catalog ?  --> NO, For catalog item we always use OOTB tables only.

Second question : When executing my flow, I get the "Scope does not have create access to table sc_cat_item". I have added the required cross scope privileges. That was not enough. I had to configure the table to allow create and update, as shown in the screenshot below

• Is that the right way to fix that error ? --> Make sure you create the flow in correct scope to avoid issues
• Is that a configuration our customers would accept ? I have the feeling this is too much permission on "Global" tables. --> It can be risk so avoid non-scoping if possible.

https://youtu.be/Hf21HMI8n_o

https://youtu.be/F6w0jRLyBuw

•  

[Olivier Detille]

Dear Atul, thanks a lot for your first answers. Yes, my flow is part of my custom application, so definitely in the scope of the application. I'm quite surprised I had to add those "can create" and "can update" options on some tables, in addition to the cross scope privileges I've created. Any ideas ? 

I'll review your videos if they provide some answers to my questions as well.

[Dr Atul G- LNG]

Hi @Olivier Detille 

yes, need to one by one

https://www.servicenow.com/community/developer-forum/how-to-access-global-scope-table-from-scoped-ap...

[Olivier Detille]

Thanks a lot for your answer. My flow is scoped as it is part of my custom application. I'll review your video for sure.

Since I am using a scoped flow, is it acceptable to set "can create" and "can update" Application Access on "Global" tables ?