In this Article, we will be going over the ways you can filter out the collection fields, along with some tips.
But first, let us define what Filtering is and how it can help you achieve the desired results.
The important thing to note is that it is completely optional and that you can apply as many filters as you wish.
Additionally, when a Filter is applied, only the Data affected by it will get sent over during the task execution. A common misconception is that the filtered values will get left out.
The criteria for Filtering will vary based on:
• Source Integration
• The Entity (Data Type)
You can find a step by step guide on how to integrate any of our native Integrations on the following hyperlink.
With the Filters defined, we can proceed with filtering out the Collection Fields:
First of all, we need to understand the term "Item" which represents a sort of entity.
E.G. If there's an entity called "car", then one item would be one car.
Items can have various fields in themselves such as Name, ID, etc.
Items can also have the so-called Collection field.
Collection fields contain multiple values in them, and they are always of the same type (e.g. number or text, etc.)
To better illustrate this, let's imagine two items arriving at SyncSpider, and both of them having collection fields:
1st Item's collection field:
Item1.collection = [
2nd Item's collection field:
Item2.collection = [
Now, if we wished to export the items that have the value "orange" at least once, we would apply the "only one item needs to pass filter" option, and set the value to "orange".
In that case, both Item 1 and Item 2 would get exported.
However, if we go with the "all items need to pass filter" option and set the value to "orange", then only Item 2 would get exported.
We hope that this example helped you understand how Collection filtering works and gave you some ideas that you can apply to your own tasks that migrate Items with collection fields. :)
If you have any additional questions you can contact our Customer Support through the chatbox on your bottom right.