Uploading a dataset, can only be done using a csv file.
What I did: save the generated dataset as a CSV file. I then modified the from_dataset formula to use the CSV version of the dataset. For Example: from_dataset(“lookupErrorv2”,“id”, “addr.state”: “FL”). I found that the ‘JSON’ data in the csv had to be quoted. in order for the data to be returned.
See the attached csv:
id,first_name,last_name,email,addr.line1,addr.state
1,Konstantine,Blannin,kblannin0@amazon.co.uk,1 Cody Junction,FL
2,Zarla,Ilchuk,zilchuk1@dmoz.org,03 Bluejay Center,FL
3,Briana,Koene,bkoene2@tinypic.com,5 Ilene Point,FL
4,Clem,Gofford,cgofford3@geocities.com,7 Glacier Hill Avenue,FL
5,Bamby,Freeman,bbertomieu4@issuu.com,0586 Utah Avenue,FL
This is related to From_dataset() doesn’t work with json datasets - Mockaroo Community Forum.
It would be great if the from_dataset would work on JSON datasets and not just CSV.
Any chance on making this happen? @mockaroo