{"id":172926,"date":"2023-11-05T11:23:02","date_gmt":"2023-11-05T10:23:02","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=172926"},"modified":"2023-11-05T11:31:08","modified_gmt":"2023-11-05T10:31:08","slug":"api-integration-in-python-databases-made-easy","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy","title":{"rendered":"API Integration in Python: Databases Made Easy"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"172926\" class=\"elementor elementor-172926\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-705c924 e-flex e-con-boxed e-con\" data-id=\"705c924\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-52d3124 elementor-widget elementor-widget-text-editor\" data-id=\"52d3124\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>In our first article, we looked at some of the principles involved in building REST <a href=\"https:\/\/datascientest.com\/en\/api-the-path-to-seamless-integration\">APIs<\/a>, as well as a first example of their implementation in Python using Flask.<br \/>In this example, data was integrated into the code in the form of a list of dictionaries.<br \/>We also have an article on how to program and document an <strong>API with python, flask, swagger and connection.<\/strong><br \/>In the following example, we&#8217;ll look at how to connect an API to an <a href=\"https:\/\/datascientest.com\/en\/all-about-non-relational-databases\">external relational database<\/a> and allow items to be filtered by various conditions:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9814989 e-flex e-con-boxed e-con\" data-id=\"9814989\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-05dfbf6 elementor-widget elementor-widget-text-editor\" data-id=\"05dfbf6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ol>\n \t<li><a href=\"#API1\">Relational databases<\/a><\/li>\n \t<li><a href=\"#API2\">SQLite<\/a><\/li>\n \t<li><a href=\"#API3\">Connecting an API to the Chinook database<\/a><\/li>\n \t<li><a href=\"#API4\">Understanding the new API<\/a><\/li>\n \t<li><a href=\"https:\/\/datascientest.com\/programmer-et-documenter-une-api-avec-python-flask-swagger-et-connexion\">Using the new API<\/a><\/li>\n \t<li><a href=\"#API6\">Bibliographical references<\/a><\/li>\n<\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6d0ed1c elementor-widget elementor-widget-menu-anchor\" data-id=\"6d0ed1c\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\nbody.elementor-page .elementor-widget-menu-anchor{margin-bottom:0}<\/style>\t\t<div id=\"API1\" class=\"elementor-menu-anchor\"><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-520ca89 e-flex e-con-boxed e-con\" data-id=\"520ca89\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-dd4138d elementor-widget elementor-widget-heading\" data-id=\"dd4138d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h3 class=\"elementor-heading-title elementor-size-default\">1. Relational databases<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-751cfce elementor-widget elementor-widget-text-editor\" data-id=\"751cfce\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Relational databases store and retrieve data in the form of tables.<\/p><p>Tables are <strong>similar to spreadsheets:<\/strong> they <a href=\"https:\/\/datascientest.com\/en\/how-do-i-insert-columns-and-rows-in-excel\">have rows and columns,<\/a> with the columns indicating what the data corresponds to, such as a title or a date. The rows represent individual data items, which may correspond to users, transactions or any other type of entity.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3ea4ce9 elementor-widget elementor-widget-menu-anchor\" data-id=\"3ea4ce9\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"API2\" class=\"elementor-menu-anchor\"><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-de7e495 e-flex e-con-boxed e-con\" data-id=\"de7e495\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-432c781 elementor-widget elementor-widget-heading\" data-id=\"432c781\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2. SQLite<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b564f8e elementor-widget elementor-widget-text-editor\" data-id=\"b564f8e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The database engine used in the suite is SQLite, a very lightweight database engine available under Python by default.<\/p><p>The standard extension for <strong>SQLite files is .db.<\/strong><\/p><p>The database used is the Chinook database (available via the following link), comprising 11 tables. In the following, we&#8217;ll be focusing on the employees table: this contains data on employees of the Chinook company, such as their ID, surname, first name, etc.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-01a21f8 elementor-widget elementor-widget-menu-anchor\" data-id=\"01a21f8\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"API3\" class=\"elementor-menu-anchor\"><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-47ed58f e-flex e-con-boxed e-con\" data-id=\"47ed58f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6bb2741 elementor-widget elementor-widget-heading\" data-id=\"6bb2741\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">3. Connecting an API to the Chinook database<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9280f0e elementor-widget elementor-widget-text-editor\" data-id=\"9280f0e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We start by copying the chinook.db database into our api directory.<\/p><p>Our <strong>API will query this database<\/strong> to return the desired results to users.<\/p><p>The corresponding code is as follows:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-36f7d15 elementor-widget elementor-widget-shortcode\" data-id=\"36f7d15\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\"><script src=\"https:\/\/gist.github.com\/ssime-git\/3877cb9e2c7c657270e0882d9db89593.js\"><\/script><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-113f3aa elementor-widget elementor-widget-text-editor\" data-id=\"113f3aa\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We save it in the api directory under the name api4.py.<\/p><p>To run it, launch a command line window from the api directory and <strong>enter the following commands:<\/strong><\/p><p><strong>$ export FLASK_APP = api4.py<\/strong><\/p><p><strong>$ export FLASK_ENV = development<\/strong><\/p><p><strong>$ flask run<\/strong><\/p><p>(to stop execution, press Ctrl-C).<\/p><p>Among other messages, you get<\/p><p>* Running on http:\/\/127.0.0.1:5000\/ (Press CTRL+C to quit)<\/p><p>Once the program has run, you can submit requests like :<\/p><p>http:\/\/127.0.0.1:5000\/api\/v1\/resources\/employees\/all<\/p><p>http:\/\/127.0.0.1:5000\/api\/v1\/resources\/employees?LastName=Edwards<\/p><p>http:\/\/127.0.0.1:5000\/api\/v1\/resources\/employees?LastName=Edwards&City=Calgary<\/p><p>http:\/\/127.0.0.1:5000\/api\/v1\/resources\/employees?City=Calgary<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-10fa5d2 elementor-widget elementor-widget-text-editor\" data-id=\"10fa5d2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The employees table in the Chinook database has 8 records, one for each Chinook employee.<\/p><p><br \/>The data includes, among other things, the employee&#8217;s ID, surname, first name, city of residence, date of birth and date of recruitment.<\/p><p><br \/>Our API allows filtering by three fields: EmployeeId, LastName and City.<\/p><p><br \/>The new API responds to user requests by extracting information from the database using SQL queries.<\/p><p><br \/>It also enables filtering by more than one field.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cf87bb5 elementor-widget elementor-widget-menu-anchor\" data-id=\"cf87bb5\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"API4\" class=\"elementor-menu-anchor\"><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f580ba1 e-flex e-con-boxed e-con\" data-id=\"f580ba1\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d914b2f elementor-widget elementor-widget-heading\" data-id=\"d914b2f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">4. Understanding the new API<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c2d3da6 elementor-widget elementor-widget-text-editor\" data-id=\"c2d3da6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The employees table in the Chinook database is made up of eight columns: EmployeeId, LastName, FirstName, Title, ReportsTo, BirthDate, HireDate and Address.<\/p><p>Each row represents a Chinook employee.<\/p><p>Rather than specifying the data in the code, our api_all function <a href=\"https:\/\/datascientest.com\/en\/database-what-is-it\">extracts it from the Chinook database:<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6ab13aa elementor-widget elementor-widget-shortcode\" data-id=\"6ab13aa\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\"><script src=\"https:\/\/gist.github.com\/ssime-git\/f101abdafe7fe0bf2f3fd33cc858ee5c.js\"><\/script><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bb42f9d elementor-widget elementor-widget-text-editor\" data-id=\"bb42f9d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We start by <strong>connecting to the database<\/strong> using the sqlite3 library.<\/p><p>An object representing the database connection is bound to the conn variable.<\/p><p>The instruction conn.row_factory = dict_factory tells the object corresponding to the connection to use the dict_factory function, which returns results as dictionaries rather than lists &#8211; which converts better to JSON format.<\/p><p>We then create a cursor object (cur = conn.cursor( )), which scans the database to extract the data.<\/p><p>Finally, we execute a <a href=\"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function\">SQL query<\/a> using the cur.execute method to extract all available data ( * ) from the employees table in our database.<\/p><p>At the end of our function, the retrieved data is converted to JSON format: jsonify(all_employees).<\/p><p>The other function returning data, api_filter, uses the same approach to extract specific data from the database.<\/p><p>The purpose of the page_not_found function is to create an error page displayed to the user if he specifies a route that is not supported by the API:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a22c066 elementor-widget elementor-widget-shortcode\" data-id=\"a22c066\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\"><script src=\"https:\/\/gist.github.com\/ssime-git\/74a72f71cf8d48f73548d7658ed7307a.js\"><\/script><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c30aaef elementor-widget elementor-widget-text-editor\" data-id=\"c30aaef\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In HTML results, code 200 means &#8220;OK&#8221; (data transferred), while code 404 means &#8220;not found&#8221; (no resources available at the specified address).<\/p><p>The page_not_found function returns 404 if something goes wrong.<\/p><p>The api_filter function filters according to three fields: EmployeeId, LastName and City.<\/p><p>It begins by identifying all the query parameters supplied in the URL, using the instruction :<\/p><p>query_parameters = request.args<\/p><p>It then retrieves the parameter values and binds them to variables:<\/p><p>employeeid = query_parameters.get(&#8216;EmployeeId&#8217;)<\/p><p>lastname = query_parameters.get(&#8216;LastName&#8217;)<\/p><p>city = query_parameters.get(&#8216;City&#8217;)<\/p><p>The following code portion is used to build an SQL query which is used to extract the required information from the database.<\/p><p>The simplest SQL queries are of the form :<\/p><p>SELECT &lt;columns&gt; FROM &lt;table&gt; WHERE &lt;column=match&gt; AND &lt;column=match&gt;;<\/p><p>To obtain the data you&#8217;re looking for, you need to build both an SQL query of the type described above and a list with the specified filters (values).<\/p><p>We begin by defining the query and the list of filters:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f53b863 elementor-widget elementor-widget-shortcode\" data-id=\"f53b863\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\"><script src=\"https:\/\/gist.github.com\/ssime-git\/949fe43fdeca328ad79d76ed6afa022e.js\"><\/script><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ae66be8 elementor-widget elementor-widget-text-editor\" data-id=\"ae66be8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Then, if EmployeeId, LastName and City have been passed as query parameters, they are added to the query and to the filter list:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-20f2d5b elementor-widget elementor-widget-shortcode\" data-id=\"20f2d5b\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\"><script src=\"https:\/\/gist.github.com\/ssime-git\/f12f7f5be78826b1e6ac416bd8f78a88.js\"><\/script><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-329ffa7 elementor-widget elementor-widget-text-editor\" data-id=\"329ffa7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400; color: #000000;\">If the user has not specified any of these query parameters, the 404 error page is returned:<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6c4de62 elementor-widget elementor-widget-shortcode\" data-id=\"6c4de62\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\"><script src=\"https:\/\/gist.github.com\/ssime-git\/d7393d2144759971c096649897bbe3ac.js\"><\/script><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-81b4e8b elementor-widget elementor-widget-text-editor\" data-id=\"81b4e8b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400; color: #000000;\">To perfect our SQL query, we delete the last AND and complete the query with the semicolon required by SQL :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-062c334 elementor-widget elementor-widget-shortcode\" data-id=\"062c334\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\"><script src=\"https:\/\/gist.github.com\/ssime-git\/014c247926489cafcfe16d1341eee46d.js\"><\/script><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-25ffb57 elementor-widget elementor-widget-text-editor\" data-id=\"25ffb57\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400; color: #000000;\">Next, we connect to the database, then execute the SQL query built using our list of filters:<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-38a06ec elementor-widget elementor-widget-shortcode\" data-id=\"38a06ec\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\"><script src=\"https:\/\/gist.github.com\/ssime-git\/11389b002316cf3ae75ca02c70d867bf.js\"><\/script><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d2ebe96 elementor-widget elementor-widget-text-editor\" data-id=\"d2ebe96\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Finally, we return the results in JSON format to the user:<\/p><p>return jsonify(results)<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7f26c1a elementor-widget elementor-widget-menu-anchor\" data-id=\"7f26c1a\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"API5\" class=\"elementor-menu-anchor\"><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f2d33c0 e-flex e-con-boxed e-con\" data-id=\"f2d33c0\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7ad877d elementor-widget elementor-widget-heading\" data-id=\"7ad877d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">5. Using the new API<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-10d0c8c elementor-widget elementor-widget-text-editor\" data-id=\"10d0c8c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Our new<strong> API<\/strong> enables more sophisticated user queries.<\/p><p>What&#8217;s more, as soon as new data is added to the database, it becomes immediately available to projects built using the API.<\/p><p>So, in many cases, it makes sense to start by creating an <strong>API-like interface<\/strong> for project data before building a data-driven visualization, application or website.<\/p><p>In the next article, we&#8217;ll expand on the techniques presented earlier to see how to program a professional REST API in Python using Flask, OpenAPI (formerly Swagger) and Connexion.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cbddbc2 elementor-widget elementor-widget-menu-anchor\" data-id=\"cbddbc2\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"API6\" class=\"elementor-menu-anchor\"><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f807f09 e-flex e-con-boxed e-con\" data-id=\"f807f09\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b10f927 elementor-widget elementor-widget-heading\" data-id=\"b10f927\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">6. References<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e7a993f elementor-widget elementor-widget-text-editor\" data-id=\"e7a993f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li><em>Creating Web APIs with Python and Flask, Patrick Smyth : <a href=\"https:\/\/programminghistorian.org\/en\/lessons\/creating-apis-with-python-and-flask\">https:\/\/programminghistorian.org\/en\/lessons\/creating-apis-with-python-and-flask<\/a>.<\/em><\/li><li><em>Flask RESTful documentation : <a href=\"https:\/\/flask-restful.readthedocs.io\/en\/latest\/index.html\">https:\/\/flask-restful.readthedocs.io\/en\/latest\/index.html<\/a>.<\/em><\/li><li><em>Flask Web Development : Developing Web Applications with Python (2\u00e8me \u00e9dition). M. Grinberg. O\u2019Reilly 2018.<\/em><\/li><li><em>Architectural Styles and the Design of Network-Based Software Architectures. T. Fielding. Th\u00e8se, Universit\u00e9 de Californie, 2000.<\/em><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>In our first article, we looked at some of the principles involved in building REST APIs, as well as a first example of their implementation in Python using Flask.In this example, data was integrated into the code in the form of a list of dictionaries.We also have an article on how to program and document [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":172927,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>API Integration in Python: Databases Made Easy<\/title>\n<meta name=\"description\" content=\"Learn the seamless process of API integration in Python. Harness the power of data integration for your projects and applications with step-by-step guidance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"API Integration in Python: Databases Made Easy\" \/>\n<meta property=\"og:description\" content=\"In our first article, we looked at some of the principles involved in building REST APIs, as well as a first example of their implementation in Python\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-05T10:23:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-05T10:31:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/api-python-datenbank.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"843\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"API Integration in Python: Databases Made Easy\",\"datePublished\":\"2023-11-05T10:23:02+00:00\",\"dateModified\":\"2023-11-05T10:31:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy\"},\"wordCount\":1075,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy\",\"url\":\"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy\",\"name\":\"API Integration in Python: Databases Made Easy\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2023-11-05T10:23:02+00:00\",\"dateModified\":\"2023-11-05T10:31:08+00:00\",\"description\":\"Learn the seamless process of API integration in Python. Harness the power of data integration for your projects and applications with step-by-step guidance.\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"API Integration in Python: Databases Made Easy","description":"Learn the seamless process of API integration in Python. Harness the power of data integration for your projects and applications with step-by-step guidance.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy","og_locale":"en_GB","og_type":"article","og_title":"API Integration in Python: Databases Made Easy","og_description":"In our first article, we looked at some of the principles involved in building REST APIs, as well as a first example of their implementation in Python","og_url":"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-11-05T10:23:02+00:00","article_modified_time":"2023-11-05T10:31:08+00:00","og_image":[{"width":1536,"height":843,"url":"https:\/\/datascientest.com\/en\/files\/2023\/11\/api-python-datenbank.webp","type":"image\/webp"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"API Integration in Python: Databases Made Easy","datePublished":"2023-11-05T10:23:02+00:00","dateModified":"2023-11-05T10:31:08+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy"},"wordCount":1075,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy","url":"https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy","name":"API Integration in Python: Databases Made Easy","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2023-11-05T10:23:02+00:00","dateModified":"2023-11-05T10:31:08+00:00","description":"Learn the seamless process of API integration in Python. Harness the power of data integration for your projects and applications with step-by-step guidance.","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/api-integration-in-python-databases-made-easy"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/172926"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=172926"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/172926\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/172927"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=172926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=172926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=172926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}