This plan helps you to integrate the external/ third-party REST API endpoints in WordPress such that you can perform operations on these External / Third-Party API endpoints on any of the WordPress or third-party plugin events by embedding the WordPress hook specific to the External API connection provided by this plugin. This plan also provides the feature to generate the custom REST endpoints in WordPress specific to your own complex SQL query.

1. Use cases for Custom REST API Plugin [Enterprise] version

Directly fetch/get the data from a given REST API endpoint provided by third-party/external provider to display it on WordPress site

• Suppose you have REST API endpoint provided by your API provider and want to fetch the data from the API provider side, then it can be very easy to fetch the data within seconds in whatever format you want directly to the WordPress backend by this plugin’s External APIs integration feature and these data can further be used to display on your WordPress site. Also you will be able to pass the real-time data to the API endpoint request. The plugin provides a WordPress hook which can be used whenever a call to External API is required.

Call External(Non-WordPress) RESTs API based on third-party plugin form submission events

• Suppose you have a WordPress site integrated with any external/third-party provider and want to perform some actions like register/sign in/delete members on the third-party provider side or want to fetch/update some other data by making the REST APIs call to the provider based on events like WPforms,Gravity Forms, Elementor, Contact-form7 or any other etc forms submission for all these events. The plugin provides the WordPress hook specific to the External/third-party API connections made in the plugin. The hook can be easily integrated further dynamically with all the forms and run on the submission and also provide you the status of the API call.

Integrate External REST APIs on Payment gateways

• Suppose you have a payment gateway like PayPal, Stripe or any other that are provided by Woocommerce, Wpforms, Stripe plugin or any other plugin embedded in your WordPress application and you want to to call specific APIs to update the user status, membership level etc on the third-party API provider based on the payment status and amount, so this can easily be achieved by using the hook provided by our plugin for this external REST API endpoints integrated and this hook can be embedded directly into the gateways and run only based on the transaction status.

Sync/Fetch data from Supplier’s external API into Woocommerce (Integrate External API into Woocommerce)

• Suppose you have the external APIs provided by your Supplier’s(Distributor) and want to sync that real-time data fetched from these external APIs into Woocommerce to display these data/ products, then this plugin provides you with the feature to connect any external API into your WordPress and these API can be called in the backend using the developer hooks to sync the real time data with Woocommerce products/items feeds and can be displayed on your site.
• Click here to know more about WooCommerce Product Sync via APIs.

Note: Our plugin will generate the WordPress developer hook specific to each External API Connection configured and saved in the plugin. You can use these developer hooks on your own to integrate these to the backend wherever that specific external API call is required. In case you are also looking to integrate these developer hooks on the backend according to your requirements, please contact apisupport@xecurify.com to know more and let us know your complete requirements.

2. Steps to configure Custom REST API Endpoints request with different Methods

3. Generate Custom REST API endpoints using custom SQL in WordPress

• To use this feature go to ‘Create Custom SQL API tab’ in the plugin.

• For GET Method:

Sample SQL query → Select * from custom_table NATURAL JOIN custom_table2 where ID={{custom_param1}};

Sample API request format → 
<Your domain>/wp-json/mo/v1<api name>?custom_param1=2

                  

• For POST Method:

Sample SQL query → INSERT INTO custom_table (ID, name, email, status) VALUES ('{{custom_param1}}','{{custom_param2}}','{{custom_param3}}','{{custom_param4}}');

Sample API request format → curl -d "custom_param1=2&custom_param2=testuser&custom_param3=testuser@gmail.com&custom_param4=1” -X POST <Your domain>/wp-json/mo/v1/<api name>

                  

• For PUT Method:

Sample SQL query→ UPDATE custom_table SET 
ID='{{custom_param1}}',name='{{custom_param2}}',email='{{custom_param3}}',status='{{custom_param4}}' WHERE ID={{custom_param5}};


Sample API request format → curl -d "custom_param1=2&custom_param2=testuser&custom_param3=testuser@yahoo.com&custom_param4=1&custom_param5=2" -X PUT <Your domain>/wp-json/mo/v1/<api name>
                  

• For DELETE Method:

Sample SQL query→ DELETE FROM custom_table WHERE ID={{custom_param1}};

Sample API request format → curl -d "custom_param1=0" -X DELETE<Your domain>/wp-json/mo/v1/<api name>

                  

Note 1:Please pass the arguments as per the sequence/order as mentioned in the above sample SQL query and sample API request examples.

Note 2:The custom attribute passed in the query should be in the following format “custom_param<i>” where i is the integer value that starts from 1 and increases as the number of custom parameters increases in the SQL query and also should be passed in the incremental sequence as shown in the above examples.