Call the ListFlowNodeSqlResult to query the sql query results of the node instance.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Request parameters

Parameter Type Required Example Description
NodeInstanceId String Yes FE4BD156E939****

The ID of the job instance.

ProjectId String Yes FP-7A1018ADE917****

The ID of the project.

RegionId String Yes cn-hangzhou

The region ID of the instance.

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
RequestId String 90F14544-832D-4D81-8F8C-8F8547AE5B9D

The ID of the request.

End Boolean true

Indicates whether the query ended.

RowList Array

The row of the SQL result.

RowIndex Integer 0

The number of the row.

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

The contents of the row.

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

The header list of the SQL result.

Examples

Sample request

http(s)://[Endpoint]/? Action=ListFlowNodeSqlResult
&NodeInstanceId=FE4BD156E939****
&ProjectId=FP-7A1018ADE917 static website hosting *
&RegionId=cn-hangzhou
&<Common request parameters>

Sample success responses

XML format

<ListFlowNodeSqlResultResponse>
  <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>
    

</ListFlowNodeSqlResultResponse>

JSON format

{
    "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
}

Error codes

For a list of error codes, visit the API Error Center.