Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Your JSON Object fields need to be encapsulated by quotes</p> <p>IE</p> <pre><code>{ "code": "BOAC", "cours_jour": "29 000", "variation": "-1.69" } </code></pre> <p>How was the JSON file generated?</p> <p>--Edit</p> <p>You can use the below code to download the page to a string and then convert it to a JSONArray and then pull each JSONObject. You cannot run any web requests on the main thread so either extend a new asynctask or thread or runnable to perform the below</p> <pre><code>DefaultHttpClient httpclient = new DefaultHttpClient(); HttpPost httpost = new HttpPost("http://www.impaxis-securities.com/securities/cours-actions/cours.json"); httpost.setHeader("Accept", "application/json"); httpost.setHeader("Content-type", "application/json"); ResponseHandler&lt;String&gt; responseHandler = new BasicResponseHandler(); String response; try { response = httpclient.execute(httpost, responseHandler); JSONArray arr = new JSONArray(response); int arrLength = arr.length(); if(arrLength &gt; 0) { for(int i = 0; i &lt; arrLength; i++) { JSONObject item = arr.getJSONObject(i); String code = item.getString("code"); String cours_jour = item.getString("cours_jour"); String variation = item.getString("variation"); //Either insert to a DB or add to an array list and return it } } } catch (ClientProtocolException e) { //Issue with web server } catch (IOException e) { //Issue with request } catch (JSONException e) { //ISSUE Parsing JSON from site } </code></pre> <p>---Edit</p> <p>I tested the code and it looks like there is a bug with the JSON plugin/REST service</p> <p><a href="http://drupal.org/node/1433436" rel="nofollow">http://drupal.org/node/1433436</a></p>
    singulars
    1. This table or related slice is empty.
    1. POJsonArray parsing
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USainesophaur
    1. USainesophaur
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COthe json file was generated by a drupal module.. i don't really know the name of the module but i work with the json file they give to me..
      singulars
      1. PO
      1. USH.S.H
    2. COSounds like the array object created by the module isn't putting quotes around it's keys..IE $a = array("code" => "$code", "cours_jour" => "$cours_jour", "variation" => "$variation"); <br /> json_encode($a); but instead they're doing $a = array(code => "$code", cours_jour => "$cours_jour", variation => "$variation");
      singulars
      1. PO
      1. USainesophaur
    3. COhi. Do you really get the code, cours_jours and variation.?? i do System.out.println(response) int the try catch but i have nothing
      singulars
      1. PO
      1. USH.S.H
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload