Error at context.sync()

[deeData]

Hello, I've been getting the error below when running this code https://github.com/OfficeDev/office-js-snippets/blob/prod/samples/excel/20-data-types/data-types-references.yaml

RichApi.Error: Cell A2 has a property "referencedValues" which isn't recognized for this data type.

This error happens at context.sync(). Please advise.

[AlexJerabek]

Thank you for reporting this @deeData.

@alison-mk, could you please investigate?

[alison-mk]

Hi @deeData, thank you for submitting an issue. I'm not seeing this error when I test the sample. Can you tell me more about your environment so I can test further?

• Which platform are you using? (Excel on Windows, Excel on Mac, or Excel on the web)
• Which version of Excel are you using? How to check your Office version

Thanks,
Alison

[deeData]

Hi, I am using Excel on the web, using a custom js add-on that uses the sample code from this sample https://github.com/OfficeDev/office-js-snippets/blob/prod/samples/excel/20-data-types/data-types-references.yaml

When console logging, I am seeing these values as my entities:
[
[
{
"type": "Entity",
"text": "Nancy Davolio",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "1"
},
"Last Name": {
"type": "String",
"basicValue": "Davolio"
},
"First Name": {
"type": "String",
"basicValue": "Nancy"
},
"Name": {
"type": "String",
"basicValue": "Nancy Davolio"
},
"Title": {
"type": "String",
"basicValue": "Vice President, Sales"
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 1
}
],
[
{
"type": "Reference",
"reference": 2
}
],
[
{
"type": "Reference",
"reference": 8
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Direct Reports"
]
}
]
}
},
"referencedValues": [
{
"type": "Root"
},
{
"type": "Entity",
"text": "Andrew Fuller",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "2"
},
"Last Name": {
"type": "String",
"basicValue": "Fuller"
},
"First Name": {
"type": "String",
"basicValue": "Andrew"
},
"Name": {
"type": "String",
"basicValue": "Andrew Fuller"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 0
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Margaret Peacock",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "4"
},
"Last Name": {
"type": "String",
"basicValue": "Peacock"
},
"First Name": {
"type": "String",
"basicValue": "Margaret"
},
"Name": {
"type": "String",
"basicValue": "Margaret Peacock"
},
"Title": {
"type": "String",
"basicValue": "Sales Manager"
},
"Manager": {
"type": "Reference",
"reference": 0
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 3
}
],
[
{
"type": "Reference",
"reference": 4
}
],
[
{
"type": "Reference",
"reference": 5
}
],
[
{
"type": "Reference",
"reference": 6
}
],
[
{
"type": "Reference",
"reference": 7
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Janet Leverling",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "3"
},
"Last Name": {
"type": "String",
"basicValue": "Leverling"
},
"First Name": {
"type": "String",
"basicValue": "Janet"
},
"Name": {
"type": "String",
"basicValue": "Janet Leverling"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Steven Buchanan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "5"
},
"Last Name": {
"type": "String",
"basicValue": "Buchanan"
},
"First Name": {
"type": "String",
"basicValue": "Steven"
},
"Name": {
"type": "String",
"basicValue": "Steven Buchanan"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Michael Suyama",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "6"
},
"Last Name": {
"type": "String",
"basicValue": "Suyama"
},
"First Name": {
"type": "String",
"basicValue": "Michael"
},
"Name": {
"type": "String",
"basicValue": "Michael Suyama"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Robert King",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "7"
},
"Last Name": {
"type": "String",
"basicValue": "King"
},
"First Name": {
"type": "String",
"basicValue": "Robert"
},
"Name": {
"type": "String",
"basicValue": "Robert King"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Anne Dodsworth",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "9"
},
"Last Name": {
"type": "String",
"basicValue": "Dodsworth"
},
"First Name": {
"type": "String",
"basicValue": "Anne"
},
"Name": {
"type": "String",
"basicValue": "Anne Dodsworth"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Laura Callahan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "8"
},
"Last Name": {
"type": "String",
"basicValue": "Callahan"
},
"First Name": {
"type": "String",
"basicValue": "Laura"
},
"Name": {
"type": "String",
"basicValue": "Laura Callahan"
},
"Title": {
"type": "String",
"basicValue": "Inside Sales Coordinator"
},
"Manager": {
"type": "Reference",
"reference": 0
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
}
]
}
],
[
{
"type": "Entity",
"text": "Andrew Fuller",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "2"
},
"Last Name": {
"type": "String",
"basicValue": "Fuller"
},
"First Name": {
"type": "String",
"basicValue": "Andrew"
},
"Name": {
"type": "String",
"basicValue": "Andrew Fuller"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
},
"referencedValues": [
{
"type": "Root"
},
{
"type": "Entity",
"text": "Nancy Davolio",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "1"
},
"Last Name": {
"type": "String",
"basicValue": "Davolio"
},
"First Name": {
"type": "String",
"basicValue": "Nancy"
},
"Name": {
"type": "String",
"basicValue": "Nancy Davolio"
},
"Title": {
"type": "String",
"basicValue": "Vice President, Sales"
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 0
}
],
[
{
"type": "Reference",
"reference": 2
}
],
[
{
"type": "Reference",
"reference": 8
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Margaret Peacock",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "4"
},
"Last Name": {
"type": "String",
"basicValue": "Peacock"
},
"First Name": {
"type": "String",
"basicValue": "Margaret"
},
"Name": {
"type": "String",
"basicValue": "Margaret Peacock"
},
"Title": {
"type": "String",
"basicValue": "Sales Manager"
},
"Manager": {
"type": "Reference",
"reference": 1
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 3
}
],
[
{
"type": "Reference",
"reference": 4
}
],
[
{
"type": "Reference",
"reference": 5
}
],
[
{
"type": "Reference",
"reference": 6
}
],
[
{
"type": "Reference",
"reference": 7
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Janet Leverling",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "3"
},
"Last Name": {
"type": "String",
"basicValue": "Leverling"
},
"First Name": {
"type": "String",
"basicValue": "Janet"
},
"Name": {
"type": "String",
"basicValue": "Janet Leverling"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Steven Buchanan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "5"
},
"Last Name": {
"type": "String",
"basicValue": "Buchanan"
},
"First Name": {
"type": "String",
"basicValue": "Steven"
},
"Name": {
"type": "String",
"basicValue": "Steven Buchanan"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Michael Suyama",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "6"
},
"Last Name": {
"type": "String",
"basicValue": "Suyama"
},
"First Name": {
"type": "String",
"basicValue": "Michael"
},
"Name": {
"type": "String",
"basicValue": "Michael Suyama"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Robert King",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "7"
},
"Last Name": {
"type": "String",
"basicValue": "King"
},
"First Name": {
"type": "String",
"basicValue": "Robert"
},
"Name": {
"type": "String",
"basicValue": "Robert King"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Anne Dodsworth",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "9"
},
"Last Name": {
"type": "String",
"basicValue": "Dodsworth"
},
"First Name": {
"type": "String",
"basicValue": "Anne"
},
"Name": {
"type": "String",
"basicValue": "Anne Dodsworth"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Laura Callahan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "8"
},
"Last Name": {
"type": "String",
"basicValue": "Callahan"
},
"First Name": {
"type": "String",
"basicValue": "Laura"
},
"Name": {
"type": "String",
"basicValue": "Laura Callahan"
},
"Title": {
"type": "String",
"basicValue": "Inside Sales Coordinator"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
}
]
}
],
[
{
"type": "Entity",
"text": "Janet Leverling",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "3"
},
"Last Name": {
"type": "String",
"basicValue": "Leverling"
},
"First Name": {
"type": "String",
"basicValue": "Janet"
},
"Name": {
"type": "String",
"basicValue": "Janet Leverling"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
},
"referencedValues": [
{
"type": "Root"
},
{
"type": "Entity",
"text": "Margaret Peacock",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "4"
},
"Last Name": {
"type": "String",
"basicValue": "Peacock"
},
"First Name": {
"type": "String",
"basicValue": "Margaret"
},
"Name": {
"type": "String",
"basicValue": "Margaret Peacock"
},
"Title": {
"type": "String",
"basicValue": "Sales Manager"
},
"Manager": {
"type": "Reference",
"reference": 2
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 0
}
],
[
{
"type": "Reference",
"reference": 5
}
],
[
{
"type": "Reference",
"reference": 6
}
],
[
{
"type": "Reference",
"reference": 7
}
],
[
{
"type": "Reference",
"reference": 8
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Nancy Davolio",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "1"
},
"Last Name": {
"type": "String",
"basicValue": "Davolio"
},
"First Name": {
"type": "String",
"basicValue": "Nancy"
},
"Name": {
"type": "String",
"basicValue": "Nancy Davolio"
},
"Title": {
"type": "String",
"basicValue": "Vice President, Sales"
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 3
}
],
[
{
"type": "Reference",
"reference": 1
}
],
[
{
"type": "Reference",
"reference": 4
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Andrew Fuller",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "2"
},
"Last Name": {
"type": "String",
"basicValue": "Fuller"
},
"First Name": {
"type": "String",
"basicValue": "Andrew"
},
"Name": {
"type": "String",
"basicValue": "Andrew Fuller"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Laura Callahan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "8"
},
"Last Name": {
"type": "String",
"basicValue": "Callahan"
},
"First Name": {
"type": "String",
"basicValue": "Laura"
},
"Name": {
"type": "String",
"basicValue": "Laura Callahan"
},
"Title": {
"type": "String",
"basicValue": "Inside Sales Coordinator"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Steven Buchanan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "5"
},
"Last Name": {
"type": "String",
"basicValue": "Buchanan"
},
"First Name": {
"type": "String",
"basicValue": "Steven"
},
"Name": {
"type": "String",
"basicValue": "Steven Buchanan"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Michael Suyama",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "6"
},
"Last Name": {
"type": "String",
"basicValue": "Suyama"
},
"First Name": {
"type": "String",
"basicValue": "Michael"
},
"Name": {
"type": "String",
"basicValue": "Michael Suyama"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Robert King",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "7"
},
"Last Name": {
"type": "String",
"basicValue": "King"
},
"First Name": {
"type": "String",
"basicValue": "Robert"
},
"Name": {
"type": "String",
"basicValue": "Robert King"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Anne Dodsworth",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "9"
},
"Last Name": {
"type": "String",
"basicValue": "Dodsworth"
},
"First Name": {
"type": "String",
"basicValue": "Anne"
},
"Name": {
"type": "String",
"basicValue": "Anne Dodsworth"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
}
]
}
],
[
{
"type": "Entity",
"text": "Margaret Peacock",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "4"
},
"Last Name": {
"type": "String",
"basicValue": "Peacock"
},
"First Name": {
"type": "String",
"basicValue": "Margaret"
},
"Name": {
"type": "String",
"basicValue": "Margaret Peacock"
},
"Title": {
"type": "String",
"basicValue": "Sales Manager"
},
"Manager": {
"type": "Reference",
"reference": 1
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 4
}
],
[
{
"type": "Reference",
"reference": 5
}
],
[
{
"type": "Reference",
"reference": 6
}
],
[
{
"type": "Reference",
"reference": 7
}
],
[
{
"type": "Reference",
"reference": 8
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager",
"Direct Reports"
]
}
]
}
},
"referencedValues": [
{
"type": "Root"
},
{
"type": "Entity",
"text": "Nancy Davolio",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "1"
},
"Last Name": {
"type": "String",
"basicValue": "Davolio"
},
"First Name": {
"type": "String",
"basicValue": "Nancy"
},
"Name": {
"type": "String",
"basicValue": "Nancy Davolio"
},
"Title": {
"type": "String",
"basicValue": "Vice President, Sales"
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 2
}
],
[
{
"type": "Reference",
"reference": 0
}
],
[
{
"type": "Reference",
"reference": 3
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Andrew Fuller",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "2"
},
"Last Name": {
"type": "String",
"basicValue": "Fuller"
},
"First Name": {
"type": "String",
"basicValue": "Andrew"
},
"Name": {
"type": "String",
"basicValue": "Andrew Fuller"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Laura Callahan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "8"
},
"Last Name": {
"type": "String",
"basicValue": "Callahan"
},
"First Name": {
"type": "String",
"basicValue": "Laura"
},
"Name": {
"type": "String",
"basicValue": "Laura Callahan"
},
"Title": {
"type": "String",
"basicValue": "Inside Sales Coordinator"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Janet Leverling",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "3"
},
"Last Name": {
"type": "String",
"basicValue": "Leverling"
},
"First Name": {
"type": "String",
"basicValue": "Janet"
},
"Name": {
"type": "String",
"basicValue": "Janet Leverling"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 0
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Steven Buchanan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "5"
},
"Last Name": {
"type": "String",
"basicValue": "Buchanan"
},
"First Name": {
"type": "String",
"basicValue": "Steven"
},
"Name": {
"type": "String",
"basicValue": "Steven Buchanan"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 0
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Michael Suyama",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "6"
},
"Last Name": {
"type": "String",
"basicValue": "Suyama"
},
"First Name": {
"type": "String",
"basicValue": "Michael"
},
"Name": {
"type": "String",
"basicValue": "Michael Suyama"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 0
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Robert King",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "7"
},
"Last Name": {
"type": "String",
"basicValue": "King"
},
"First Name": {
"type": "String",
"basicValue": "Robert"
},
"Name": {
"type": "String",
"basicValue": "Robert King"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 0
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Anne Dodsworth",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "9"
},
"Last Name": {
"type": "String",
"basicValue": "Dodsworth"
},
"First Name": {
"type": "String",
"basicValue": "Anne"
},
"Name": {
"type": "String",
"basicValue": "Anne Dodsworth"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 0
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
}
]
}
],
[
{
"type": "Entity",
"text": "Steven Buchanan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "5"
},
"Last Name": {
"type": "String",
"basicValue": "Buchanan"
},
"First Name": {
"type": "String",
"basicValue": "Steven"
},
"Name": {
"type": "String",
"basicValue": "Steven Buchanan"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
},
"referencedValues": [
{
"type": "Root"
},
{
"type": "Entity",
"text": "Margaret Peacock",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "4"
},
"Last Name": {
"type": "String",
"basicValue": "Peacock"
},
"First Name": {
"type": "String",
"basicValue": "Margaret"
},
"Name": {
"type": "String",
"basicValue": "Margaret Peacock"
},
"Title": {
"type": "String",
"basicValue": "Sales Manager"
},
"Manager": {
"type": "Reference",
"reference": 2
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 5
}
],
[
{
"type": "Reference",
"reference": 0
}
],
[
{
"type": "Reference",
"reference": 6
}
],
[
{
"type": "Reference",
"reference": 7
}
],
[
{
"type": "Reference",
"reference": 8
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Nancy Davolio",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "1"
},
"Last Name": {
"type": "String",
"basicValue": "Davolio"
},
"First Name": {
"type": "String",
"basicValue": "Nancy"
},
"Name": {
"type": "String",
"basicValue": "Nancy Davolio"
},
"Title": {
"type": "String",
"basicValue": "Vice President, Sales"
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 3
}
],
[
{
"type": "Reference",
"reference": 1
}
],
[
{
"type": "Reference",
"reference": 4
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Andrew Fuller",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "2"
},
"Last Name": {
"type": "String",
"basicValue": "Fuller"
},
"First Name": {
"type": "String",
"basicValue": "Andrew"
},
"Name": {
"type": "String",
"basicValue": "Andrew Fuller"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Laura Callahan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "8"
},
"Last Name": {
"type": "String",
"basicValue": "Callahan"
},
"First Name": {
"type": "String",
"basicValue": "Laura"
},
"Name": {
"type": "String",
"basicValue": "Laura Callahan"
},
"Title": {
"type": "String",
"basicValue": "Inside Sales Coordinator"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Janet Leverling",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "3"
},
"Last Name": {
"type": "String",
"basicValue": "Leverling"
},
"First Name": {
"type": "String",
"basicValue": "Janet"
},
"Name": {
"type": "String",
"basicValue": "Janet Leverling"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Michael Suyama",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "6"
},
"Last Name": {
"type": "String",
"basicValue": "Suyama"
},
"First Name": {
"type": "String",
"basicValue": "Michael"
},
"Name": {
"type": "String",
"basicValue": "Michael Suyama"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Robert King",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "7"
},
"Last Name": {
"type": "String",
"basicValue": "King"
},
"First Name": {
"type": "String",
"basicValue": "Robert"
},
"Name": {
"type": "String",
"basicValue": "Robert King"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Anne Dodsworth",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "9"
},
"Last Name": {
"type": "String",
"basicValue": "Dodsworth"
},
"First Name": {
"type": "String",
"basicValue": "Anne"
},
"Name": {
"type": "String",
"basicValue": "Anne Dodsworth"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
}
]
}
],
[
{
"type": "Entity",
"text": "Michael Suyama",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "6"
},
"Last Name": {
"type": "String",
"basicValue": "Suyama"
},
"First Name": {
"type": "String",
"basicValue": "Michael"
},
"Name": {
"type": "String",
"basicValue": "Michael Suyama"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
},
"referencedValues": [
{
"type": "Root"
},
{
"type": "Entity",
"text": "Margaret Peacock",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "4"
},
"Last Name": {
"type": "String",
"basicValue": "Peacock"
},
"First Name": {
"type": "String",
"basicValue": "Margaret"
},
"Name": {
"type": "String",
"basicValue": "Margaret Peacock"
},
"Title": {
"type": "String",
"basicValue": "Sales Manager"
},
"Manager": {
"type": "Reference",
"reference": 2
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 5
}
],
[
{
"type": "Reference",
"reference": 6
}
],
[
{
"type": "Reference",
"reference": 0
}
],
[
{
"type": "Reference",
"reference": 7
}
],
[
{
"type": "Reference",
"reference": 8
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Nancy Davolio",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "1"
},
"Last Name": {
"type": "String",
"basicValue": "Davolio"
},
"First Name": {
"type": "String",
"basicValue": "Nancy"
},
"Name": {
"type": "String",
"basicValue": "Nancy Davolio"
},
"Title": {
"type": "String",
"basicValue": "Vice President, Sales"
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 3
}
],
[
{
"type": "Reference",
"reference": 1
}
],
[
{
"type": "Reference",
"reference": 4
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Andrew Fuller",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "2"
},
"Last Name": {
"type": "String",
"basicValue": "Fuller"
},
"First Name": {
"type": "String",
"basicValue": "Andrew"
},
"Name": {
"type": "String",
"basicValue": "Andrew Fuller"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Laura Callahan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "8"
},
"Last Name": {
"type": "String",
"basicValue": "Callahan"
},
"First Name": {
"type": "String",
"basicValue": "Laura"
},
"Name": {
"type": "String",
"basicValue": "Laura Callahan"
},
"Title": {
"type": "String",
"basicValue": "Inside Sales Coordinator"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Janet Leverling",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "3"
},
"Last Name": {
"type": "String",
"basicValue": "Leverling"
},
"First Name": {
"type": "String",
"basicValue": "Janet"
},
"Name": {
"type": "String",
"basicValue": "Janet Leverling"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Steven Buchanan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "5"
},
"Last Name": {
"type": "String",
"basicValue": "Buchanan"
},
"First Name": {
"type": "String",
"basicValue": "Steven"
},
"Name": {
"type": "String",
"basicValue": "Steven Buchanan"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Robert King",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "7"
},
"Last Name": {
"type": "String",
"basicValue": "King"
},
"First Name": {
"type": "String",
"basicValue": "Robert"
},
"Name": {
"type": "String",
"basicValue": "Robert King"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Anne Dodsworth",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "9"
},
"Last Name": {
"type": "String",
"basicValue": "Dodsworth"
},
"First Name": {
"type": "String",
"basicValue": "Anne"
},
"Name": {
"type": "String",
"basicValue": "Anne Dodsworth"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
}
]
}
],
[
{
"type": "Entity",
"text": "Robert King",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "7"
},
"Last Name": {
"type": "String",
"basicValue": "King"
},
"First Name": {
"type": "String",
"basicValue": "Robert"
},
"Name": {
"type": "String",
"basicValue": "Robert King"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
},
"referencedValues": [
{
"type": "Root"
},
{
"type": "Entity",
"text": "Margaret Peacock",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "4"
},
"Last Name": {
"type": "String",
"basicValue": "Peacock"
},
"First Name": {
"type": "String",
"basicValue": "Margaret"
},
"Name": {
"type": "String",
"basicValue": "Margaret Peacock"
},
"Title": {
"type": "String",
"basicValue": "Sales Manager"
},
"Manager": {
"type": "Reference",
"reference": 2
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 5
}
],
[
{
"type": "Reference",
"reference": 6
}
],
[
{
"type": "Reference",
"reference": 7
}
],
[
{
"type": "Reference",
"reference": 0
}
],
[
{
"type": "Reference",
"reference": 8
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Nancy Davolio",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "1"
},
"Last Name": {
"type": "String",
"basicValue": "Davolio"
},
"First Name": {
"type": "String",
"basicValue": "Nancy"
},
"Name": {
"type": "String",
"basicValue": "Nancy Davolio"
},
"Title": {
"type": "String",
"basicValue": "Vice President, Sales"
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 3
}
],
[
{
"type": "Reference",
"reference": 1
}
],
[
{
"type": "Reference",
"reference": 4
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Andrew Fuller",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "2"
},
"Last Name": {
"type": "String",
"basicValue": "Fuller"
},
"First Name": {
"type": "String",
"basicValue": "Andrew"
},
"Name": {
"type": "String",
"basicValue": "Andrew Fuller"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Laura Callahan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "8"
},
"Last Name": {
"type": "String",
"basicValue": "Callahan"
},
"First Name": {
"type": "String",
"basicValue": "Laura"
},
"Name": {
"type": "String",
"basicValue": "Laura Callahan"
},
"Title": {
"type": "String",
"basicValue": "Inside Sales Coordinator"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Janet Leverling",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "3"
},
"Last Name": {
"type": "String",
"basicValue": "Leverling"
},
"First Name": {
"type": "String",
"basicValue": "Janet"
},
"Name": {
"type": "String",
"basicValue": "Janet Leverling"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Steven Buchanan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "5"
},
"Last Name": {
"type": "String",
"basicValue": "Buchanan"
},
"First Name": {
"type": "String",
"basicValue": "Steven"
},
"Name": {
"type": "String",
"basicValue": "Steven Buchanan"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Michael Suyama",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "6"
},
"Last Name": {
"type": "String",
"basicValue": "Suyama"
},
"First Name": {
"type": "String",
"basicValue": "Michael"
},
"Name": {
"type": "String",
"basicValue": "Michael Suyama"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Anne Dodsworth",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "9"
},
"Last Name": {
"type": "String",
"basicValue": "Dodsworth"
},
"First Name": {
"type": "String",
"basicValue": "Anne"
},
"Name": {
"type": "String",
"basicValue": "Anne Dodsworth"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
}
]
}
],
[
{
"type": "Entity",
"text": "Laura Callahan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "8"
},
"Last Name": {
"type": "String",
"basicValue": "Callahan"
},
"First Name": {
"type": "String",
"basicValue": "Laura"
},
"Name": {
"type": "String",
"basicValue": "Laura Callahan"
},
"Title": {
"type": "String",
"basicValue": "Inside Sales Coordinator"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
},
"referencedValues": [
{
"type": "Root"
},
{
"type": "Entity",
"text": "Nancy Davolio",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "1"
},
"Last Name": {
"type": "String",
"basicValue": "Davolio"
},
"First Name": {
"type": "String",
"basicValue": "Nancy"
},
"Name": {
"type": "String",
"basicValue": "Nancy Davolio"
},
"Title": {
"type": "String",
"basicValue": "Vice President, Sales"
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 2
}
],
[
{
"type": "Reference",
"reference": 3
}
],
[
{
"type": "Reference",
"reference": 0
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Andrew Fuller",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "2"
},
"Last Name": {
"type": "String",
"basicValue": "Fuller"
},
"First Name": {
"type": "String",
"basicValue": "Andrew"
},
"Name": {
"type": "String",
"basicValue": "Andrew Fuller"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Margaret Peacock",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "4"
},
"Last Name": {
"type": "String",
"basicValue": "Peacock"
},
"First Name": {
"type": "String",
"basicValue": "Margaret"
},
"Name": {
"type": "String",
"basicValue": "Margaret Peacock"
},
"Title": {
"type": "String",
"basicValue": "Sales Manager"
},
"Manager": {
"type": "Reference",
"reference": 1
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 4
}
],
[
{
"type": "Reference",
"reference": 5
}
],
[
{
"type": "Reference",
"reference": 6
}
],
[
{
"type": "Reference",
"reference": 7
}
],
[
{
"type": "Reference",
"reference": 8
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Janet Leverling",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "3"
},
"Last Name": {
"type": "String",
"basicValue": "Leverling"
},
"First Name": {
"type": "String",
"basicValue": "Janet"
},
"Name": {
"type": "String",
"basicValue": "Janet Leverling"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 3
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Steven Buchanan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "5"
},
"Last Name": {
"type": "String",
"basicValue": "Buchanan"
},
"First Name": {
"type": "String",
"basicValue": "Steven"
},
"Name": {
"type": "String",
"basicValue": "Steven Buchanan"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 3
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Michael Suyama",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "6"
},
"Last Name": {
"type": "String",
"basicValue": "Suyama"
},
"First Name": {
"type": "String",
"basicValue": "Michael"
},
"Name": {
"type": "String",
"basicValue": "Michael Suyama"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 3
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Robert King",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "7"
},
"Last Name": {
"type": "String",
"basicValue": "King"
},
"First Name": {
"type": "String",
"basicValue": "Robert"
},
"Name": {
"type": "String",
"basicValue": "Robert King"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 3
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Anne Dodsworth",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "9"
},
"Last Name": {
"type": "String",
"basicValue": "Dodsworth"
},
"First Name": {
"type": "String",
"basicValue": "Anne"
},
"Name": {
"type": "String",
"basicValue": "Anne Dodsworth"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 3
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
}
]
}
],
[
{
"type": "Entity",
"text": "Anne Dodsworth",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "9"
},
"Last Name": {
"type": "String",
"basicValue": "Dodsworth"
},
"First Name": {
"type": "String",
"basicValue": "Anne"
},
"Name": {
"type": "String",
"basicValue": "Anne Dodsworth"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
},
"referencedValues": [
{
"type": "Root"
},
{
"type": "Entity",
"text": "Margaret Peacock",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "4"
},
"Last Name": {
"type": "String",
"basicValue": "Peacock"
},
"First Name": {
"type": "String",
"basicValue": "Margaret"
},
"Name": {
"type": "String",
"basicValue": "Margaret Peacock"
},
"Title": {
"type": "String",
"basicValue": "Sales Manager"
},
"Manager": {
"type": "Reference",
"reference": 2
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 5
}
],
[
{
"type": "Reference",
"reference": 6
}
],
[
{
"type": "Reference",
"reference": 7
}
],
[
{
"type": "Reference",
"reference": 8
}
],
[
{
"type": "Reference",
"reference": 0
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Nancy Davolio",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "1"
},
"Last Name": {
"type": "String",
"basicValue": "Davolio"
},
"First Name": {
"type": "String",
"basicValue": "Nancy"
},
"Name": {
"type": "String",
"basicValue": "Nancy Davolio"
},
"Title": {
"type": "String",
"basicValue": "Vice President, Sales"
},
"Direct Reports": {
"type": "Array",
"elements": [
[
{
"type": "Reference",
"reference": 3
}
],
[
{
"type": "Reference",
"reference": 1
}
],
[
{
"type": "Reference",
"reference": 4
}
]
]
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Direct Reports"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Andrew Fuller",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "2"
},
"Last Name": {
"type": "String",
"basicValue": "Fuller"
},
"First Name": {
"type": "String",
"basicValue": "Andrew"
},
"Name": {
"type": "String",
"basicValue": "Andrew Fuller"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Laura Callahan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "8"
},
"Last Name": {
"type": "String",
"basicValue": "Callahan"
},
"First Name": {
"type": "String",
"basicValue": "Laura"
},
"Name": {
"type": "String",
"basicValue": "Laura Callahan"
},
"Title": {
"type": "String",
"basicValue": "Inside Sales Coordinator"
},
"Manager": {
"type": "Reference",
"reference": 2
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Janet Leverling",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "3"
},
"Last Name": {
"type": "String",
"basicValue": "Leverling"
},
"First Name": {
"type": "String",
"basicValue": "Janet"
},
"Name": {
"type": "String",
"basicValue": "Janet Leverling"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Steven Buchanan",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "5"
},
"Last Name": {
"type": "String",
"basicValue": "Buchanan"
},
"First Name": {
"type": "String",
"basicValue": "Steven"
},
"Name": {
"type": "String",
"basicValue": "Steven Buchanan"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Michael Suyama",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "6"
},
"Last Name": {
"type": "String",
"basicValue": "Suyama"
},
"First Name": {
"type": "String",
"basicValue": "Michael"
},
"Name": {
"type": "String",
"basicValue": "Michael Suyama"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
},
{
"type": "Entity",
"text": "Robert King",
"properties": {
"Employee ID": {
"type": "String",
"basicValue": "7"
},
"Last Name": {
"type": "String",
"basicValue": "King"
},
"First Name": {
"type": "String",
"basicValue": "Robert"
},
"Name": {
"type": "String",
"basicValue": "Robert King"
},
"Title": {
"type": "String",
"basicValue": "Sales Representative"
},
"Manager": {
"type": "Reference",
"reference": 1
}
},
"layouts": {
"compact": {
"icon": "AnimalCat"
},
"card": {
"title": {
"property": "Title"
},
"sections": [
{
"layout": "List",
"properties": [
"Employee ID",
"First Name",
"Last Name",
"Name",
"Title",
"Manager"
]
}
]
}
}
}
]
}
]
]

[alison-mk]

Hi @deeData, thank you for the additional information. I tested the sample in Excel on the web, and it's not producing an error on that platform either. We use GitHub issues to report bugs with the product, and it looks like you are asking for assistance troubleshooting an error in custom code you've written.

For programming questions like this, we suggest you go to Stack Overflow and see if your question has already been asked or ask a new question. Stack Overflow has an active community of developers that regularly provide feedback and guidance.

Since this isn't a bug, I will close this issue. Let me know if you have any questions!

Alison