Loading a Json file to a table in ARIS Process Mining with webMethods.io

Knowledge base
, , , ,
1

Summary

This article describes the step-by-step process of loading a Json file to a table in ARIS Process Mining. The webMethods workflow creates the table if not already created and loads the data from json file.

Prerequisites

The user needs to have a working account in ARIS with client id and a secret key

Working webMethods.io Integration cloud tenant.

Json Data in the requested format

Steps

1.Login to webMethods.io Integration tenant.

2.Create a new project or choose an existing project.

image
image855Ă—468 39.9 KB

3.Click on Import icon on the top right corner to import the workflow into your project.

image
image834Ă—316 20.5 KB

4.Select the archive file “Pushdata_Arisprocess.Zip” shared in the article.
5.The workflow name and description are preloaded.

image
image756Ă—436 28.1 KB

6.Configure the account information for ARIS Process Mining(click on + button against Connect to ARIS Process Mining). Provide the account information like accountlabel, ariscloudurl, projectroom, datasetname, clientID and Client Secret.

image
image503Ă—623 37.1 KB

7.Once the details have been entered you can save and import the workflow.

8.The workflow is imported successfully and now you can enable the flow service.

image

9.Once you enable the flow service you can import the formTableData.zip file.

image
image940Ă—470 43 KB

image
image940Ă—454 34.5 KB

10.Review the mappings and test the workflow.

image
image940Ă—483 35.8 KB

11.You can check if the data is loaded by logging into ARIS.

image
image940Ă—494 140 KB

12.The workflow requires the json file to be sent in a specific format.

{
  "TableName": "ARISTableName",
  "Namespace": "ARISTableNameSpace",
  "ColumnNames": {
    "Header": [
      {
        "name": "ColumnName1",
        "type": "ColumnName1Type"
      },
      {
        "name": "ColumnName2",
        "type": "CloumnName2Type"
      },
      {
        "name": "ColumnNameN",
        "type": "ColumnNameNType"
      },  
    ]
  },
  "ColumnData": {
    "Record": [
      {
        "data": [     --//Record 1
          "ColumnNameRecord1",
          "ColumnNameRecord2",
          "ColumnNameRecordN"
         
        ]
      },
      {
          "data": [     ---//Record 2
          "ColumnNameRecord1",
          "ColumnNameRecord2",
          "ColumnNameRecordN"
         
        ]
      },
      {
         "data": [            --- //Record N
          "ColumnNameRecord1",
          "ColumnNameRecord2",
          "ColumnNameRecordN"
         
        ]
          
          ]
      
      {
      
    ]
  }
}

13.Sample is also available in the webhook.

{
  "TableName": "Student",
  "Namespace": "NewStudent",
  "ColumnNames": {
    "Header": [
      {
        "name": "CUSTOMER_ID",
        "type": "STRING"
      },
      {
        "name": "CUSTOMER_NAME",
        "type": "STRING"
      }      
    ]
  },
  "ColumnData": {
    "Record": [
      {
        "data": [
          "CUST00001",
          "Rolls-Royce Ltd"
        ]
      },
      {
        "data": [
          "CUST00002",
          "Holiday Inn" 
        ]
      }
    ]
  }
}

Next Steps

Would you like to create a BulkUpload of data Please follow the steps in the post: Loading data in batches to a table in ARIS Process Mining with webMethods.io

Pushdata_Arisprocess.zip (160.0 KB)
formTableData.zip (9.7 KB)

4 Likes
2

Very Informative. Thanks Sandhya.

3

Very good explanation - do you plan to go further - after the data load?

4

Hi Monika,

On the integration side we are planning to go further like batch processing of data sets into ARIS and data movement samples from few data sources like ServiceNow, Salesforce etc. On the ARIS side not planned yet. What are you looking for?

5

Just saw it in a live demonstration.
Tremendous work which will for sure speed-up any Process Mining project.

1 Like