Skip to main content

Magento API Filter operators and list of fields for Product.List

Following are operators you can use when create filter for Magento Api calls:

from returns rows that are after this value (datetime only)
to returns rows that are before this value (datetime only)
eq returns rows equal to this value
neq returns rows not equal to this value
like returns rows that match this value (with % as a wildcard)
nlike returns rows that do not match this value (with % as a wildcard)
in returns rows where the value is in this array (pass an array in)
nin returns rows where the value is not in this array (pass an array in)
is
null returns rows that are null
notnull returns rows that are not null
moreq
gt returns rows greater than this value
lt returns rows less than this value
gteq returns rows greater than or equal to this value
lteq returns rows less than or equal to this value
finset

And following are the lits of fields you can filter on using Product.List api call


[0] => entity_id
[1] => entity_type_id
[2] => attribute_set_id
[3] => type_id
[4] => sku
[5] => has_options
[6] => required_options
[7] => created_at
[8] => updated_at
[9] => name
[10] => url_key
[11] => gift_message_available
[12] => meta_title
[13] => meta_description
[14] => image
[15] => small_image
[16] => thumbnail
[17] => custom_design
[18] => page_layout
[19] => options_container
[20] => url_path
[21] => image_label
[22] => thumbnail_label
[23] => small_image_label
[24] => description
[25] => short_description
[26] => meta_keyword
[27] => custom_layout_update
[28] => weight
[29] => price
[30] => special_price
[31] => cost
[32] => news_from_date
[33] => news_to_date
[34] => special_from_date
[35] => special_to_date
[36] => custom_design_from
[37] => custom_design_to
[38] => exclusive
[39] => size
[40] => color
[41] => status
[42] => visibility
[43] => is_imported
[44] => tax_class_id
[45] => enable_googlecheckout
[46] => is_recurring
[47] => is_salable
[48] => stock_item

Comments

Popular posts from this blog

Reflector for .Net - amaizing how open your .Net source code

Reflector for .Net - Reflector is the class browser, explorer, analyzer and documentation viewer for .NET. Reflector allows to easily view, navigate, search, decompile and analyze .NET assemblies in C#, Visual Basic and IL. At same site there are also other interesting tools like: Resourcer for .NET - Resourcer is an editor for .resources binaries and .resX XML file formats used with the .NET platform Mapack for .NET - Mapack is a .NET class library for basic linear algebra computations.

Must To Have Utilities

FileMon - FileMon monitors and displays file system activity on a system in real-time. Note: Filemon and Regmon have been replaced by Process Monitor on versions of Windows starting with Windows 2000 SP4, Windows XP SP2, Windows Server 2003 SP1, and Windows Vista. Unlocker - The solution for "Cannot delete file: Access is denied" error message. Dependency.exe - Dependency Walker is a free utility that scans any 32-bit or 64-bit Windows module (exe, dll, ocx, sys, etc.) and builds a hierarchical tree diagram of all dependent modules. SCDL version 1.1 - Generates source code for config sections based on an XML sample, also creates the XSD schema for the section. Expresso - Regular Expression Editor and Tester

Post on behalf of Facebook Page using Graph API

Assuming someone would like to give your permissions to post on his Facebook Pages :-), you need to do following things: Ask for the publish_stream and manage_pages using Facebook Authentication Dialog Get Page Access Token. Such access token can be retrieved by issuing an HTTP GET to /USER_ID/accounts with the manage_pages permission. This will bring you list of the pages and access tokens of such pages. You also can you /PAGE_ID?fields=access_token request to get access token for specific page. (Reference - https://developers.facebook.com/docs/reference/api/page/) Once you have page access token you will be able to post. Posting can be done using following parameters: curl -F 'access_token={ACCESS_TOKEN}' \ -F 'message={MESSAGE TO POST}' \ https://graph.facebook.com/{PAGE}/feed