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
Matches the exact value only (e.g., "Apple"). -
Wildcard (Multiple characters / Starts with, Ends with, or Contains):
-
&search[equal][mobile_device_model][]=iPhone+15*(Starts with "iPhone 15", e.g., "iPhone 15 Pro") -
&search[equal][mobile_device_model][]=*iPhone+15(Ends with "iPhone 15") -
&search[equal][mobile_device_model][]=*iPhone+15*(Contains "iPhone 15". Tip: Use this if your XML data has hidden trailing/leading spaces inside CDATA tags!)
-
-
Wildcard (Single character):
&search[equal][mobile_device_model][]=iPhone+1?
Matches exactly one variable character (e.g., "iPhone 14", "iPhone 15", or "iPhone 16"). -
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]=2025-03-08 -
Smaller than or equal to:
&search[lte][release_date]=2025-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.
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.