Data Scraper Using APIs

I need someone that can scrape Item IDs from [login to view URL] and then use [login to view URL] API to perform a query and spits back the info into Excel. I then need it to integrate with another program to see if the UPC is already a listing on Amazon. Then we need to use the Walmart API to pull the data. Below is an Example: Product Lookup API Product Lookup API gives access to item price and availability in real-time. Item id needs to be specified for doing a lookup. Response type returned is full response. Example Queries Lookup for item id 12417832, XML Response [login to view URL]{apiKey}&lsPublisherId={Your LinkShare Publisher Id}&format=xml Lookup for item id 12417832, JSON Response [login to view URL]{apiKey}&lsPublisherId={Your LinkShare Publisher Id}&format=json Lookup by UPC "10001137891": [login to view URL]{apiKey}&upc=10001137891 Lookup for mutiple item ids 12417832,19336123 (supports upto 20 items in one call): [login to view URL],19336123&apiKey={apiKey}&lsPublisherId={Your LinkShare Publisher Id} Formats xml, json Query Parameters Param Name Description Required/Optional apiKey Your API access key. Required lsPublisherId Your LinkShare Publisher Id Optional format Type of response required, allowed values [json, xml]. Default is json. Optional ids Comma separated list of item ids Optional upc upc of the item Optional To play with the API, please checkout the I/O Docs. Response Lookup API returns the Full Response. Response types are covered in the Item Response Groups section. Sample Response { itemId: 19336123, parentItemId: 19336123, name: "Intex Krystal Clear Saltwater System 15,000 Gallon", msrp: 199, salePrice: 139, upc: "078257317042", categoryPath: "Toys/Outdoor Play/Swimming Pools & Waterslides/Pool Supplies", shortDescription: "You can enjoy a clean and comfortable pool using the Intex Krystal Clear saltwater pool filtration system. This easy to maintain saltwater filter is compact and efficient in generating clear pool water. The Intex filter replaces hazardous chlorine with inexpensive, natural salts as it cleans.", I'm interested in two things. 1. The corresponding UPC. I can use this API to find out what the UPC is for each product and can then use this UPC as a method of quickly listing on [login to view URL] 2. in the event that the listing is not on Amazon.com. Then I would need the other information given such as Image URL, Description, etc. I envision the program working like this. 1. we do a pull of model numbers for specified categories. 2. we run the API which pulls the information 3. separately a test is run to see if Amazon has this product listed. ( I already have a VBA file that can do this) 4. If yes, then just the UPC is displayed on one sheet 5. If no, the on a different sheet in excel all the information is pasted. Please reply with API so I know you read this I already have developed Key information. Key Rate Limits 5 Calls per second 5,000 Calls per day