I believe you can store the entire XML result to a field and then parse the data from there using the tags to find the data you need. The tags make it fairly easy actually.
AngellEye Consulting has a Paypal plugin for FM that returns similar XML to a field when doing an API search and I had to parse that by script to get a TransactionID when all I had in FM was the InvoiceID from an imported and parsed email.
You may take a look at Andews plugin as most of the returns are pretty slick already for some ideas. There are also a number of people that have been connecting FM to eBay for a while and they might have something commercially available you can use.
Maybe one day someone will offer an ebay plugin as I do not know of anyone having a solid solution yet. Some people use ebay fileexchange to get data, but I am not sure if that is any different or will work for you.
Hope some of this may help.
If you are asking about how to get the data into FM in the first place you can import the text to a field or check out SmartPill or Scriptmaster as I think both offer some sort of PHP functionality to execute the calls directly through FM scripts. SmartPill has issues with FM13.
PHP is not something I am very good at.
Have you tried out the free BaseElements plug-in yet? Is has all the http and XML functions you need to retrieve the data and extract any information.
Nice! Just starting to read about it, looks like it does some really cool stuff. Looks like this could be just what I was looking for related to this post plus other stuff. Thanks a bunch!
After checking it out I tried to install it. Tell me, does that have other files that work with it. I could not get the functions listed here to show up in FileMaker. I am using advanced 13 on Windows. It shows activated in the plugins area of FileMaker but don’t see any other signs it is there. I also see a 64bit version of the download, did not know if that has to be drop somewhere. Thanks
Try using a custom function for parsing the XML.
If the XML response is in a variable called $XML you could use
ExtractData ( $XML ; "ItemID" ; 1 )
to get the first ItemID value.
Thanks, I saw that a while ago and got some use out of it. It is a great function! Thanks