Create Contract API Endpoint Unclear "inputfields" Requirements

Create Contract API Endpoint Unclear "inputfields" Requirements

Hello,

I'm trying to create a Deluge function that accepts inputs from a form in Zoho Creator and creates a barebones contract of a given type. See below for the current code, cleaned of authentication information.
  2. // Fetch form data
  3. // Hidden field
  4. client_name = input.Client_Name;
  5. if(client_name == null || client_name == "")
  6. {
  7. client_name = "Testing Client";
  8. }
  9. // Dropdown field
  10. contract_type = input.Contract_Type;
  11. // Single line field
  12. title = input.Title;
  13. // Multi-line field
  14. description = input.Description;
  15. // Dropdown field
  16. signer_name = input.Signer_Name;
  17. //
  18. // Define the access token and refresh token
  19. accessToken = "ACCESS_TOKEN";
  20. refreshToken = "REFRESH_TOKEN";
  21. //
  22. // Define headers for token refresh request
  23. tokenRefreshHeaders = Map();
  24. tokenRefreshHeaders.put("Content-Type","application/x-www-form-urlencoded");
  25. tokenRefreshParameters = Map();
  26. tokenRefreshParameters.put("grant_type","refresh_token");
  27. tokenRefreshParameters.put("client_id","CLIENT_ID");
  28. tokenRefreshParameters.put("client_secret","CLIENT_SECRET");
  29. tokenRefreshParameters.put("refresh_token",refreshToken);
  30. //
  31. // Refresh the access token
  32. response = invokeurl
  33. [
  34. url :"https://accounts.zoho.com/oauth/v2/token"
  35. type :POST
  36. parameters:tokenRefreshParameters
  37. headers:tokenRefreshHeaders
  38. ];
  39. if(response.get("access_token") != null)
  40. {
  41. accessToken = response.get("access_token");
  42. }
  43. //
  44. // Define headers for Zoho Contracts API request
  45. contractsHeaders = Map();
  46. contractsHeaders.put("Authorization","Zoho-oauthtoken " + accessToken);
  47. contractsHeaders.put("Content-Type","application/json");
  48. //
  49. // Prepare contract data
  50. contract_type = lower(replaceAll(contract_type," ","-"));
  51. client_name = lower(replaceAll(client_name," ","-"));
  52. signerNameContainsTitle = signer_name.containsIgnoreCase(". ");
  53. signerFirstSpace = signer_name.find(" ");
  54. if(signerNameContainsTitle)
  55. {
  56. signerTitle = signer_name.left(signerFirstSpace);
  57. signerFullName = signer_name.remove(signerTitle).trim();
  58. signerFirstSpace = signerFullName.find(" ");
  59. signerFirstName = signerFullName.left(signerFirstSpace);
  60. signerLastName = signerFullName.remove(signerFirstName).trim();
  61. }
  62. else
  63. {
  64. signerFirstName = signer_name.left(signerFirstSpace);
  65. signerLastName = signer_name.remove(signerFirstName).trim();
  66. }
  67. signer_record = zoho.crm.searchRecords("Contacts","(First_Name:equals:" + signerFirstName + ") and (Last_Name:equals:" + signerLastName + ")");
  68. signer_email = signer_record.get(0).get("Email");
  69. //
  70. // Create nested maps/lists in the structure of the contracts API JSON
  71. contractDataMap = Map();
  72. contractDataMap.put("source",1);
  73. inputFieldsList = List();
  74. contractTypeInputFieldMap = Map();
  75. contractTypeInputFieldMap.put("metaApiName","contract-type");
  76. contractTypeInputsList = List();
  77. contractTypeInput = Map();
  78. contractTypeInput.put("inputApiName","contract-type");
  79. contractTypeInput.put("inputValue","non-disclosure-agreement");
  80. contractTypeInputsList.add(contractTypeInput);
  81. contractTypeInputFieldMap.put("inputs",contractTypeInputsList);
  82. inputFieldsList.add(contractTypeInputFieldMap);
  83. titleInputFieldMap = Map();
  84. titleInputFieldMap.put("metaApiName","title");
  85. titleInputsList = List();
  86. titleInput = Map();
  87. titleInput.put("inputApiName","title");
  88. titleInput.put("inputValue",title);
  89. titleInputsList.add(titleInput);
  90. titleInputFieldMap.put("inputs",titleInputsList);
  91. inputFieldsList.add(titleInputFieldMap);
  92. descriptionInputFieldMap = Map();
  93. descriptionInputFieldMap.put("metaApiName","description");
  94. descriptionInputsList = List();
  95. descriptionInput = Map();
  96. descriptionInput.put("inputApiName","description");
  97. descriptionInput.put("inputValue",description);
  98. descriptionInputsList.add(descriptionInput);
  99. descriptionInputFieldMap.put("inputs",descriptionInputsList);
  100. inputFieldsList.add(descriptionInputFieldMap);
  101. requesterNameInputFieldMap = Map();
  102. requesterNameInputFieldMap.put("metaApiName","requester-name");
  103. requesterNameInputsList = List();
  104. requesterNameInput = Map();
  105. requesterNameInput.put("inputApiName","requester-name");
  106. requesterNameInput.put("inputValue","Tom Rismeyer");
  107. requesterNameInputsList.add(requesterNameInput);
  108. requesterNameInputFieldMap.put("inputs",requesterNameInputsList);
  109. inputFieldsList.add(requesterNameInputFieldMap);
  110. requesterDepartmentInputFieldMap = Map();
  111. requesterDepartmentInputFieldMap.put("metaApiName","requester-department");
  112. requesterDepartmentInputsList = List();
  113. requesterDepartmentInput = Map();
  114. requesterDepartmentInput.put("inputApiName","requester-department");
  115. requesterDepartmentInput.put("inputValue","sales");
  116. requesterDepartmentInputsList.add(requesterDepartmentInput);
  117. requesterDepartmentInputFieldMap.put("inputs",requesterDepartmentInputsList);
  118. inputFieldsList.add(requesterDepartmentInputFieldMap);
  119. partyBNameInputFieldMap = Map();
  120. partyBNameInputFieldMap.put("metaApiName","party-b-name");
  121. partyBNameInputsList = List();
  122. partyBNameInput = Map();
  123. partyBNameInput.put("inputApiName","party-b-name");
  124. partyBNameInput.put("inputValue","guy-mcnobody);
  125. partyBNameInputsList.add(partyBNameInput);
  126. partyBNameInputFieldMap.put("inputs",partyBNameInputsList);
  127. inputFieldsList.add(partyBNameInputFieldMap);
  128. counterpartyPrimaryContactInputFieldMap = Map();
  129. counterpartyPrimaryContactInputFieldMap.put("metaApiName","counterparty-primary-contact");
  130. counterpartyPrimaryContactInputsList = List();
  131. counterpartyPrimaryContactInput = Map();
  132. counterpartyPrimaryContactInput.put("inputApiName","party-b-primary-contact-name");
  133. counterpartyPrimaryContactInput.put("inputValue",signer_email);
  134. counterpartyPrimaryContactInputsList.add(counterpartyPrimaryContactInput);
  135. counterpartyPrimaryContactInputFieldMap.put("inputs",counterpartyPrimaryContactInputsList);
  136. inputFieldsList.add(counterpartyPrimaryContactInputFieldMap);
  137. contractTermInputFieldMap = Map();
  138. contractTermInputFieldMap.put("metaApiName","contract-term");
  139. contractTermInputsList = List();
  140. contractTermInput = Map();
  141. contractTermInput.put("inputApiName","contract-term");
  142. contractTermInput.put("inputValue",false);
  143. contractTermInputsList.add(contractTermInput);
  144. contractTermInputFieldMap.put("inputs",contractTermInputsList);
  145. inputFieldsList.add(contractTermInputFieldMap);
  146. contractEffectiveDateInputFieldMap = Map();
  147. contractEffectiveDateInputFieldMap.put("metaApiName","contract-effective-date");
  148. contractEffectiveDateInputsList = List();
  149. contractEffectiveDateInput = Map();
  150. contractEffectiveDateInput.put("inputApiName","contract-effective-date");
  151. contractEffectiveDateInput.put("inputValue",1);
  152. contractEffectiveDateInputsList.add(contractEffectiveDateInput);
  153. contractEffectiveDateInputFieldMap.put("inputs",contractEffectiveDateInputsList);
  154. inputFieldsList.add(contractEffectiveDateInputFieldMap);
  155. renewalTypeInputFieldMap = Map();
  156. renewalTypeInputFieldMap.put("metaApiName","renewal-type");
  157. renewalTypeInputsList = List();
  158. renewalTypeInput = Map();
  159. renewalTypeInput.put("inputApiName","renewal-type");
  160. renewalTypeInput.put("inputValue",1);
  161. renewalTypeInputsList.add(renewalTypeInput);
  162. renewalTypeInputFieldMap.put("inputs",renewalTypeInputsList);
  163. inputFieldsList.add(renewalTypeInputFieldMap);
  164. contractDataMap.put("inputfields",inputFieldsList);
  165. //
  166. // Create the contract in Zoho Contracts
  167. response = invokeurl
  168. [
  169. url :"https://contracts.zoho.com/api/v1/contracts"
  170. type :POST
  171. parameters:contractDataMap
  172. headers:contractsHeaders
  173. ];
  174. if(response.get("code") == 201)
  175. {
  176. alert "Contract created successfully";
  177. }
  178. else
  179. {
  180. alert "Error in creating contract: " + response.toString();
  181. cancel submit;
  182. }

Here is the resulting JSON per logging:
  2. {
  3.   "source": 1,
  4.   "inputfields": [
  5.     {
  6.       "metaApiName": "contract-type",
  7.       "inputs": [
  8.         {
  9.           "inputApiName": "contract-type",
  10.           "inputValue": "non-disclosure-agreement"
  11.         }
  12.       ]
  13.     },
  14.     {
  15.       "metaApiName": "title",
  16.       "inputs": [
  17.         {
  18.           "inputApiName": "title",
  19.           "inputValue": "Test title"
  20.         }
  21.       ]
  22.     },
  23.     {
  24.       "metaApiName": "description",
  25.       "inputs": [
  26.         {
  27.           "inputApiName": "description",
  28.           "inputValue": ""
  29.         }
  30.       ]
  31.     },
  32.     {
  33.       "metaApiName": "requester-name",
  34.       "inputs": [
  35.         {
  36.           "inputApiName": "requester-name",
  37.           "inputValue": "Tom Rismeyer"
  38.         }
  39.       ]
  40.     },
  41.     {
  42.       "metaApiName": "requester-department",
  43.       "inputs": [
  44.         {
  45.           "inputApiName": "requester-department",
  46.           "inputValue": "sales"
  47.         }
  48.       ]
  49.     },
  50.     {
  51.       "metaApiName": "party-b-name",
  52.       "inputs": [
  53.         {
  54.           "inputApiName": "party-b-name",
  55.           "inputValue": "guy-mcnobody"
  56.         }
  57.       ]
  58.     },
  59.     {
  60.       "metaApiName": "counterparty-primary-contact",
  61.       "inputs": [
  62.         {
  63.           "inputApiName": "party-b-primary-contact-name",
  64.           "inputValue": "contact@mail.com"
  65.         }
  66.       ]
  67.     },
  68.     {
  69.       "metaApiName": "contract-term",
  70.       "inputs": [
  71.         {
  72.           "inputApiName": "contract-term",
  73.           "inputValue": false
  74.         }
  75.       ]
  76.     },
  77.     {
  78.       "metaApiName": "contract-effective-date",
  79.       "inputs": [
  80.         {
  81.           "inputApiName": "contract-effective-date",
  82.           "inputValue": 1
  83.         }
  84.       ]
  85.     },
  86.     {
  87.       "metaApiName": "renewal-type",
  88.       "inputs": [
  89.         {
  90.           "inputApiName": "renewal-type",
  91.           "inputValue": 1
  92.         }
  93.       ]
  94.     }
  95.   ]
  96. }

I'm getting this error when I submit the form, triggering the deluge function:

  1. Error in creating contract: {"Errors":{"ErrorCode":"ZSEC-JSON_PARSE_ERROR","ErrorMessage":"Sorry, unable to complete your action due to an unknown error. Please try again.","APIErrorMessage":"JSON_PARSE_ERROR"}}

The error message is not very helpful, as it does not specify where it has an issue when parsing the JSON. The API documentation does not specify which fields are required for the Create Contract Endpoint, so I'm either left posting here to request more info, or to just tinker with different combinations of fields included and excluded, so I'm posting here. Can anybody help determine exactly which fields I'm missing, using incorrectly, or other issues with the JSON?

    Access your files securely from anywhere






                    Zoho Campaigns Resources




                          Zoho Developer Community



                              Bootcamp
                              Community
                              Pricing
                              Webinars
                              What's New
                              Integrations
                              Contact Support
                              Contact Sales
                                Zoho Survey Resources
                                  Features
                                  Survey Templates
                                  Integrations
                                  Community
                                  iOS Mobile Surveys
                                  Pricing
                                  Android Mobile Surveys
                                  Insurvey Blogs
                                  Insight Blogs
                                  Tips & Tricks





                                              Latest Feature Updates

                                                • Desk Community Learning Series


                                                • Digest


                                                • Functions


                                                • Meetups


                                                • Kbase


                                                • Resources


                                                • Glossary


                                                • Desk Marketplace


                                                • MVP Corner


                                                • Word of the Day


                                                • Ask the Experts




                                                    Zoho SalesIQ Resources


                                                          Manage your brands on social media
                                                          Access Zoho Social

                                                            Zoho Pagesense Resources


                                                                Zoho TeamInbox Resources

                                                                  Zoho DataPrep Resources


                                                                    Zoho CRM Plus Resources

                                                                      Zoho Books Resources


                                                                        Zoho Subscriptions Resources

                                                                          Zoho Projects Resources


                                                                            Zoho Sprints Resources


                                                                              Qntrl Resources


                                                                                Zoho Creator Resources



                                                                                    Zoho CRM Resources

                                                                                    • CRM Community Learning Series

                                                                                      CRM Community Learning Series


                                                                                    • Kaizen

                                                                                      Kaizen

                                                                                    • Functions

                                                                                      Functions

                                                                                    • Meetups

                                                                                      Meetups

                                                                                    • Kbase

                                                                                      Kbase

                                                                                    • Resources

                                                                                      Resources

                                                                                    • Digest

                                                                                      Digest

                                                                                    • CRM Marketplace

                                                                                      CRM Marketplace

                                                                                    • MVP Corner

                                                                                      MVP Corner







                                                                                        Design. Discuss. Deliver.

                                                                                        Create visually engaging stories with Zoho Show.

                                                                                        Get Started Now


                                                                                          Zoho Show Resources

                                                                                            Zoho Writer

                                                                                            Get Started. Write Away!

                                                                                            Writer is a powerful online word processor, designed for collaborative work.

                                                                                              Zoho CRM コンテンツ






                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方