Ebay API call

[Shippwreck]

Hi,

I need to perform a query on Ebay using a specific API call. It is the Getsellerlist one. Now i have quite a bit of experience with VBA, but no experience with API calls.

I have done quite a bit of reading over the past couple of days but am still not sure if it is possible to use VBA to make the call and display the results in Excel. All the articles that i have read mention .net, however i have no experince with .net and frankly am a little confused over the differences between VBA, VB.net and other .net languages.

So if anyone can answer the mess of a question i have then i would be very grateful. Also if anyone knows of some good developer websites that preferably have free code examples (as i always learn best by dissecting code) please post them.

Thanks for any help given

http://www.orlandoluxuryvilla-pool.com

 

[SkipVought]

Shippwreck,

Have you tried playing in Excel with Data/Get External Data/New Web Query....

Skip,

_{[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH!}

 

[Shippwreck]

Hi Skip,

Yeah i have played around with that, however i can't get it to return the data i need.

What i want is to have an excel file that lists the name of all the items i'm selling, the price they are selling at, the item id, auction close date/time.

Now correct me if i'm wrong but in order to return data from the new web query you need a URL that will display the data required, however i can't find any way for ebay to display all those fields, just by simple searching on the site.

The only way i found to return those fields was via the API call mentioned. I believe that Ebay returns the data in an XML document that would then need to be translated into a table with the headings i mentioned.

If i'm wrong and you know of a way to return the data via the URL then please let me know as that would be superb, but otherwise i guess i'm back to the questions of:

Can i run the API call using VBA?
If i can, how? (examples would be good)

If i can't how would be the best way bearing in mind ultimately i need it to end up in Excel?
What languages are needed and can anyone tell me a good place to start learning them/any examples?
What programs are needed to write in those languages that preferably are free as cash is VERY limited (as usual)?

Thanks for any help in advance

http://www.orlandoluxuryvilla-pool.com