microsoft / botframework-sdk

Bot Framework provides the most comprehensive experience for building conversation applications.
MIT License
7.47k stars 2.44k forks source link

connecting bot framework composer to mysql and getting queries #6583

Closed scorpioswati closed 1 year ago

scorpioswati commented 1 year ago

This is not for asking questions or filing bugs

To get help with an issue with your bot

To file an issue against a component please go to the components repo

Issue

Describe the issue you are addressing

I want to add mysql to bot framework composer and get queries from this..Please help me with this

Describe the proposed solution

Component Impact

Describe which components need to be updated

Customer Impact

Describe the impact on customers

Tracking Status

Dotnet SDK [TODO]()

Javascript SDK [TODO]()

Python SDK [TODO]()

Java SDK [TODO]()

Samples [TODO]()

Docs [TODO]()

Tools [TODO]()

anishprasad01 commented 1 year ago

Hi @scorpioswati,

There are two main ways you could accomplish this in Composer:

  1. The simpler way would be to make an HTTP request on your MySQL database to send and retrieve information. See the documentation on making HTTP requests in Composer.
  2. A more complex but more flexible method would be to create a custom action. In Composer, things like Send a response or Set a property are called actions. You can write code to perform database operations and call this code as an action in Composer.

Additionally, the Microsoft Bot Framework team prefers that how-to questions be submitted on Stack Overflow. The official Bot Framework Github repo is the preferred platform for information on submitting bug fixes and feature requests. This issue will be closed, but if you have a bug or feature request, please feel free to open a new issue in the appropriate repository.