On this page

    Job Results

    Use the Job API to retrieve results for a specific job.

    Job Results Object
    {
      "rowCount": 11,
      "schema": [
        {
          "name": "pickup_datetime",
          "type": {
            "name": "TIMESTAMP"
          }
        },
        {
          "name": "passenger_count",
          "type": {
            "name": "BIGINT"
          }
        },
        {
          "name": "trip_distance_mi",
          "type": {
            "name": "DOUBLE"
          }
        },
        {
          "name": "fare_amount",
          "type": {
            "name": "DOUBLE"
          }
        },
        {
          "name": "tip_amount",
          "type": {
            "name": "DOUBLE"
          }
        },
        {
          "name": "total_amount",
          "type": {
            "name": "DOUBLE"
          }
        }
      ],
      "rows": [
        {
          "pickup_datetime": "2013-02-10 20:00:00.000",
          "passenger_count": 9,
          "trip_distance_mi": 3,
          "fare_amount": 10,
          "tip_amount": 3,
          "total_amount": 13
        },
        {
          "pickup_datetime": "2013-05-27 19:15:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 1.26,
          "fare_amount": 7.5,
          "tip_amount": 0,
          "total_amount": 8
        },
        {
          "pickup_datetime": "2013-05-31 16:40:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 0.73,
          "fare_amount": 5,
          "tip_amount": 1.2,
          "total_amount": 7.7
        },
        {
          "pickup_datetime": "2013-05-27 19:03:00.000",
          "passenger_count": 2,
          "trip_distance_mi": 9.23,
          "fare_amount": 27.5,
          "tip_amount": 5,
          "total_amount": 38.33
        },
        {
          "pickup_datetime": "2013-05-31 16:24:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 2.27,
          "fare_amount": 12,
          "tip_amount": 0,
          "total_amount": 13.5
        },
        {
          "pickup_datetime": "2013-05-27 19:17:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 0.71,
          "fare_amount": 5,
          "tip_amount": 0,
          "total_amount": 5.5
        },
        {
          "pickup_datetime": "2013-05-27 19:11:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 2.52,
          "fare_amount": 10.5,
          "tip_amount": 3.15,
          "total_amount": 14.15
        },
        {
          "pickup_datetime": "2013-05-31 16:41:00.000",
          "passenger_count": 5,
          "trip_distance_mi": 1.01,
          "fare_amount": 6,
          "tip_amount": 1.1,
          "total_amount": 8.6
        },
        {
          "pickup_datetime": "2013-05-31 16:37:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 1.25,
          "fare_amount": 8.5,
          "tip_amount": 0,
          "total_amount": 10
        },
        {
          "pickup_datetime": "2013-05-31 16:39:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 2.04,
          "fare_amount": 10,
          "tip_amount": 1.5,
          "total_amount": 13
        },
        {
          "pickup_datetime": "2013-05-27 19:02:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 11.73,
          "fare_amount": 32.5,
          "tip_amount": 8.12,
          "total_amount": 41.12
        }
      ]
    }
    

    Job Results Attributes

    rowCount

    Integer

    Number of rows the job returned.

    Example 11


    schema

    Array

    Array of schema definitions for the data the job returned.


    rows

    Array

    Array of the data the job returned for each row of results.

    Retrieve Job Results

    Method and URL
    GET /v0/projects/{project-id}/job/{id}/results
    

    Parameters

    project-id

    path

    String (UUID)

    Unique identifier for the project where the job was run.


    id

    path

    String (UUID)

    Unique identifier for the job to retrieve. Get the job id from responses to SQL API requests.


    limit

    query

    Integer

    Maximum number of records to return. Default: 100.


    offset

    query

    Integer

    Number of records to skip for pagination. Default: 0.


    Example Request
    curl -X GET 'https://api.dremio.cloud/v0/projects/994508c4-5041-536b-ka63-09p98727a3c4/job/6j6c34cf-9drf-b07a-5ab7-abea69a66d00/results' \
    -H 'Authorization: Bearer <personal access token>' \
    -H 'Content-Type: application/json'
    
    Example Response
    {
      "rowCount": 11,
      "schema": [
        {
          "name": "pickup_datetime",
          "type": {
            "name": "TIMESTAMP"
          }
        },
        {
          "name": "passenger_count",
          "type": {
            "name": "BIGINT"
          }
        },
        {
          "name": "trip_distance_mi",
          "type": {
            "name": "DOUBLE"
          }
        },
        {
          "name": "fare_amount",
          "type": {
            "name": "DOUBLE"
          }
        },
        {
          "name": "tip_amount",
          "type": {
            "name": "DOUBLE"
          }
        },
        {
          "name": "total_amount",
          "type": {
            "name": "DOUBLE"
          }
        }
      ],
      "rows": [
        {
          "pickup_datetime": "2013-02-10 20:00:00.000",
          "passenger_count": 9,
          "trip_distance_mi": 3,
          "fare_amount": 10,
          "tip_amount": 3,
          "total_amount": 13
        },
        {
          "pickup_datetime": "2013-05-27 19:15:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 1.26,
          "fare_amount": 7.5,
          "tip_amount": 0,
          "total_amount": 8
        },
        {
          "pickup_datetime": "2013-05-31 16:40:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 0.73,
          "fare_amount": 5,
          "tip_amount": 1.2,
          "total_amount": 7.7
        },
        {
          "pickup_datetime": "2013-05-27 19:03:00.000",
          "passenger_count": 2,
          "trip_distance_mi": 9.23,
          "fare_amount": 27.5,
          "tip_amount": 5,
          "total_amount": 38.33
        },
        {
          "pickup_datetime": "2013-05-31 16:24:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 2.27,
          "fare_amount": 12,
          "tip_amount": 0,
          "total_amount": 13.5
        },
        {
          "pickup_datetime": "2013-05-27 19:17:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 0.71,
          "fare_amount": 5,
          "tip_amount": 0,
          "total_amount": 5.5
        },
        {
          "pickup_datetime": "2013-05-27 19:11:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 2.52,
          "fare_amount": 10.5,
          "tip_amount": 3.15,
          "total_amount": 14.15
        },
        {
          "pickup_datetime": "2013-05-31 16:41:00.000",
          "passenger_count": 5,
          "trip_distance_mi": 1.01,
          "fare_amount": 6,
          "tip_amount": 1.1,
          "total_amount": 8.6
        },
        {
          "pickup_datetime": "2013-05-31 16:37:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 1.25,
          "fare_amount": 8.5,
          "tip_amount": 0,
          "total_amount": 10
        },
        {
          "pickup_datetime": "2013-05-31 16:39:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 2.04,
          "fare_amount": 10,
          "tip_amount": 1.5,
          "total_amount": 13
        },
        {
          "pickup_datetime": "2013-05-27 19:02:00.000",
          "passenger_count": 1,
          "trip_distance_mi": 11.73,
          "fare_amount": 32.5,
          "tip_amount": 8.12,
          "total_amount": 41.12
        }
      ]
    }
    

    Responses

    200

    OK

    400

    Bad Request

    403

    Forbidden

    404

    Not Found