Qlik Sense Bot with Node.js and Enigma.js

[Yianni_Ververis]

Hello everyone. After I saw the popularity of Juan's Qlik Bot for Telegram written all in C#, I decided to create another one in JavaScript with Node.js‌ and Enigma.js. Today I am going to share with you the code and how to get started creating your own bot for Telegram on any Operating System that has Node.js installed.

The server will be running under https so if you do not have valid certificates for your domain, or localhost if you are testing it on your local computer, you can have Qlik Sense Enterprise take care of that for you. From QMC, go to start->Certificates and then export for localhost using the "Platform Independent PEM-format"

Copy these certificates and paste them into {QlikBotNode folder}/app/server/certs/localhost

I have used 3 apps in this, helpdesk, Salesforce and CIO dashboard. The qvf for helpdesk is bundled in your Qlik Sense Desktop while the Salesforce one you can get from Salesforce/Files at master · yianni-ververis/Salesforce · GitHub and the CIO Dashboard one from CIO/Files at master · yianni-ververis/CIO · GitHub.

Now lets get the code from GitHub - qlik-bots/QlikBotNode: QlikBotNode is a server build in nodejs, expressjs and MySql that co...

From the command line using your favorite tool, I am using Git Bash for this one, type Npm install to get all of the required modules.

Install MySql or Xampp / Wamp and connect to it. Xampp is bundled with phpmyadmin so you can use that. Then create the database and the tables by running sql query (QlikBotNode/sensebot.sql at master · qlik-bots/QlikBotNode · GitHub)

Every platform, upon creation of the bot, it gives you some tokens so your code can authenticate with the platform's servers. Once we have these tokens, for security reasons, we need to set them as environment variables. So, lets create our bot and get our token.

Once you install Telegram Desktop, go to your "BotFather" contact and type "/newbot". Everything in Telegram that starts with "/" is a command. So we typed the command to create a new bot. This will give you an options menu to configure your bot.

Go ahead and give your Bot a name, an icon and a description. If you click on "Back to Bot", you will get a button with the "API Token". Take that token and store it as Environment Variable.

In windows you have to go to "Control Panel" -> "System" -> "Advanced System Settings" -> "Environment Variables" and set a new one as "TELEGRAM_BOT_TOKEN", while in Linux, from your directory (~), type "nano .bash_profile" or "vim .bash_profile" and enter a new line with the token "export TELEGRAM_BOT_TOKEN=######".

Now you should be ready to run your code. From the command line (Git Bash), type "gulp". If everything goes well and you do not have any errors, you should see a message "[nodemon] starting `node app/server/server.js`". Your server is up and running and communication via the Token auth has been established.

Now lets explore the Bot.

• Type help to view all of the available commands

• Click on the Salesforce button or type /salesforce
• Here, there are some buttons to get KPIs and one that takes you to the mashup for validation. Try them all!!!!!
  
• Click on the CIO button or type /cio and then click on "Management" to get the set of KPIs
• Click on the Helpdesk button or type /helpdesk

That's it! Now you can a have a Node.js server running with your QlikBotNode and you can start experimenting with KPI commands in the Telegram app.

The code is open sourced at GitHub - qlik-bots/QlikBotNode: QlikBotNode is a server build in nodejs, expressjs and MySql that co...

[Yianni_Ververis]

I think you need to set privileges

GRANT ALL ON sensebot.* TO 'local'@'%';

GRANT SELECT, EXECUTE, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES ON `sensebot`.* TO 'local'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

[andyjalexlive]

Hi Yianni,

Great post. Can i set this up without Qlik Sense Enterprise? i.e using Qlik Sense Desktop

Also, can this node bot be extended to understand natural language?

Thanks

Andy

[andyjalexlive]

Hi Yianni,

The demo bot Qlik Bot Node doens't seem to work anymore in Skype or Telegram. When i click on Dashboard or Opportunities it returns the error message below. Any ideas?

Thanks

Andy

[Yianni_Ververis]

Thank you Alexander. Everything is fixed now. Please try again

[vikraant]

Hi Yianni,

I have tried this. Not supported Auth error is still popping up. Could you please help.

[Yianni_Ververis]

Hello Vikraant,

Tried what? What Auth error? Are you in the live published one, because I have just checked it and works fine, or on your own servers?

[vikraant]

Hi Yianni,

Sorry for not mentioning the problem clearly.

I have set the plugin to 'mysql_native_password'  as per the following

https://github.com/mysqljs/mysql/issues/1507

I have also set privileges as per your earlier message.

GRANT ALL ON sensebot.* TO 'sensebot'@'%';

GRANT SELECT, EXECUTE, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES ON `sensebot`.* TO 'sense'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

However, I am still getting the following error when i try to send message to the bot via Telegram.

[nodemon] starting `node app/server/server.js`

info: error: Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client model=models/sense-bot/Db::get

info: error: Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client model=models/sense-bot/Db::put

Please help!

[vikraant]

I guess the problem is with mysql 8. i have installed mysql 5.7.22. It is working fine now Thanks

[Anonymous]

Hi jvs

I have done full configuration setup as described by you but i am not getting any response in telegram.

Also after successfully running server i am getting message in console as  ""Failed to get update" (as in below screenshot).

Please help me out of this error i am not getting any clue to solve it.

[Yianni_Ververis]

Hello Gaurav,

This is telegram's ip. Check your firewall or ask your IT if its blocked. It seems that it is...

After you do that, make sure that you have the correct token.