Get help with morph.io and scraping

Morph IO not showing Data

Hi all,

I am relatively new to Morph.io. I tried to implement a scrapper based on the following scrapper
https://classic.scraperwiki.com/scrapers/ratemyprofessors/

This scrapper runs fine returning results. However, when I try to reduce the number of schools in the following line from:
colleges = {“580”:(“MIT”,16),“1222”:(“Yale”,23),“181”:(“CMU”,28), “1085”:(“UChicago”,28),“1040”:(“Tufts”,46), “1350”:(“Duke”,84),“1255”:(“UTexas”,84),“953”:(“Stanford”,32),“799”:(“Rice”,17),“780”:(“Princeton”,16)}

to

colleges = {“580”:(“MIT”,16)}

I get the following error:

error":“no such table: data”}

I understand that this issue is rather specific… However any insight to this problem would be greatly appreciated.

I’m guessing this is the scraper? https://morph.io/ronnpang1/ratemyprofessors

It’s not erroring, did you fix it?

Apologies, the scrapper in question is :

https://morph.io/ronnpang1/teachergrab

And running it through the following API site:

https://morph.io/documentation/api?scraper=ronnpang1%2Fteachergrab

Using the following SQL query: select * from data limit 10

When I curl it or click the URL, it yields the following error: error":“no such table: data”}

It is rather strange considering the only thing that I modified is the amount of colleges. The reduction of colleges is the only thing I’ve changed yet the input is resulting in an error. If I use the original code from:

https://morph.io/ronnpang1/ratemyprofessors

…And run it through the API site, It runs fine.

All the data in the scraper has now disappeared so I guess you changed something else since I last looked.

Post here when you’ve got data back in the scraper and I can have a look again. I suspect the table name was just different (ScraperWiki used swdata) so all you probably need to do is change the SQL query the API is using.