Jump to

• Request
• Response
• Examples

Run a Python Function on Chunks of Rows with Script Owner Specified

post

/api/py-scripts/v1/row-apply/{scriptName}/{ownerName}

Run a Python function on data chunked in sets of rows with script owner specified.

Request

Supported Media Types

• application/json

Path Parameters

• ownerName: string
  The owner of the Python script
• scriptName: string
  The name of the Python script

Body ()

A JSON str of (name - value) pairs specifying arguments of the request and additional arguments to the script

Root Schema : EmbedScriptComputeRow

Type: object

Show Source

• asyncFlag(optional): boolean
  Whether to execute the job asynchronously.
• envName(optional): string
  Name of the conda environment.
• graphicsFlag(optional): boolean
  Whether to capture images rendered in the script to the result.
• input: string
  Query statement specifying input data.
• parallel(optional): integer(int32)
  Degree of parallelism.
• parallelFlag(optional): boolean
  Whether to execute job in parallel.
• parameters(optional): string
  A JSON str of (name - value) pairs specifying keyword arguments to be passed into the script.
• rows: integer(int32)
  Number of rows to chunk by.
• service(optional): string
  Allowed Values: [ "LOW", "MEDIUM", "HIGH" ]

  LEVEL of the service. Default is LOW.
• timeout(optional): integer(int32)
  Minimum Value: 1800

  Maximum Value: 43200

  The timeout limit (in seconds, default 1800s) of asynchronous job. Must be used together with `asyncFlag`=true.

{
    "type":"object",
    "required":[
        "input",
        "rows"
    ],
    "properties":{
        "parameters":{
            "type":"string",
            "description":"A JSON str of (name - value) pairs specifying keyword arguments to be passed into the script."
        },
        "graphicsFlag":{
            "type":"boolean",
            "description":"Whether to capture images rendered in the script to the result."
        },
        "asyncFlag":{
            "type":"boolean",
            "description":"Whether to execute the job asynchronously."
        },
        "timeout":{
            "type":"integer",
            "format":"int32",
            "description":"The timeout limit (in seconds, default 1800s) of asynchronous job. Must be used together with `asyncFlag`=true.",
            "minimum":1800,
            "maximum":43200
        },
        "service":{
            "type":"string",
            "description":"LEVEL of the service. Default is LOW.",
            "enum":[
                "LOW",
                "MEDIUM",
                "HIGH"
            ]
        },
        "envName":{
            "type":"string",
            "description":"Name of the conda environment."
        },
        "input":{
            "type":"string",
            "description":"Query statement specifying input data."
        },
        "rows":{
            "type":"integer",
            "format":"int32",
            "description":"Number of rows to chunk by."
        },
        "parallelFlag":{
            "type":"boolean",
            "description":"Whether to execute job in parallel."
        },
        "parallel":{
            "type":"integer",
            "format":"int32",
            "description":"Degree of parallelism."
        }
    }
}

Example Request (application/json)

{"input":"select name, finalgrade from GRADE where score > 90", "rows":5, "parameters":"{\"oml_input_type\":\"numpy.recarray\"}", "asyncFlag":true}

Back to Top

Response

Supported Media Types

• application/json

200 Response

By default, returns the job result.

Body ()

Root Schema : JSONObject

Type: object

Show Source

• empty(optional): boolean

{
    "type":"object",
    "properties":{
        "empty":{
            "type":"boolean"
        }
    }
}

201 Response

If asyncFlag=True, returns the location header where the status of the job can be fetched.

Headers

• Location: string(uri)

400 Response

Invalid parameters specified, output exceeding size limit or other script execution error.

Body ()

Root Schema : InvalidParameterValueException

Type: object

Show Source

• errorCode: integer(int64)
• errorMessage(optional): string
• parameterName(optional): string
• parameterValue(optional): string

{
    "type":"object",
    "required":[
        "debug",
        "errorCode"
    ],
    "properties":{
        "errorMessage":{
            "type":"string"
        },
        "errorCode":{
            "type":"integer",
            "format":"int64"
        },
        "parameterName":{
            "type":"string"
        },
        "parameterValue":{
            "type":"string"
        }
    }
}

500 Response

Problem connecting to Broker, executing job or other unexpected error.

Body ()

Root Schema : ComputeContainerException

Type: object

Show Source

• errorCode: integer(int64)
• errorMessage(optional): string

{
    "type":"object",
    "required":[
        "debug",
        "errorCode"
    ],
    "properties":{
        "errorMessage":{
            "type":"string"
        },
        "errorCode":{
            "type":"integer",
            "format":"int64"
        }
    }
}

Back to Top

Examples

The following example runs the script named return_df and specifies the script owner.

curl -i -X POST --header "Authorization: Bearer ${token}" \
--header 'Content-Type: application/json' --header 'Accept: application/json' \
-d '{"input":"select * from IRIS", "parameters":"{\"oml_input_type\":\"pandas.DataFrame\"}", "rows":4, "parallelFlag":true, "service":"LOW"}' \
"<oml-cloud-service-location-url>/oml/api/py-scripts/v1/row-apply/my_predict/<owner_name>"

Response Headers

The response headers are the following:

HTTP/1.1 200 OK
Date: Thu, 27 Aug 2020 15:56:43 GMT
Content-Type: application/json
Content-Length: 209
Connection: keep-alive
Cache-Control: no-cache, no-store, private
X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1;mode=block
Strict-Transport-Security: max-age=31536000; includeSubDomains
X-Content-Type-Options: nosniff
Set-Cookie: JSESSIONID=node01hcb0uek7gln31efrxvgnnc1xa714.node0; Path=/oml; Secure; HttpOnly
Expires: Thu, 01 Jan 1970 00:00:00 GMT

Response Body

The response body in JSON format is the following:

{"result":[{"Pred_Petal_Width":6.8462408185,"Species":"setosa","Petal_Width":0.2},
{"Pred_Petal_Width":5.2786489228,"Species":"versicolor","Petal_Width":1.1},
{"Pred_Petal_Width":5.0951801182,"Species":"versicolor","Petal_Width":1},...]}

Back to Top