Display json with disctonary and view to listview

Discuss
#1

How can I display this format of my json in a listview?, by using a dictonary or anything, help me please.

format json saya =

[{
“DEPT_NO”: “102”,
“DEPT_NAME”: “BANDSAW”,
“PERSON_ID”: “100029”,
“FIRST_NAME”: “SUK”,
“INITIAL_TIME”: “1988”,
“POSITION”: “Tetap”,
“DOOR_ACCESS”: [{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 07:09:59”,
“DD”: “2023-04-03”,
“TT”: “07:09:59”
},
{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 07:10:00”,
“DD”: “2023-04-03”,
“TT”: “07:10:00”
},
{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 07:10:02”,
“DD”: “2023-04-03”,
“TT”: “07:10:02”
},
{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 07:10:03”,
“DD”: “2023-04-03”,
“TT”: “07:10:03”
},
{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 15:16:14”,
“DD”: “2023-04-03”,
“TT”: “15:16:14”
},
{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 15:16:17”,
“DD”: “2023-04-03”,
“TT”: “15:16:17”
}
]
},
{
“DEPT_NO”: “102”,
“DEPT_NAME”: “BANDSAW”,
“PERSON_ID”: “100579”,
“FIRST_NAME”: “SO”,
“INITIAL_TIME”: “1990”,
“POSITION”: “Tetap”,
“DOOR_ACCESS”: [{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 07:09:59”,
“DD”: “2023-04-03”,
“TT”: “07:09:59”
},
{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 07:10:00”,
“DD”: “2023-04-03”,
“TT”: “07:10:00”
},
{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 07:10:02”,
“DD”: “2023-04-03”,
“TT”: “07:10:02”
},
{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 07:10:03”,
“DD”: “2023-04-03”,
“TT”: “07:10:03”
}
]
},
{
“DEPT_NO”: “102”,
“DEPT_NAME”: “BANDSAW”,
“PERSON_ID”: “100024”,
“FIRST_NAME”: “SU”,
“INITIAL_TIME”: “1993”,
“POSITION”: “Tetap”,
“DOOR_ACCESS”: [{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 07:09:59”,
“DD”: “2023-04-03”,
“TT”: “07:09:59”
},
{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 07:10:00”,
“DD”: “2023-04-03”,
“TT”: “07:10:00”
}
]
},
{
“DEPT_NO”: “102”,
“DEPT_NAME”: “BANDSAW”,
“PERSON_ID”: “102692”,
“FIRST_NAME”: “RIB”,
“INITIAL_TIME”: “1997”,
“POSITION”: “Tetap”,
“DOOR_ACCESS”: [{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 07:09:59”,
“DD”: “2023-04-03”,
“TT”: “07:09:59”
},
{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 07:10:00”,
“DD”: “2023-04-03”,
“TT”: “07:10:00”
}
]
},
{
“DEPT_NO”: “102”,
“DEPT_NAME”: “BANDSAW”,
“PERSON_ID”: “101496”,
“FIRST_NAME”: “MUH”,
“INITIAL_TIME”: “1999”,
“POSITION”: “Tetap”,
“DOOR_ACCESS”: [{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 07:09:59”,
“DD”: “2023-04-03”,
“TT”: “07:09:59”
},
{
“CHANNEL_NAME”: “ACS100 GK”,
“OWNER_NAME”: “102 BAND SAW”,
“CARD_NUMBER”: “E7FC4B63”,
“SWIPE_TIME”: “2023-04-03 07:10:00”,
“DD”: “2023-04-03”,
“TT”: “07:10:00”
}
]
}
]

#2

What are the details you want it to be in json? Is this complete json? Share your json in text file or use the option "

#3

I’m sorry, I don’t really understand using community codular.

#4

I want to fetch variables
“DEPT_NAME”
“FIRST_NAME”
“POSITIONS”
.
“SWIPE_TIME”
“OWNER_NAME”
and “CHANNEL_NAME” in each existing line,
can you give an example, what block do I use to retrieve the variable in my json format? Please help.

this is my json format :
json1.txt (4.0 KB)