Skip to main content
arunkumarc0003
November 18, 2021
Solved

Write to datastore while loading the Appian page

  • November 18, 2021
  • 6 replies
  • 0 views

Dear all,

we have a scenario to capture the use activity when they are accessing Appian to track the user activity. 

decided to capture the data and store into database for generating report out of it.

Could you suggest any approach to write the data into database without button click.

Thanks in advance

Best answer by stefanhelzle0001

The username must be made a rule input in the integration and sent to the API using a query parameter or the body. You want to track the user that is looking at the interface but not the technical user you set up for the API call.

Did you test the API itself?

6 replies

stefanhelzle0001
Brainy
November 18, 2021

You are already part of that discussion:

https://community.appian.com/discussions/f/user-interface/13252/write-a-row-to-db-on-ui-load

The last comment is the only OOTB option I am aware of. While not recommended, it is possible. You would need

- Web API writing at least user and time stamp to DB

- Integration that is calling that API, passing the user, configured as POST and "Queries Data"

In Appian user activity is typically considered to be "real activity", not just looking at something. And activity in Appian is always a process which can easily create all the tracking data you might need.

For record usage, there is a log file.

arunkumarc0003
November 19, 2021

Hi Stefan. I tried the same approach but its not writing into database when we are calling the write to datastore WebAPI in POST Integration. any suggestion on top of it ?

stefanhelzle0001
Brainy
November 19, 2021

OK. My remote debugging capabilities are pretty bad. Do you have some details for me?