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.
3.Click on Import icon on the top right corner to import the workflow into your project.
4.Select the archive file “Pushdata_Arisprocess.Zip” shared in the article.
5.The workflow name and description are preloaded.
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.
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.
9.Once you enable the flow service you can import the formTableData.zip file.
10.Review the mappings and test the workflow.
11.You can check if the data is loaded by logging into ARIS.
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)