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?
Solved
Compare old/new data when updating a MDA Object
Best answer by sai_ram
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.
View originalThere 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.
+1Hi 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.
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
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.