Chatbot.com using webhook with Node.js to find 1 price from mysql database

Programmer

Chatbot.com using webhook with Node.js to find 1 price from mysql database

The chatbot will send a few inputs (product name, country, qty) to the javascript node js, which will find the price from maria db (like mysql) database (contains 5 tables), and return 1 value (the price).
I need your help to write the javascript in node js to talk with the chatbot and the database.

Chatbot is: http://chatbot.com and https://livechatinc.com
some javascript webhook instructions are at chatbot.com - https://www.chatbot.com/help/webhooks/setting-up-your-webhook,.
node js is v11 at http://inmotionhosting.com
maria db database is at http://inmotionhosting.com
the database and tables are ready - http://inmotionhosting.com
the login details are ready - for ssh putty and the database

i have setup the chatbot story at http://chatbot.com and the chat users at https://livechatinc.com
here is a demo of the chatbot that only collects the input of product category, screen size, qty, name, email.
https://www.videoplusprint.com/chat/livechatinc-LIVEC3.html

Questions:
Will you follow all the steps on this webpage?
https://www.chatbot.com/help/webhooks/setting-up-your-webhook

Will you use the Ready to use examples - * Node.js without any libraries?
Do I need it With or without libraries?

Not sure if i need to install ngrok, please advise. “Install ngrok to expose the web server, you’ve just created, running on your local machine to the internet.” - from https://www.chatbot.com/help/webhooks/setting-up-your-webhook

Are you going to use zapier?
Do i need to use zapier?
https://www.chatbot.com/help/webhooks/create_webhook_with_zapier

How long?
How much total price?
Demo site of your work or can you make a prototype?

Thanks

Are you looking to pay or is this a collaboration?
Pay to hire someone

Is this ongoing work or a one off job?
One-off specific project or job

How would you prefer to pay for the project?
Fixed project total

Enter your job or project budget range? (USD)
$25-100

Do you have an estimate of the job or project length?
A few weeks

Are you a company or individual hiring?
Company

Do you have internal sign off on the hire?
Yes

Do you need to hire for a specific city, country or place?
No, we can work online

When do you want to have the freelancer secured by?
1 week

What is most important for this job?
Quality

Twine can guarantee 3 relevant freelancers for an upfront fee of $650/£500. Would you like to know more?
No

How many freelancers do you want to contact you?
10+

Do you have a job specification or creative brief?
Yes (please enter this in the description)

Does the freelancer need insurance?
No

Where did you find Twine?
Google

Client contact preference:
- Email
- WhatsApp
- Phone

Twine Pro members will get direct contact details of this client after applying. Upgrade now.
Posted 5 years ago
Private
based in Hong Kong
Last online: 5 years ago


No longer accepting applications


Don't miss out! Drop your email to get notified for Programmer roles

  • How It Works


    Create your Profile for Free

    Build your Twine portfolio to highlight your skills, and experience, while setting your desired pay rate.


    Send Customized Pitches

    Pitch for available jobs that match your skills, and access exclusive opportunities that are specifically tailored to your expertise.


    Secure Payment Process

    Clients make upfront Vault payments held by Twine, ensuring freelancer payment security, with 0% commission for freelancers.