Data from JSON (API)

Help Studio
1

Hello,

I have a simple task to complete but I have some problems with it.

I am calling API (https://date.nager.at/Api/v2/PublicHolidays/2022/SI) to receive data (JSON) regarding public holidays. I deserialize JSON (Json.Linq.JArray) normally but later on in For Each I have some issues getting data only from the “date”. I would like to loop through all the “date” entries. How can i accomplish that? :slight_smile:

printScreen1
printScreen1906×499 70.3 KB

Thank you,
Žan

2

@iZan
Welcome to the Forums

Have a Look on the deserialize JArray activity

Give a try in setting the for each typeargument to JObject and Loop over the different Array items.

Access the Date With Item(“date”).value(of String) to get Back the Date as String. Or use value(of DateTime) for retrieving it as a DateTime

1 Like
3

Hi @iZan

Please find the attached xaml file, i developed a workflow as per your requirement
Json(Autosaved).xaml (9.3 KB)

image
image1366×768 86.2 KB

Hope its solves yours issue

Thanks,
Robin

1 Like
4

Perfect! @ppr and @Robinnavinraj_S, both solutions are working! Thank you for your time.

Bottom line

result
result1087×638 61.9 KB

Solution file
GetPublicHolidays.xaml (9.9 KB)

5

Perfect. May we ask you for Marking the solving Post solution. So Others can benefit from IT. Thanks

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.