Extract date from url json

[Dani R]

Hello

I have a json date i get from URL and i whant to extract date from it.

 

That data is lan and log. how can i do it.

 

{
"results" : [
{
"address_components" : [
{
"long_name" : "Tel Aviv",
"short_name" : "Tel Aviv",
"types" : [ "locality", "political" ]
},
{
"long_name" : "Israel",
"short_name" : "IL",
"types" : [ "country", "political" ]
}
],
"formatted_address" : "Tel Aviv, Israel",
"geometry" : {
"bounds" : {
"northeast" : {
"lat" : 32.1466110,
"lng" : 34.85197610
},
"southwest" : {
"lat" : 32.02925310,
"lng" : 34.74251590
}
},
"location" : {
"lat" : 32.0661580,
"lng" : 34.7778190
},
"location_type" : "APPROXIMATE",
"viewport" : {
"northeast" : {
"lat" : 32.1466110,
"lng" : 34.85197610
},
"southwest" : {
"lat" : 32.02925310,
"lng" : 34.74251590
}
}
},
"types" : [ "locality", "political" ]
}
],
"status" : "OK"
}

 

[jbante]

Read the documentation on the Position and Middle functions, then let us know if you need any more help applying them. (I know the links are to the FileMaker 12 help, but these functions haven't changed between versions 10 and 12.)

[Dani R]

Thank you for the help.

 i read about the functions but do not understand how to do it.

[argwallace]

Here is a link to a the Excelisys demo files area. You will see an example that works with pulling Zip data from the web. This demo file also parses json data from a website. I would encourage you to download this example and see how they did it since it is quite straight forward to follow and exactly what you are wanting to do.

 

Hope that helps!

 

Stephen

 

http://www.excelisys.com/filemaker-tips-tricks-demos-downloads.php

[Dani R]

thanks but i sill can get it to work for me.

 

can some pelase send me a demo 

[dansmith65]

This reminds me of a conversation I was having over at filemakerstandards.org about converting JSON to "Let Notation". I would still love to do this, but I don't know when, (if ever), I'll get to it.

 

If you want to accomplish this task the long way, you could write a parser that convert's JSON into "Let Notation" - but that will be a fairly complicated task.

[argwallace]

thanks but i sill can get it to work for me.

 

can some pelase send me a demo 

 

Were you not able to look at the demo of the Zip demo?

[Dani R]

HI i can see the demo. but i do not under stand  how to work with the  Position and Middle.

[argwallace]

Are you using version 10 as your profile states or version 12? I believe the demo for the Zips file is in version 12.

[Dani R]

i am using FM12.

[Dani R]

Can please someone help me with this i am stuck with this.

I am trint to get from json Data the location  (Lng & Lag).

 

Thanks

Dani

[bruceR]

Learn to use Filemaker help.

[Wim Decorte]

As Bruce is saying: read up on the help, try it out and then post what you have tried... The help does a good job of explaining the functions and we can help you where you get stuck after you tried a calc.  But we can't tutor you from the ground up; that's just asking too much...

[Lee Smith]

HI i can see the demo. but i do not under stand  how to work with the  Position and Middle.

Maybe the link I posted here can help. LINK

[Dani R]

Thanks got is working