Answered

How to access values inside double bracket and/or remove extra bracket

(0) Share

Report

Posted on by mithras

I'll start off with the statement of "maybe I'm going about this the wrong way".

I have the correct output of my flow, to a certain point.

The array/JSON is supposed to look like:

[

{

"USERID": "ID#####",

"LN": "lastname",

"FN": "firstname",

"Org": "OrgCode",

"Email": "email address"

...(multiple more objects)

...

]

Instead, what I'm getting is:

[

{

"USERID": "ID####",

"LN": "lastname",

"FN": "firstname",

"Org": "OrgCode",

"Email": "email address"

}

... (again multiple entries)

...

]

The data is all correct; I've just got those extra brackets at the start and the end. And because of that, I cannot process my next step, which is a select map with no keys, to then send to the output report, via an HTTP post.

The JSON is being built inside a apply to each loop from a select; that select produces the correct JSON, it's when I'm outside the apply to each, and gather them all together that it adds the extra brackets.

I'm guessing it's something terribly obvious that I'm just missing.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

lbendlin 8,624 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

can you use array(0) (conceptually) to get rid of the outer shell?

Was this reply helpful? Yes No
mithras 25 on at

Like (0)

Report
Copy link

Link copied!

Yes and no; Yes, it works, but that gives me only the first entry.

Like, if I have as the input:

[
[
{
  "USERID": "ID###1",
  "LN": "lastname1",
  "FN": "firstname1",
  "Org": "OrgCode1",
  "Email": "email address1"
}
],
[
[
{
  "USERID": "ID###2",
  "LN": "lastname2",
  "FN": "firstname2",
  "Org": "OrgCode2",
  "Email": "email address2"
}
],
[
[
{
  "USERID": "ID###3",
  "LN": "lastname3",
  "FN": "firstname3",
  "Org": "OrgCode3",
  "Email": "email address3"
}
]
]

then outputs('FullList')[0]

just gives me:

[
{
  "USERID": "ID###1",
  "LN": "lastname1",
  "FN": "firstname1",
  "Org": "OrgCode1",
  "Email": "email address1"
}
]

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
That sample nested array is invalid. Assuming you meant something like this:
[ [ { "USERID": "ID###1", "LN": "lastname1", "FN": "firstname1", "Org": "OrgCode1", "Email": "email address1" } ], [ { "USERID": "ID###2", "LN": "lastname2", "FN": "firstname2", "Org": "OrgCode2", "Email": "email address2" } ], [ { "USERID": "ID###3", "LN": "lastname3", "FN": "firstname3", "Org": "OrgCode3", "Email": "email address3" } ] ]

Then you could just use a Select as shown below. Note that the Compose contains the data shown above. The expression used is:
first(item())

The output of the Select would be:
[ { "USERID": "ID###1", "LN": "lastname1", "FN": "firstname1", "Org": "OrgCode1", "Email": "email address1" }, { "USERID": "ID###2", "LN": "lastname2", "FN": "firstname2", "Org": "OrgCode2", "Email": "email address2" }, { "USERID": "ID###3", "LN": "lastname3", "FN": "firstname3", "Org": "OrgCode3", "Email": "email address3" } ]

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
mithras 25 on at

Like (0)

Report
Copy link

Link copied!

Yeah, that was a copy paste error on here that I missed.

Thanks; the first bit work. Of course, it also revealed a flaw in the underlying data which I've now got to sort out, but isn't that always the way?

Was this reply helpful? Yes No