Create a Web Service Data Source

You can easily create a web service data source in Sigma Studio with viable and feasible configurations. Web Service data source serves as the vital cog in facilitating the process of fetching the data from the web service.

The step-by-step procedure to create a web service data source in Sigma Studio is listed as follows:

1. On the home page of Sigma Studio, click Connections on the left pane.
   The connections created will be available in the Connections list on the right pane.
   
   
   
   
2. Click the Data Source  icon on the web service connection.
   
   
   
   The Create New Data Source screen appears.
   
   
   
   
3. In the Create New Data Source screen, configure the property fields in the Web Service Maintenance tab as follows:
   1. Connection Name: This is a non-editable field and displays the unique name provided by you for the connection. For example, WEB SERVICE CONNECTION.
   2. Data Source Name: Provide a unique data source name. For example, NEW WEB SERVICE DS.

   3. Relative part of the URL: Provide the relative URL. For example,

      accountservice/user/account/details?usrId=201206000013

      
      In the case of http://localhost:9090/accountservice/user/account/details?usrId=201206000013 URL, http://localhost:9072/ is the base URL (domain name) and accountservice/user/account/details?usrId=201206000013 serves as the relative part of the URL. Here, accountservice is the Web service, which based on the parameters specified returns the account details as shown in the following screen shot:
      
      
      
      

   4. Communication App ID: The Rest GET JSON Gateway option is auto-populated by default in the Communication App ID field. For more information on this field, refer Field Descriptions.
   5. Forms: If required, you can select a form from the Forms lookup field for configuring the objects as the JSON Configuration for the web service.
      
      
   6. In the Response Data Mapping panel, perform the following steps:
      1. Click the Upload JSON option and select the respective JSON file be uploaded, e.g. Web_Service_JSON.json. 
      2. Provide inputs in the fields as follows:
         1. Column Root: Provide the hierarchical path to the element that contains the JSON array of data from the Web service response. For example, $ will be the root element for the accountservice Web service.
         2. Value Select Expression: For the accountservice Web service, the value select expressions are CURRENCY, ACCOUNT_TYPE, ACCOUNT_ID, IFSC_CODE, ADDRESS and USER_ID. When the JSON file gets uploaded, the value select expressions appear automatically.

         3. View Column Id: Provide the column name for each of the value select expressions of the web service that you want to display in the app. For example, country, name, etc. can be the column names for the value select expressions.

            • Same column name must be provided in the Column ID field in App Designer screen.
            • If the View Column Id is changed for any Value Select Expression in the data source screen later, those columns must be re-mapped in the App Designer screen to reflect the changes.

         4. Data Type: Select the data type from the drop-down list. 
            
            

         5. In case, if you want to add more columns, click to add more columns.
            
            

         6. Click Save.

            When you try to exit the Datasource screen, before saving the configured web service data source, a warning pop-up message appears, as shown in the following screen shot:
            

            • Click Cancel, if you do not want to exit the Datasource screen.
            • Click Ok, if you want to exit the Datasource screen.

            

            
            A confirmation message, indicating a successful save, appears.
            
            
            
            

4. Click Ok.