API returns JSON object instead of Array - Cannot use items node

Questions
,
1

Describe the problem/error/question

I get the following API response from the LastPass API. How can I transform the following JSON to be used in the item node as I get the error that is no Array? I want to split out the Users and its fields and use it in the rest of the flow

[
{
“total”: 41,
“count”: 41,
“Users”:
{
“161151992”:
{
“username”: “test@infozorg.nl”,
“field”: “x”
},
“172898622”:
{
“username”: test2@infozorg.nl,
“field:” “y”,
}
]

2

Hey @timautomation,

As the Users items in the object isn’t an array it is a bit trickier, What is the format you want to have the data in are you just after the usernames and fields or do you need the ID in there as well

3

Hi Tim,

Try this code node.

4

Hi BramKn

You are awesome! Thanks worked like a charm :slight_smile: