azure-functions-python-worker icon indicating copy to clipboard operation
azure-functions-python-worker copied to clipboard

[Bug] Azure Table row key not honoured

Open d-s-dc opened this issue 6 months ago • 2 comments

Expected Behavior

I want to read only rows for specific row key and partition key from a table storage in azure.

Actual Behavior

The function returned all rows for the partition instead of filtering on row key.

Steps to Reproduce

  1. Create a python v2 function in vs code on mac.
  2. Specify the table as input binding with the relevant details
  3. Print the table data read

Relevant code being tried

import logging
import azure.functions as func
import json

app = func.FunctionApp()

@app.table_input(arg_name="messageJSON",
    connection="table_conn",
    table_name="lastSyncStatus",
    row_key="inspector",
    partition_key="category")
@app.timer_trigger(schedule="0 */5 * * * *", arg_name="myTimer", run_on_startup=False, use_monitor=False) 
def table_in_binding(myTimer: func.TimerRequest, messageJSON):
    message = json.loads(messageJSON)
    logging.info(message)

Relevant log output

Executing 'Functions.table_in_binding' (Reason='This function was programmatically called via the host APIs.', Id=33c96dd8-2a8a-4182-af0c-fe5b884e4373)
[2025-07-28T18:44:02.465Z] [{'PartitionKey': 'category', 'RowKey': 'infrastructure', 'last_sync_time': '2025-07-28T18:15:00.004945+00:00', 'pipeline_succeeded': False}, {'PartitionKey': 'category', 'RowKey': 'inspector', 'last_sync_time': '2025-07-28T18:15:00.004945+00:00', 'pipeline_succeeded': True}]
[2025-07-28T18:44:02.476Z] Executed 'Functions.table_in_binding' (Succeeded, Id=33c96dd8-2a8a-4182-af0c-fe5b884e4373, Duration=1025ms)

requirements.txt file

azure-functions

Where are you facing this problem?

Local - Core Tools

Function app name

No response

Additional Information

No response

d-s-dc avatar Jul 28 '25 18:07 d-s-dc