# Database (MySQL) conncectivity for custom actions

**URL:** <https://forum.rasa.com/t/database-mysql-conncectivity-for-custom-actions/5592>\
**Category:** Rasa Open Source\
**Created:** [February 28, 2019, 7:42am UTC](https://forum.rasa.com/t/database-mysql-conncectivity-for-custom-actions/5592 "2019-02-28T07:42:22Z")\
**Posts on this page:** 10\
**Page:** 3

<div class="post-metadata">

**Author:** ![zaidalvi](https://avatars.discourse-cdn.com/v4/letter/z/ecc23a/32.png) [@zaidalvi](https://forum.rasa.com/u/zaidalvi)\
**Post date:** [April 24, 2020, 6:24pm UTC](https://forum.rasa.com/t/database-mysql-conncectivity-for-custom-actions/5592/44 "2020-04-24T18:24:35Z")

</div>

Sorry man this seems too complex. Can you tell me how can I add this to my code? Do I need to make another function for this?

---

<div class="post-metadata">

**Author:** ![Prskriti](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/prskriti/32/4993_2.png) [@Prskriti](https://forum.rasa.com/u/Prskriti)\
**Post date:** [April 27, 2020, 12:28pm UTC](https://forum.rasa.com/t/database-mysql-conncectivity-for-custom-actions/5592/45 "2020-04-27T12:28:46Z")

</div>

Hey Jitesh Client as well as data value are getting printed.

 ![30%20PM](https://europe1.discourse-cdn.com/flex013/uploads/rasa/original/2X/8/8bf7e7e095f8813f6b73bd146726d269928925f7.png)

But output is not getting reflected on UI side. Could you please tell me how to organise output in simple text format and send response back to front end.

---

<div class="post-metadata">

**Author:** ![JiteshGaikwad](https://avatars.discourse-cdn.com/v4/letter/j/77aa72/32.png) [@JiteshGaikwad](https://forum.rasa.com/u/JiteshGaikwad)\
**Post date:** [April 27, 2020, 12:35pm UTC](https://forum.rasa.com/t/database-mysql-conncectivity-for-custom-actions/5592/46 "2020-04-27T12:35:45Z")

</div>

Actually the data is in tuple format within a Array, you need to convert it to list. Check this, it may help you:

> <https://stackoverflow.com/questions/43796423/python-converting-mysql-query-result-to-json/43796849#43796849>

---

<div class="post-metadata">

**Author:** ![Prskriti](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/prskriti/32/4993_2.png) [@Prskriti](https://forum.rasa.com/u/Prskriti)\
**Post date:** [April 28, 2020, 6:08am UTC](https://forum.rasa.com/t/database-mysql-conncectivity-for-custom-actions/5592/47 "2020-04-28T06:08:20Z")

</div>

Hey Jitesh I did mentioned changes but still not getting json data on UI Could u pls tell me what changes I should.I am using ChatBot Widget developed by u.

---

<div class="post-metadata">

**Author:** ![JiteshGaikwad](https://avatars.discourse-cdn.com/v4/letter/j/77aa72/32.png) [@JiteshGaikwad](https://forum.rasa.com/u/JiteshGaikwad)\
**Post date:** [April 28, 2020, 6:09am UTC](https://forum.rasa.com/t/database-mysql-conncectivity-for-custom-actions/5592/48 "2020-04-28T06:09:23Z")

</div>

how do you want to show the response in the UI, I mean text, buttons or something else?

---

<div class="post-metadata">

**Author:** ![Prskriti](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/prskriti/32/4993_2.png) [@Prskriti](https://forum.rasa.com/u/Prskriti)\
**Post date:** [April 28, 2020, 6:10am UTC](https://forum.rasa.com/t/database-mysql-conncectivity-for-custom-actions/5592/49 "2020-04-28T06:10:44Z")

</div>

In text form

---

<div class="post-metadata">

**Author:** ![JiteshGaikwad](https://avatars.discourse-cdn.com/v4/letter/j/77aa72/32.png) [@JiteshGaikwad](https://forum.rasa.com/u/JiteshGaikwad)\
**Post date:** [April 28, 2020, 6:30am UTC](https://forum.rasa.com/t/database-mysql-conncectivity-for-custom-actions/5592/50 "2020-04-28T06:30:10Z")

</div>

> [@Prskriti](#):
>
> ![30%20PM](https://europe1.discourse-cdn.com/flex013/uploads/rasa/original/2X/8/8bf7e7e095f8813f6b73bd146726d269928925f7.png)
> 
> Screen Shot 2020-04-27 at 5.32.30 PM.png1376×196 110 KB

based on your output, I have written the sample code, test it out:

```auto
data=[('NorthWell','PHY6056',48596099.0)]
data=list(data[0])
msg=""

for i in range(len(data)):
    msg=msg+str(data[i])+" <br> "

print(msg)

##dispatcher.utter_mesage(text=msg)

```

---

<div class="post-metadata">

**Author:** ![Prskriti](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/prskriti/32/4993_2.png) [@Prskriti](https://forum.rasa.com/u/Prskriti)\
**Post date:** [April 28, 2020, 7:18am UTC](https://forum.rasa.com/t/database-mysql-conncectivity-for-custom-actions/5592/51 "2020-04-28T07:18:56Z")

</div>

this works thanks for your help

---

<div class="post-metadata">

**Author:** ![Prskriti](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/prskriti/32/4993_2.png) [@Prskriti](https://forum.rasa.com/u/Prskriti)\
**Post date:** [May 6, 2020, 1:20pm UTC](https://forum.rasa.com/t/database-mysql-conncectivity-for-custom-actions/5592/52 "2020-05-06T13:20:28Z")

</div>

Hi, @JiteshGaikwad if possible Can u please tell me how to get the same response in button form?

---

<div class="post-metadata">

**Author:** ![deepali0162](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@deepali0162](https://forum.rasa.com/u/deepali0162)\
**Post date:** [September 17, 2021, 9:32am UTC](https://forum.rasa.com/t/database-mysql-conncectivity-for-custom-actions/5592/53 "2021-09-17T09:32:14Z")

</div>

Hi @JiteshGaikwad , I am similar code to fetch data from db. The reference you have given is not accessible. Could you please share updated link for help?

Thanks in advance!!

[Previous page](https://forum.rasa.com/t/database-mysql-conncectivity-for-custom-actions/5592.md?page=2)
