I eventualy worked out a solution for my restaurants
table, which sits alongside the wp_*
tables in my WP database. Hope this helps
add_action( 'rest_api_init', function () {
register_rest_route( 'restos/v1', '/all', array(
'methods' => 'GET',
'callback' => 'handle_get_all',
'permission_callback' => function () {
return current_user_can( 'edit_others_posts' );
}
) );
} );
function handle_get_all( $data ) {
global $wpdb;
$query = "SELECT qname, rname, recommendation FROM `restaurants`";
$list = $wpdb->get_results($query);
return $list;
}
I have variations on this theme for all the CRUD actions I need
Related Posts:
- How to: Make JWT-authenticated requests to the WordPress API
- Understanding SHORTINIT with WordPress 5
- WP REST API create post authentication issue
- Why is my custom API endpoint not working?
- Are there server performance benefits to fetching only specific fields when querying the REST API?
- How to define a query parameter with REST API?
- How do I correctly setup an AJAX nonce for WordPress REST API?
- Using the REST API (v2) javascript client on a private namespaced route
- Hiding API routes list
- Filter post_content before loading in Gutenberg editor
- rest api authentication
- Does accessing WordPress via REST API affect the site stats and analytics?
- Wp Rest Api Custom Endpoint for page subpages
- x-wp-nonce is not allowed by Access-Control-Allow-Headers in preflight response
- How to get around WP REST API per page limit without pagination?
- How to properly add custom entities in Gutenberg
- REST API custom endpoint without authentication for POST method?
- CORS & Remote access to WP via RestAPI
- Create Session with JWT
- WP API ignores filter parameter
- WordPress doesn’t send a notification email when submitting a comment using REST API
- Using WordPress RESTapi to call a php file instead of post or page
- WordPress REST API – Modify JSON before importing
- Can you Use the Rest API to query a custom database table
- pagination in WP rest api
- Is there anyway to format my EndPoint URL in WordPress?
- Return WP_Error as WP_REST_Response
- How to use REST API to send user metadata?
- Can the new REST API now make WP into it’s own push notification server?
- Confused about AngularJS and WordPress
- Post API tax_relation field doesn’t work
- What is the meta field in the response of the user REST API?
- How to post an unserialized array via wordpress rest API as meta data
- Is there any way to clear cache when making REST API request?
- Use the backbone.js client to save custom post type meta
- Override WordPress POST REST API
- Creating a custom endpoint for rest, I see the endpoint exists in the wp-json, but the request is returning 404
- WordPress + Vue — Single page app giving me 404s when I use query params
- No ‘Access-Control-Allow-Origin’ when call rest API
- Get subscribers via REST API and send post notification
- Custom API endpoint to create gallery for post
- Register REST route with a multi-value parameter
- How do I add meta when creating a post with rest api?
- How to Get Featured Image from REST API?
- Allow “wp-admin” edit access through headless WP web application
- WordPress + REST API v2 and private pages Load by slug
- Validate rest-api call on create
- Error invalid parameters with REST API
- How to get featured image in WP rest api
- WordPress REST API rest_comment_invalid_author Sorry, you are not allowed to edit ‘author’ for comments
- How to delete user using rest api without reassigning
- How to send the body in wp_remote_post as “raw”?
- Accessing private posts through REST API, same code that works in remote doesn’t in local
- REST API and filtering by meta value
- Rest API: trouble receiving response through script (browser and Postman display correctly)
- Advanced Access Manager: RESTful endpoint to refresh token
- Custom Endpoints not working
- Is there a way I can fetch the WordPress Developer Code References with an API?
- Pull in ALL posts from the last two weeks using Rest API
- Extending REST API responses
- 403 error when publishing a post in wordpress. Error => Publishing failed. The response is not a valid JSON response
- Cannot use WordPress Application Passwords: “code”: “rest_no_route” “status”:404 for /wp-json/wp/v2/users/me/application-passwords
- How to add Relations of a CCT from JetEngine via WordPress Rest API
- Pass multiple tags slug to rest API
- Return a WP_REST_Response from an inner function (and not from the root callback)
- register_rest_route with method POST but in wp-json/ is showing GET
- Rest Api fetching only one random post
- WP REST API returns empty posts despite entries in wp_posts
- Accessing Custom REST endpoint with rest_do_request()
- How to add taxonomy to a post using WP REST API?
- WP CLI in WP 5.3 with PHP 7.4
- The REST API encountered an error in wordpress?
- Get wordpress post with featured image, category and tag from WordPress API
- Do something when publish a post in Gutenberg with hook rest_after_insert_post
- Uploading picture via REST API
- How to modify the HTML output of Gutenberg block? (Youtube)
- Can I use REST API if the site is protected with .htpasswd
- REST API and Loopback error
- Rest API: Register and Login errors aren’t specific
- Fetching all users that didn’t post with rest api (current version 2)
- Calling a python script from custom wordpress rest api returns null
- Autotrader API Integration
- Fix Characters WordPress Ionic App
- Accessing secure endpoint with X-WP-Nonce?
- Return all custom taxonomy terms for post in REST API v2? Currently limited to 10 terms
- Can we use website data which is having wp rest api plugin?
- WP Rest API V2 OR Operator in URL
- how can I add an URL parameter to a rest route using register_rest_route()?
- Is it possible to bulk update a table using WP Rest API?
- Call to undefined function upload_is_user_over_quota()
- Rest api request throttling
- Delete row from table using custom endpoint via API
- Fetch post by author slug
- Cant POST with REST API on WordPress
- How can I set the default ‘orderby’ and ‘order’ parameters for a REST API call?
- Problem with custom WordPress Rest API search route with query parameters
- What filtering is available for backbone.js?
- How to limit what fields are returned through the WP API Backbone JS client
- Woocommerce API for calling products by Category ID
- wordpress rest api authentication failed