Does this plugin expose all WordPress data?

  • Resolved systamper

    (@systamper)


    8 months ago

    Hi. I am just starting to research to get API access to all my data (to build an external report). I want to be able to show all new users. All new orders added. New appointments. etc. All this data either comes from native WordPress tables or from tables created by plugins. Does the WP-Data-Access let me create an API to access this other data? Or does it only work with tables created directly for use by this plug in?

    Hopefully this question makes sense. Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    8 months ago

    Hi @systamper

    Thank you for reaching out, and yes, your question certainly makes sense.

    The REST API allows you to access all your tables and views stored in both your local and remote databases. This works for WordPress, plugin, and custom tables and views. Just make sure to set authorization properly.

    You can find the REST API documentation here:
    https://wpdataaccess.com/docs/rest-api/getting-started-rest-api/

    Hope this helps,
    Peter

    Thread Starter systamper

    (@systamper)

    8 months ago

    Thanks, Peter. My use case is that I want to be able to connect from an external location (e.g. Micros ft Power BI workspaces) to build reports against my data. So to be clear, will this create endpoints I can access from outside? Or do I just need to stick to the normal WP API to get to that data? It SOUNDS like this plugin simplifies that process, which is what I am hoping for. Again, I really appreciate your help.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    8 months ago

    Hi @systamper

    Yes, you can use the WP Data Access REST API to access your tables and views from outside. For each individual table and view, you need to:
    – enable the REST API
    – enabled supported HTTP methods
    – enable anonymous access

    If you only need to read data, ensure that the REST API for inserting, updating, and deleting is disabled (this is the default setting).

    Let us know if you need any help,
    Peter

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Does this plugin expose all WordPress data?’ is closed to new replies.