Use service orchestration

Obtain the values of request and response parameters

DataService Studio uses JSONPath to obtain parameter values. JSONPath is a query language that allows you to extract data from JSON files. For more information, see JSONPath.

The built-in start node provides request parameters for the whole workflow. Assume that a request parameter of a workflow is {"namewf":"valuewf"}. All nodes of the workflow can obtain the value of the request parameter by using the ${START.namewf} expression.

Set parameters

Use service orchestration to configure a workflow

You must first create a connection. For more information, see Configure a connection. In this example, a MySQL connection is used.

1. Go to the DataService Studio page.
   1. Log on to the DataWorks console.
   2. In the left-side navigation pane, click Workspaces.
   3. In the top navigation bar, select the region where the target workspace resides. Find the target workspace and click DataService Studio in the Actions column.
2. Register an API.
   In this example, create an API by using the registration method.
   1. On the Service Development tab, move the pointer over the icon and choose API > Register API.
      You can also click the required business process, right-click API, and then choose New > Register API.
   2. In the Register API dialog box, set the parameters as required. For more information, see Register an API.
   3. Click OK.
3. Register a function.
   1. On the Service Development tab, move the pointer over the icon and choose Function > Create Python Function.
      You can also click the required business process, right-click Function, and then choose New > Create Python Function.
   2. In the Create Python Function dialog box, set the parameters as required.
   3. Click OK.
   4. On the configuration tab of the function, enter the following code in the Edit Code section:

      # -*- coding: utf-8 -*-
      # event (str) : in filter it is the API result, in other cases, it is your param
      # context : some environment information, temporarily useless
      # import module limit: json,time,random,pickle,re,math
      import json
      def handler(event,context):
          # load str to json object
          obj = json.loads(event)
          # add your code here
          # end add
          return obj

   5. In the Environment Configuration section, set the Memory and Function Timeout parameters.
   6. Click the icon in the top toolbar.
4. Create a workflow.
   1. On the Service Development tab, click the required business process and choose Service Orchestration > Service Orchestration.
      You can also click the required business process, right-click Service Orchestration, and then select Service Orchestration.
   2. In the Service Orchestration dialog box, set the parameters as required.
      

      Parameter	Description
      API Name	The name must be 4 to 50 characters in length and can contain letters, digits, and underscores (_). It must start with a letter.
      API Path	The path for storing the API, such as /user. Note The path can be up to 200 characters in length and can contain letters, digits, underscores (_), and hyphens (-). It must start with a forward slash (/).
      Protocol	Valid values: HTTP and HTTPS. If you need to call the API by using HTTPS, you must bind an independent domain name to the API in the API Gateway console after the API is published to API Gateway. In addition, you must upload a Secure Sockets Layer (SSL) certificate in the API Gateway console. For more information, see Enable HTTPS for an API operation.
      Request Method	Valid values: GET and POST.
      Response Content Type	Set the value to JSON.
      Visible Range	Valid values: Work Space and Private. Work Space: The API is visible to all members in the current workspace. Private: The API is visible only to its owner and permissions on the API cannot be granted to other users. Note If you set the Visible Range parameter to Private, the API is visible only to you in the API list. Other members in the workspace cannot view the API in the API list.
      Label	Select tags from the Label drop-down list. Note A tag can be up to 20 characters in length and can contain letters, digits, and underscores (_). You can set at most five tags for a workflow.
      Description	The description of the API. The description can be up to 2,000 characters in length.
      Target Folder	The folder for storing the workflow.

   3. Click OK.
5. Configure the workflow.
   1. On the configuration tab of the workflow, drag nodes to the DAG and connect the nodes, as shown in the following figure.
      
   2. Click the API1 node. In the API1 panel, select the API that you registered earlier from the Select API drop-down list. Then, select set output results and enter {"user_id":"$.data[0].id"}.
      

      Use JSONPath expressions to set response parameters. The syntax for obtaining the value of a parameter is ${Node A.namea}, which is the same as that for setting request parameters. {"user_id":"$.data[0].id"} assigns the value of the id parameter of the first element in the data array to the user_id parameter. Then, the API1 node returns {"user_id":"value"} in the JSON format.

   3. Click the PYTHON1 node. In the PYTHON1 panel, select the function that you registered earlier from the Select Function drop-down list.
   4. Click the SWITCH1 node. In the SWITCH1 panel, click Set branch conditions.
      Enter conditional expressions based on the response parameter of the parent node. For example, you can enter expressions in the ${Node ID.Parameter}>1 or $.Parameter>1 format. Conditional expressions support the following operators: ==, !=, >=, >, <=, <, &&, !, (), +, -, *, /, and %.

      In this example, the user_id parameter is the response parameter of the API1 node and is used as the request parameter of the SWITCH1 node.

      Branch node 1: $.user_id != 1, which indicates that Branch node 1 is run if the value of the user_id parameter is not 1.
      Branch node 2: $.user_id == 1, which indicates that Branch node 2 is run if the value of the user_id parameter is 1.

   5. Click the The end node, and then click the Response Parameters tab in the right-side navigation pane to configure the response parameters.
6. Test the workflow.
   1. Click Test in the upper-right corner.
   2. In the Test APIs dialog box, click Determine.
   3. View the operational logs and execution results on the Operation Log and Execution results tabs in the lower part of the configuration tab.