Issue in Plugin: JSON Tools Smart Services Load JSON to a database

Certified Senior Developer

Hi everyone,

I'm trying to load json to db using this Appian smart serivces. My sample json data i have given below. It has multiple dynamics parameter for example user have multiple types of phone number. if it flattens json file then its working without any issue but sub paramters are not working as expected. Added more details below

Main Issue while accessing the json sub parameters which is dynamic

In smart service Load JSON to a database, "JSON key/Column Name mapping" Field for json fields key i have tried like this Phone.number as well as Phone[].number but while executing Process model considered as "FirstName", "Phone" as column instead of each table column fields like FirstName, PhoneType PhoneNumber. I cant able to navigate inside of sub paramters while mapping json key to table columns name

Plugin name: JSON Tools

Smart service name: Load JSON to a database

my sample appian rule

{
"FirstName": "First_Name",
"Phone[].number": """Phone_Number""",

}

and

{
"FirstName": "First_Name",
"Phone.number": """Phone_Number""",

}

Sample JSON:

{
  "FirstName": "Fred",
  "Phone": [
    {
      "type": "home",
      "number": "0203 544 1234"
    },
    {
      "type": "office",
      "number": "01962 001234"
    },
    {
      "type": "office",
      "number": "01962 001235"
    },
    {
      "type": "mobile",
      "number": "077 7700 1234"
    }
  ]
  }

  Discussion posts and replies are publicly visible