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

    • Meeting integration with Otter.ai

      Would love for an integration with an AI transcription service like Otter.ai to be integrated with Zoho Meeting. Thanks

    • How to close/delete a free creator account?

      I have a free zoho creator account associated with my email address that is not being used.  I want to become a user of another paid zoho creator account but I can not associate with the paid account with the same email.  I assume if I can close or delete the free account I will be able to use the paid account. I have emailed support but no response. Suggestions?

    • Zoho books and zapier causes Invalid data provided

      I have been using zoho books with zapier for over 2 years now, everything was working fine. On September 13th my zaps stopped working. Now on step create sales invoice in zoho books i get an error: Failed to create a create_invoice_v2 in Zoho Books The

    • CRM report

      Is it possible to pull a contacts report that also includes the company industry, as well as the company name? I’m having trouble combining company and contact fields – any help is appreciated. Thank you, Sam

    • Early Payment Discount customize Text

      Hi, I’m currently using Zoho Books and am trying to customize the standard “Early Payment Discount” message that appears in the PDF invoice template. I’ve reviewed the documentation here: https://www.zoho.com/books/help/invoice/early-payment-discount.html

    • Enhancements to Client script?

      Hi Zoho CRM, I've been extensively using Client Scripts to enhance our Deal form experience, particularly for real time validations and auto updating fields based on specific logic. However, I've encountered a challenge regarding permission boundaries.

    • Add views to new CRM UI navigation + Unlimited Webtabs

      Zoho CRM is so close now to being the ultimate business application with the new UI, as soon as this one feature is added. This is probably where Zoho is headed but if it's not I want to BEG for this to be incorporated. What we need is to be able to put

    • E-Mail Distribution List

      How do I create an e-mail distribution list in Zoho Mail?

    • Custom "create meeting" button with more functionality than Zoho currently has?

      I'm looking for a little help/direction in how to do this. Even just some general high level pointers on how this might be able to be done. The current Zoho Meeting Activity functionality is not ideal for my org's workflow. I'd like to try and create

    • Error Code 4: Invalid value passed for JSONString

      Okay, I want to start by saying I know I'm a terrible scripter, so sorry if this is a dumb mistake. I just can't figure it out, even with LLM help. Here's my code: // --- Input Variables --- customer_id = salesorder.get("customer_id"); so_id = salesorder.get("salesorder_id");

    • Organizing contacts/members by company

      I work for a membership organization (representing businesses) and am trying to use Zoho CRM more effectively for managing the points of contact for our members. Currently, our members are listed in our CRM by the primary point of contact's name, but

    • Unable to search in Zoho Email

      I've started using Zoho Email (free version) recently and realized that it doesn't have email search functionality. Am I missing anything here? I've gone through the Zoho tutorial which does show the search bar on the right top of the Zoho UI. But in

    • Response Time Report

      From data to decisions: A deep dive into ticketing system reports Every organization that interacts with its customers should have an established timeframe for how soon an agent is expected to send the first response and any reply to any follow-up messages.

    • Problem : Auto redirect from zoho flow to zoho creator

      Hi there, I've been waiting for zoho team to get back on this for last couple of days. Anyone else have the problem to access zoho flow? everytime I click on zoho flow it redirects me to zoho creator. I tried incognito mode but it still direct me to zoho

    • Zoho - Outlook plugin

      Does anyone know if there is a way to modify the autofill in the Zoho plugin in outlook? When we create a contact, it enters the correct email address and name, but then pulls information from our own signature line to add phone number, address, etc.

    • Zoho Books - Sales Person Information

      Hi Team, On Invoices, Quotes, etc... I can include the Sales Person, but it only shows their name and not their email or phone number. It would be great to have place on invoice templates where we can manage what sales person information should be shows

    • Offline working in Zoho Creator portal

      Zoho's help says that offline working is only available in the Creator mobile app and not in the portal app. But I can see offline options in the portal app too and it seems to work when I test it. My portal users are often in areas where there is poor

    • Fetch Records using Dynamic Criteria

      Hi,  I have a form that builds a filter based on user input.  I need to fetch the records based on dynamic criteria.  How would I accomplish this as there is no eval function? For example: desiredRecord = Form1[dynamicCriteria];

    • Url filter Report date (pivot chart)

      Hello. Is it possible to filter the data in pivot char using parameters in the url? I'm trying but I should not doing very well. Something like: https://creator.zoho.com/.../....../#Report:MyPivotChartReport?MyDate=01-Jan-2012;31-Jun-2012;MyDate_op=58 Saludos

    • Sending gmail to a particular person fails because the address gets changed to "gmaill", with a second "l" typo somewhere

      I send to bob@gmail.com (example) and get an error sending to bob@gmaill.com, only for this one person. Note the extra "l" in the email the system tried to send to, which was not in the address I entered. Can't find a typo in the contact or anywhere else

    • Emoji Support in Bigin CRM

      We request the implementation of emoji support across Bigin CRM. This feature should allow users to seamlessly use emojis in text fields, headlines, and deals. It would enhance communication, improve the visual appeal of records, and bring more personalization

    • Bigin Booking Pages enhancements

      I would like to ask for several enhancements for the brand new (and promising) Booking feature. 1. Add "Contact/Mobile" Field to Booking form We use Mobile as key (id), but unfortunately it is missing from the Booking form, only Home Phone is available.

    • Amount in words in Indian format

      Hi, I had coded the following code to convert amount in words. But in the code in the format of US like million. But i need in Lakh and Crore. So pls suggest ideas r post corrected code string Num2Words(int val) {     val_s = input.val.toString();     th = {"", "thousand", "million", "billion", "trillion"};     // uncomment this line for English Number System     // th = {"","thousand","million", "milliard","billion"};     dg = {"zero", "one", "two", "three", "four", "five", "six", "seven", "eight",

    • What are people using to send Service based emails?

      Zoho Campaigns is for marketing. Users can unsubscribe from these emails. Service based emails need to be delivered and can without the worry of Can-spam act. What are people using to send service based emails? My mailing list is derived from a database

    • Standalone LMS tool

      Will Zoho release a standalone LMS (Learning management System) than can be used by external parties (guest)?

    • Announcing Kiosk 1.1 - Customize screen titles, configure new fields & actions, use values from your Kiosk to update fields, and more.

      Hello all We are back again with more enhancements to Kiosk. So what's new? Enhancements made to the Components Add titles for your Kiosk screens and adjust its width to suit your viewing preferences. Three new fields can be added to your screen: Percentage,

    • An Overview of Dario Schiraldi Deutsche Bank Executive

      Hello Community, Dario Schiraldi is an executive at Deutsche Bank, focused on advancing the firm’s financial services and crafting its global strategic vision. With 20 years of expertise in leadership roles, he has spearheaded successful market acquisitions

    • Emailing a document to WorkDrive

      Does WorkDrive include the ability to upload a document by sending an attachment to an email address? (Books and Expenses include this functionality) If it doesn't is it under consideration? on the Road Map?

    • Allow Changing Appointment Status from "Completed" to "No Show" or Other Valid States

      Hi Zoho Bookings Team, We hope you're doing well. We would like to submit a feature request regarding appointment status management in Zoho Bookings. 🎯 Use Case Sometimes, an appointment is mistakenly marked as Completed, but later we realize that the

    • Ability to modify what displays in calendar invite?

      I am a long time calendly user and want to make the switch to bookings.  I understand that there is not currently a meets/hangouts integration, is one on the roadmap? Is there anyway I can modify the calendar invite to include the meet link?  I can add it to the emails no problem, but I would also like it to display on their calendar.  Is there some work around I can do to get it on the calendar?  Also am I able to modify the calendar event title?

    • Zoho One and Tally Integration

      Has Anyone in this forum done any implementation with Zoho CRM and Tally accounting software. If so who have you used and how easy was it?

    • Microsoft PowerPoint files Extremely slow to save

      I and others on my team have noticed that Microsoft PowerPoint documents are extremely slow to save when using WorkDrive. It always takes over 30 seconds to save a file. Word and Excel files seem to save in a typical length of time, but PowerPoint is

    • How can users unblock their blocked Zoho Mail accounts?

      After the reason for the account block (storage exceeded, spam detection etc.) has been rectified, the user can unblock the account from the UnBlock Me page. Account support@edu2review.com  Edu2Review is an education review platform, we rate the quality

    • Adding additional fields for batch information

      Hello, I am looking at adding additional information into our inventory module. we would like to be able to see up to 8 attributes that will be individual & different for each batch (i.e. batch specific information) but currently I seem to only be able

    • Dynamic Pickup List Values using Deluge and Client Script

      I would like to dynamically show Pickup List Values For example we need to fetch some data from an on premise application and display it so they can choose and pick This can be done in Creator but I didn't find anything for CRM

    • Validation Rule for Controlled Stage Movement in Deals Module (Deluge Script)

      For keeping a control over module stage or status, you can use the below deluge script. The below deluge script defines validation control over deals module stages: // Function to validate allowed stage transitions in the Deals module map validation_rule.LeadStatustValidation1(String

    • Pick List Issues

      I have created a pick list that looks at a table in a sheet, it selects the column I want fine. Various issues have come along. The option to sort the pick list is simplistic, only allows an ascending alphabetical sort. Bad luck if you want it descending.

    • Four types of task dependencies

      "Nothing is particularly hard if you divide it into small jobs."                                                                                                                  - Henry Ford Projects, small or large, are driven by simple work units called tasks. Monitoring standalone tasks might look simple but as the workflow becomes elaborate, tasks may start relying on one another. In project management, this relationship between tasks is termed as "Task Dependencies". Dependency between tasks arise

    • 1099 tracking

      Do zoho books offer feature of tracking for 1099's for contractors, etc? Quick books offers this feature and wondered when/if Zoho books will do same

    • VAT-type Taxes in US Edition?

      I'm located in the US, and I use the Zoho One US edition of Books. We are in the process of registering with Canadian authorities for their GST / HST, which is a VAT-type of scheme. It is not immediately obvious to me how one would deal with input tax

    • Next Page