Roku Developer Program

Join our online forum to talk to Roku developers and fellow channel creators. Ask questions, share tips with the community, and find helpful resources.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ramim94
Visitor

JSON key with special Character($)

Hi everyone, I have an API response where one of the keys in the JSON response is a $ sign. for example

response { 
...
category{
    $nCat : "something",
    $sCat : "some other things"
}
...
}


Now, when I'm trying to parse this inside a for-each loop,

for each video in allVideos
gridposter.category = video.category.$nCat
...
end for


The error is 'Syntax error: unexpected character $'

is there a way to parse this JSON? Thanks in Advance 🙂 
0 Kudos
4 REPLIES 4
destruk
Binge Watcher

Re: JSON key with special Character($)

Prior to parsing, do a string replace for the $.
temp=strreplace(readInternet,"$","z_")
Function strReplace(basestr As String,oldsub As String,newsub As String) As String
newstr=""
i=1
While i<=Len(basestr)
x=Instr(i,basestr,oldsub)
If x=0
newstr=newstr+MID(basestr,i)
Exit While
End If
If x>i
newstr=newstr+MID(basestr,i,x-i)
i=x
End If
newstr=newstr+newsub
i=i+Len(oldsub)
End While
Return newstr
End Function

0 Kudos
destruk
Binge Watcher

Re: JSON key with special Character($)

Or you can probably try
gridposter.category = video.category["$nCat"]
0 Kudos
ramim94
Visitor

Re: JSON key with special Character($)

Thanks a lot for the quick response, i was looking through associative array methods and doing 
video.category.Lookup("$nCat")


worked for me.
0 Kudos
destruk
Binge Watcher

Re: JSON key with special Character($)

 cool
0 Kudos