You can call the ListFlowNodeSqlResult operation to query the SQL results of a node instance.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. You can use OpenAPI Explorer to search for API operations, call API operations, and dynamically generate SDK sample code.

Request parameters

Parameter Type Required Example Description
Action String Yes ListFlowNodeSqlResult

The operation that you want to perform. Set the value to ListFlowNodeSqlResult.

NodeInstanceId String Yes FE4BD156E939****

The IDs of the nodes. You can call ListFlowNodeInstance View the instance ID.

ProjectId String Yes FP-7A1018ADE917****

The ID of the project. You can call ListFlowProject View the project ID.

RegionId String Yes cn-hangzhou

The ID of the region. You can call DescribeRegions View the latest list of Alibaba Cloud regions.

SqlIndex Integer No 0

The number of the SQL result.

Offset Integer No 0

The offset of the SQL result.

Length Integer No 100

The length of the SQL result.

Response parameters

Parameter Type Example Description
End Boolean true

Indicates whether the query ended.

HeaderList List { "Header": [ "rankings.pageurl", "rankings.pagerank", "rankings.avgduration" ] }

The header of the SQL result.

RequestId String 90F14544-832D-4D81-8F8C-8F8547AE5B9D

The ID of the request.

RowList Array of Row

The row list of the SQL result.

Row
RowIndex Integer 0

The number of the row.

RowItemList List { "rowItem": [ "1", "1", "1" ] }

The content of the row.

Examples

Sample requests

{
    "RowList": {
        "Row": [
            {
                "RowItemList": {
                    "rowItem": [
                        "1",
                        "1",
                        "1"
                    ]
                },
                "RowIndex": 0
            },
            {
                "RowItemList": {
                    "rowItem": [
                        "1",
                        "1",
                        "1"
                    ]
                },
                "RowIndex": 1
            }
        ]
    },
    "RequestId": "90F14544-832D-4D81-8F8C-8F8547AE5B9D",
    "HeaderList": {
        "Header": [
            "rankings.pageurl",
            "rankings.pagerank",
            "rankings.avgduration"
        ]
    },
    "End": true
}

Sample success responses

XML format

<RowList>
    <Row>
        <RowItemList>
            <rowItem>1</rowItem>
            <rowItem>1</rowItem>
            <rowItem>1</rowItem>
        </RowItemList>
        <RowIndex>0</RowIndex>
    </Row>
    <Row>
        <RowItemList>
            <rowItem>1</rowItem>
            <rowItem>1</rowItem>
            <rowItem>1</rowItem>
        </RowItemList>
        <RowIndex>1</RowIndex>
    </Row>
</RowList>
<RequestId>90F14544-832D-4D81-8F8C-8F8547AE5B9D</RequestId>
<HeaderList>
    <Header>rankings.pageurl</Header>
    <Header>rankings.pagerank</Header>
    <Header>rankings.avgduration</Header>
</HeaderList>
<End>true</End>

JSON

{
    "RowList": {
        "Row": [
            {
                "RowItemList": {
                    "rowItem": [
                        "1",
                        "1",
                        "1"
                    ]
                },
                "RowIndex": 0
            },
            {
                "RowItemList": {
                    "rowItem": [
                        "1",
                        "1",
                        "1"
                    ]
                },
                "RowIndex": 1
            }
        ]
    },
    "RequestId": "90F14544-832D-4D81-8F8C-8F8547AE5B9D",
    "HeaderList": {
        "Header": [
            "rankings.pageurl",
            "rankings.pagerank",
            "rankings.avgduration"
        ]
    },
    "End": true
}