Remove by query API

Auto generated schema based 'Remove by query' API used POST request method. Here, give some examples and references.

Sample data

customer_id	first_name	last_name	last_update	pincode	isActive
1	Bob	lin	2022-11-14 04: 34: 58	382345	1
2	Alice	Page	2022-10-15 02: 10: 40	382346	1
3	Mallory	Brown	2022-09-13 03: 44: 05	382347	1
4	Eve	Mathly	2022-11-12 01: 59: 33	382348	1
5	Eve	Page	2022-11-12 01: 59: 33	382349	1

URL

/api/schema/user-path/instance/database/table/query/delete

Request Payload

{
    "find": {
        "first_name": "Bob"
    }
}

$in with select, limit, deep

Request Payload

{
    "find": {
        "first_name": {
            "$in": [
                "Bob"
            ]
        }
    },
    "select": "name,description",
    "limit": 1,
    "deep": [
        {
            "s_key": "customer_id",
            "t_col": "products",
            "t_key": "owner_id"
        }
    ]
}

string | number supports different datatype

'pincode' datatype is a number, but we pass it as a string in the payload. Yet, it will delete.

Request Payload

{
    "find": {
        "pincode": "382330"
    }
}

'$nin' not in

Request Payload

{
    "find": {
        "first_name": {
            "$nin": [
                "Bob",
                "Alice"
            ]
        }
    }
}

$eq

Request Payload

{
    "find": {
        "customer_id": {
            "$eq": 19
        }
    }
}

$ne

Request Payload

{
    "find": {
        "customer_id": {
            "$ne": 19
        }
    }
}

$lt

Request Payload

{
    "find": {
        "customer_id": {
            "$lt": 19
        }
    }
}

$lte

Request Payload

{
    "find": {
        "customer_id": {
            "$lte": 19
        }
    }
}

$gt

Request Payload

{
    "find": {
        "customer_id": {
            "$gt": 19
        }
    }
}

$gte

Request Payload

{
    "find": {
        "customer_id": {
            "$gte": 19
        }
    }
}

$and

Request Payload

{
    "find": {
        "$and": [
            {
                "customer_id": {
                    "$lte": 15
                }
            },
            {
                "first_name": "Bob"
            }
        ]
    }
}

$or

Request Payload

{
    "find": {
        "$or": [
            {
                "customer_id": 155
            },
            {
                "first_name": "Bob"
            }
        ]
    }
}