Data load and transform using catalog item

SK41
Giga Guru

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

by @Ankur Bawiskar 

 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?

 

1 ACCEPTED SOLUTION

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!

View solution in original post

19 REPLIES 19

Hi Ankur,

 

I created the cross scope, but still the issue persists. Not sure why the delete is not working. Is there any other way I can delete it? Through some other script instead of scheduled import?

Can you try putting the code into a background script and see if you throw any errors?

the script seems to work in background script. But, not working in the scheduled post import. What could be the reason?

Did you run the background script in global or your scope?

there is no other scope coming to select. How can I check for other scope?