How to apply filters for SQL tables in Logic Apps?

Data and Databases
1

I’m facing an issue when trying to retrieve data from my SQL table based on the datetimeoffset column. I have a table called A that contains a column named UpdatedAt. My SQL query looks like this:

SELECT * 
FROM A 
WHERE UpdatedAt = '2025-01-17 19:31:58 +2:00'

However, it returns no results. When translating the same filter into Logic Apps using the SQL Action, it still yields an empty result. What could be the issue, and how can I address it? The UpdatedAt column is of type datetimeoffset(0). Here’s a snippet of my Logic App definition for filtering by datetime:

{
    "definition": {
        "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
        "actions": {
            "Get_current_batches": {
                "type": "ApiConnection",
                "description": "Fetching current in-progress rows via custom SQL",
                "inputs": {
                    "host": {
                        "connection": {
                            "referenceName": "sql-1"
                        }
                    },
                    "method": "get",
                    "path": "/v2/datasets/@{encodeURIComponent(parameters('SQL_SERVER_C'))},@{encodeURIComponent('Apax_CoreServices')}/tables/@{encodeURIComponent('[A].[A]')}/items",
                    "queries": {
                        "$filter": "UpdatedAt eq '2025-01-17T19:31:58Z'"
                    }
                }
            }
        },
        "contentVersion": "1.0.0.0"
    },
    "kind": "Stateful"
}

Despite the row being present with this datetime, the result remains empty. What might be causing this?

2

maybe try changing the+2:00 timezone to Z in your SQL query and see if it works, sometimes timezone mismatches cause issues. check if ur logic app action has proper permissions to access the data too. hope this helps! good luck! :+1: