Run a draft QuerySpec

POST

/query-specs/dry-run

Query Specs

Executes a draft QuerySpec against the workspace database and returns the rows, the compiled SQL, and — for a rule's postMatchCondition — the verdict the evaluator would reach. Persists nothing.

Request

Body Params application/jsonRequired

Examples

Responses

🟢200OK

application/json

Query executed

Bodyapplication/json

🟠401Unauthorized

🟠404Record Not Found

Request Example

Shell

JavaScript

Java

Swift

curl --location 'https://api.aworld.cloud/dashboard/v1/query-specs/dry-run' \
--header 'Content-Type: application/json' \
--data '{
    "spec": {
        "from": {
            "sources": [
                {
                    "table": "string",
                    "alias": "string",
                    "joins": [
                        {
                            "type": "INNER",
                            "toAlias": "string",
                            "condition": {
                                "==": [
                                    1,
                                    1
                                ]
                            }
                        }
                    ]
                }
            ],
            "where": {
                "==": [
                    1,
                    1
                ]
            }
        },
        "select": {
            "fields": [
                {
                    "source": "string",
                    "alias": "string"
                }
            ],
            "expressions": [
                {
                    "name": "string",
                    "expression": {
                        "==": [
                            1,
                            1
                        ]
                    }
                }
            ]
        },
        "with": [
            {
                "name": "string",
                "query": {
                    "from": {
                        "sources": [
                            {
                                "table": "string",
                                "alias": "string"
                            }
                        ],
                        "where": {
                            "==": [
                                1,
                                1
                            ]
                        }
                    },
                    "select": {
                        "fields": [
                            {
                                "source": "string",
                                "alias": "string"
                            }
                        ],
                        "expressions": [
                            {
                                "name": "string",
                                "expression": {
                                    "==": [
                                        1,
                                        1
                                    ]
                                }
                            }
                        ]
                    },
                    "groupBy": {
                        "columns": [
                            "string"
                        ]
                    },
                    "having": {
                        "==": [
                            1,
                            1
                        ]
                    },
                    "orderBy": {
                        "expressions": [
                            {
                                "expression": {
                                    "==": [
                                        1,
                                        1
                                    ]
                                },
                                "direction": "ASC"
                            }
                        ],
                        "window": {
                            "function": "ROW_NUMBER",
                            "alias": "string"
                        },
                        "tieExpressions": [
                            {
                                "expression": {
                                    "==": [
                                        1,
                                        1
                                    ]
                                },
                                "direction": "ASC"
                            }
                        ]
                    }
                },
                "recursive": {
                    "table": "string",
                    "keyColumn": "string",
                    "parentColumn": "string",
                    "startFrom": {
                        "==": [
                            1,
                            1
                        ]
                    },
                    "maxDepth": 1
                },
                "join": {
                    "type": "INNER",
                    "on": {
                        "==": [
                            1,
                            1
                        ]
                    }
                }
            }
        ],
        "groupBy": {
            "columns": [
                "string"
            ]
        },
        "having": {
            "==": [
                1,
                1
            ]
        },
        "orderBy": {
            "expressions": [
                {
                    "expression": {
                        "==": [
                            1,
                            1
                        ]
                    },
                    "direction": "ASC"
                }
            ],
            "window": {
                "function": "ROW_NUMBER",
                "alias": "string"
            },
            "tieExpressions": [
                {
                    "expression": {
                        "==": [
                            1,
                            1
                        ]
                    },
                    "direction": "ASC"
                }
            ]
        },
        "search": [
            {
                "in": "title",
                "as": "inTitle",
                "for": {
                    "==": [
                        1,
                        1
                    ]
                }
            }
        ]
    },
    "contract": "leaderboard",
    "timeframeStartsAt": "2019-08-24T14:15:22.123Z",
    "timeframeEndsAt": "2019-08-24T14:15:22.123Z",
    "sampleRuntimeVars": {
        "property1": "string",
        "property2": "string"
    },
    "limit": 20
}'

Response Example

{
    "rows": [
        {
            "property1": "string",
            "property2": "string"
        }
    ],
    "rowCount": 0,
    "truncated": true,
    "compiledSql": "string",
    "verdict": true,
    "unboundVars": [
        "string"
    ],
    "durationMs": 0
}

Modified at 2026-09-10 08:52:11

Search assignments

ActivityTranslation