Jump to content

Ronji

Newbies
  • Content count

    3
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Ronji

  • Rank
    newbie
  1. JSON Parsing

    The answer is firstly get a count of the items ValueCount ( JSONListKeys ( Clients::JSONZIPDATA; "places" ) ) then loop through and create the list set variable[$i ; Value: 0 ] Loop Set variable[ $list & "¶" & JSONGetElement ( Clients::JSONZIPDATA ; "places[" & $i & "].place name") ] end loop
  2. Hi Guys Thank you to Richard Carlton for his video on integrating Zippapotamus with Filemaker and the zipcode lookup. In Australia you can have multiple cities for a zipcode and the parsing code is pulling out the first entry and I would like to populated a value list if more than 1 is returned? A scriptParameter is sending this: "place name" &¶& $JSONdata to: Let ( ~startPosition = Position ( $JSONdata ; Quote ( $valueName ) ; 1 ; 1 ) + Length ( $valueName ) + 1 ; Middle ( $JSONdata ; ~startPosition ; Position ( $JSONdata ; "\"" ; ~startPosition ; 1 ) - ~startPosition ) ) Here is the JSON data {"post code": "4220", "country": "Australia", "country abbreviation": "AU", "places": [{"place name": "Burleigh Heads", "longitude": "153.45", "state": "Queensland", "state abbreviation": "QLD", "latitude": "-28.1"}, {"place name": "Burleigh Waters", "longitude": "153.4341", "state": "Queensland", "state abbreviation": "QLD", "latitude": "-28.0895"}, {"place name": "Burleigh Town", "longitude": "153.4341", "state": "Queensland", "state abbreviation": "QLD", "latitude": "-28.0895"}, {"place name": "Miami", "longitude": "153.4341", "state": "Queensland", "state abbreviation": "QLD", "latitude": "-28.0895"}]} Only the first "Place name" is being returned. Thank you in advance. Ron
  3. Hi there all you amazing geniouses (if thats correct) I need a calc that will tell me how many days till a birthdate. I have tried this (Get(CurrentDate)-BirthDate)/365.2425 but if the date is passed it does some strange things. Any help will be greatly appreciated regards Ron
×

Important Information

By using this site, you agree to our Terms of Use.