Skip to main content
Question

Unable to delete record via API using the EX operator

  • April 9, 2021
  • 0 replies
  • 18 views

Hello,

I am unable to delete a single record use the 'EX' operator. I can successfully delete all records using the 'GT' operator but I would like to selectively delete records. Below are the payloads I am sending to the API. Please advise.

EX example:

{
"from": "<table_id>",
"where": "{'3'.EX.'109391'}"
}

EX response: 405

    {
       "message": "METHOD_NOT_ALLOWED",
       "description": "Error APIKIT:METHOD_NOT_ALLOWED"
    }

GT example:

{
"from":"<table_id>",
"where":"{3.GT.0}"
}

GT response: 200

NOTE: Http verb is the same (DELETE) for both requests, so the error message is not correct.



------------------------------
Andrew Pitts
------------------------------
This topic has been closed for replies.

  • Author
  • Registered
  • April 9, 2021
I have discovered the issue. I was hitting the incorrect endpoint. Initially, I was hitting the 'records/query' endpoint which worked when deleting all records using the GT operator but not the EX. Remove the 'query' portion of the uri resolved the issue.

------------------------------
Andrew Pitts
------------------------------