Reading all "date"´s

Hi,

I need to read all “date” values from this content response:

Response Content: [{“date”:“2024-01-01”,“localName”:“Neujahr”,“name”:“New Year’s Day”,“countryCode”:“AT”,“fixed”:false,“global”:true,“counties”:null,“launchYear”:null,“type”:“0”},{“date”:“2024-01-06”,“localName”:“Heilige Drei Könige”,“name”:“Epiphany”,“countryCode”:“AT”,“fixed”:false,“global”:true,“counties”:null,“launchYear”:null,“type”:“0”},{“date”:“2024-04-01”,“localName”:“Ostermontag”,“name”:“Easter Monday”,“countryCode”:“AT”,“fixed”:false,“global”:true,“counties”:null,“launchYear”:null,“type”:“0”},{“date”:“2024-05-01”,“localName”:“Staatsfeiertag”,“name”:“National Holiday”,“countryCode”:“AT”,“fixed”:false,“global”:true,“counties”:null,“launchYear”:null,“type”:“0”},{“date”:“2024-05-09”,“localName”:“Christi Himmelfahrt”,“name”:“Ascension Day”,“countryCode”:“AT”,“fixed”:false,“global”:true,“counties”:null,“launchYear”:null,“type”:“0”},{“date”:“2024-05-20”,“localName”:“Pfingstmontag”,“name”:“Whit Monday”,“countryCode”:“AT”,“fixed”:false,“global”:true,“counties”:null,“launchYear”:null,“type”:“0”},{“date”:“2024-05-30”,“localName”:“Fronleichnam”,“name”:“Corpus Christi”,“countryCode”:“AT”,“fixed”:false,“global”:true,“counties”:null,“launchYear”:null,“type”:“0”},{“date”:“2024-08-15”,“localName”:“Maria Himmelfahrt”,“name”:“Assumption Day”,“countryCode”:“AT”,“fixed”:false,“global”:true,“counties”:null,“launchYear”:null,“type”:“0”},{“date”:“2024-10-26”,“localName”:“Nationalfeiertag”,“name”:“National Holiday”,“countryCode”:“AT”,“fixed”:false,“global”:true,“counties”:null,“launchYear”:null,“type”:“0”},{“date”:“2024-11-01”,“localName”:“Allerheiligen”,“name”:“All Saints’ Day”,“countryCode”:“AT”,“fixed”:false,“global”:true,“counties”:null,“launchYear”:null,“type”:“0”},{“date”:“2024-12-08”,“localName”:“Mariä Empfängnis”,“name”:“Immaculate Conception”,“countryCode”:“AT”,“fixed”:false,“global”:true,“counties”:null,“launchYear”:null,“type”:“0”},{“date”:“2024-12-25”,“localName”:“Weihnachten”,“name”:“Christmas Day”,“countryCode”:“AT”,“fixed”:false,“global”:true,“counties”:null,“launchYear”:null,“type”:“0”},{“date”:“2024-12-26”,“localName”:“Stefanitag”,“name”:“St. Stephen’s Day”,“countryCode”:“AT”,“fixed”:false,“global”:true,“counties”:null,“launchYear”:null,“type”:“0”}]

Any suggestion?

Thx. KR, Vanja

@VanjaV

Its a json array

Use deserialize json array

Then loop theough array and inside loop currentitem("Date").ToString will give the dates

Else rry deserialize json and select target argument as datatable you would get a column with date

Cheers

2 Likes

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