ServiceNow introduces Export Events [isc_export_event]table. The table stores export transactions that are performed by any user. The table gives information about what data is being exported, who exported the data, and when the data is being exported.
Every now and then I find myself debating with a friend or colleague on whether we should use ACL or Business rules query.
Personally, I think the use of business rule query should be minimised. if you think about it, ACL called ACL for a reason! your security admin is the only one who can change ACL where anyone in your organisation with personalize_rules role can play with a query business rule that can be integral to your team.
again, I am not saying never use query business rules , I am just saying it should be minimised.
Here is when you shouldn’t use query business rules
- Your query BR is going to run on large table.
- Your query BR might contain a lot of OR clauses or LIKE operator.
- You are not concern about your instance performance.
In Quebec release, ServiceNow introduce new capability to enable users to insert multiple records into a staging table and trigger a transformation that is based on predefined transform maps in a single API request. In this post i am going to use the Insert Multiple REST API end point.
First thing, I am going to structure my JSON, I use company.do?JSONv2 to help me structure my JSONContinue reading “Quebec Tour Part 3:Import Set REST API – Insert Multiple”