Example on filtering data in GET methods

You can use several filters together and it will then be interpreted as AND.

Note: Do not use quotation marks (like "this" or 'this') when using filters. All parameters will be interpreted on our side, use our examples where possible. Enums and strings should be written out without quotation marks.([parameter][EQ]=this)

Selecting the article with id between 120 and 150, take 50 rows, skip 0 rows, order by id descending. Note that id is an integer datatype

                                        {
                                            "id": {
                                            "BETWEEN": [
                                            120, 150
                                            ]
                                            },
                                            "take": 50,
                                            "skip": 0,
                                            "orderby": {
                                            "desc": [
                                            "id"
                                            ]
                                            }
                                            }
                                        

filter[id][BETWEEN]=1&filter[id][BETWEEN]=20&filter[take]=50&filter[skip]=0&filter[orderby][desc]=id

Selecting all articles with articleType in "hour","normal"

                                            {
                                            "articleType": {
                                            "IN": [
                                            "hour",
                                            "normal"
                                            ]
                                            }
                                            }
                                        
                                        

filter[articleType][in]=hour&filter[articleType][IN]=normal

Use the Rowversion on the mother object to filter on newer or older versions. Its only possible to use [GT] (only) on Rowversion due to datatype limitations. To get those rows that has been changed since the last query, you have to take the MAX(Rowversion) of the "mother" object from that result and select like the next time to get the new and changed rows:

                                            {
                                            "rowversion": {
                                            "GT": [
                                            "9535698"
                                            ]
                                            }
                                            }
                                        

filter[Rowversion][GT]=9535698

You can query two levels deep like this:

                                            {
                                            "carrierType.carrierTypeKind": {
                                            "NIN": [
                                            "free", "activity"
                                            ]
                                            },
                                            "take": 50,
                                            "skip": 50,
                                            "orderby": {
                                            "asc": [
                                            "id"
                                            ]
                                            }
                                            }
                                        

carrierType.carrierTypeKind][NIN]=free&filter[carrierType.carrierTypeKind][NIN]=activity&filter[take]=50&filter[skip]=50&filter[orderby][asc]=id