- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2024 05:04 AM
Hi All,
I have a requirement where I have to load the data in a table in scoped app, using attachment which user will attach on a catalog item. When user submits the request, it should invoke the transform map and automatically load the data in the table. I am able to achieve this taking reference from below article, but I am facing few issues.
Data load and transform via Catalog Item - Page 5 - ServiceNow Community
The delete attachment through scheduled import is not working, although I followed the same steps. Not sure what could be the reason.
Also, when the data load happens, it is creating all the records in required table but it also creates an empty record as well whenever the transformation happens. Can anyone help?
I followed the same steps in the above link (shared), @Ankur Bawiskar Could you please suggest what can be the issue?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-09-2024 07:17 AM
API also not solved the issue.
I found the solution for it. I created Script include in global and made it accessable for all scopes and put the delete attachment code in it. I Called this script include in my scheduled import's post import script. Also, keeping the cross scope privelege where "delete" is "allowed" for customer service application.
This solution worked for me!
Thanks, for all the help!Appreciate it!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2024 08:47 AM
please find below for reference:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2024 09:05 AM
Okay, so it does seem like a scope issue. Try created a fix script (delete when done because servicenow runs those when you move scoped apps) in your scope and try running it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2024 10:23 AM
Created a fix script in the scope app and it is throwing below error:
Security restricted: Delete operation against 'sys_attachment' from scope 'sn_customerservice' has been refused due to the table's cross-scope access policy
I have already created the cross scope as mentioned by Ankur, still it is giving this error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2024 10:28 AM
Can you share the configuration of the sys_attachment table's application access and the cross-scope access policy?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2024 10:49 AM
Below are the screen shots: