Is there a way to parse data from JSON info received from a URL? For instance this url, http://search.mobile.walmart.com/search?query=673419247382&store=5430
Can you make each thing a cell in a csv? like "upc" would be i a cell and the "67341924738" would be in the next?
I've created a bot that scrapes info from an inventory checker online. The output comes out in a continuous strings but I want it each store to be it's own column for easier analysis. The website I am using is brickseek.com/walmart-inventory-checker. An example zip code and item number are zip:60403, ID: 47335781.
It appears as the data is set in a table on the website. I was able to make the bot grab the first set of information that appears and divided it into 3 columns, one for the product name, one for the store it's at, and one for the price/availability, for this example:
Walmart Supercenter #3790
16241 S Farrell Rd
Lockport IL 60441
(815) 838-1027
7.71 Miles $ 5.00
Limited Stock
Est Qty in Stock: 1 or Less
But I can't get it to pull the second stores information, it just keeps pulling the first store.
Again I was able to create a bot that would pull the entire table but the output is a continuous string of text for each item.
The second task I need a bot to complete but I absolutely cannot figure out is I would like the bot to take the output data and be able to run it against a previously run version of the bot to spot the differences. Ideally, if the price or availability changes it would output a list of the changes. Any help is greatly appreciated.