C#•4w ago

Azure Data API Builder - Partial Match

Anyone familiar with the Azure Data API Builder how I can do a partial match filter with a string? There doesn't seem to be a filter operator for a "like". https://learn.microsoft.com/en-us/azure/data-api-builder/rest#filter

5 Replies

AugerOP•4w ago

For example, I do a filter query param like the following, but this of course does not support a partial match

$"$filter={nameof(User.FirstName)} eq '{name}' or {nameof(User.LastName)} eq '{name}'"

$"$filter={nameof(User.FirstName)} eq '{name}' or {nameof(User.LastName)} eq '{name}'"

that's odata, not c# 😒 anyway, there are also azure and power stuff discord servers anyway a google search for "odata like" answers with contains()

AugerOP•4w ago

I should have mentioned before, but I've tried that. Results in

{
    "error": {
        "code": "BadRequest",
        "message": "$filter query parameter is not well formed.",
        "status": 400
    }
}

{
    "error": {
        "code": "BadRequest",
        "message": "$filter query parameter is not well formed.",
        "status": 400
    }
}

AugerOP•4w ago

From everything I've researched, Data API Builder might just not support it

there seem to be too many ' i guess it should be contains(FirstName, 'Auger')