Android Question Json edit

[Tom1s]

Hi

I got jason with http2tools
[{"CurrDate":"11-11-2014","TotalSumPerDay":"12"},{"CurrDate":"11-17-2014","TotalSumPerDay":"43"}]

I try to put these into google graphs but I cant have those currdate&totalsumperday away.

I used jsonparser and tried to get it working with this:
https://www.b4x.com/android/forum/threads/add-charts-with-google-charts-service.39197/#content

Dim parser As JSONParser
parser.Initialize(json)
Dim root As List = parser.NextArray
For Each colroot As Map In root
Dim TotalSumPerDay As String = colroot.Get("TotalSumPerDay")
Dim CurrDate As String = colroot.Get("CurrDate")
Next

I got this and no google graph. The rows part is a mess....any help?
var data = new google.visualization.DataTable({"cols":[{"type":"string","id":"","label":"CurrDate"},{"type":"number","id":"","label":"TotalSumPerDay"}],"rows":[{"c":[{"v":{"CurrDate":"11-11-2014","TotalSumPerDay":"12"}},{"v":{"CurrDate":"11-17-2014","TotalSumPerDay":"43"}}]}]});

Thanks.

 

[DonManfred]

In the tutorials from that link i cannot see anything what needs a json as parameters...
Which of the examples (pie, bar, line) you want to fill with the json you got from httputils?

 

[Tom1s]

I got that json from a website and i cannot change it. Thats why i try to remove the text from the json. Or i could perhaps replace Currdate&totalsumperday with "v" (as value in google string) ?

 

[DonManfred]

got that json from a website and i cannot change it.

you dont need to!
Just get this json and parse it (you already did that)... Then use the values like you need them to use in the pie chart example (that´s the part you are missing in your code)....

 

[Tom1s]

Thanks I got it working..I had problem in google charts code as well.
Still learning this but getting there slowly....

 

[Tom1s]

Another question:
I am not sure but perhaps it worked once but... how i can change APIKey and ID from srv string before it downloads.
Now log(apikey &ID) shows right input texts but log(srv) it keeps unchange

Sub Globals
Dim Job1 As HttpJob
Dim srv As String
Private APIKey As EditText
Private ID As EditText
srv = "http://....Api.ashx?method=ID&apikey=APIKey"

sub connect
Job1.Initialize("Job1", Me)
Job1.Download(srv)

 

[DonManfred]

1. use code-tags when posting code!!
2. move

Dim Job1 As HttpJob

from Globals to connect

sub connect
Dim Job1 As HttpJob
Job1.Initialize("Job1", Me)
Job1.Download(srv)

3.

how i can change APIKey and ID from srv string before it downloads

Build srv string new in sub connect...

The point is that you actually use ONE instance of httpjob. You should generate a new instance for each job you want to start.

DIMming the job in Globals is a totally NO GO except you want to call it just ONCE!

 

[Tom1s]

Ok Thanks How do i do that Build srv string new? I am still learning...

Sub connect
Dim srvnew As String
srvnew = ???

when I have these text places?:

Sub ID_TextChanged (Old As String, New As String)

End Sub
Sub APIKey_TextChanged (Old As String, New As String)

End Sub

 

[Tom1s]

I dont know what i do wrong but still cant get it....

SUB GLOBAL
Dim srv As String = "http://...pi.ashx?method=I&apikey=A"

SUB CONNECT
Dim A As String = APIKey.Text
Dim I As String = ID.Text

Dim srvnew As String = srv

 

[DonManfred]

You find the beginners guide here.

I suggest learning the basics about variables and their declaration if you dont know how to set a string to a new value.

 

[Tom1s]

I have red those but need check again..feel stupid but didnt find string replace... I will check again. Thank you!

 

[Tom1s]

I just tried and tried to put variables in the http: string like $apikey$ etc
Is it so that it is not even possible?

Now I came up with this solution:

Dim srv As String = "http://........./Api.ashx?"
Dim srvnew As String = srv & "method=" & IDtxt & "&apikey=" & APIKeytxt

 

[DonManfred]

Now I came up with this solution

that´s what i mean with build the string new...