Within the following code snippet lies a custom endpoint that aims to extract data from the saic3_LibraryIndex database.
<?php
add_action('rest_api_init', function () {
register_rest_route('libraries/v1', '/all', array(
'methods' => 'GET',
'callback' => 'retrieve_libraries'
) );
} );
function retrieve_libraries( $data ) {
global $saic3_LibraryIndex;
$query = "SELECT * FROM `Library`";
$list = $saic3_LibraryIndex->get_results($query);
return $list;
}
In my JavaScript, I trigger an ajax call on page load to dynamically populate the page with data from the database. Currently, I'm using this call to confirm if I am receiving any data.
<script type="text/javascript">
jQuery(document).ready(function( $ ){
$.ajax({
url: "/wp-json/libraries/v1",
method: 'GET',
success: function(response) {
console.log(response);
},
failure: function(err) {
console.log(err);
}
});
});
</script>
The route is successful in hitting and not resulting in a 404 error, but the response I receive back is empty. The response looks like this:
{namespace: "libraries/v1", routes: {…}, _links: {…}}
namespace
:
"libraries/v1"
routes
:
/libraries/v1
:
endpoints
:
[{…}]
methods
:
["GET"]
namespace
:
"libraries/v1"
_links
:
{self: "{`my-url-.com`/wp-json/libraries/v1"}
__proto__
:
Object
/libraries/v1/all
:
endpoints
:
[{…}]
methods
:
["GET"]
namespace
:
"libraries/v1"
_links
:
{self: "`my-url-.com`/wp-json/libraries/v1/all"}
__proto__
:
Object
__proto__
:
Object
_links
:
up
:
[{…}]
__proto__
:
Object
__proto__
:
Object
Being new to WordPress, any guidance on this matter would be highly appreciated. I was informed that the database is named saic3_LibraryIndex, which I assumed would replace wpdb. I also attempted switching it to wpdb and fetching local posts, but the console still displays the same response. I strongly believe that the endpoint is incorrectly written, but I lack the knowledge to correct it.