Appointment field: Deleting the submissions using API call doesn't clear the associated timeslots

  • Profile Image
    M4_Bill
    Asked on June 17, 2020 at 06:20 PM

    I asked how to clear an appointment, and I received a message from Amin_N on editing the appointment. I tried to do as shown but it only made me change the time of the appointment. I tried deleting the request of the appointment but it still showed  the time as not available.

    Are there any other suggestions? Some sort of work around?

    Thanks.

  • Profile Image
    Jed_C
    Answered on June 17, 2020 at 09:11 PM

    You just need to delete the submission and it should be cleared on the appointment field. Can you please share the submission ID so we can check?

    Looking forward for your response. 

  • Profile Image
    zedney
    Answered on June 18, 2020 at 11:18 AM

    Hello,

    Yes by deleting the submission in the control panel the time slot is deleted also.

    But if we use jotform API to delete it like this 

    curl -X DELETE "https://api.jotform.com/submission/{submissionID}?apiKey={apiKey}"

    it delete the submission and not the time slot!!

    we are blocked here 

    1592493318Screen Shot 2020-06-18 at 16.1


    1592493400Screen Shot 2020-06-18 at 16.1

  • Profile Image
    ashwin_d
    Answered on June 18, 2020 at 11:57 AM

    I am sorry for the trouble caused to you. I did test this issue with one of my own form, and I am not able to replicate the issue you are having. 

    I deleted the submission using API and that cleared the appointment slot without any problem. Please check the screenshot below:

    1592495819appointmentDelAPI.gif

    I would suggest you to please try out again and get back to us if the issue persists.

    We will wait for your response.

  • Profile Image
    zedney
    Answered on June 18, 2020 at 12:29 PM

    Thank you for your help

    The issue persist on this form https://www.jotform.com/build/201694131199558


    can you check it please 


    Thank you

  • Profile Image
    VincentJay
    Answered on June 18, 2020 at 01:44 PM

    I checked the form and there's no submission to delete. As for the time slot, I cleared your form cache on our server to fix the issue.

    1592502040fvxcd.png

    Please check it and if the issue still persists, please provide a screenshot so we can check it further. 

    Guide: How-to-Post-Screenshots-to-Our-Support-Forum

  • Profile Image
    zedney
    Answered on June 19, 2020 at 05:26 AM

    Hello


    as you can see below we have only one submission: Sunday, Jun 21, 2020 23:30-00:00

    1592558481Screen Shot 2020-06-19 at 10.1


    and the time slot is booked 3 times like this:


    1592558678Screen Shot 2020-06-19 at 10.2


    1592558716Screen Shot 2020-06-19 at 10.2


    Thank you for your help

  • Profile Image
    ashwin_d
    Answered on June 19, 2020 at 06:56 AM

    I am sorry for the trouble caused to you. I see the issue in your form. You only have one submission but there are 3 different time slots blocked in appointment field. 

    Have you manually deleted the submissions or you have deleted it through API call? Please let us know and we will take a look.

    We will wait for your response.

  • Profile Image
    zedney
    Answered on June 19, 2020 at 08:19 AM

    Thank you for your response. I have delete it using API call:

    php curl call to https://api.jotform.com/submission/{submissionID}?apiKey={apiKey}


  • Profile Image
    JohnRex
    Answered on June 19, 2020 at 08:57 AM

    Thank you for sharing that detail.

    Let me conduct a few tests on my end and get back to you here shortly.

  • Profile Image
    JohnRex
    Answered on June 19, 2020 at 09:13 AM

    Thank you for waiting!

    I tried to replicate the method you are using on my test form and was able to reproduce the issue. Deleting the submissions via API doesn't clear the timeslots in the Appointment field.

    I'm not sure if this is a limitation with using the API. Because even when you use API to create new submissions, integrations and email notifications will not be triggered as well. So let me consult this with our backend team for clarification.

    We'll let you know here once we received an update.

    Meantime, what I can suggest is to clone the form to reset the slots in the appointment field. Then delete the submissions via the Submission page instead of the API.

  • Profile Image
    zedney
    Answered on June 19, 2020 at 10:35 AM

    Thank you John for your help. 

    As an IT manager I think it's a real issue and not an API limitation like not sending email notifications or integration trigger when create submission. Because it cause a wrong data synchronization between submissions and timeslots.

    Unfortunately using web page to delete submission doesn't resolve our problem as we use jotform to book meeting on our CRM system and need to delete canceled booking from jotform using API in other case we need a dedicated person to do that manually and this is not practical.


    Waiting your replay. Thank you again

  • Profile Image
    zedney
    Answered on June 22, 2020 at 06:23 AM

     Hello


    any update about the issue??


    Thank you

  • Profile Image
    ashwin_d
    Answered on June 22, 2020 at 07:44 AM

    Unfortunately we have not received any update from our backend team yet. As per the ticket status, it is already assigned to concerned team. I am also sending a note to them. Though we cannot provide an ETA on this, but we will get back to you as soon as we have any update from them. 

  • Profile Image
    zedney
    Answered on July 13, 2020 at 07:17 AM

    Hello


    any update about the issue??


    Thank you

  • Profile Image
    Bojan_J
    Answered on July 13, 2020 at 08:41 AM

    Unfortunately, we still did not hear back from our Developers. 

    I will send them a message to see if there are any updates. As soon as we hear back from them, we will let you know.

    Thank you for your patience.