List of filters for sales order API

Question

I'm working with the Magento SOAP API. Many of the methods will list entites and allow for filtering in the request - however I can find no information in the documentation about what filters are available to use.

I've found some documentation about the kinds of operators we can use, but I'm left guessing at the field names themselves. Perhaps this is considered obvious for Magento developers, but I have little familarity with the Magento core.

Is there a list anywhere of the various fields that can be used for filtering? Specifically I'm looking for sales order filters at present, but ideally I'd like a comprehensive list of every field that can be filtered on every API method that allows filtering.

Answer 1

I don't think there's a good way to definitively answer this question. In the Magento core, filters tie either to attributes or database columns. Attributes are store-specific, and there's no definitive list of what each store will or will not have. The best way to discover the attributes in your store is to look in the admin panel "Manage attributes" page.

Database columns can also differ somewhat from store to store, but not as much. I suggest looking in your store's database to see what columns map to what entities.

If you have any other, more specific questions, please let me know in the comments!