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

        • Adding multiple Attendee email addresses when adding a Zoho Calendar event in Zoho Flow

          I am trying to integrate Notion and Zoho Calendar via Zoho Flow. However, the Attendee email address supported by Zoho Calendar - Create event only supports one email address, so I am having difficulty implementing automation to automatically register

        • Transfer between two customers (Peters Rental account to Peters Private account)

          we are a Property Management company. Our customers have to accounts (registered as two customers - Peter Rental and Peter Private On the rental account all income and costs fron rental activities are noted. On the private account all private are noted

        • Peppol: Accept Bill (Belgium)

          Hi, This topic might help you if you're facing the same in Belgium. We are facing an issue while accepting a supplier bill received by Peppol in Zoho Books. There is a popup with an error message: This bill acceptance could not be completed, so it was

        • How to set a multi-lookup field as mandatory?

        • Remove the “One Migration Per User” Limitation in Zoho WorkDrive

          Hi Zoho WorkDrive Team, Hope you are doing well. We would like to raise a critical feature request regarding the Google Drive → Zoho WorkDrive migration process. Current Limitation: Zoho WorkDrive currently enforces a hard limitation: A Zoho WorkDrive

        • CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

          Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files

        • Service and Parts Line Item Limitations

          Hi FSM Team, We work with clients who deliver large-scale field service projects. In many cases, a single work order can contain 200+ service and parts line items. Currently, Zoho FSM limits work orders to 30 service and parts line items. While this works

        • Critical Need for Global Search in Zoho FSM

          Hello Zoho FSM Team, We are currently in the process of deciding whether to fully transition to Zoho FSM for managing our field service operations. At present, our team actively uses Zoho Desk (with over 50 users) and Service Fusion, which we are considering

        • 【Zoho CRM】やりとりの要約機能リリースのお知らせ

          ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 今回は「Zoho CRM アップデート情報」の中から、新機能のやりとり要約機能をご紹介します。 Zoho CRMのやりとりの要約は、Ziaが生成する機能で、データに関連付けられた最近のやりとりを簡潔にまとめて提供します。 メール、通話、ミーティング、メモなどを1つの明確な要約にまとめ、重要なポイント、過去の話し合いの要点、結果、次のステップを表示することで、日常的な課題に対処します。 Ziaの強みは、単なる要約にとどまらず、内容の解釈も行える点です。やりとりの要約では、顧客との会話に潜む遅延、フォローアップ漏れ、約束、期限、感情、意図を特定します。

        • Recent post analytics not very useful

          Hi, I'm enjoying some aspects of the Zoho Social. like being able to schedule posts to multiple channels. However, the recent posts analytics is disappointing. For example, I put up a reel on Instagram and Facebook yesterday. Instagram insights shows

        • [Product Update] Locations module migration in Zoho Books integration with Zoho Analytics

          Dear Customers, As Zoho Books are starting to support an advance version of the Branches/Warehouses module called the Locations module, users who choose to migrate to the Locations module in Zoho Books will also be migrated in Zoho Analytics-Zoho Books

        • What happens to the files created by user, whose account is deleted.

          Hello, I created a folder in the My folders names "Quote" I shared the same with my colleague. She created some files and folders in that folder over the period of 1 and half year. Now she left company, and I deleted her account from Zoho. What happens

        • Internal Error When Accessing Team Inbox.

          All our users are seeing this error in teaminbox. Because its a critical tool kindly resolve this issue ASAP.

        • Sharing URLs and direct access

          Hello, I am storing my team's email signature images on Workdrive. I am creating a public image download share and adding “?directDownload=true” so that the image can be accessed without the Workdrive interface. A few questions: 1) Can we generate friendly

        • Can I re-send the Customer Satisfaction Survey after a ticket closure?

          Hello, Some customers does not answer the survey right after closure, is it possible to re-send after a few days or weeks? Best Regards!

        • How to prevent users from switching price lists in an order?

          Hi, I have Zoho Finance integrated with Zoho CRM. My team will be placing orders through the CRM using the Finance module. When creating a new customer I will assign it a price list, I don't want the sales rep to switch to a different Price List, other

        • Zoho Mail Android app update: Calendar enhancements

          Hello everyone! In the most recent version of the Zoho Mail Android app update, we have introduced various new enhancements for the calendar module. Let's explore what's new. Drag and drop events to update the date and time We have enhanced the calendar

        • Enhance Delay Configuration in Zoho Flow

          Dear Zoho Flow Support Team, We are writing to request an improvement to the delay configuration process within Zoho Flow. Currently, users are required to manually enter the exact delay duration (e.g., "2 days") in the delay block. This can be time-consuming

        • Internal Server Error (500) When Attempting to View Banking Transactions

          I am experiencing an Internal Server Error (500) when attempting to view transactions across all of my banking accounts. Despite multiple attempts to resolve this, I have received little more than runaround from support, and the issue remains unresolved.

        • 1stDibs Integration to Zoho Inventory

          Hello is it possible to integrate my Zoho inventory and 1stDibs?

        • Contratação ProdutivosX

          Bem-vindo(a) ao processo de contratação da ProdutivosX. Este formulário tem como objetivo coletar informações essenciais para análise de perfil profissional, alinhamento de competências e possível integração ao equipamento ProdutivosX. A ProdutivosX é

        • Zoho Books - How to Invoke a Custom Function in Schedulers

          We have multiple schedulers that send emails to customers in batches. Currently, we are maintaining the same code across several schedulers. Is it possible to use a custom function inside a scheduler script? If yes, how can we invoke the custom function

        • Enhance Sign CRM integration

          Hello all, I'm working on a custom Deluge script to enhance the integration between Zoho CRM and Sign by using a writer merge template for additional flexibility. I want to replicate the post-sign document integration that exists between CRM and Sign

        • why does my campaign move back to draft?

          Every time I try to send my email campaign, it reverts back to Draft status.. this has happened three times in a row..how do i find out what the problem is? Thanks

        • How create a draft via workflow?

          I wish to create a workflow rule for specific emails that creates a draft response - not an automatic email reply, but just a draft with a set response ready to be verified by an agent who can then manually select recipients. Alternatively, the workflow

        • Unified WhatsApp Number Management in Zoho Desk and SalesIQ

          Dear Zoho Desk Support Team, We are currently utilizing both Zoho Desk and Zoho SalesIQ for our customer support operations. While both platforms offer WhatsApp integration, we are facing challenges due to the requirement of separate WhatsApp numbers

        • Problem using Zoho Desk API

          Goodmorning, I am trying to use the Zoho Desk API to create a dashboard in Grafana, but I am having a problem. Following the instructions in the API documentation, I created the API Console application (server-based application). Then I created the string

        • Email Field Validation Incorrectly Rejects RFC-Compliant Addresses (Forward Slashes)

          I've encountered a validation issue with Zoho Creator's Email field that rejects RFC-compliant email addresses containing forward slashes, and I'm hoping the Zoho team can address this in a future update. The Issue When entering an email address containing

        • Support for Custom Fonts in Zoho Recruit Career Site and Candidate Portal

          Dear Zoho Recruit Team, I hope you're doing well. We would like to request the ability to use custom fonts in the Zoho Recruit Career Site and Candidate Portal. Currently only the default fonts (Roboto, Lato, and Montserrat) are available. While these

        • Customer ticket creation via Microsoft Teams

          Hi all, I'm looking to see if someone could point me in the right direction. I'd love to make it so my customers/ end users can make tickets, see responses and respond within microsoft teams. As Admin and an Agent i've installed the zoho assist app within

        • Whatsapp Connection Status still "Pending" after migration

          Hello, I migrated my WhatsApp API to Zoho from another provider a day ago. So far the connection status is still “Pending”. There is a problem? How long does it usually take?

        • Zoho Books Sandbox environment

          Hello. Is there a free sandbox environment for the developers using Zoho Books API? I am working on the Zoho Books add-on and currently not ready to buy a premium service - maybe later when my add-on will start to bring money. Right now I just need a

        • Plug Sample #15 - Enable Human-Like, Contextual Interactions in SalesIQ with Zia Agents

          Zia Agents are conversational AI assistants designed to understand user intent and respond intelligently, helping businesses automate conversations and offer personalized support at scale. While Zia Agents are yet to be publicly released, access is currently

        • Simple Callback Notifications Needed

          My team are terrible at remembering their CRM callbacks, often due to how long in the future they are set for. Is there a way i can set an e-mail notification for when a callback is due? For example we set it for 9am one day and five minutes before they

        • Best way to schedule bill payments to vendors

          I've integrated Forte so that I can convert POs to bills and make payments to my vendors all through Books. Is there a way to schedule the bill payments as some of my vendors are net 30, net 60 and even net 90 days. If I can't get this to work, I'll have

        • Seamless Round-Trip Navigation for Related Blocks (Detail View)

          As highlighted previously in this post (and here, here, here, and here), we still lack a fundamental capability for seamless navigation in Related Blocks. The popup that appears when adding a related record doesn't exist for viewing/editing existing records,

        • Social Profile Logo Format

          Hello, I'm using Zoho Sites and am attempting to add a couple of social media accounts to my profile that aren't included in the default platforms that are available. What format is the logo required to be in? I have tried .png and .jpg with no success.

        • How to create Sepa Direct Debit XML file: solution and code

          Even though Books provides a payment integration for Stripe and Gocardless (in Europe) there are customers that want to use the Sepa services of their own bank. Mainly because Stripe and Gocardless are quite expensive. In that case they would need a Sepa

        • Traditional Spreadsheet vs Zoho Tables

          Hello everyone, This article explains the differences between Spreadsheet applications and no-code databases, such as Zoho Tables. While both tools belong to the "grid" family, the core difference lies in their purpose. A spreadsheet (such as Zoho Sheet,

        • RFQ MODEL

          A Request for quotation model is used for Purchase Inquiries to multiple vendors. The Item is Created and then selected to send it to various vendors , once the Prices are received , a comparative chart is made for the user. this will help Zoho books

        • Next Page