How to delete a record in Zoho Creator from a Deluge function in CRM

How to delete a record in Zoho Creator from a Deluge function in CRM

Hello,

I've got a Deluge function in the Zoho CRM triggered by workflow with this code, trying to delete a record containing a product code.

  2. creatorApiUpdateUrl = "https://www.zohoapis.eu/creator/v2.1/data/xxxxxxxx/yyyyyyyy/report/All_Courses";
  3. payload.put("criteria","(Course_Code==\"" + coursecode + "\")");
  4. info "(Course_Code == '" + coursecode + "')";
  5. info payload;
  6. // Delete
  7. deletePayload = Map();
  8. deletePayload.put("criteria","(Course_Code==\"" + coursecode + "\")");
  9. //deletePayload.put("skip_workflow", ["form_workflow"]);
  10. //deletePayload.put("result", {"message": true, "tasks": true});
  11. info "-------- DELETE PAYLOAD --------";
  12. info deletePayload;
  13. creatorApiDeleteResp = invokeurl
  14. [
  15. url : creatorApiUpdateUrl
  16. type : DELETE
  17. parameters : deletePayload
  18. connection : "creatorfunctions"
  19. ];
  20. info "-------- DELETE RESPONSE ---------";
  21. info creatorApiDeleteResp;
The payload looks like this.

  • {"criteria":"(Course_Code==\"SKU TEST01\")"}
I keep getting this error...

  • {"code":1060,"description":"Invalid request parameter found - criteria"}
I've been closely following the documentation and don't understand why this is giving me an error. How can I solve this?

Thanks