#WebAPI #Monitoring: We are on 7.11 cloud. We have developed WebAPIs and want to

sathishkumars over 8 years ago

#WebAPI #Monitoring: We are on 7.11 cloud. We have developed WebAPIs and want to monitor them, by updating a database table. Thought of using executestoredprocedure fn from within WebAPI but the function does not support writes, it supports only reads ! Thought of using writer functions (bind() within load()) but it isn't working. Looks like, it works only from a saveInto or SAIL UI. Any ideas or thoughts on how can we update/write to a database table from within WebAPI expression in 7.11 ? Or should I consider that since WebAPIs in 7.11 support only GET method, therefore it is not possible to write/update database table ?

Discussion posts and replies are publicly visible

0 Justin
Appian Employee
over 8 years ago

What are you trying to monitor with these writes? In 7.11, there are several logs that track performance of calls and other details that might meet your use case: forum.appian.com/.../Logging.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sathishkumars over 8 years ago

Hi Justin, Thanks for the suggestion. Since we are on cloud, we can't have SPLUNK. Therefore, we write to an external database table which then gets splunk-ed. Splunk produces nice graphs/charts on how many times a service is called, no of failures vs successes etc and we can configure filters as well.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Carlos Santander
A Score Level 2
over 8 years ago

Have you looked into the Start Process Writer plugin? forum.appian.com/.../summary
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sathishkumars over 8 years ago

Thanks Carlos, I did consider it. Thought of using writer functions (bind() within load()) but it isn't working. Looks like, it works only from a saveInto or SAIL UI, where there is some event (like button click or tab out etc) !!! I could not see any errors in log files and neither the process model was started !
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Carlos Santander
A Score Level 2
over 8 years ago

That makes sense, actually. Another option might be to go back to the Exec SP plugin and modify it to allow inserts/updates.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jacob Rank
Appian Employee
over 8 years ago

Functions should not have side-effects, which is why the Exec SP function does not support write operations. See forum.appian.com/.../Custom_Function_Plug-ins.html for details.

Try user the Log Reader plugin to retrieve the built-in web api log. Run a process periodically that dumps the necessary details into your database.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sathishkumars over 8 years ago

Thank you Carlos.

Thanks Jacob, seems to be a viable solution.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel