ACL or Query Business Rules ?

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.

Quebec Tour Part 3:Import Set REST API – Insert Multiple

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.

POST https://INSTANCENAME.service-now.com/api/now/import/{stagingTableName}/insertMultiple

First thing, I am going to structure my JSON, I use company.do?JSONv2 to help me structure my JSON

Continue reading →