API: WorkflowStatus missing from API response

I have emailed api@jotform.com and not received a response. I need a response ASAP.

workflowStatus is missing from response. The form is linked to an approvals workflow. I have tried on two different forms to no avail. Can you please advise how to rectify this? ASAP

Hello Brunswickshow,

Thanks for reaching out to Jotform Support. I’m sorry you're having issues with getting workflow status via API. I'm wondering if you are getting other form data via API? Are you only missing this workflow status data in the API response? If you could please share the API endpoint you are using to get data via API and some screenshots showing the response you are getting, that will be great.

As an additional measure, I have cleared the form cache for you to avoid any temporary cache issues so please try once again and let us know how it goes now.

You might also want to checkout our API Documentation page here to get more details about submission endpoint.

Hi Rahul,

Thanks for the response.

I'm using this endpoint: https://api.jotform.com/submission/{submissionID}?apiKey={apiKey}

And I'm getting the following response:

{

"responseCode": 200,

"message": "success",

"content": {

"id": "5311666312421285453",

"form_id": "221658732900860",

"ip": "203.54.189.242",

"created_at": "2022-06-16 01:30:31",

"status": "ACTIVE",

"new": "0",

"flag": "0",

"notes": "",

"updated_at": "2022-06-16 01:30:54",

"answers": {

"1": {

"name": "clickTo",

"order": "1",

"text": "Customer Details:",

"type": "control_head"

},

"2": {

"name": "submit",

"order": "13",

"text": "Submit",

"type": "control_button"

},

"3": {

"name": "fullName3",

"order": "2",

"sublabels": "{\"prefix\":\"Prefix\",\"first\":\"First Name\",\"middle\":\"Middle Name\",\"last\":\"Last Name\",\"suffix\":\"Suffix\"}",

"text": "Full Name",

"type": "control_fullname",

"answer": {

"first": "Steve",

"last": "Jobs"

},

"prettyFormat": "Steve Jobs"

},

"4": {

"name": "address4",

"order": "3",

"sublabels": "{\"cc_firstName\":\"First Name\",\"cc_lastName\":\"Last Name\",\"cc_number\":\"Credit Card Number\",\"cc_ccv\":\"Security Code\",\"cc_exp_month\":\"Expiration Month\",\"cc_exp_year\":\"Expiration Year\",\"addr_line1\":\"Street Address\",\"addr_line2\":\"Street Address Line 2\",\"city\":\"City\",\"state\":\"State \\/ Province\",\"postal\":\"Postal \\/ Zip Code\",\"country\":\"Country\"}",

"text": "Address",

"type": "control_address",

"answer": {

"addr_line1": "123 Apple Street",

"city": "Silicon Valley",

"state": "CA",

"postal": "12345"

},

"prettyFormat": "Street Address: 123 Apple Street

City: Silicon Valley

State / Province: CA

Postal / Zip Code: 12345

"

},

"5": {

"name": "phoneNumber5",

"order": "4",

"sublabels": "{\"area\":\"Area Code\",\"phone\":\"Phone Number\"}",

"text": "Phone Number",

"type": "control_phone",

"answer": {

"full": "(123) 456-4444"

},

"prettyFormat": "(123) 456-4444"

},

"6": {

"name": "email6",

"order": "5",

"text": "E-mail",

"type": "control_email",

"answer": "steve@apple.com"

},

"7": {

"name": "clickTo7",

"order": "6",

"text": "",

"type": "control_text"

},

"8": {

"name": "howDid8",

"order": "7",

"text": "How did you hear about us?",

"type": "control_dropdown",

"answer": "Internet"

},

"9": {

"name": "other",

"order": "8",

"text": "Other",

"type": "control_textbox"

},

"11": {

"name": "feedbackAbout11",

"order": "9",

"text": "Feedback about us:",

"type": "control_textarea"

},

"12": {

"name": "suggestionsIf",

"order": "10",

"text": "Suggestions if any for further improvement:",

"type": "control_textarea"

},

"13": {

"name": "willYou",

"order": "11",

"text": "Will you be willing to recommend us?",

"type": "control_checkbox"

},

"14": {

"dcolumns": "[{\"type\":\"Radio Button\",\"text\":\"Not Satisfied\"},{\"type\":\"Check Box\",\"text\":\"Somewhat Satisfied\"},{\"type\":\"Drop Down\",\"text\":\"Satisfied\",\"options\":\"Yes|No\"},{\"type\":\"Text Box\",\"text\":\"Any thoughts?\"}]",

"emojiCount": "5",

"inputType": "Text Box",

"mcolumns": "Full Name|Address|Contact Number",

"mrows": "1|2",

"name": "pleaseGive14",

"order": "12",

"text": "Please give reference of any two people whom you feel:",

"toggleText": "Yes|No",

"type": "control_matrix",

"answer": {

"1": "[\"\",\"\",\"\"]",

"2": "[\"\",\"\",\"\"]"

},

"prettyFormat": " Full NameAddressContact Number12"

}

}

},

"duration": "23.91ms",

"limit-left": 998

}

According to the documentation I should be getting the response. Your assistance would be great.

Thanks

Hello Brunswickshow,

Thank you for getting back to us. Since the support team members are not qualified developers I would still recommend you to please contact our API team directly using this form, they would be able to properly help you with this issue.

However, please allow me some time to consult this with other support team members. I will get back to you as soon as I have more information.

We appreciate your patience and understanding as we look into this further.

Hello Brunswickshow,

Thank you for your patience. Due to an issue, our developers removed workflowStatus in API responses by default. Please add the parameter addWorkflowStatus=1 to the submission query. For example:

https://api.jotform.com/form/{FORM_ID}/submissions?apiKey=xxx&addWorkflowStatus=1

or

https://api.jotform.com/submission/{SUBMISSION_ID}?apiKey=xxx&addWorkflowStatus=1

Please give it a try and let us know how it goes.

Hi Sigit,

This worked great. Thank you very much.

Cheers,