Passing JSON format into datastore

stuartt0002 Can you explain the configuration you did here to push data into the database?

The basic answer is already there. What exactly are you looking for?

I'm a newcomer to the Appian platform, and I need guidance on uploading a .json file using a file upload component. The goal is to incorporate the file's data into the database. Here's a sample .json format:

Could you provide a concise explanation on how can I go about achieving this task?

That's a nice challenge for a newcomer.

To be able to help you, I need to understand what you already learned. So, which of the following things do you already know?

- Store a uploaded file in a folder in Appian

- Create a record and store data to it

- Do all of the above in a process model

- Calling a record type constructor to create a new data structure

- Local variables in expressions

- Plugins

I did a similar challenge that involved importing Excel data into a database using a plugin (Excel Tools) and a smart service (“import excel to database”). I used  concepts you mentioned, except for “- calling a record type constructor for creating a new data structure.”

OK. You need the plugin "Text File Utilities".

Then:

- Upload the file

- Then, in an expression with the uploaded file as a rule input

  - load the JSON from the file (plugin function)

  - convert it into an Appian dictionary using fromJSON()

  - map the data to your record type (https://docs.appian.com/suite/help/23.4/reference-records.html#use-a-record-type-constructor)

  - the record data is the output of the expression

- call this expression in a script task and store the output in a process variable.

- write the record

An alternative approach could also be to use the JSON Tools plugin.

Currently working on configuring the "Load JSON Document To Database" plugin, and I'm seeking some clarification on specific fields. let's say my format for json is 

1. JSON Document (Document): [Should there be a appropriate expression to parse the json or just the document?]
2. JSON Path (Text)
3. JSON Fields Match (Any Type): 
4. JSON key/Column Name mapping (Any Type)
5. Columns To Process (Text) 
6. Table Audit fields (Any Type)
7. Unique Index Columns (Text)

is this possible on nested Json structure?

could you please help us to configure that plugin if you use, there is no documentation so we tried to understand by looking into code but we observed parameters are different in SS config and the code.

Hi Yogi Patel (yogip3177), 

{
	"date":"2024-06-18T06:42:25.528Z",
	"age":12,
	"name":"test",
	"test":{
		"designation":"consultant"
	}
}

My code is kind of this in an array. How to get nested fields and save in DB using Load JSON document to DB