XML to JSON

Question

I would like to add some twitter functionality to my channel so my first step is needing to "fix" the SDK twitterOauth example which is currently broken since Twitter upgraded their API and now uses JSON instead of XML. My question for this first function is what is the JSON equivalent of xml.GetChildElements() since what i have there is not working

Function parse_status_response(json As Object, tweetArray As Object) As Void

    tweetElements = json.GetChildElements()
    tweetCount = 0

    for each tweet in tweetElements

        item = init_tweet_item()

        item.Message          = validstr(tweet.text.GetText()) 
        item.UserName         = validstr(tweet.user.screen_name.GetText()) 
        item.ImageSource      = validstr(tweet.user.profile_image_url.GetText())

        tweetCount = tweetCount + 1
        tweetArray.Push(item)
    end for

End Function

And secondly Is there anything really obviously wrong with the start of this function (although the debugger wont let me get to this until the first question gets answered)

Function show_tweet_canvas() As Void

    http = NewHttp(m.prefix+"1.1/statuses/user_timeline.json?screen_name=RokuPlayer")
    oa = Oauth()
    oa.sign(http,false)
    rsp = http.getToStringWithTimeout(10)
    
    json = ParseJson(rsp)

    tweetArray = CreateObject("roArray", 100, true)
    m.ParseTweets(json, tweetArray)
-----------------------

BTW the Oauth part is working fine.

Thanks

RokuMarkn · Answer

The return value from ParseJSON is just a normal AssociativeArray.  You should be able to sayfor each tweet in json--Mark

squirreltown · Answer

Thanks Mark but i'm not clear how to implement that, with xml the hierarchy was:

xml
tweetElements = xml.getchildElements()
for each tweet in tweetElements

switching json for xml i have:

json
tweetElements =? (what goes here? another "for each"? And for each what of what?
for each tweet in tweetElements'

I changed

 tweetElements = xml.GetChildElements()

to

tweetElements = json

which get me past that point but I'm getting a blank canvas no tweets yet.
I am getting this message in the debugger and cant find what 400 means -

Http: # 5975 done status: 400

Thanks

RokuChris · Answer

"squirreltown" wrote:Thanks Mark but i'm not clear how to implement that, with xml the hierarchy was:xmltweetElements = xml.getchildElements()for each tweet in tweetElementsswitching json for xml i have:jsontweetElements =? (what goes here? another "for each"? And for each what of what? for each tweet in tweetElementsIt's not as simple as switching xml for json. They are different types, like Mark said. Parsing XML gives you a roXMLElement with its own set of member functions. ParseJSON() returns a plain old roAssociativeArray, so you can work with it like you would any other roAssociativeArray. roAssociativeArray doesn't have a function equivalent to GetChildElements(). To step through the members of a roAssociativeArray, you'd do something like:for each key in myAA  ? key + ":" + myAA.Lookup(key) ' if the value isn't a string, this won't work, but you get the ideanextSomewhere in the SDK sample code should be a function called PrintAA(). If you use that function on the result you get from ParseJSON(), you might get a better idea of what the structure looks like.

RokuMarkn · Answer

"squirreltown" wrote:I changed  tweetElements = xml.GetChildElements()to tweetElements = jsonThat's fine, although you don't really need the tweetElements variable.  You can just write the for statement the way I quoted it above."squirreltown" wrote:which get me past that point but  I'm getting a blank canvas no tweets yet.I am getting this message in the debugger and cant find what 400 means - Http: # 5975 done status: 400 Status 400 is "Bad Request".  It means the server is rejecting your request for some reason.  You're sending something that twitter doesn't like. http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html has a list of all HTTP error codes.--Mark

squirreltown · Answer

Thank You Chris and Mark. I will work with it some more and I'm sure I'll be back. Chris, I have used that PrintAA function before, thats a real good idea, and thank you Mark for the codes, thats useful.

Forum Discussion

XML to JSON

9 Replies

Recent Discussions

DoRecovery API

Developing a personal/private media player

Anyone experiencing trouble adding new products?

Consumable Product?

Bif file creator