How to get the most recently updated orders via the REST API?

As it turns out, it’s only possible to query the orders after a certain time with the legacy v3 WooCommerce REST API with the filter[updated_at_min] parameter, not with the new v3 WooCommerce REST API.

I also want to query the customers who recently updated their data, which is impossible with any versions of the WooCommerce REST API to my knowledge.

It’s possible to extend the WooCommerce REST API, but I’m fed up with the limitation and slowness of the REST API, and I also dislike PHP, so I’ll probably end up directly querying the WordPress MySQL database from our ERP that uses node.js.

This post describes the related MySQL tables quite well.

Related Posts:

  1. Is the WordPress REST API installed and enabled in a vanilla WordPress 4.7 installation?
  2. check the requesting url
  3. WP REST API Require Password for GET Endpoint
  4. Getting user meta data from WP REST API
  5. WP REST API V2 – Retrieve sub page by full slug (URL/Path)
  6. Increase per_page limit in REST API
  7. Can’t send emails through REST API
  8. WP REST API: check if user is logged in
  9. How to login to WordPress site using basic authentication HTTP headers?
  10. Adding post fields in wp-json/wp/v2/search
  11. Unable to get the info of the user which doesn’t have created any post via REST API
  12. WordPress Gutenberg get page template value when post updated?
  13. WP Rest API convert permalink to post ID for fetch
  14. Can’t GET draft posts via REST API from headless frontend
  15. How to update custom meta fields with rest api?
  16. Formating content rendered from wordpress REST API as JSON and not HTML
  17. Rest API and Custom Fields
  18. How to filter users on custom meta fields in WP JSON v2?
  19. How can I return an image from a custom REST API endpoint?
  20. WordPress REST API, Expired Nonce from Cache results in 403 forbidden
  21. WP Rest API: Get User by Email
  22. Gutenberg Custom Block Getting All Posts
  23. Check Password Strength using WordPress API
  24. Send request to WordPress REST API
  25. Request to REST endpoint works fine in browser and curl, but fails from WP_REST_Request
  26. WP REST api.wordpress.org discovery
  27. Rest API in integration tests – filtering by slug not working?
  28. How to hook into “register_rest_field” to modify the behavior of a custom field?
  29. How do you format the set_body option for WP_Rest_Request?
  30. Get all PDF files from page with WordPress API
  31. current_user_can(‘administrator’) returns false when I’m logged in
  32. How to add / embed an author into REST data from a custom post type?
  33. featured image not found in json from wp rest api
  34. How to enable the view of revisions of post in WordPress Api for custom post type?
  35. Problem on creating custom endpoints for REST
  36. New user signup via REST API
  37. is it possible to filter a rest api endpoint by using a registered rest field?
  38. rendering view in backbone
  39. Update a post based on results from GET request to another server
  40. WP REST API can’t set post tags
  41. Manipulating/view postmeta remotely
  42. WP API post__not_in is not working
  43. Check authentication credentials using WP REST API
  44. WordPress REST API V2: how to get list of all posts?
  45. Getting 401 from ajax using an application password
  46. How to connect android app with WordPress website?
  47. WordPress REST API calls that depend on the WordPress User
  48. Sidebar endpoint using WordPress API
  49. How to get data from /wp-json/wp/v2/users/me
  50. Get custom posts in gutenberg block
  51. WordPress REST API parameters are not affecting a response
  52. Getting 401 (access denied) when trying to use the REST API
  53. Update meta_value in wp_postmeta using API
  54. WordPress plugin with CORS
  55. WordPress REST API not working on localhost
  56. User following system via REST API
  57. REST API – Allow /users endpoint depending on a custom capability
  58. “Error: cURL error 60: SSL certificate problem: certificate has expired” when create product in WooCommerce via REST API
  59. 403 Error When Fetching Data from the Settings Rest Route for Non-Admin Users
  60. How to use WordPress REST api to login a user?
  61. REST API post times out when content is too large
  62. Can I overwrite default WordPress Json API For no more pages text
  63. Secure WordPress API, how?
  64. Create User with Profile and Cover Images using REST API
  65. Wrong encoding of dynamic block properties problem when loggen in as editor
  66. Media gallery images url instead of ID on WP API
  67. What’s the right way to validate JSON data coming from an AJAX POST request?
  68. Remove unwanted fields from WP API response
  69. Need wp rest api for featured video post
  70. WordPress and React how to integrate? [closed]
  71. WordPress API “code”:”rest_no_route” with Custom Route
  72. Using WordPress solely as a Backend – dealing with WP_SITEURL
  73. WordPress Update Role using API Cross site
  74. Rest API. Post content
  75. Error rest_post_invalid_page_number trying to call Rest API
  76. Is it possible to combine two rest endpoints in the url?
  77. use WordPress Rest API to build a web application
  78. REST Request Post including meta/custom fields
  79. Why wp_set_password not working within a api endpoint?
  80. WordPress api returns distinct data
  81. Redefine REST API variables
  82. How to use WordPress rest API with Angularjs 4 [closed]
  83. Retrieve posts by page in wp rest api
  84. Where is the HTML content for my post in the API
  85. How to change WordPress api v2
  86. REST API Integration without user account?
  87. WordPress Rest API Escapes Returned URLs Forward Slash
  88. WP_REST_Request::get_json_params() Parsing null as Zero
  89. WP REST API with Basic Auth at target website
  90. API request forbidden when requesting from same domain
  91. Custom WP Rest API Endpoints from JSON Schema
  92. Get custom data from the user REST API endpoint
  93. Custom rest api endpoint response json problem
  94. How can I set the default ‘orderby’ and ‘order’ parameters for a REST API call?
  95. JS WordPress API fetch no response headers
  96. Woocommerce API for calling products by Category ID
  97. Rest API nonce is being cached
  98. WordPress custom endpoint returns Security violated
  99. custom REST endpoints and application passwords
  100. wordpress rest api authentication failed