Hello all!

I have been a member of this site only a short period of time but wow has my knowledge grown by leaps and bounds!

One of the decisions I made after watching over a hundred videos from DNNCreative was that I was going to use OpenWebStudio to develop my modules instead of doing it the straight up Visual Studio DotNetNuke way. So far I have had great success and your tutorial videos have been instrumental in this.

However I have recently begun to work on my most difficult projects and the road blocks are popping up!

I posted this same question in the OWS forums but haven't gotten any response, so I hope someone here can shed some light.

What I am trying to do is parse a JSON query that returns the following:

[
{
"source_id": "24047",
"uptodate": [2010, 9, 24],
"name": "Outremont",
"electoral_group": {
"province": "",
"name": "Canada",
"level": "Federal"
}
},
{
"source_id": "62",
"uptodate": [2010, 9, 24],
"name": "Mercier",
"electoral_group": {
"province": "QC",
"name": "Québec",
"level": "Provincial"
}
}
]


I have tried implementing every method of defining child items as shown here:

http://goessner.net/articles/JsonPath/

But keep coming up with nothing.

I need to iterate through each item, selecting only the item whose child "level" value is either federal, provincial or municipal (depending on the case) and then display the parent "Name" value and "Source_id". I have attached my OWS config file which contains the whole module, so that it may help in understanding what I am trying to accomplish.

Any and all help would be greatly appreciated!

What are you using to parse the query? Is it something that is built into OWS?

Yes, it is an action method and the setup looks like this:


As you can see I tried one of each of the xpath formats to get the data I need, but none of them return and OWS log reports 0 rows and 3 columns.

I am pretty close to calling it quits and developing a normal DNN module which would allow me to parse the JSON with javascript or C# even... Or hiring someone at OWS for a few hours to build the blocks I can't figure out! lol...

As you may have guessed, I'm not very familiar with OWS. So, if you can afford to go their paid route that might be the most efficient way of getting things done.

Good luck!

Thank you for atleast replying! I appreciate your time.

Don't forget that the R2i folks offer subscriptions with different support levels. If you are doing this in a business context, it would seem one of their paid support options would be cost effective.

I am trying another method but if I can't break through over the weekend I am going to go the paid support route

Its just frustrating due to the lack of documentation! Anyway, I am sure once I register for paid support it will be an easy fix.

Please let me know what happens.

So the answer to my $150 question was very simple. Kevin over at OWS forums pointed me in the right direction and was very helpful. Anyone struggling with an OWS project I can personally recommend the subscription. Its pricey but worth every penny if you are working on a deadline.

The secret is that OWS parses the nodes one after another, so I had to nest an IF statement to check the current value of the node I was interested in. If it was untrue then it would iterate on thru the results until it became true. Very nice method once you figure it out.

I'm guessing that Kevin is Kevin Schreiner. He's the creator of OWS and quite a smart guy!

And I'm glad that you got this worked out.

Another bottom line to this story is ... developers really do know their products. So, when it comes to third-party modules and highly technical questions, they are usually the most helpful in answering!