Many of the product feeds contain thousands of products, but what if you only want a selection of these products? Let’s say you have a website about Apple products—then you don’t want Samsung products. Or perhaps you have a website focused on last-minute travel offers, and you don’t want trips with a departure date too far in the future.
That's why Daisycon has created filter options that you can use to get parts of the feeds. First, you need to create a product feed using the interface or the Build a product feed URL feature. Use the feed URL and add one or more of the following options.
Filter Options
-
Exact match:
&search[equal][mobile_device_brand][]=Apple -
Wildcard with multiple characters:
&search[equal][mobile_device_model][]=Iphone+6* -
Wildcard with one character:
&search[equal][mobile_device_model][]=Iphone+6? -
Unequal:
&search[unequal][mobile_device_model][]=Iphone -
Greater than or equal to:
&search[gte][price]=200 -
Smaller than:
&search[lt][price]=600 -
Greater than:
&search[gt][release_date]=2023-03-08 -
Smaller than or equal to:
&search[lte][release_date]=2023-03-08
*Filtering is not possible on fields with TEXT as SQL Data Type.
As you can see in these parameters, you can simply insert the field name (for example, ‘mobile_device_model’) and specify what you're looking for. This option is available for all fields except the description field. You can search the description field using our free search functionality, which filters across all fields (e.g., in the title, description, etc.) using &search[free]=Sony+Xperia+Z5.
Examples of Filtered product feed URLs
Example 1: A URL of trips to Greece with a departure date between 2025-03-01 and 2025-03-08:
https://daisycon.io/datafeed/?program_id=7611&media_id=22848&standard_id=1&language_code=nl&locale_id=1&type=xml&encoding=utf8&search[equal][destination_country][]=GR&search[gte][departure_date]=2025-03-01&search[lt][departure_date]=2025-03-08&
Example 2: A URL of a product feed with the Adidas brand and size XL:
https://daisycon.io/datafeed/?program_id=7611&media_id=22848&standard_id=1&language_code=nl&locale_id=1&type=xml&encoding=utf8&search[equal][brand][]=Adidas&search[equal][size][]=*XL*
Retrieving Updated Data
It's also possible to retrieve only updated or removed products since a specific date:
-
All products:
&update=normal(default value) -
Updated products:
&update=update -
New products:
&update=insert -
Removed products:
&update=delete -
All changes:
&update=all(includes updated, new, and removed products)
When retrieving updates, you must always include a date using &update_since=YYYY-MM-DD%20HH:MM:SS.
Example: Only the changes since 2024-12-01 00:00:00:
https://daisycon.io/datafeed/?program_id=7611&media_id=22848&standard_id=1&language_code=nl&locale_id=1&type=xml&encoding=utf8&update=all&update_since=2024-12-01%2000:00:00
Pagination
If you don’t want all the products in one response and prefer to paginate, please read our paginating functionality.