How to access elements from dictionary which is wrapped with list of dictionary

Question

{
 {
 '1': {
 loggedInStatus: "Succeeded",
 timestamp: {
 sessionDeletion: "",
 lastActivity: "",
 login: "2025-12-03 07:43:17"
 },
 sessionId: "abcb9532-b5f5-4e2f-8946-8f08a17e307f",
 status: "Active"
 },
 '2': {
 loggedInStatus: "Succeeded",
 timestamp: {
 sessionDeletion: "",
 lastActivity: "",
 login: "2025-12-03 08:27:31"
 },
 sessionId: "08ad7f98-85f6-4fd5-a072-6278731cbfef",
 status: "Active"
 }
 }
} Here in this example I want to access a field "sessionId". I tried to wrap this using a!flatten () but still it doesnt work. Any help here ? Thanks in advance.

Shubham Aware · Answer

a!localVariables(
 local!data: {
 {
 '1': {
 loggedInStatus: "Succeeded",
 timestamp: {
 sessionDeletion: "",
 lastActivity: "",
 login: "2025-12-03 07:43:17"
 },
 sessionId: "abcb9532-b5f5-4e2f-8946-8f08a17e307f",
 status: "Active"
 },
 '2': {
 loggedInStatus: "Succeeded",
 timestamp: {
 sessionDeletion: "",
 lastActivity: "",
 login: "2025-12-03 08:27:31"
 },
 sessionId: "08ad7f98-85f6-4fd5-a072-6278731cbfef",
 status: "Active"
 }
 }
 },

 /* Extract all sessionIds */
 a!forEach(
 items: { "1", "2" },
 expression: index(index(local!data, 1, {}), fv!item, {}).sessionId
 )
)

Shubham Aware · Answer

Dynamic approach. a!localVariables(
 local!data: {
 {
 '1': {
 loggedInStatus: "Succeeded",
 timestamp: {
 sessionDeletion: "",
 lastActivity: "",
 login: "2025-12-03 07:43:17"
 },
 sessionId: "abcb9532-b5f5-4e2f-8946-8f08a17e307f",
 status: "Active"
 },
 '2': {
 loggedInStatus: "Succeeded",
 timestamp: {
 sessionDeletion: "",
 lastActivity: "",
 login: "2025-12-03 08:27:31"
 },
 sessionId: "08ad7f98-85f6-4fd5-a072-6278731cbfef",
 status: "Active"
 }
 }
 },

 local!dict: local!data[1],
 local!keys: a!keys(local!dict),

 a!forEach(
 items: local!keys,
 expression: index(local!dict, fv!item, "sessionId", {})
 )
)