Data load and transform using catalog item

[SK41]

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?

[SK41]

I also tried after checking "can delete" in attachment table, still getting the same error.

[Kristen Ankeny]

Can you confirm that the scheduled import record is in Customer Service scope and not another one?

[SK41]

Yes, it is in customer service scope only

[Kristen Ankeny]

Can you try using the API instead of gliderecord? https://developer.servicenow.com/dev.do#!/reference/api/vancouver/server/no-namespace/c_GlideSysAtta...

[SK41 · 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!