Amazon API using msaccess 2007 vba

Using msaccess 2007 we need to make the following 4 API calls to Amazon. 1- GetReport ReportID = 9952180983 - Returns all our current listings including ASIN, seller SKU, etc. 2- Getlowestofferlistings by ASIN - Returns all seller's prices, landed cost, if multiple sellers are at the same price, etc. - EXCLUDING ourselves, NEW ITEMS ONLY 3- Getcompetitiveprice by ASIN- Returns buy box price and if we own it or not, etc. - NEW ITEMS ONLY 4- SubmittFeed - to change our price and quantity available The database will contain 3 tables, one for each GET API call. GetReport table field list 1-seller sku 2- price 3- Quantity 4- ASIN -primary key Getcompetitiveprice by ASIN field list 1- buy box price 2- Landed Price 3- Shipping 4- buy box belongs to requester, yes/no 5- ASIN - primary key Getlowestofferlistings by ASIN field list 1- Lowest Landed Cost (excluding ourselves) 2- handling time 3- fulfillment channel 4- ASIN - primary key Program Flow: 1- GetReport ReportID = 9952180983 - Returns all our current listings including ASIN, seller SKU, etc. Populate table 2- Loop through all our current listings calling the following 2 api calls a- Getlowestofferlistings by ASIN b- Getcompetitiveprice by ASIN VERY IMPORTANT: when making the getlowestofferlistings and getcompetitiveprice calls submit as MANY ASINs as possible for each call. We have over 100,000 items listed on Amazon. This project must call more than 1 ASIN at a time. We believe the max number is 200 ASINs at once. 3- We will insert our own code which will re-calculate our selling price and update the quantity available. READ TWICE, we will insert our own code to re-calculate our selling price and update the quantity . You do not have to write the code for this step. We will do it. 4- SubmittFeed to update our selling price and quantity available. The database has to be well documented, (comments throughout the code). The database has to have complete error trapping. Checking to see if the Amazon status is green before making the API call, etc. Do not bid on this project unless you have successfully called ALL 4 API calls listed above from msAccess2007. Please feel free to ask any questions before bidding.