Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Update all the previous records and keep the current

Jake Adams
Tera Contributor

‎10-29-2023 07:05 AM

Hi,

 

I have an import API on Key Values (cmdb_key_value) table. It has only four fields CI, Key, Tag, Value. 

 

In the import I might get a record with same CI, Tag, Value as below:

 

JakeAdams_0-1698588102320.png

 

Now if I again get an new import with the same CI, Tag and Value. I want to keep only the latest record and in all the above 3 records the Key value must be updated to blank/Inactive.

 

How can I achieve this?

 

0 Helpfuls
  • 724 Views
5 REPLIES 5

Jake Adams
Tera Contributor
In response to Danish Bhairag2

‎11-02-2023 03:10 AM

No the client don't want this to be done through Business rule and must be done on the Transform script.

 

Any idea on why the onBefore transform script is not working?

0 Helpfuls