Using json data from another field

Follow

Jean-Claude Massé

• September 30, 2015 02:11

Hi,
i want to use json data. For example:
var dist = @test;
dist.rows[0].elements[0].distance.value /1000

The json data look like that: {
"destination_addresses" : [ "Victoria, BC, Canada" ],
"origin_addresses" : [ "Seattle, Washington, États-Unis" ],
"rows" : [
{
"elements" : [
{
"distance" : {
"text" : "297 km",
"value" : 296838
},
"duration" : {
"text" : "4 heures 48 minutes",
"value" : 17266
},
"status" : "OK"
}
]
}
],
"status" : "ha"
}

If i test directly with json data, i get what i want (distance value)
But replacing the data with @field (where the json data are stored) give me a "cannot read property '0' of undefined" error

Can you help on this please?

0

• 

  Rainer Grabowski

  • September 30, 2015 07:16

  Hi Jean-Claude, search a bit in the questions. There are 2 others JSON-related questions with solutions.

  0

  Comment actions Permalink
• 

  Jean-Claude Massé

  • September 30, 2015 13:11

  Very sorry for that! I check this before and found only thread about API. Maybe i didn't search correctly.
  Here's the answer: https://help.podio.com/hc/communities/public/questions/202620823-Using-calulation-field-javascript-to-parse-JSON

  Thanks a lot.

  0

  Comment actions Permalink
• 

  Gus H.

  • March 09, 2017 01:33

  Hi Jean-Claude. Did you have any luck with getting the distance "number", or should we continue to harass Rainer? For the life of me I cannot get "var pattern" regex to extract the number. Thank you.

  0

  Comment actions Permalink
• 

  Jean-Claude Massé

  • March 09, 2017 01:37

  Hi Gus. Not sure to understand what is your Issue? Also, do you get your data using Globiflow? You can now parse json into GF.

  Do you check the other post from my previous comment?

  0

  Comment actions Permalink
• 

  Gus H.

  • March 09, 2017 02:04

  Hi Jean-Claude. So sorry, I totally ignored the other GF Forum Dimension we have....  As for GF, I am trying to go easy on my flows over there. Man, they add up so quickly. If it can be done in Podio, I'd rather save GF for mission-impossible.

  Here it is for anyone who is interested in parsing Google Matrix JSON for distance and/or time between Point A and B. It works for me, Thanks Jean-Claude for starting this post.

  try {
  String(JSON.parse(@Distance JSON).rows[0].elements[0].distance.text);
  } catch (e) {
  "Could not parse JSON"
  };

  I still cannot remove the word "ml" for miles after parsing the mileage number. :-(

  0

  Comment actions Permalink
• 

  Jean-Claude Massé

  • March 09, 2017 02:27

  You can try to put your result in a var miles = ...code...

  and... miles.replace("ml","")

  0

  Comment actions Permalink

Please sign in to leave a comment.