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

Request parameters

Parameter Type Required Example Description
NodeInstanceId String Yes FE4BD156E939CF1F The ID of the node instance.
ProjectId String Yes FP-7A1018ADE9179EE1 The ID of the project.
RegionId String Yes cn-hangzhou The ID of the region.
Length Integer No 100 The number of results to show.
Offset Integer No 0 The starting point to return results.
SqlIndex Integer No 0 The specified result that you want to view.

Response parameters

Name Type Example Description
RequestId String 90F14544-832D-4D81-8F8C-8F8547AE5B9D The ID of the request.
End Boolean true Indicates whether all results are shown.
RowList The list of rows.
RowIndex Integer 0 The number of the row.
RowItemList String { "rowItem": [ "1", "1", "1" ] } The content of the row.
HeaderList String { "Header": [ "rankings.pageurl", "rankings.pagerank", "rankings.avgduration" ] } The header row.

Examples

  • Sample requests
    
    /? Action=ListFlowNodeSqlResult
    &NodeInstanceId=FE4BD156E939CF1F
    &ProjectId=FP-7A1018ADE9179EE1
    &RegionId=cn-hangzhou
    &Length=100
    &Offset=0
    &SqlIndex=0
    &<Common request parameters>
  • Successful response examples
    JSON format
    {
    	"End":true,
    	"HeaderList":{
    		"Header":[
    			"rankings.pageurl",
    			"rankings.pagerank",
    			"rankings.avgduration"
    		]
    	},
    	"RequestId":"90F14544-832D-4D81-8F8C-8F8547AE5B9D",
    	"RowList":{
    		"Row":[
    			{
    				"RowIndex":0,
    				"RowItemList":{
    					"rowItem":[
    						"1",
    						"1",
    						"1"
    					]
    				}
    			},
    			{
    				"RowIndex":1,
    				"RowItemList":{
    					"rowItem":[
    						"1",
    						"1",
    						"1"
    					]
    				}
    			}
    		]
    	}
    }
  • Error response examples
    JSON format
    {
    	"code":"FLOW_API_FAILED",
    	"message":"Job instance does not exist [FJI-38BA0B24245155A]",
    	"requestId":"67C4D5F0-E8E1-408C-9BD0-4268A721EC3A",
    	"successResponse":false
    }

Error codes

View error codes.