You are not logged in.
Got it figured out. bad file info at top. Missing a line from xml.
I am setting up a job to take a persons address data from a database, look it up using the whitepages.com api and gather and return the reverse lookup info (via xml) into a new table. I will be sharing this operation if it works since I think it may be very useful for people.
Whitepages.com offers an XML Schema file (XSD). I am no XML expert but this seems fairly straight forward and I feel I am very close.
I have set up the core of the job using the a test XML file from whitepages.com. The job is based on the tutorial in the help file: Scenario: Extracting the structure of an XML file and inserting it into the fields of a database table.
I set up the schema based on the XSD file and the three components tfileInputXML -> twriteXMLField -> tMySQLOutput
When I run the job I get an error:
The prefix "wp" for element "wp:wp" is not bound.
There are additional errors but I have found with Talend that the first error is usually the cause of the rest of the errors.
Rather than include the XSD file can be seen at (sorry no live URLs for users with less than 10 posts so you'll have to copy and paste)
and a sample of the XML that is returned is at
http://developer.whitepages.com/docs/Re … s_Response
I am really hoping someone can save me a ton of time and investigation here. I have a feeling this is something simple I am missing. Please help.