Populate State by Phone Area Code | Community
Skip to main content
October 24, 2013
Solved

Populate State by Phone Area Code

  • October 24, 2013
  • 2 replies
  • 1330 views
We have some cases were leads are in our database and we are given phone #s but aren't asking for states. However, our leads get assigned out by territory. So I'd like to make a rule - if state is blank and area code is ..., state = ...

Has anyone done this before? I'm curious if there's already lists of area codes out there in the community for this and also how to deal with data standardization (ie. 904. or (904) or 904-).

Thanks!

PS I found this thread but was curious if there was any more discussion around this (http://community.marketo.com/MarketoDiscussionDetail?id=90650000000PbPqAAK)
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by
A webhook would be the simplest method, taking the area code and reading the response to populate state.

http://www.allareacodes.com/api/

2 replies

Accepted solution
October 24, 2013
A webhook would be the simplest method, taking the area code and reading the response to populate state.

http://www.allareacodes.com/api/

October 25, 2013
Thanks for the reply. I'll have to start looking into webhooks more :)