Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

how to access variables from audit logs

Avatar

Avatar
Validate 10
Level 3
ketangp28686788
Level 3

Likes

23 likes

Total Posts

73 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
ketangp28686788
Level 3

Likes

23 likes

Total Posts

73 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
ketangp28686788
Level 3

04-08-2017

Hi,

I want to access Insert/update variables of Audit logs so as to maintain how many records got inserted or updated of particular schema which is part of import workflow.

Regards,

Ketan Pardeshi

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 5
Level 2
_nkur
Level 2

Likes

11 likes

Total Posts

23 posts

Correct Reply

6 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Affirm 5
View profile

Avatar
Boost 5
Level 2
_nkur
Level 2

Likes

11 likes

Total Posts

23 posts

Correct Reply

6 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Affirm 5
View profile
_nkur
Level 2

04-08-2017

Hi,

insert and update count are maintained in event variable you can get them using below variable on next activity after update data activity.

vars.insertCount & vars.updateCount

Regards,

Ankur A.

Answers (1)

Answers (1)

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

04-08-2017

Hi Ketan,

It's a two step process

Step 1: Enable success and reject from update data activity(this will work for CRM export activity as well)

Use the following screen for the reference.

1272115_pastedImage_1.png

Step2:  Use vars.recCount or vars.insertCount & vars.updateCount to get the count of records, you can use this variable to do what ever you want to use it for.

Example logInfo("successfully inserterd or updated records: "+vars.recCount);

1272131_pastedImage_2.png

Hope this helps!

Amit