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?

      • Recent Topics

      • Cliq iOS can't see shared screen

        Hello, I had this morning a video call with a colleague. She is using Cliq Desktop MacOS and wanted to share her screen with me. I'm on iPad. I noticed, while she shared her screen, I could only see her video, but not the shared screen... Does Cliq iOS is able to display shared screen, or is it somewhere else to be found ? Regards

      • Zoho People - Retrieve the Leave Details - get("LeaveCount")

        Hi, Zoho People I need to collect all of an employee's leave requests for the calendar year and check how many half-days they have taken. If I run the script on the query he just modified, I can retrieve the information related to that query and use the

      • Mapping a new Ticket in Zoho Desk to an Account or Deal in Zoho CRM manually

        Is there any way for me to map an existing ticket in Zoho desk to an account or Deal within Zoho CRM? Sometimes people use different email to put in a ticket than the one that we have in the CRM, but it's still the same person. We would like to be able

      • Which WhatsApp API works seamlessly with Zoho CRM?

        I’m exploring WhatsApp API solutions that integrate seamlessly with Zoho CRM for customer communication, lead nurturing, and automation. I would love to hear insights from those who have successfully implemented WhatsApp within Zoho CRM. My Requirements:

      • Allow people to sign a zoho form by using esign or scanned signature

        Allow people to sign a zoho form by using esign or scanned signature

      • Button to Reapply Filters on Sheet(s)

        I wrote a macro that I attached to a button to reapply the filters on all my sheets and it says it works, but it doesn't actually do anything. What is wrong with it? Is there another way? Or even make it work for one sheet? Sub UniversalFilterRefresh()

      • Integrate Multiple ZohoBooks organization with zoho projects

        We have successfully connected our Zoho Books with Zoho Projects for synronizing timesheet data. Our Business specialty is, that the staff of the Main company (A) is working on several projects, but the Clients are sometimes contracted and paying to a

      • Zoho OAuth Connector Deprecation and Its Impact on Zoho Desk

        Hello everyone, Zoho believes in continuously refining its integrations to uphold the highest standards of security, reliability, and compliance. As part of this ongoing improvement, the Zoho OAuth default connector will be deprecated for all Zoho services

      • How to drag row(s) or column(s)?

        Hi. Selecting a row or column and then dragging it to a new position does not seem to work. Am i missing something or this is just not possible in Zoho Sheet? Cheers, Jay

      • Flexible Partial-Use Coupons (Stored Value Credits)

        Subject: Feature Request: Ability for users to apply partial coupon balances per transaction Problem Statement Currently, our coupons are "one-and-done." If a user has a $50 coupon but only spends $30, they either lose the remaining $20 or are forced

      • Unable to Assign Multiple Categories to a Single Product in Zoho Commerce

        Hello Zoho Commerce Support Team, I am facing an issue while assigning categories to products in Zoho Commerce. I want to assign multiple categories to a single product, but in the Item edit page, the Category field allows selecting only one category

      • How do I add todays date to merge field

        I don't see any selection of todays date when creating a letter. Surely the date option of printing is standard? John

      • Polish signer experience to compete with docusign

        I would like to suggest that someone spend the little bit of time to polish the signer experience, and the email templates to more of a modern professional feel. They are currently very early 2000s and with some simple changes could vastly improve the

      • Add RTL and Hebrew Support for Candidate Portal (and Other Zoho Recruit Portals)

        Dear Zoho Recruit Team, I hope you're doing well. We would like to request the ability to set the Candidate Portal to be Right-to-Left (RTL) and in Hebrew, similar to the existing functionality for the Career Site. Currently, when we set the Career Site

      • Uplifted homepage experience

        Hello everyone, Creating your homepage is now much easier, more visual, and more impactful. Until now, your homepage allowed you to display custom views, widgets, analytic components, and Kiosk. With the following improvements, the homepage is now a smarter,

      • Tracking Emails sent through Outlook

        All of our sales team have their Outlook 365 accounts setup with IMAP integration. We're trying to track their email activity that occurs outside the CRM. I can see the email exchanges between the sales people and the clients in the contact module. But

      • Whats that

        Price?

      • Crossbeam

        Does anyone use Crossbeam with their Zoho CRM? I'm looking for a way to import Crossbeam partner leads into Zoho CRM. If so: - What's your experience been like? - Are you able to automatically import Crossbeam leads > Zoho CRM? How? - What doesn't work

      • The same Contact associated to multiple Companies - Deals

        Hi, I would like to know if there is an option to associate the same contact with multiple companies (two or more) deals, using the same contact details for all. This is because we have contacts who are linked to different companies or branches of the

      • How to Print the Data Model Zoho CRM

        I have created the data model in Zoho CRM and I want the ability to Print this. How do we do this please? I want the diagram exported to a PDF. There doesnt appear to be an option to do this. Thanks Andrew

      • Convert invoice from zoho to xml with all details

        How to convert an Invoice to XML format with all details

      • Portals-Adjust Column Sizes

        I am trying to adjust the column widths in Portals tabs. Columns that don't need to be wide are wide and longer ones are very short. I thought adding more to the digits box in Edit would widen them, but it doesn't. Anyone know how to adjust these?

      • Add link/button to open approved record from approval list and detail views?

        Hi, How do I allow users to click on an approval record and open that submission? For example, userA submits a quotation then userB approves/rejects. They both can see the quotation on "completed task" list & detail views, but there's no way for them

      • record submitted from creator and invoice is creating in books , but the workflow of books is not tiggering on create of record in books

        record submitted from creator and invoice is creating in books , but the workflow of books is not tiggering on create of record in books headermap = Map(); headermap.put("X-ZOHO-Execute-CustomFunction","true"); response_inv = invokeurl [ url :"https://www.zohoapis.com/books/v3/invoices/fromsalesorder?salesorder_id="

      • Prevent editing of a record after getting approved/rejectedr

        Hi, I'd like to block any user from editing a record after it was approved or rejected, how can I do that?

      • Formula Field/Campo de Fórmula

        Hello everyone, I have a purchase requisition form in which each department submits a request, and the request is automatically routed to the person responsible for that department. In this form, I have several fields with the following link names: Quantidade1,

      • Free Webinar: Zoho Sign for Zoho Projects: Automate tasks and approvals with e-signatures

        Hi there! Handling multiple projects at once? Zoho Projects is your solution for automated and streamlined project management, and with the Zoho Sign extension, you can sign, send, and manage digital paperwork directly from your project workspace. Join

      • Formatting Problem | Export to Zoho Sheet View

        When I export data to Zoho Sheet View, ID columns are automatically formatted as scientific notation. Reformatting them to text changes the actual ID values. For example, 6557000335603071 becomes 6557000335603070. I have attached screenshots showing this

      • Introducing Workqueue: your all-in-one view to manage daily work

        Hello all, We’re excited to introduce a major productivity boost to your CRM experience: Workqueue, a dynamic, all-in-one workspace that brings every important sales activity, approval, and follow-up right to your fingertips. What is Workqueue? Sales

      • Feature Request - The Ability to Link A Customer with a Vendor

        Hi Finance Suite Team, Many businesses buy and sell products from the same companies or individuals. For example, a car sales business may buy a car from a member of the public, and that member of the public may also buy a new car from us. This makes

      • Long table name (sync from Zoho Creator)

        Dears, How can I remove the suffix in parentheses? These tables are synced from Zoho Creator and are treated as system tables, so their names cannot be changed. This issue makes the aggregation formulas look awful.

      • How to apply customized Zoho Crm Home Page to all users?

        I have tried to study manuals and play with Zoho CRM but haven't found a way how to apply customized Zoho CRM Home Page as a (default) home page for other CRM users.. How that can be done, if possible? - kipi Moderation Update: Currently, each user has

      • CRM limit reached: only 2 subforms can be created

        we recently stumbled upon a limit of 2 subforms per module. while we found a workaround on this occasion, only 2 subforms can be quite limiting in an enterprise setting. @Anonymous User I've read about imminent increase of other components (e.

      • [Free Webinar] Learning Table Series - Streamlining incident management process with Zoho Creator

        Hello everyone, We’re excited to invite you to another edition of the Learning Table Series webinar. As you may already know, we've moved to a purpose-based approach in the Learning Table Series this year. Each session now focuses on how a Zoho Creator

      • Unattended - Silent

        How can I hide the tray icon / pop up window during unattended remote access for silent unattended remote access?

      • Importing into Multiselect Picklist

        Hi, We just completed a trade show and one of the bits of information we collect is tool style. The application supplied by the show set this up as individual questions. For example, if the customer used Thick Turret and Trumpf style but not Thin Turret,

      • Text snippet

        There is a nice feature in Zoho Desk called Text Snippet. It allows you to insert a bit of text anywhere in a reply that you are typing. That would be nice to have that option in Zoho CRM as well when we compose an email. Moderation Update: We agree that

      • Marketing Tip #18: Make your online store mobile-friendly to improve traffic

        Most online shoppers browse on their phones first. If your store is hard to read, slow to load, or tricky to navigate on mobile, they’ll bounce fast. A mobile-friendly store doesn’t just look nice; it improves engagement, reduces drop-offs, and helps

      • [Need help] Form closed. Please contact your form administrator for further assistance.

        https://forms.zohopublic.com/cceinfoifly1/form/CCE2025CCEFocusGroupRegistrationForm2025Fall/formperma/s_8XcLETTbFxZ_TAS4r_W6W5UBl8o5oxEnIX35IBKg4 I checked we didn't exceed the usage limit and form availability is enabled, Please help us enable this form

      • Zoho People. Updating TabularData

        I am trying to update tabular data in the record. I always have the same response. I have checked many times. Section ID is correct. May be something wrong with request structure itself. Can someone help me. Body content type: form urlencoded query params

      • Next Page