eBay Finding API (findCompletedItems)
I would like to some code written that I can run in a Windows 7 environment (may upgrade to Windows 10 soon) on a win64 or win32 machine that calls the eBay Finding API (findCompletedItems). The code would retrieve completed listings (that resulted in a sale) that meet certain criteria and write the output to a CSV file. Please note that I need the auction item image or images for the item listing in addition to the CSV file. So another process will be needed to download these images…perhaps renamed to the item ID and a suffix if more than one. I am expecting to get roughly 5000 listings per day but this estimate could be off. I would love to only have to run it once a week but do not mind running it multiple times with different input (start and end date) especially if it was parameterized…just enter the start and end and it would iterate though the other dates. I might like to have some checks developed such as the number of records retrieved per run (either in total or by type) as well as something that checks for changes in the category structure and possible the version (from the getVersion call)
Note: I should be smart enough to figure out how to slightly modify the code once it is written just not smart enough to actually write it. I will want access to raw code and I can substitute in my eBay developer program APPID. I may need a small rewrite-up or verbal explanation as to what is going on at a high to medium level. I am open to the format or language it is written in but will need to be able to run it myself.
*** Source URL: [url removed, login to view]
*** Output File Fields
-item number (text, but usually all numbers)
-date/time of close time (date/time, CCYYMMDDhhmmsssss as an example in the times zone of the international date line where sssss is seconds and hundredths of seconds or whatever you suggest with other punctuation. I really cannot envision needing the seconds)
-seller ID (text (unsure of maximum length))
-buyer ID (text (unsure of maximum length))
-auction type and length (1 day, 3 day, 5 day, 7 day auction, buy it now, store, etc.) (text (unsure of maximum length) or code)
-category 1 and 2 (text (unsure of maximum length) or perhaps a code)
-item title (text (unsure of maximum length))
-item description (text (unsure of maximum length and may need to cut it off after so many characters like 500))
-final successful bid/selling price (number, allow up to $99,999.99 in US Dollars)
-picture and gallery url(s) (text in a valid format (unsure of maximum length))
File format can be fixed length or CSV with semi-colons as separators and several of the text fields enclosed in double quotes, or whatever format you suggest. Depending on the size of the file it should be broken into perhaps 2 GB chunks. I can download from your ftp site or once I am set up have you upload to mine.
*** search criteria
The approach that may work best is to do the keyword search excluding the specific categories and then do all items in the specific categories either one at a time or all at once.
keywords: similar to containing the phrase "USA", "U.S.A.", "U. S. A." , “United States of America” (none of these are case specific) - I will give you the exact keywords once the project is assigned.
categories: any of the following
<21 total categories with "Stamps>Topical Stamps>Other Topical Stamps" as a example>
I will give you the exact categories once the project is assigned.