filtering an array of json objects and building an html table.

Like (0) Share

Report

Posted on 19 Dec 2024 01:48:23 by TP-09081649-0

Hello,

I'm attempting to process a JSON response from an HTTP request and when the endDate is sooner than 60 days, add the details into an html table.

My HTTP Response looks like this:

{
    "detail": [
        {
            "product": "productName",
            "systemId": 12345,
            "productId": 5,
            "endDate": "2025-01-31",
            "company": "Contoso",
            "location": "Seattle",
            "projectName": "7859"
        },
        {
            "product": "productName2",
            "machineId": 23456,
            "productId": 5,
            "endDate": "2025-05-13",
            "company": "Acme",
            "location": "Chicago",
            "projectName": "8404"
        }
    ]
}

This is my flow

And this fails with the following message:

The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_Each')' is of type 'Object'. The result must be a valid array.

Can anyone share some advice? TIA!

Categories:

Business Process Flows

All responses (4)

Answers (0)

TP-09081649-0 27 on 19 Dec 2024 at 20:40:30

Like (0)

Report

filtering an array of json objects and building an html table.

Disregard my last post, through some other examples I realized that I was over complicating it and built the HTML table from the Filter Body instead of from items in the body.

Thanks!
TP-09081649-0 27 on 19 Dec 2024 at 17:35:16

Like (0)

Report

filtering an array of json objects and building an html table.

@Nived and @Chriddle,

Thank you for that advice, definitely a useful Filter, however I don't think that helps with adding it to a visual table for email as the result is still an array of JSON objects:

[

  {

    "product": "productName",

    "systemId": 12345,

    "productId": 5,

    "endDate": "2025-01-31",

    "company": "Contoso",

    "location": "Seattle",

    "projectName": "7859"

  }

]

I'm still having trouble selecting an input for Create HTML Table that doesn't require For Each loop hitting the same error.
Chriddle 7,738 Super User 2025 Season 1 on 19 Dec 2024 at 08:17:28

Like (1)

Report

filtering an array of json objects and building an html table.

This filter is a bit simpler (IMHO)

item()['endDate'] is less than addDays(utcNow(), 60, 'yyyy-MM-dd')
Suggested answer

Nived_Nambiar 17,654 Super User 2025 Season 1 on 19 Dec 2024 at 03:16:48

Like (1)

Report

filtering an array of json objects and building an html table.

Hi @TP-09081649-0

Since you have looped through Current Item dynamic content which is an object - that's why you got the issue.

I have designed a demo flow which would not be using loops as shown below

div(sub(ticks(item()?['endDate']),ticks(formatDateTime(utcNow(),'yyyy-MM-dd'))),864000000000)

Hope it helps !

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!