Need a script that will query the Semantics3 API
[login to view URL]
Input will be a list of thousands of Amazon URL's, one per line - see attached "[login to view URL]" for a small example
Each URL should be used to run the following query against the API.
/v1/products?q= {
"url": "[login to view URL]"
}
These are the Raw JSON results
{"code":"OK","offset":0,"results_count":1,"results":[{"gtins":["00099555018714"],"sem3_id":"2VTQf03do8GGic4q64aw4u","cat_id":"13454","price_currency":"USD","brand":"Gloria Jean's Coffees","upc":"099555018714","price":"9.98","model":"111194","created_at":1464004737,"name":"Gloria Jean's Coffee Macadamia Cookie, Flavored Keurig K-Cup Pod, Medium Roast, 18 Ct","messages":[{"SEM3_IMAGE_HIDDEN":"To view image links for this product, please upgrade your plan"},{"SEM3_PAID_SITES_HIDDEN":"To view products from top sites including [login to view URL], [login to view URL] and more, please upgrade your plan"},{"SEM3_ADDITIONAL_MERCHANTS_HIDDEN":"To view additional merchants for this product, please upgrade your plan"}],"variation_secondaryids":["1ibUXunATkgq2kq60wSg2U","1wazRviVfwgUq24EiWiwW0","43rMbUTqASQek4q84EEmws"],"geo":["usa"],"manufacturer":"keurig","ean":"0099555018714","updated_at":1552549622,"images":[],"sitedetails":[{"name":"[login to view URL]","listprice":"11.48","url":"[login to view URL]","sku":"20606832","listprice_currency":"USD","latestoffers":[{"lastrecorded_at":1552406600,"currency":"USD","availability":"Available","id":"541X8KOkfAUsCiwkE2IGyC","firstrecorded_at":1545621000,"price":"9.98","seller":"Walmart","isactive":1},{"availability":"Available","id":"7IYM0mDXbkCUiAgsMmQQ2u","lastrecorded_at":1545186600,"currency":"USD","seller":"Walmart","price":"8.98","firstrecorded_at":1543883800,"isactive":0}],"recentoffers_count":1},{"latestoffers":[{"seller":"Kohl'[login to view URL]","price":"14.99","firstrecorded_at":1515657200,"id":"1uWTtl1CSSq0o4cAyQ2GGo","availability":"Available","currency":"USD","lastrecorded_at":1539482600,"isactive":0},{"id":"368FKLRlqaYGoqGucI2uuk","availability":"Available","lastrecorded_at":1515575700,"currency":"USD","price":"20.00","seller":"Kohl'[login to view URL]","firstrecorded_at":1514767900,"isactive":0},{"firstrecorded_at":1513506700,"seller":"Kohl'[login to view URL]","price":"10.49","lastrecorded_at":1514107500,"currency":"USD","id":"47SrOlPnCao42KKUGmcsKs","availability":"Available","isactive":0}],"recentoffers_count":0,"name":"[login to view URL]","url":"[login to view URL]","sku":"1257822_93537728"}],"features":{"Assembled Product Weight":"0.5 POUNDS","Food Form":"Solid"},"images_total":0,"category":"Coffee"}],"total_results_count":1}
The following details should be extracted from the JSON and added to a master "[login to view URL]" file (example attached)
[login to view URL],B007KTFY2S,[login to view URL],[login to view URL],9.98,seller:Walmart,isactive:1
[login to view URL],B007KTFY2S,Kohl'[login to view URL],[login to view URL],sku:1257822_93537728,14.99,Kohl'[login to view URL],isactive:0
Once the information is extracted and added to the "[login to view URL]" file the script should proceed to the next link from the "[login to view URL]" and continue working it's way through the entire list.
I am open to whatever form of code you chose to utilize, in your bid please specify what code base you would use as well as an estimated timeframe to deliver the finished script if I select you for this job.