Created a Bot to get info from a table

[luizsilv]

Hello Community!

I have started creating a bot and would like to get an output based on user input. Example:

User: @AskCSON case 413546

Output: Returning case details. Information are saved on an table (excel file).

I have tried with dialog flow, but it seems we do not have this available anymore for webex.

Best Regards,

Luiz Silva

[luizsilv]

Hello Sandip,

Thanks for your information. Really appreciated I have already implemented all steps, created bot, did some changes in index.js and got replies after called it.

Now, my challenge is how to call a table to return a specific data with this bot. If we type @askbot case 123456, bot would return with details saved on an .xlsx file. Please can you assist me in this project?

[dtibbe]

The framwork allows you to expand the commands, the bot is listening to. Check out the various versions of framwork.hears(command, action). Create your own extensions to the bot by adding a new action for a case-command.

The action may evaluate the command to extract the case number. Looking up the data from the xslx file is up to you :). Finally let the bot respond by calling bot.say() as in the other examples as well.

[sandiban]

Hello @luizsilv, 
Have you tried it with the latest Bot workflow demonstration from here - https://developer.webex.com/blog/from-zero-to-webex-teams-chatbot-in-15-minutes

If not, could you kindly try this out and let us know how it goes.
In this case, it's a simple reply from the chatbot in response to some specific command set.

But to design & build the application as per your requirement mentioned, you need to additionally work with it so that the Bot can read the excel file and share the corresponding answer accordingly.

However, you can just go through the sample shared above first and try to clone it in your system & get it worked.
Once done and it's working as shown in the sample in the Blog post, then you can start implementing the feature/s as per your requirement on that existing setup.
In case you're facing some error or, unexpected outcome - let us know.

Regards!
Sandip