Loading a Json file to a table in ARIS Process Mining with webMethods.io
Tags: json, proccesmining, tutorial, integration
Published: 2022-11-24 10:59:56

---
title: Loading a Json file to a table in ARIS Process Mining with webMethods.io
published: true
date: 2022-11-11 08:49:26 UTC
tags: json, proccesmining, tutorial, integration
canonical_url: https://tech.forums.softwareag.com/t/loading-a-json-file-to-a-table-in-aris-process-mining-with-webmethods-io/265881
---

## 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](http://webmethods.io/)Integration cloud tenant.

Json Data in the requested format

## Steps

1.Login to [webMethods.io](http://webmethods.io/)Integration tenant.

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

[![image](https://aws1.discourse-cdn.com/techcommunity/optimized/3X/4/e/4e3d634c20c1ff1f940c12b15b46f66ba47a4351_2_690x377.png)](https://aws1.discourse-cdn.com/techcommunity/original/3X/4/e/4e3d634c20c1ff1f940c12b15b46f66ba47a4351.png "image")

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

[![image](https://aws1.discourse-cdn.com/techcommunity/optimized/3X/b/d/bd538c299fc2bc8206d5648b1f9fcdaca3b8d5d5_2_690x261.png)](https://aws1.discourse-cdn.com/techcommunity/original/3X/b/d/bd538c299fc2bc8206d5648b1f9fcdaca3b8d5d5.png "image")

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

[![image](https://aws1.discourse-cdn.com/techcommunity/optimized/3X/f/a/fa055f6a2faf84245fcbdd5f99726100e4a019ba_2_690x397.png)](https://aws1.discourse-cdn.com/techcommunity/original/3X/f/a/fa055f6a2faf84245fcbdd5f99726100e4a019ba.png "image")

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](https://aws1.discourse-cdn.com/techcommunity/optimized/3X/7/a/7a03f3d938d9aef0518db71533c99dff6f1a74be_2_403x500.png)](https://aws1.discourse-cdn.com/techcommunity/original/3X/7/a/7a03f3d938d9aef0518db71533c99dff6f1a74be.png "image")

7.Once the details have been entered you can save and import the workflow.  
8.The workflow is imported successfully, enabled and ready to use.  
9.Review the mappings and test the workflow.

[![image](https://aws1.discourse-cdn.com/techcommunity/optimized/3X/5/3/536cd9bbaa037a5bc534b8cf276f97289d105595_2_690x354.png)](https://aws1.discourse-cdn.com/techcommunity/original/3X/5/3/536cd9bbaa037a5bc534b8cf276f97289d105595.png "image")

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

[![image](https://aws1.discourse-cdn.com/techcommunity/optimized/3X/7/9/79d76b9da33d453ed75fa05e46c6563808b490d6_2_690x362.png)](https://aws1.discourse-cdn.com/techcommunity/original/3X/7/9/79d76b9da33d453ed75fa05e46c6563808b490d6.png "image")

11.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"
         
        ]
          
          ]
      
      {
      
    ]
  }
}

```

12.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" 
        ]
      }
    ]
  }
}

```

[Pushdata\_Arisprocess.zip](https://tech.forums.softwareag.com/uploads/short-url/4GrkkSRRdSPLX92sgNwW8KiLflc.zip) (160.0 KB)

[Read full topic](https://tech.forums.softwareag.com/t/loading-a-json-file-to-a-table-in-aris-process-mining-with-webmethods-io/265881)