Describe the bug
I try to get the trigger type of a workflow using OPENJSON.
The problem is all the lines have the same data (like if it was the data from the first line)

To Reproduce
Query to reproduce the behavior:

SELECT 
    W.name, 
    (SELECT TOP 1 [key] from OPENJSON(W.clientdata, '$.properties.definition.triggers')) AS triggers_section
FROM workflow W
WHERE W.category = 5 

Expected behavior
I want the trigger type of the workflow

Screenshots

Environment (please complete the following information):

• SQL 4 CDS edition: XrmToolBox
• Results of SELECT @@VERSION:Microsoft Dataverse - 9.2.25052.230
  SQL 4 CDS - 1.0.0.0
  juin 09 2025 23:22:37
  Copyright © 2020 - 2025 Mark Carrington