# WagoAppJSON and FOR loops

**URL:** <https://www.wago.community/t/wagoappjson-and-for-loops/343>\
**Category:** CODESYS\
**Created:** [December 22, 2022, 8:53am UTC](https://www.wago.community/t/wagoappjson-and-for-loops/343 "2022-12-22T08:53:10Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![quenorha](https://sea2.discourse-cdn.com/flex016/user_avatar/www.wago.community/quenorha/32/429_2.png) [@quenorha](https://www.wago.community/u/quenorha)\
**Post date:** [December 22, 2022, 9:08am UTC](https://www.wago.community/t/wagoappjson-and-for-loops/343/2 "2022-12-22T09:08:21Z")

</div>

Hey Thomas, Have you take a look to the SAX parser ?  
This is mentionned in this topic :

> [@E!cockpit JSON string, sort data](https://www.wago.community/t/e-cockpit-json-string-sort-data/294):
>
> Hello. I’m trying and retrieve information from a JSON file. I manage to pick up the json string. But I can’t sort the data with WagoAppJSON.FbWrite\_ToIEC\_ByRule. The data I try and retrieve is electricity prices in Norway during 24 hours. link to json file [https://www.hvakosterstrommen.no/api/v1/prices/2022/10-30\_NO5.json](https://www.hvakosterstrommen.no/api/v1/prices/2022/10-30_NO5.json) VAR FbWrite\_ToIEC\_ByRuleStrom : WagoAppJSON.FbWrite\_ToIEC\_ByRule; // Function block to sort the info from the JSON file stringPath : STRING(20):='/'; …

It’s really convenient when it comes to nested or array JSON data.  
(Looks like a good beer is on the way 🙂 )

---

_[View the full topic](https://www.wago.community/t/wagoappjson-and-for-loops/343)._