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