Zoho API insert product record subform

Zoho API insert product record subform

I'm trying to insert products into the Zoho CRM via the API (version 1.0). I have several hundereds of products in a custom XML file that need to be inserted in the CRM as products in my custom layout, but I am encountering several issues.
The custom layout contains several custom fields (I can insert these just fine) except for the subform.
  1. Is it possible to insert subforms? Searching yielded nothing helpful except this zoho help article which didn't have a conclusive answer regarding my specific query.
  2. How can I insert an image? The uploadPhoto endpoint only works with Leads and contacts.

This is the XML I'm currently sending (this works fine for default and custom fields):
  1. <Products>
  2. <row no="1">
  3. <FL val="Layout">128694000000128516</FL>
  4. <FL val="Product Name">Test product 1</FL>
  5. <FL val="Vendor Name"></FL>
  6. <FL val="EAN code">123456</FL>
  7. <FL val="Product Category">Ring</FL>
  8. <FL val="Inkoopprijs">1234</FL>
  9. <FL val="Unit Price">9876</FL>
  10. <FL val="Hoeveelheid in voorraad">1</FL>
  11. <FL val="Description">description here!</FL>
  12. </row>
  13. </Products>
For the subform, I tried adding the following inside the above:
  1. <FL val="SubFormName">
  2.    <row no="1">
  3.       <FL val="SubFormField1">x</FL>
  4.       <FL val="SubFormField2">y</FL>
  5.    </row>
  6. </FL>
Alternatives for " <row no=1>" I tried " <add>" and " <product>", but none seem to work.


Any help would be greatly appreciated!