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
Discussion posts and replies are publicly visible
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.
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 ?
OK. My remote debugging capabilities are pretty bad. Do you have some details for me?
I have called the webAPI in integration but when I am clicking "Test Request" in Integration its not writing the new entry into database. I have added the screenshot for the setup. Did I miss anything here ? Please suggest.
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?
Thanks for the suggestion. It was problem with SAML I was trying with SAML Account so it was not able to authenticate. I created new user and added the Authentication it started working.