I feel like I am missing something simple as this works normally for SQL databases but not CouchDB databases. I have a need to where I would want to sync a CouchDB database with another database where I am pulling the data via Rest API, which that part works fine and I can insert data in. I would also want to Update and Delete data as needed which is where I am having issues.
The issue I am having is I am unable to delete or update CouchDB data using the normal Database Query and Database Delete inside of a repeat or Update options. For Delete I will always get an error of “Request body must be a JSON object” with status of 500. With Update I will get error of “error happened in your connection. Reason: getaddrinfo ENOTFOUND undefined” again status of 500.
During troubleshooting I simplified the request by doing a Database Single Query, which I can output and verify I receive exactly what I asked for and in JSON format which then the next step would be Database Delete where the _id is equal to the single query _id and I receive the same error.
During another test with a separate project using SQLite using the above steps works just fine. What is the method to use for CouchDB?
Thanks