Trying to add Products from Accounts subform

Trying to add Products from Accounts subform

Hi, 

I have the following script to to add separate Products from a subform in an Account record. There is data in the subform, but I keep getting the error "No records were added". 

Please advise.


  2. string related_list.relateBuyerCriteria(String accountId)
  3. {
  4. // Convert accountId to string (if required by API)
  5. accountIdStr = accountId.toString();
  6. // Get the latest Account record from Zoho CRM
  7. formResponse = zoho.crm.getRecordById("Accounts",accountIdStr);
  8. if(formResponse.containsKey("Acquisition_Criteria"))
  9. {
  10. productList = formResponse.get("Acquisition_Criteria");
  11. successCount = 0;
  12. for each  product in productList
  13. {
  14. // Create a new related list entry in CRM
  15. productEntry = Map();
  16. productEntry.put("Account_Name",accountIdStr);
  17. productEntry.put("EBITDA",ifnull(product.get("EBITDA"),"N/A"));
  18. productEntry.put("Minimum_number_of_employees",ifnull(product.get("Minimum_number_of_employees"),"N/A"));
  19. productEntry.put("Minimum_number_of_years_in_business",ifnull(product.get("Minimum_number_of_years_in_business"),"N/A"));
  20. // Insert into the related list (Business_Wanted under Accounts)
  21. response = zoho.crm.createRecord("Business_Wanted",productEntry);
  22. // Check if insertion was successful
  23. if(response.containsKey("id"))
  24. {
  25. successCount = successCount + 1;
  26. }
  27. }
  28. if(successCount > 0)
  29. {
  30. return "Success: " + successCount + " related records added.";
  31. }
  32. else
  33. {
  34. return "No records were added.";
  35. }
  36. }
  37. else
  38. {
  39. return "No related records found.";
  40. }
  41. }


Thanks,

Jason