Import Json error for Canvas


(Sunil Edupuganti) #1

Hi,
When I am trying to import the JSON file for canvas, I am getting an import error like some properties required for canvas are missing. Could anyone please tell me the structure of JSON required for canvas.

Actually, my JSON is correct only, but I don't know what exact properties needed for JSON. Below is my JSON data. I have attached the error screenshot too. Please check and help me to figureout the issue.

[
{
"Vendor ID": 1000,
"Vendor Name": "Fox Head Inc.",
"Address": "913 N Market Street, Wilmington, DE",
"Category": "Food",
"Status": "Active",
"Region": "DE",
"Date Active": "10 Jul, 2018 18:25:22",
"Classsification": "Diverse Business",
"Minority_owned": "No",
"Woman_owned": "Yes",
"Small_business": "Yes",
"Veteran_owned": "No",
"Service_disabled_owned": "No"
},
{
"Vendor ID": 2000,
"Vendor Name": "M/s.Supermak Foils Pvt Ltd",
"Address": "18 Campus Blvd, Newtown Square, PA",
"Category": "Information Technology",
"Status": "Active",
"Region": "PA",
"Date Active": "10 Jul, 2018 18:25:22",
"Classsification": "Veteran Owner",
"Minority_owned": "No",
"Woman_owned": "Yes",
"Small_business": "No",
"Veteran_owned": "No",
"Service_disabled_owned": "No"
},
{
"Vendor ID": 3000,
"Vendor Name": "Luckhoo",
"Address": "32 MLK Blvd, Newark, NJ",
"Category": "Security Services",
"Status": "Active",
"Region": "NJ",
"Date Active": "01 Oct, 2018 06:01:27",
"Classsification": "Small Business",
"Minority_owned": "No",
"Woman_owned": "Yes",
"Small_business": "No",
"Veteran_owned": "No",
"Service_disabled_owned": "Yes"
},
{
"Vendor ID": 1012,
"Vendor Name": "Food Express",
"Address": "32 MLK Blvd, Newark, NJ",
"Category": "Security Services",
"Status": "Active",
"Region": "NJ",
"Date Active": "01 Oct, 2018 06:01:27",
"Classsification": "Diverse Business",
"Minority_owned": "Yes",
"Woman_owned": "No",
"Small_business": "Yes",
"Veteran_owned": "Yes",
"Service_disabled_owned": "No"
},
{
"Vendor ID": 1035,
"Vendor Name": "Dc Sports",
"Address": "",
"Category": "",
"Status": "",
"Region": "",
"Date Active": "",
"Classsification": "",
"Minority_owned": "Yes",
"Woman_owned": "No",
"Small_business": "Yes",
"Veteran_owned": "Yes",
"Service_disabled_owned": "No"
},
{
"Vendor ID": 1234,
"Vendor Name": "K.F.W. Berlin",
"Address": "",
"Category": "",
"Status": "",
"Region": "",
"Date Active": "",
"Classsification": "",
"Minority_owned": "No",
"Woman_owned": "No",
"Small_business": "Yes",
"Veteran_owned": "Yes",
"Service_disabled_owned": "No"
},
{
"Vendor ID": 3018,
"Vendor Name": "Fremont Supplies",
"Address": "",
"Category": "",
"Status": "",
"Region": "",
"Date Active": "",
"Classsification": "",
"Minority_owned": "No",
"Woman_owned": "No",
"Small_business": "No",
"Veteran_owned": "No",
"Service_disabled_owned": "No"
},
{
"Vendor ID": 9500,
"Vendor Name": "Mohanty Gargiulo LLC",
"Address": "230 Park Ave 3rd Floor",
"Category": "Financial Consultant",
"Status": "Active",
"Region": "NY",
"Date Active": "",
"Classsification": "Small Business",
"Minority_owned": "Yes",
"Woman_owned": "No",
"Small_business": "No",
"Veteran_owned": "No",
"Service_disabled_owned": "Yes"
},
{
"Vendor ID": 9501,
"Vendor Name": "PFM Swap Advisors LLC",
"Address": "1735 Market Street, 43 Fl., Philadelphia, PA 19103",
"Category": "Financial Consultant",
"Status": "Active",
"Region": "PA",
"Date Active": "",
"Classsification": "Veteran Owned Business",
"Minority_owned": "No",
"Woman_owned": "No",
"Small_business": "No",
"Veteran_owned": "No",
"Service_disabled_owned": "No"
},
{
"Vendor ID": 9502,
"Vendor Name": "Microdesk Inc",
"Address": "",
"Category": "Information Technology",
"Status": "",
"Region": "CA",
"Date Active": "",
"Classsification": "Small Business",
"Minority_owned": "Yes",
"Woman_owned": "No",
"Small_business": "No",
"Veteran_owned": "No",
"Service_disabled_owned": "No"
},
{
"Vendor ID": 9503,
"Vendor Name": "Stantec Consulting Services Inc",
"Address": "Stantec ResourceNet India Pvt Ltd, Sphurti Society, Wakadewadi, Shivajinagar",
"Category": "Security Services",
"Status": "Active",
"Region": "IN",
"Date Active": "",
"Classsification": "Small Business",
"Minority_owned": "No",
"Woman_owned": "Yes",
"Small_business": "No",
"Veteran_owned": "Yes",
"Service_disabled_owned": "No"
},
{
"Vendor ID": 9504,
"Vendor Name": "WSP USA Inc",
"Address": "",
"Category": "Security Services",
"Status": "Active",
"Region": "NY",
"Date Active": "",
"Classsification": "Small Business",
"Minority_owned": "No",
"Woman_owned": "Yes",
"Small_business": "Yes",
"Veteran_owned": "No",
"Service_disabled_owned": "No"
}
]


(Robert Monfera) #2

Hi Sunil,

for the representative structure, please export a dashboard first; search for "Restoring a dashboard is done by dropping the exported JSON into the dialog." on this page.

Please note that while we try not to change the structure too much, for the time being the structure is not guaranteed to hold stable over time.


(Sunil Edupuganti) #3

Hi Monfera,
When i am trying to import the DashBoards JSON, at that time also i am facing the same issue.

[
{
"_id": "AWc_9OhxNzZ9T6yNkfkD",
"_type": "dashboard",
"source": {
"title": "Tickets DashBoard",
"hits": 0,
"description": "",
"panelsJSON": "[{"size_x":6,"size_y":5,"panelIndex":1,"type":"visualization","id":"AWc_2xSNNzZ9T6yNkfj-","col":1,"row":1},{"size_x":6,"size_y":6,"panelIndex":2,"type":"visualization","id":"AWc2XWHLNzZ9T6yNkfjv","col":7,"row":1},{"size_x":6,"size_y":5,"panelIndex":3,"type":"visualization","id":"AWc_3ohaNzZ9T6yNkfj
","col":1,"row":6},{"size_x":6,"size_y":5,"panelIndex":4,"type":"visualization","id":"AWc_4Iz5NzZ9T6yNkfkA","col":7,"row":7},{"size_x":6,"size_y":6,"panelIndex":5,"type":"visualization","id":"AWc_407FNzZ9T6yNkfkB","col":1,"row":11}]",
"optionsJSON": "{"darkTheme":false}",
"uiStateJSON": "{}",
"version": 1,
"timeRestore": true,
"timeTo": "now",
"timeFrom": "now-15m",
"refreshInterval": {
"display": "Off",
"pause": false,
"value": 0
},
"kibanaSavedObjectMeta": {
"searchSourceJSON": "{"filter":[{"query":{"match_all":{}}}],"highlightAll":true,"version":true}"
}
}
},
{
"_id": "AWdAQ10wNzZ9T6yNkfkL",
"_type": "dashboard",
"_source": {
"title": "Compliance DashBoard",
"hits": 0,
"description": "",
"panelsJSON": "[{"size_x":6,"size_y":3,"panelIndex":1,"type":"visualization","id":"AWc2IUW9NzZ9T6yNkfjl","col":1,"row":1},{"size_x":6,"size_y":6,"panelIndex":2,"type":"visualization","id":"AWdALYU6NzZ9T6yNkfkF","col":7,"row":1},{"size_x":6,"size_y":5,"panelIndex":3,"type":"visualization","id":"AWdAOTMuNzZ9T6yNkfkH","col":1,"row":4},{"size_x":6,"size_y":5,"panelIndex":4,"type":"visualization","id":"AWdAP7KnNzZ9T6yNkfkJ","col":7,"row":7},{"size_x":6,"size_y":3,"panelIndex":5,"type":"visualization","id":"AWdAQQFINzZ9T6yNkfkK","col":1,"row":9}]",
"optionsJSON": "{"darkTheme":true}",
"uiStateJSON": "{"P-5":{"vis":{"colors":{"Audit report":"#3F6833"}}},"P-3":{"vis":{"colors":{"Diverse Business Certification":"#E0F9D7","Audit report":"#E5AC0E"}}},"P-4":{"vis":{"colors":{"ABC - Audit report.pdf":"#6D1F62","ABC - Diverse busines cert.pdf":"#64B0C8"}}},"P-2":{"vis":{"colors":{"Diverse Business Certification":"#F2C96D","Audit report":"#99440A"}}},"P-1":{"vis":{"colors":{"Small Business":"#E0F9D7","":"#EA6460","Veteran Owner":"#2F575E"}}}}",
"version": 1,
"timeRestore": false,
"kibanaSavedObjectMeta": {
"searchSourceJSON": "{"filter":[{"query":{"match_all":{}}}],"highlightAll":true,"version":true}"
}
}
},
{
"_id": "AWdAk1IWNzZ9T6yNkfkR",
"_type": "dashboard",
"_source": {
"title": "RFx DashBoard",
"hits": 0,
"description": "",
"panelsJSON": "[{"size_x":6,"size_y":3,"panelIndex":1,"type":"visualization","id":"AWdAhrgyNzZ9T6yNkfkN","col":1,"row":1},{"size_x":6,"size_y":3,"panelIndex":2,"type":"visualization","id":"AWdAiaI7NzZ9T6yNkfkO","col":7,"row":1},{"size_x":6,"size_y":5,"panelIndex":3,"type":"visualization","id":"AWdAkinxNzZ9T6yNkfkQ","col":1,"row":4}]",
"optionsJSON": "{"darkTheme":false}",
"uiStateJSON": "{}",
"version": 1,
"timeRestore": false,
"kibanaSavedObjectMeta": {
"searchSourceJSON": "{"filter":[{"query":{"match_all":{}}}],"highlightAll":true,"version":true}"
}
}
},
{
"_id": "AWc2nMKlNzZ9T6yNkfj7",
"_type": "dashboard",
"_source": {
"title": "Vendor DashBoard",
"hits": 0,
"description": "",
"panelsJSON": "[{"col":1,"id":"AWc2Mh0cNzZ9T6yNkfjq","panelIndex":1,"row":1,"size_x":3,"size_y":3,"type":"visualization"},{"col":10,"id":"AWc2XWHLNzZ9T6yNkfjv","panelIndex":2,"row":1,"size_x":3,"size_y":3,"type":"visualization"},{"col":7,"id":"AWcxv0myNzZ9T6yNkfjh","panelIndex":3,"row":1,"size_x":3,"size_y":3,"type":"visualization"},{"col":4,"id":"AWc2IUW9NzZ9T6yNkfjl","panelIndex":4,"row":4,"size_x":3,"size_y":3,"type":"visualization"},{"col":1,"id":"AWc2inhONzZ9T6yNkfj5","panelIndex":5,"row":4,"size_x":3,"size_y":3,"type":"visualization"},{"size_x":3,"size_y":3,"panelIndex":6,"type":"visualization","id":"AWc_1gr6NzZ9T6yNkfj9","col":4,"row":1}]",
"optionsJSON": "{"darkTheme":false}",
"uiStateJSON": "{"P-1":{"vis":{"params":{"sort":{"columnIndex":null,"direction":null}}}},"P-4":{"spy":{"mode":{"fill":false,"name":null}}}}",
"version": 1,
"timeRestore": false,
"kibanaSavedObjectMeta": {
"searchSourceJSON": "{"filter":[{"query":{"match_all":{}}}],"highlightAll":true,"version":true}"
}
}
}
]