Inserting SalesOrder with product referred by Product name

Inserting SalesOrder with product referred by Product name

In the API documentation it is stated that for a product attached to a sales order, the field "Product Id" is mandatory.
Then the docs say that the "Product Name" can be specified,  if you do not have a valid product ID.

I've made several tries to implement this. I've tried
  • Filling in Product Name and leaving Product Id empty (or not sending it)
<SalesOrders>
<row no="1">
<FL val="Subject">Test - SO</FL>
<FL val="Product Details">
<product no="1">
<FL val="Product Name">Product name</FL>
</product>
</FL>
</row>
</SalesOrders>








  • Filling the product name in for Product Id and leaving Product Name empty (or not sending it)
<SalesOrders>
<row no="1">
<FL val="Subject">Test- SO</FL>
<FL val="Product Details">
<product no="1">
<FL val="Product Id">Product name</FL>
</product>
</FL>
</row>
</SalesOrders>









I am currently working on an application which doesn't know the different product ids, but does know the product names. So I really need this to work! Having to make requests to get the product ids is not preferred, because of the API limits..

Thanks,