I'm doing a REST request and if I put it directly into the
address it works fine. But when I do a cfhttp request it throws an
The column name "45123114097Montgomery Ward104755Tue Jul 01
19:31:29 GMT 2008D1817PKUG 8 Audiovox? Portable DVD Player Package
Home Electronics DVD & Home Theater 249.99Audiovox? Portable
DVD Player PackagesThe perfect package for the person on the go.
The system includes a" is invalid.
Column names must be valid variable names. They must start
with a letter and can only include letters, numbers, and
Here is what the actual XML page looks like:
<?xml version="1.0" encoding="UTF-8" ?>
<createdon>Tue Jul 01 19:31:29 GMT
<productname>8 Audiovox? Portable DVD Player
<secondary>DVD & Home Theater</secondary>
<short>Audiovox? Portable DVD Player
<long>The perfect package for the person on the go.
The system includes a, 16:9 aspect ratio portable DVD player with
built-in stereo speakers, two folding headphones, car headrest
mounting bag/carrying case, high capacity rechargeable battery and
credit-card-size remote. Complete cabling with car power adapter.
Plays DVD, CD, MP3, CDR, CDRW and picture CDs. 7 player is 7-7/8W x
6D x 1-1/2H. 8 player is 9-1/4W x 7D x 1-3/8H. UL listed.
http://click.linksynergy.com/fs-bin/click?id=pB75s*fErHM&offerid=113018.104755&type=15&sub id=0</linkurl> <imageurl>
and on to the next product.
Here is my code:
Now obviously this code works as far as getting to the url
and getting a response. But it is not seeing it as xml as far as I
can tell because it is going to the first node's text and thinking
that is the column name. It is doing this right in the HTTP request
so I can't manipulate the data at all.