+ Reply to Thread
Results 1 to 3 of 3

White pages API

  1. #1
    Registered User
    Join Date
    04-21-2005
    Posts
    9

    White pages API

    Any help would be greatly appreciated. What I would like to do is using an excel spreadsheet with the following columns:
    First Name
    Last Name
    and State of Residence
    I would like to pull the person's address and phone number using whitepages.api
    http://developer.whitepages.com/docs...ds/find_person

    Would someone be able to help out on this?
    Thanks again!

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573
    What format did you set for the key, XML? There are several ways to get the data. If you are doing XML, then an XML parser will be needed I suspect. It will return 0-20 matches so I am not sure how you would want to handle that.

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello bobbak,

    First, you must be a registered user on WhitePages. Only users can obtain an API key and be granted a license to use the API. The site explains how to invoke the API and describes the methods it uses. If you use the API on your site then you must provide the end user a click-wrap or browse-wrap agreement between you and any End User as stated in the license agreement under End User Terms. When registering you will also be asked your preferred protocol and output format. This will directly effect how you interface with Excel. In short, you really haven't provided enough information for anyone to answer your question.

    Sincerely,
    Leith Ross

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. prints 8 pages, only 4 have content?
    By LTUser54 in forum Excel General
    Replies: 3
    Last Post: 08-26-2008, 03:24 PM
  2. Print Formula
    By swordswinger710 in forum Excel Programming / VBA / Macros
    Replies: 36
    Last Post: 06-27-2008, 04:30 AM
  3. Printing (blank pages)
    By kc27315 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2008, 11:11 AM
  4. Fails to calculate pages to print
    By Mossy in forum Excel General
    Replies: 1
    Last Post: 05-24-2007, 05:33 AM
  5. Referencing different pages in another workbook
    By call_me_bob in forum Excel General
    Replies: 5
    Last Post: 01-27-2007, 12:09 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1