Skip to main content
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?
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.

Reply