HTTP > JSON > Rows to a table

(0) Share

Report

Posted on by kenvanderhorst

Hi Guys,

I'm calling a webservices. Results I'm getting back are great.

I'm parsing JSON.

Output after testing shows me results I'm expecting. All good.

When I try to Add a row into a table no data is being populated in the Excel file.

For each.png json parse.png

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @kenvanderhorst

In the apply to each - try this expression instead - body('JSON_parseren')?['rows'] > this will give you an array which has rows data to be added on.

Next in add row to table > corresponding to each field > use the correct expression

for items('Apply_to_each')?['Nr Verkooprelatie'] for Nr Verkooprelatie field

items('Apply_to_each')?['Omschrijving'] for Omschrijving field.

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
kenvanderhorst 7 on at

Like (0)

Report

Hi @Nived_Nambiar,

Mapped the fields like you explain. First column stays empty in the Excel file. But that was an missing underscore.

Regards,
Ken

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @kenvanderhorst

i did understand what you said- could you explain it clearly ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
kenvanderhorst 7 on at

Like (0)

Report

Your solution works great!

Was this reply helpful? Yes No