CODEWITHSUNDEEP
mysqlibm-cloudwatson-assistant
Abraham Bruck
Abraham Bruck

Reputation: 49

IBM Watson Assistant: How to read data from an AWS MySQL table and determine dialogue based on the data (Yes or No)?

We have an AWS MySQL users table that has a column (flag) to indicate if the user is a paid member or not (Yes or No).

Can IBM Watson Assistant on IBM Cloud read the data, given the user ID, and depending on whether it's Yes or No, proceed to a different dialogue sequence?

Do you have an example of how to do it?

Upvotes: 0

Views: 481

Answers (1)

data_henrik
data_henrik

Reputation: 17156

It is possible to reach out to database systems from within an IBM Watson Assistant dialog. For an example including code see this IBM Cloud solution tutorial on building a database-driven Slackbot.

Watson Assistant supports so-called programmatic calls from within a dialog node. It allows to either signal the calling application to perform some action or to invoke an IBM Cloud Functions action. In the mentioned tutorial Cloud Functions is used to to reach out to a database system to retrieve or insert data.

In your case, you would write an IBM Cloud Functions action, would need to bind the credentials, and then, in the chatbot dialog, invoke that action to check for the member status.

Upvotes: 1

Related Questions