Anyone using zipcodeapi

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Anyone using zipcodeapi

4D Tech mailing list
Is anyone using zipcodeapi.com <http://zipcodeapi.com/> to fill in city and state fields in a 4D database? Would you be willing to share your code?

Thanks,

John


John Baughman
Kailua, Hawaii
(808) 262-0328
[hidden email]

**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

Re: Anyone using zipcodeapi

4D Tech mailing list
Actually since I am in the early stage of development any suggestions in this regard are welcome. I see another web based Zip Code site call SmartyStreets. That would work as well.

So any other suggestions would be greatly appreciated.

Thanks,

John

> On Jun 1, 2019, at 3:07 PM, JOHN BAUGHMAN via 4D_Tech <[hidden email]> wrote:
>
> Is anyone using zipcodeapi.com <http://zipcodeapi.com/> to fill in city and state fields in a 4D database? Would you be willing to share your code?
>
> Thanks,
>
> John
>
>
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> [hidden email]
>
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:[hidden email]
> **********************************************************************

**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

Re: Anyone using zipcodeapi

4D Tech mailing list
John,
I've been using SmartyStreets for several years. It's very easy to connect
with and the folks who run it are extremely helpful and friendly.

I looked at the website for zicodeapi.com and notice the service is less
expensive and offers a number of APIs for working with zip codes. It's a
solid suggestion.


On Sat, Jun 1, 2019 at 10:06 PM JOHN BAUGHMAN via 4D_Tech <
[hidden email]> wrote:

> Actually since I am in the early stage of development any suggestions in
> this regard are welcome. I see another web based Zip Code site call
> SmartyStreets. That would work as well.
>
> So any other suggestions would be greatly appreciated.
>
> Thanks,
>
> John
>
> > On Jun 1, 2019, at 3:07 PM, JOHN BAUGHMAN via 4D_Tech <
> [hidden email]> wrote:
> >
> > Is anyone using zipcodeapi.com <http://zipcodeapi.com/> to fill in city
> and state fields in a 4D database? Would you be willing to share your code?
> >
> > Thanks,
> >
> > John
> >
> >
> > John Baughman
> > Kailua, Hawaii
> > (808) 262-0328
> > [hidden email]
> >
> > **********************************************************************
> > 4D Internet Users Group (4D iNUG)
> > Archive:  http://lists.4d.com/archives.html
> > Options: https://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:[hidden email]
> > **********************************************************************
>
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:[hidden email]
> **********************************************************************



--
Kirk Brooks
San Francisco, CA
=======================

What can be said, can be said clearly,
and what you can’t say, you should shut up about

*Wittgenstein and the Computer *
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

Re: Anyone using zipcodeapi

4D Tech mailing list
Thanks Kirk. Yes after looking through the 2 I think zipcodeapi is the better choice. I registered my app and with a simple http request already have what I needed….

    C_TEXT($response)
    C_OBJECT($oResponse)
    $$zipcode:="96734"
    $clientKey:=“;alks;dlfakjldflajdkl"
    $url:="https://www.zipcodeapi.com/rest/"+$clientKey+"/info.json/"+$zipcode+"/radians”
    HTTP Request(HTTP GET method;$url;$content;$response)

   $oResponse:=JSON Parse($response)
   $city:=$oResponse.city
   $state=$oResponse.state

Didn’t think it would be that easy. Hope this post helps someone else down the line.

John



> On Jun 1, 2019, at 6:26 PM, Kirk Brooks via 4D_Tech <[hidden email]> wrote:
>
> John,
> I've been using SmartyStreets for several years. It's very easy to connect
> with and the folks who run it are extremely helpful and friendly.
>
> I looked at the website for zicodeapi.com and notice the service is less
> expensive and offers a number of APIs for working with zip codes. It's a
> solid suggestion.
>
>
> On Sat, Jun 1, 2019 at 10:06 PM JOHN BAUGHMAN via 4D_Tech <
> [hidden email]> wrote:
>
>> Actually since I am in the early stage of development any suggestions in
>> this regard are welcome. I see another web based Zip Code site call
>> SmartyStreets. That would work as well.
>>
>> So any other suggestions would be greatly appreciated.
>>
>> Thanks,
>>
>> John
>>
>>> On Jun 1, 2019, at 3:07 PM, JOHN BAUGHMAN via 4D_Tech <
>> [hidden email]> wrote:
>>>
>>> Is anyone using zipcodeapi.com <http://zipcodeapi.com/> to fill in city
>> and state fields in a 4D database? Would you be willing to share your code?
>>>
>>> Thanks,
>>>
>>> John
>>>
>>>
>>> John Baughman
>>> Kailua, Hawaii
>>> (808) 262-0328
>>> [hidden email]
>>>
>>> **********************************************************************
>>> 4D Internet Users Group (4D iNUG)
>>> Archive:  http://lists.4d.com/archives.html
>>> Options: https://lists.4d.com/mailman/options/4d_tech
>>> Unsub:  mailto:[hidden email]
>>> **********************************************************************
>>
>> **********************************************************************
>> 4D Internet Users Group (4D iNUG)
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:[hidden email]
>> **********************************************************************
>
>
>
> --
> Kirk Brooks
> San Francisco, CA
> =======================
>
> What can be said, can be said clearly,
> and what you can’t say, you should shut up about
>
> *Wittgenstein and the Computer *
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:[hidden email]
> **********************************************************************

**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

Re: Anyone using zipcodeapi

4D Tech mailing list
In reply to this post by 4D Tech mailing list
On Jun 2, 2019, at 2:00 PM, JOHN BAUGHMAN wrote:

> Thanks Kirk. Yes after looking through the 2 I think zipcodeapi is the better choice. I registered my app and with a simple http request already have what I needed….
>
>    C_TEXT($response)
>    C_OBJECT($oResponse)
>    $$zipcode:="96734"
>    $clientKey:=“;alks;dlfakjldflajdkl"
>    $url:="https://www.zipcodeapi.com/rest/"+$clientKey+"/info.json/"+$zipcode+"/radians”
>    HTTP Request(HTTP GET method;$url;$content;$response)
>
>   $oResponse:=JSON Parse($response)
>   $city:=$oResponse.city
>   $state=$oResponse.state
>
> Didn’t think it would be that easy. Hope this post helps someone else down the line.

I had the same experience with Twilio for sending SMS from 4D. It was so easy to use HTTP Request when the website has a well designed API.

If the website is returning JSON, if you can just pass $oResponse instead of $response and 4D will do the "JSON Parse” for you automatically.

Tim

*****************************************
Tim Nevels
Innovative Solutions
785-749-3444
[hidden email]
*****************************************

**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

Re: Anyone using zipcodeapi

4D Tech mailing list
> If the website is returning JSON, if you can just pass $oResponse instead of $response and 4D will do the "JSON Parse” for you automatically.

Tim, thanks. At first I did not understand, but got it now...

                C_OBJECT($oResponse)
                HTTP Request(HTTP GET method;$url;$content;$oResponse)

The HTTP Request command sees JSON coming in and an object for the response and automatically parses it in the object…. Neat. Thanks.

John



> On Jun 2, 2019, at 9:36 AM, Tim Nevels via 4D_Tech <[hidden email]> wrote:
>
> On Jun 2, 2019, at 2:00 PM, JOHN BAUGHMAN wrote:
>
>> Thanks Kirk. Yes after looking through the 2 I think zipcodeapi is the better choice. I registered my app and with a simple http request already have what I needed….
>>
>>   C_TEXT($response)
>>   C_OBJECT($oResponse)
>>   $$zipcode:="96734"
>>   $clientKey:=“;alks;dlfakjldflajdkl"
>>   $url:="https://www.zipcodeapi.com/rest/"+$clientKey+"/info.json/"+$zipcode+"/radians”
>>   HTTP Request(HTTP GET method;$url;$content;$response)
>>
>>  $oResponse:=JSON Parse($response)
>>  $city:=$oResponse.city
>>  $state=$oResponse.state
>>
>> Didn’t think it would be that easy. Hope this post helps someone else down the line.
>
> I had the same experience with Twilio for sending SMS from 4D. It was so easy to use HTTP Request when the website has a well designed API.
>
> If the website is returning JSON, if you can just pass $oResponse instead of $response and 4D will do the "JSON Parse” for you automatically.
>
> Tim
>
> *****************************************
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> [hidden email]
> *****************************************
>
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:[hidden email]
> **********************************************************************

**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

RE: Anyone using zipcodeapi

4D Tech mailing list
In reply to this post by 4D Tech mailing list
John,

I’m using the Google Geocode API. It returns XML with street address info, which can be complicated….

It’s not free, but it is very in-expensive.

David Ringsmuth

From: JOHN BAUGHMAN via 4D_Tech
Sent: Saturday, June 1, 2019 8:07 PM
To: Ed Hammond via 4D_Tech
Cc: JOHN BAUGHMAN
Subject: Anyone using zipcodeapi

Is anyone using zipcodeapi.com <http://zipcodeapi.com/> to fill in city and state fields in a 4D database? Would you be willing to share your code?

Thanks,

John


John Baughman
Kailua, Hawaii
(808) 262-0328
[hidden email]

**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************

**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

RE: Anyone using zipcodeapi

4D Tech mailing list
I’m playing with the Google Geocode too. It’s useful for certain things. It’s free for up to $200 worth or requests per month. That’s a lot for minor uses!



Sannyasin Siddhanathaswami
On Jun 8, 2019, 7:11 AM -1000, David Ringsmuth via 4D_Tech <[hidden email]>, wrote:
John,

I’m using the Google Geocode API. It returns XML with street address info, which can be complicated….

It’s not free, but it is very in-expensive.

David Ringsmuth

From: JOHN BAUGHMAN via 4D_Tech
Sent: Saturday, June 1, 2019 8:07 PM
To: Ed Hammond via 4D_Tech
Cc: JOHN BAUGHMAN
Subject: Anyone using zipcodeapi

Is anyone using zipcodeapi.com <http://zipcodeapi.com/> to fill in city and state fields in a 4D database? Would you be willing to share your code?

Thanks,

John


John Baughman
Kailua, Hawaii
(808) 262-0328
[hidden email]

**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[hidden email]
**********************************************************************

**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[hidden email]
**********************************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************