Use service orchestration

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.

Parameters

• Request parameters of a workflow
  On the configuration tab of a workflow, click the Request Parameters tab in the right-side navigation pane. Then, you can configure request parameters in manual adding or automatic parsing mode.

  • Manual adding: Click Add Parameters and manually add a request parameter for the workflow.
  • Automatic parsing: If the first node of the workflow is an API node, click Automatically parse request parameters to automatically map the request parameters of this API node to the request parameters of the workflow.
• Request parameters of an API node
  Click an API node. In the panel that appears, click Input Request Parameters and specify values for request parameters.

  • If you do not specify a value for a request parameter, DataService Studio obtains the value of the same parameter in the first layer of the JSON string that is returned by the parent node, and assigns the value to the request parameter.
    Note If the current node is the first node of a workflow, the values of the request parameters of this node are assigned to the same parameters of the workflow.
  • If you specify a value for a request parameter, DataService Studio uses the value that you specify.
    Note To reference the value of a specified parameter that is returned by a specified ancestor node, you must use a JSONPath expression.
• Response parameters of an API node
  Click an API node. In the panel that appears, select set output results and customize the output of the node by using JSON expressions similar to the following example:

  {
    "return1":"$.data.rows.user_id",
    "return2":"$.data.rows.user_name"
  }

• Request parameters of a Python node

  Click a Python node. Specify request parameters in the Request Parameters section.

• Response parameters of a Python node
  Click a Python node. In the panel that appears, select set output results and customize the output of the node by using JSON expressions similar to the following example:

  {
    "return1":"$.data.rows.user_id",
    "return2":"$.data.rows.user_name"
  }

Example

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 select 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. For more information, see Manage functions.
   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 toolbar.
4. Create a workflow.
   1. On the Service Development tab, right-click the required business process and choose New > 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 panel that appears, select the API that you registered earlier from the Select API drop-down list, select set output results, and then enter {"user_id":"$.data[0].id"}.
      

      Use JSONPath expressions to set response parameters. The syntax for obtaining the value of a parameter is ${NodeA.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 JSON format.

   3. Click the PYTHON1 node. In the panel that appears, select the function that you registered earlier from the Select Function drop-down list.
   4. Click the SWITCH1 node. In the panel that appears, click Set branch conditions.
      You can 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, indicating that Branch node 1 is run if the value of the user_id parameter is not 1.
      Branch node 2: $.user_id == 1, indicating 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.