# Newbie Question - JSON, MySQL

**URL:** <https://community.dreamfactory.com/t/newbie-question-json-mysql/4552>\
**Category:** REST API\
**Created:** [July 27, 2018, 1:58pm UTC](https://community.dreamfactory.com/t/newbie-question-json-mysql/4552 "2018-07-27T13:58:42Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jabber](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jabber/32/1192_2.png) [@Jabber](https://community.dreamfactory.com/u/Jabber)\
**Post date:** [July 27, 2018, 1:58pm UTC](https://community.dreamfactory.com/t/newbie-question-json-mysql/4552/1 "2018-07-27T13:58:42Z")

</div>

I would like to connect to external resource and query records(customer,email) for a specific time frame and then retrieve them to either send an email from a script or store them into a database, then send the email. I’m thinking that storing into the db then sending the email would be best practice?

Not sure where to start.

Thanks!