How do I search CRM SalesOrders by Product ID via the API?

How do I search CRM SalesOrders by Product ID via the API?

Hey everyone

I'm using the Zoho CRM API to retrieve SalesOrders, and I want to retrieve the SalesOrders that have a specific Product ID in their line items.

A query like this works fine:

https://crm.zoho.com/crm/private/json/SalesOrders/searchRecords?authtoken=12345&scope=crmapi&criteria=(Status:Interested)&selectColumns=All&toIndex=200&newFormat=2&version=2

... but when I try to specify Product ID like this:

https://crm.zoho.com/crm/private/json/SalesOrders/searchRecords?authtoken=12345&scope=crmapi&criteria=(Product ID:896459000000083941)&selectColumns=All&toIndex=200&newFormat=2&version=2

... or this:

https://crm.zoho.com/crm/private/json/SalesOrders/searchRecords?authtoken=12345&scope=crmapi&criteria=(PRODUCTID:896459000000083941)&selectColumns=All&toIndex=200&newFormat=2&version=2

... nothing is returned.

How can I use the API to fetch all SalesOrders that have a specific Product ID?