From_dataset throws Illegal quoting in line 1

#1

I’m trying out the following formula:

from_dataset("People", "name", id: person_id)

I’m expecting the formula to return the name of a person from a People dataset. Instead I’m getting the following error in the generated data:

{"id":1,"person_id":1,"person_name":"Error evaluating from_dataset(\"People\", \"name\", \"{\"id\":1}\"): Illegal quoting in line 1."}

Below are my 2 schemas:

https://mockaroo.com/78d42cb0
https://mockaroo.com/ed74e050

What could be the problem?

I’ll like to use a formula data type + from_dataset function over the Dataset Column data type because I’m planning to lookup fields from multiple datasets.

#2

I am having the same issue and have submitted to support as well.

Did you find any resolution.

#3

@mockaroo do you have any input on this?

#4

Hmm, that must be a new one. I’m traveling at the moment, but I should be able to have a look tomorrow at the latest. I’ll let you know what I find.

#5

This also is happening on most nested datasets of mine and I am not using from_dataset.

#6

Sadly, I was unable to find a resolution for this issue.

#7

@mockaroo Did you ever get around to looking at this?

#8

Yes, I have a fix which should be released on Monday.

#9

The fix has been released. The problem was that from_dataset only worked with CSV datasets, not JSON. This is now fixed. However, to conserve memory, I’ve limited from_dataset to datasets of 10,000 records or less.

#10

Thank you so much for the response