CRUD Operation on WordPress Database Using C# And REST API

Abstract

Purpose:  IoT is famous for research with sensor data. The standard way is to keep sensor data inside IoT platforms like AWS, Google, and Microsoft Azure cloud. We must pay to keep or exchange the data among different systems. Here, we provide a different approach to keep our research data inside the cloud. We created a communication channel using the C# application and WordPress website database over REST API, which is now widespread. Our data format is JSON, which is the industry standard. Upload data to the website database using an HTTP client from the C# application. The uploaded data can be accessible from anywhere among the various systems. Our website runs round the clock, so our data is always available. This procedure might be cheaper than the available solution due to the use of our existing website database. Through the practical approach, we demonstrate how to do that. This procedure can be helpful for the researcher trying to keep their research data at a cheap cost inside the cloud. The complete project code is available to download, and the value addition to this work.

Design/Methodology/Approach: We first install “Local” software inside our system. On that, we installed a WordPress website. Then, we create a custom route for our experiment to differentiate from existing website content inside the server using PHP. Then, we added our module, which provides CURD operation. This module receives JSON-structured content, which is converted by the WordPress engine. The module parses the command and processes it accordingly. The response is returned to the client application. We created a C# application with a couple of GUI elements to interact with the user. We added a couple of modules using the Nuget package manager for REST API. After the application opens, the first action is to connect with the database. Once the database is available, CRUD operation can be executed.

Findings/Result:  We tested the entire project using practical deployment. The performance is pretty good. A small quantity of network latency is present in our observation. The content updation time depends on website bandwidth, network traffic, the system’s specification, and the number of running applications. 

Originality/Value:  Over the net, there is some practical documentation on C# REST API on the WordPress Website. Sometimes, researchers working on WordPress websites want to use database operation over REST API. Here, we demonstrate this through practical examples. So, it is a slightly different approach for quickly understanding the communication flow.

Paper Type: Experimental-based Research.