Solved

Compare old/new data when updating a MDA Object

  • 3 July 2018
  • 1 reply
  • 31 views

I ́m updating a MDA Object thru Bulk API from a CSV file, but i need to compare the old data and the new, how can i do that?

For example: 

Send my CSV file containing:
Client: Dell
Available licences: 50
Used licences: 20

Then, a month later i send my CSV file again:
Client: Dell
Available licenses: 50
Used licenses: 15

It ́s important for us to be aware of this decrease when updating the object, is that possible?
icon

Best answer by sai_ram 5 July 2018, 18:20

View original

This topic has been closed for comments

1 reply

Userlevel 7
Badge +2
Hi Ricardo, 

There is no direct way to know the decrease of the field value. 

We have a workaround.
Step 1: Create new field called Previous Value.
Step 2: Create a rule and push the value to the Previous Value field(create a scheduler based on your requirement).
Step 3: Once the rule ran, load the CSV again. 
Step 4: Create one more rule to compare the values(Condition : Current Value <th Previous Value). 
Step 5: Create action in rule.

Let me know if you are fine with this. I can also help you in configuring the rule. 

@All,  If you have other ways to achieve the above use-case, please suggest here.