sqlEndPoint metadata refresh

curl -X POST \
  "https://api.fabric.microsoft.com/v1/workspaces/<ws_id>/sqlEndpoints/<sql_enddpoint_id>/refreshMetadata" \
  -H "Authorization: Bearer <your-access-token>" \
  -H "Content-Type: application/json" \
  -d '{"timeout": {"timeUnit": "Minutes", "value": 10}}'

 

I keep on getting Response code 200, I was expecting 202.

 

As a result, I am getting

{
  "value": [
    {
      "tableName": "test",
      "status": "NotRun",
      "startDateTime": "2025-07-31T00:07:15.0306056Z",
      "endDateTime": "2025-07-31T00:07:15.5150298Z",
      "lastSuccessfulSyncDateTime": "2025-06-05T02:29:01.543114Z",
      "error": null
    }]}

 

Why is it only returning TableSync Status and not triggering a refresh?

 

Do I understand that I need to make the service call immediately following a transaction such as following? Else it will show as NotRun if the background jobs deems it is not necessary to refresh the metadata?

def acid_transaction():
    # do something
def refresh_metadata ():
    # refresh metadata

# pseudo workflow
acid_transaction()
   ↓
refresh_metdata()