PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV 2024 → Import a nested JSON File to HFSQL analysis, select one record and redistribute it as JSON file
Import a nested JSON File to HFSQL analysis, select one record and redistribute it as JSON file
Started by danilue, Jun., 12 2019 10:51 AM - No answer
Registered member
1 message
Posted on June, 12 2019 - 10:51 AM
Dear Community
I am programming in WINDEV24 a Portal Application to administrate different projects for my customers. My customers are Consultants with their own projects. They manage their projects with a web app which writes the project data as a nested JSON File.
My intention is it to import this nested JSON File with all Project-Data in my HFSQL Database as analysis. Here I want to give every Consultant the possibility to select one single project and export it as a JSON File to the WebApp to continue working on it there.
As first step I am looking for an answer how to get the JSON-Data to my analysis and make them relational.
I was able to integrate the JSON File as an “external description” but I found no further possibilities to access the data directly from the code. I do not understand what’s the benefit of seeing this external description.
Second try was the “HImportJSON Function” – this works with a flat JSON File but I did not find out how to handle a nested one…
I think, that I have to create an analysis in the HFSQL DB for each level of the JSON structure
But how do I set the relations while importing the data?
I would be grateful for any help.
Thanks a lot
danilue

Here the view of "external description"





Here one example of one project-data-record from the JSON File
{
  "id": 13,
  "mandant": "Bluetools Solutions GmbH",
  "name": "Bluetools Solutions GmbH 2019 Strategy",
  "owner": "Florian Wieser",
  "description": "20190214 - Strategy Workshop for Bluetools Solutions GmbH ",
  "start": "2019-02-14",
  "end": "2019-02-15",
  "mainProblem": "How should Bluetools Solutions GmbH direct its activities in 2019 to be most effective?",
  "criticalEvents": [
    {
      "id": 0,
      "name": "Empty Event",
      "author": "Empty Author",
      "description": " Empty Description"
    },
    {
      "id": 1,
      "name": "new event",
      "author": "",
      "description": ""
    }
  ],
  "tensions": [
    {
      "id": 0,
      "defName": "Resources",
      "name": "How does Bluetools retrieve its resources?",
      "extName": "self-created",
      "intName": "obtained at Market",
      "subtensions": [
        {
          "yesterday": 6,
          "today": 12,
          "tomorrow": 50,
          "id": 0,
          "extName": "internal finan. inv.",
          "intName": "external finan. inv."
        },
        {
          "yesterday": 9,
          "today": 70,
          "tomorrow": 28,
          "id": 1,
          "extName": "internal knowledge",
          "intName": "external knowledge"
        },
        {
          "yesterday": 9,
          "today": 23,
          "tomorrow": 60,
          "id": 2,
          "extName": "philosophy-driven HR",
          "intName": "market-driven HR"
        },
        {
          "yesterday": 6,
          "today": 13,
          "tomorrow": 50,
          "id": 3,
          "extName": "social capital",
          "intName": "strategic partnersh."
        },
        {
          "yesterday": 5,
          "today": 22,
          "tomorrow": 75,
          "id": 4,
          "extName": "informal structures",
          "intName": "corporate structures"
        }
      ],
      "trends": [
        {
          "direction": 0,
          "knowledge": 2,
          "kind": 0,
          "id": 1,
          "name": "social: Trend to self-advice"
        },
        {
          "direction": 1,
          "knowledge": 3,
          "kind": 0,
          "id": 2,
          "name": "rise of impact investment"
        },
        {
          "direction": 1,
          "knowledge": 2,
          "kind": 0,
          "id": 3,
          "name": "increase of sense-workers"
        },
        {
          "direction": 1,
          "knowledge": 1,
          "kind": 0,
          "id": 4,
          "name": "increase in org. hybrid-think."
        },
        {
          "direction": 0,
          "knowledge": 1,
          "kind": 0,
          "id": 5,
          "name": "rising critique of angel inv."
        },
        {
          "direction": 0,
          "knowledge": 1,
          "kind": 0,
          "id": 6,
          "name": "social: DIY-movement"
        }
      ],
      "groupTrends": [
        {
          "trends": [
            {
              "direction": 0,
              "knowledge": 2,
              "kind": 0,
              "id": 1,
              "name": "social: Trend to self-advice"
            },
            {
              "direction": 1,
              "knowledge": 3,
              "kind": 0,
              "id": 2,
              "name": "rise of impact investment"
            },
            {
              "direction": 1,
              "knowledge": 2,
              "kind": 0,
              "id": 3,
              "name": "increase of sense-workers"
            },
            {
              "direction": 1,
              "knowledge": 1,
              "kind": 0,
              "id": 4,
              "name": "increase in org. hybrid-think."
            },
            {
              "direction": 0,
              "knowledge": 1,
              "kind": 0,
              "id": 5,
              "name": "rising critique of angel inv."
            },
            {
              "direction": 0,
              "knowledge": 1,
              "kind": 0,
              "id": 6,
              "name": "social: DIY-movement"
            }
          ],
          "id": -1,
          "name": "Ungrouped Trends"
        }
      ],
      "initiatives": [
        {
          "direction": 0,
          "knowledge": 3,
          "impact": 3,
          "progress": 54,
          "risk": 2,
          "disabled": false,
          "kind": 1,
          "id": 1,
          "name": "VIVA offices"
        },
        {
          "direction": 0,
          "knowledge": 4,
          "impact": 4,
          "progress": 72,
          "risk": 2,
          "disabled": false,
          "kind": 1,
          "id": 2,
          "name": "Financial investment Dani"
        },
        {
          "direction": 0,
          "knowledge": 4,
          "impact": 4,
          "progress": 50,
          "risk": 2,
          "disabled": false,
          "kind": 1,
          "id": 3,
          "name": "Knowledge-Investment"
        },
        {
          "direction": 0,
          "knowledge": 4,
          "impact": 4,
          "progress": 86,
          "risk": 2,
          "disabled": false,
          "kind": 1,
          "id": 4,
          "name": "Financial investment Urs"
        },
        {
          "direction": 0,
          "knowledge": 4,
          "impact": 4,
          "progress": 28,
          "risk": 2,
          "disabled": false,
          "kind": 1,
          "id": 5,
          "name": "Time investments"
        },
        {
          "direction": 1,
          "knowledge": 2,
          "impact": 4,
          "progress": 15,
          "risk": 1,
          "disabled": false,
          "kind": 1,
          "id": 6,
          "name": "Active search for leads"
        },
        {
          "direction": 1,
          "knowledge": 3,
          "impact": 4,
          "progress": 48,
          "risk": 2,
          "disabled": false,
          "kind": 1,
          "id": 7,
          "name": "Access to SIM"
        }
      ],
      "initiativeTrends": [
        {
          "idInitiative": 1,
          "idTrend": 3,
          "influence": 3
        },
        {
          "idInitiative": 1,
          "idTrend": 4,
          "influence": 4
        },
        {
          "idInitiative": 2,
          "idTrend": 2,
          "influence": 2
        },
        {
          "idInitiative": 2,
          "idTrend": 3,
          "influence": 4
        },
        {
          "idInitiative": 2,
          "idTrend": 4,
          "influence": 4
        },
        {
          "idInitiative": 2,
          "idTrend": 5,
          "influence": 3
        },
        {
          "idInitiative": 3,
          "idTrend": 1,
          "influence": 4
        },
        {
          "idInitiative": 3,
          "idTrend": 2,
          "influence": 4
        },
        {
          "idInitiative": 3,
          "idTrend": 3,
          "influence": 5
        },
        {
          "idInitiative": 3,
          "idTrend": 4,
          "influence": 5
        },
        {
          "idInitiative": 3,
          "idTrend": 5,
          "influence": 3
        },
        {
          "idInitiative": 3,
          "idTrend": 6,
          "influence": 4
        },
        {
          "idInitiative": 4,
          "idTrend": 1,
          "influence": 4
        },
        {
          "idInitiative": 4,
          "idTrend": 2,
          "influence": 4
        },
        {
          "idInitiative": 4,
          "idTrend": 3,
          "influence": 5
        },
        {
          "idInitiative": 4,
          "idTrend": 4,
          "influence": 4
        },
        {
          "idInitiative": 4,
          "idTrend": 5,
          "influence": 4
        },
        {
          "idInitiative": 4,
          "idTrend": 6,
          "influence": 3
        },
        {
          "idInitiative": 5,
          "idTrend": 1,
          "influence": 5
        },
        {
          "idInitiative": 5,
          "idTrend": 2,
          "influence": 4
        },
        {
          "idInitiative": 5,
          "idTrend": 3,
          "influence": 5
        },
        {
          "idInitiative": 5,
          "idTrend": 4,
          "influence": 5
        },
        {
          "idInitiative": 5,
          "idTrend": 6,
          "influence": 5
        },
        {
          "idInitiative": 6,
          "idTrend": 3,
          "influence": 3
        },
        {
          "idInitiative": 6,
          "idTrend": 4,
          "influence": 4
        },
        {
          "idInitiative": 6,
          "idTrend": 6,
          "influence": 4
        },
        {
          "idInitiative": 7,
          "idTrend": 1,
          "influence": 2
        },
        {
          "idInitiative": 7,
          "idTrend": 3,
          "influence": 4
        },
        {
          "idInitiative": 7,
          "idTrend": 4,
          "influence": 3
        },
        {
          "idInitiative": 7,
          "idTrend": 6,
          "influence": 3
        }
      ],
      "yesterday": 7,
      "today": 28,
      "tomorrow": 52.6
    },
    {
      "id": 1,
      "defName": "Value Creation",
      "name": "What is the value that Bluetools creates?",
      "extName": "socially beneficial",
      "intName": "economically profit- oriented",
      "subtensions": [
        {
          "yesterday": 12,
          "today": 32,
          "tomorrow": 54,
          "id": 0,
          "extName": "idea",
          "intName": "concrete"
        },
        {
          "yesterday": 13,
          "today": 59,
          "tomorrow": 62,
          "id": 1,
          "extName": "gift to society",
          "intName": "business"
        },
        {
          "yesterday": 16,
          "today": 50,
          "tomorrow": 75,
          "id": 2,
          "extName": "single solution",
          "intName": "systemic solution"
        },
        {
          "yesterday": 25,
          "today": 50,
          "tomorrow": 75,
          "id": 3,
          "extName": "front-end",
          "intName": "back-end"
        }
      ],
      "trends": [
        {
          "direction": 1,
          "knowledge": 2,
          "kind": 0,
          "id": 1,
          "name": "LA: Trend for boutique-consul."
        },
        {
          "direction": 0,
          "knowledge": 3,
          "kind": 0,
          "id": 2,
          "name": "Social: Social Focus"
        },
        {
          "direction": 1,
          "knowledge": 3,
          "kind": 0,
          "id": 3,
          "name": "Sustainability Business-Inte. "
        },
        {
          "direction": 1,
          "knowledge": 2,
          "kind": 0,
          "id": 4,
          "name": "Online-Education"
        },
        {
          "direction": 0,
          "knowledge": 2,
          "kind": 0,
          "id": 5,
          "name": "Social: Open-mindedness"
        },
        {
          "direction": 1,
          "knowledge": 0,
          "kind": 0,
          "id": 6,
          "name": "Strat.-Cons.: Standard Soluti."
        },
        {
          "direction": 1,
          "knowledge": 4,
          "kind": 0,
          "id": 7,
          "name": "Create Internet Infrastru."
        },
        {
          "direction": 1,
          "knowledge": 2,
          "kind": 0,
          "id": 8,
          "name": "Decentralization of organis."
        },
        {
          "direction": 1,
          "knowledge": 0,
          "kind": 0,
          "id": 9,
          "name": "Competi. based on business mo."
        },
        {
          "direction": 0,
          "knowledge": 2,
          "kind": 0,
          "id": 10,
          "name": "Internet access as human right"
        },
        {
          "direction": 0,
          "knowledge": 3,
          "kind": 0,
          "id": 11,
          "name": "Social org. more strategic"
        },
        {
          "direction": 0,
          "knowledge": 0,
          "kind": 0,
          "id": 12,
          "name": "TrendV12"
        }
      ],
      "groupTrends": [
        {
          "trends": [
            {
              "direction": 1,
              "knowledge": 2,
              "kind": 0,
              "id": 1,
              "name": "LA: Trend for boutique-consul."
            },
            {
              "direction": 0,
              "knowledge": 3,
              "kind": 0,
              "id": 2,
              "name": "Social: Social Focus"
            },
            {
              "direction": 1,
              "knowledge": 0,
              "kind": 0,
              "id": 6,
              "name": "Strat.-Cons.: Standard Soluti."
            },
            {
              "direction": 1,
              "knowledge": 2,
              "kind": 0,
              "id": 8,
              "name": "Decentralization of organis."
            },
            {
              "direction": 1,
              "knowledge": 0,
              "kind": 0,
              "id": 9,
              "name": "Competi. based on business mo."
            },
            {
              "direction": 0,
              "knowledge": 3,
              "kind": 0,
              "id": 11,
              "name": "Social org. more strategic"
            },
            {
              "direction": 1,
              "knowledge": 3,
              "kind": 0,
              "id": 3,
              "name": "Sustainability Business-Inte. "
            },
            {
              "direction": 0,
              "knowledge": 0,
              "kind": 0,
              "id": 12,
              "name": "TrendV12"
            }
          ],
          "id": -1,
          "name": "Ungrouped Trends"
        },
        {
          "trends": [
            {
              "direction": 1,
              "knowledge": 4,
              "kind": 0,
              "id": 7,
              "name": "Create Internet Infrastru."
            },
            {
              "direction": 0,
              "knowledge": 2,
              "kind": 0,
              "id": 10,
              "name": "Internet access as human right"
            },
            {
              "direction": 0,
              "knowledge": 2,
              "kind": 0,
              "id": 5,
              "name": "Social: Open-mindedness"
            },
            {
              "direction": 1,
              "knowledge": 2,
              "kind": 0,
              "id": 4,
              "name": "Online-Education"
            }
          ],
          "id": 1,
          "name": "Internet infrastructure"
        }
      ],
      "initiatives": [
        {
          "direction": 1,
          "knowledge": 3,
          "impact": 4,
          "progress": 31,
          "risk": 1,
          "disabled": false,
          "kind": 1,
          "id": 1,
          "name": "Dani sales Switzerland"
        },
        {
          "direction": 1,
          "knowledge": 3,
          "impact": 2,
          "progress": 58,
          "risk": 2,
          "disabled": false,
          "kind": 1,
          "id": 2,
          "name": "Sales-Presentation & Website"
        },
        {
          "direction": 1,
          "knowledge": 1,
          "impact": 3,
          "progress": 41,
          "risk": 1,
          "disabled": false,
          "kind": 1,
          "id": 3,
          "name": "Fundes Joint Venture"
        },
        {
          "direction": 1,
          "knowledge": 3,
          "impact": 4,
          "progress": 34,
          "risk": 1,
          "disabled": false,
          "kind": 1,
          "id": 4,
          "name": "Licensing Solution Development"
        },
        {
          "direction": 1,
          "knowledge": 1,
          "impact": 1,
          "progress": 19,
          "risk": 0,
          "disabled": false,
          "kind": 1,
          "id": 5,
          "name": "Executive education INCAE"
        },
        {
          "direction": 1,
          "knowledge": 2,
          "impact": 3,
          "progress": 29,
          "risk": 1,
          "disabled": false,
          "kind": 1,
          "id": 6,
          "name": "Back-end solution"
        },
        {
          "direction": 0,
          "knowledge": 1,
          "impact": 1,
          "progress": 48,
          "risk": 1,
          "disabled": true,
          "kind": 1,
          "id": 7,
          "name": "VIVA Idea Licensing"
        }
      ],
      "initiativeTrends": [
        {
          "idInitiative": 1,
          "idTrend": 1,
          "influence": 4
        },
        {
          "idInitiative": 1,
          "idTrend": 6,
          "influence": 4
        },
        {
          "idInitiative": 1,
          "idTrend": 9,
          "influence": 2
        },
        {
          "idInitiative": 1,
          "idTrend": 4,
          "influence": 2
        },
        {
          "idInitiative": 2,
          "idTrend": 6,
          "influence": 5
        },
        {
          "idInitiative": 2,
          "idTrend": 8,
          "influence": 3
        },
        {
          "idInitiative": 2,
          "idTrend": 9,
          "influence": 2
        },
        {
          "idInitiative": 2,
          "idTrend": 11,
          "influence": 5
        },
        {
          "idInitiative": 2,
          "idTrend": 4,
          "influence": 4
        },
        {
          "idInitiative": 3,
          "idTrend": 1,
          "influence": 5
        },
        {
          "idInitiative": 3,
          "idTrend": 6,
          "influence": 5
        },
        {
          "idInitiative": 3,
          "idTrend": 8,
          "influence": 5
        },
        {
          "idInitiative": 3,
          "idTrend": 11,
          "influence": 5
        },
        {
          "idInitiative": 3,
          "idTrend": 3,
          "influence": 5
        },
        {
          "idInitiative": 3,
          "idTrend": 4,
          "influence": 5
        },
        {
          "idInitiative": 4,
          "idTrend": 1,
          "influence": 5
        },
        {
          "idInitiative": 4,
          "idTrend": 6,
          "influence": 5
        },
        {
          "idInitiative": 4,
          "idTrend": 8,
          "influence": 3
        },
        {
          "idInitiative": 4,
          "idTrend": 9,
          "influence": 5
        },
        {
          "idInitiative": 4,
          "idTrend": 11,
          "influence": 4
        },
        {
          "idInitiative": 4,
          "idTrend": 3,
          "influence": 3
        },
        {
          "idInitiative": 4,
          "idTrend": 7,
          "influence": 5
        },
        {
          "idInitiative": 4,
          "idTrend": 4,
          "influence": 4
        },
        {
          "idInitiative": 5,
          "idTrend": 1,
          "influence": 3
        },
        {
          "idInitiative": 5,
          "idTrend": 6,
          "influence": 4
        },
        {
          "idInitiative": 5,
          "idTrend": 9,
          "influence": 2
        },
        {
          "idInitiative": 5,
          "idTrend": 11,
          "influence": 5
        },
        {
          "idInitiative": 5,
          "idTrend": 3,
          "influence": 5
        },
        {
          "idInitiative": 5,
          "idTrend": 7,
          "influence": 2
        },
        {
          "idInitiative": 5,
          "idTrend": 4,
          "influence": 5
        },
        {
          "idInitiative": 6,
          "idTrend": 1,
          "influence": 4
        },
        {
          "idInitiative": 6,
          "idTrend": 2,
          "influence": 2
        },
        {
          "idInitiative": 6,
          "idTrend": 6,
          "influence": 5
        },
        {
          "idInitiative": 6,
          "idTrend": 8,
          "influence": 5
        },
        {
          "idInitiative": 6,
          "idTrend": 9,
          "influence": 4
        },
        {
          "idInitiative": 6,
          "idTrend": 11,
          "influence": 5
        },
        {
          "idInitiative": 6,
          "idTrend": 3,
          "influence": 5
        },
        {
          "idInitiative": 6,
          "idTrend": 7,
          "influence": 5
        },
        {
          "idInitiative": 6,
          "idTrend": 10,
          "influence": 5
        },
        {
          "idInitiative": 6,
          "idTrend": 5,
          "influence": 2
        },
        {
          "idInitiative": 6,
          "idTrend": 4,
          "influence": 5
        },
        {
          "idInitiative": 7,
          "idTrend": 1,
          "influence": 5
        },
        {
          "idInitiative": 7,
          "idTrend": 2,
          "influence": 2
        },
        {
          "idInitiative": 7,
          "idTrend": 6,
          "influence": 5
        },
        {
          "idInitiative": 7,
          "idTrend": 8,
          "influence": 5
        },
        {
          "idInitiative": 7,
          "idTrend": 11,
          "influence": 5
        },
        {
          "idInitiative": 7,
          "idTrend": 3,
          "influence": 5
        },
        {
          "idInitiative": 7,
          "idTrend": 7,
          "influence": 5
        },
        {
          "idInitiative": 7,
          "idTrend": 4,
          "influence": 5
        }
      ],
      "yesterday": 16.5,
      "today": 47.75,
      "tomorrow": 66.5,
      "ScrollElementId": -1
    },
    {
      "id": 2,
      "defName": "Self-Leadership",
      "name": "What is the motivation to be part of Bluetools?",
      "extName": "indep. \nentrepre.",
      "intName": "security",
      "subtensions": [
        {
          "yesterday": 70,
          "today": 43,
          "tomorrow": 19,
          "id": 0,
          "extName": "FW: fulfilment",
          "intName": "FW: given tasks"
        },
        {
          "yesterday": 49,
          "today": 27,
          "tomorrow": 19,
          "id": 1,
          "extName": "JV: fulfilment",
          "intName": "JV: given tasks"
        },
        {
          "yesterday": 10,
          "today": 39,
          "tomorrow": 75,
          "id": 2,
          "extName": "DL: fulfilment",
          "intName": "DL: given tasks"
        },
        {
          "yesterday": 96,
          "today": 50,
          "tomorrow": 25,
          "id": 3,
          "extName": "UJ: fulfilment",
          "intName": "UJ: given tasks"
        }
      ],
      "trends": [
        {
          "direction": 1,
          "knowledge": 2,
          "kind": 0,
          "id": 1,
          "name": "Social: Request of standardiz."
        },
        {
          "direction": 0,
          "knowledge": 2,
          "kind": 0,
          "id": 2,
          "name": "Social: Gig-Economy"
        },
        {
          "direction": 0,
          "knowledge": 2,
          "kind": 0,
          "id": 3,
          "name": "Millenials need for self-fulf."
        },
        {
          "direction": 1,
          "knowledge": 3,
          "kind": 0,
          "id": 4,
          "name": "Need for basic security"
        },
        {
          "direction": 0,
          "knowledge": 2,
          "kind": 0,
          "id": 5,
          "name": "Rising critic on current secu."
        }
      ],
      "groupTrends": [
        {
          "trends": [
            {
              "direction": 1,
              "knowledge": 2,
              "kind": 0,
              "id": 1,
              "name": "Social: Request of standardiz."
            },
            {
              "direction": 0,
              "knowledge": 2,
              "kind": 0,
              "id": 2,
              "name": "Social: Gig-Economy"
            },
            {
              "direction": 0,
              "knowledge": 2,
              "kind": 0,
              "id": 3,
              "name": "Millenials need for self-fulf."
            },
            {
              "direction": 1,
              "knowledge": 3,
              "kind": 0,
              "id": 4,
              "name": "Need for basic security"
            },
            {
              "direction": 0,
              "knowledge": 2,
              "kind": 0,
              "id": 5,
              "name": "Rising critic on current secu."
            }
          ],
          "id": -1,
          "name": "Ungrouped Trends"
        },
        {
          "trends": [],
          "id": 1,
          "name": "Pura Vida"
        }
      ],
      "initiatives": [
        {
          "direction": 1,
          "knowledge": 4,
          "impact": 2,
          "progress": 47,
          "risk": 2,
          "disabled": false,
          "kind": 1,
          "id": 1,
          "name": "Accounting by Dani"
        },
        {
          "direction": 1,
          "knowledge": 3,
          "impact": 3,
          "progress": 56,
          "risk": 1,
          "disabled": false,
          "kind": 1,
          "id": 2,
          "name": "Salary to Florian"
        },
        {
          "direction": 1,
          "knowledge": 3,
          "impact": 4,
          "progress": 31,
          "risk": 1,
          "disabled": false,
          "kind": 1,
          "id": 3,
          "name": "Process of implementation"
        },
        {
          "direction": 0,
          "knowledge": 1,
          "impact": 3,
          "progress": 6,
          "risk": 0,
          "disabled": false,
          "kind": 1,
          "id": 4,
          "name": "Book on Bluetools"
        },
        {
          "direction": 1,
          "knowledge": 4,
          "impact": 4,
          "progress": 100,
          "risk": 2,
          "disabled": false,
          "kind": 1,
          "id": 5,
          "name": "Team"
        }
      ],
      "initiativeTrends": [
        {
          "idInitiative": 1,
          "idTrend": 1,
          "influence": 5
        },
        {
          "idInitiative": 1,
          "idTrend": 3,
          "influence": 3
        },
        {
          "idInitiative": 1,
          "idTrend": 4,
          "influence": 5
        },
        {
          "idInitiative": 2,
          "idTrend": 2,
          "influence": 2
        },
        {
          "idInitiative": 2,
          "idTrend": 3,
          "influence": 5
        },
        {
          "idInitiative": 2,
          "idTrend": 4,
          "influence": 5
        },
        {
          "idInitiative": 2,
          "idTrend": 5,
          "influence": 2
        },
        {
          "idInitiative": 3,
          "idTrend": 1,
          "influence": 4
        },
        {
          "idInitiative": 3,
          "idTrend": 2,
          "influence": 1
        },
        {
          "idInitiative": 3,
          "idTrend": 3,
          "influence": 2
        },
        {
          "idInitiative": 3,
          "idTrend": 4,
          "influence": 3
        },
        {
          "idInitiative": 4,
          "idTrend": 1,
          "influence": 4
        },
        {
          "idInitiative": 4,
          "idTrend": 5,
          "influence": 5
        },
        {
          "idInitiative": 5,
          "idTrend": 1,
          "influence": 3
        },
        {
          "idInitiative": 5,
          "idTrend": 3,
          "influence": 2
        },
        {
          "idInitiative": 5,
          "idTrend": 4,
          "influence": 3
        }
      ],
      "yesterday": 56.25,
      "today": 39.75,
      "tomorrow": 34.5
    },
    {
      "id": 3,
      "defName": "Leadership",
      "name": "How does leadership within Bluetools take place ?",
      "extName": "collective",
      "intName": "directive",
      "subtensions": [
        {
          "yesterday": 25,
          "today": 59,
          "tomorrow": 50,
          "id": 0,
          "extName": "knowledge-driven",
          "intName": "market-driven"
        },
        {
          "yesterday": 25,
          "today": 75,
          "tomorrow": 53,
          "id": 1,
          "extName": "philosophy",
          "intName": "tool"
        },
        {
          "yesterday": 87,
          "today": 22,
          "tomorrow": 73,
          "id": 2,
          "extName": "Partner-Model",
          "intName": "Role-Model"
        },
        {
          "yesterday": 75,
          "today": 20,
          "tomorrow": 94,
          "id": 3,
          "extName": "creative",
          "intName": "result-driven"
        }
      ],
      "trends": [
        {
          "direction": 0,
          "knowledge": 3,
          "kind": 0,
          "id": 1,
          "name": "Mindfulness of employees"
        },
        {
          "direction": 0,
          "knowledge": 2,
          "kind": 0,
          "id": 2,
          "name": "Participatory processes"
        },
        {
          "direction": 0,
          "knowledge": 1,
          "kind": 0,
          "id": 3,
          "name": "Decentralized work structures"
        },
        {
          "direction": 1,
          "knowledge": 3,
          "kind": 0,
          "id": 4,
          "name": "Request for given tasks"
        },
        {
          "direction": 1,
          "knowledge": 3,
          "kind": 0,
          "id": 5,
          "name": "Revival of the family business"
        },
        {
          "direction": 1,
          "knowledge": 3,
          "kind": 0,
          "id": 6,
          "name": "TrendL6"
        },
        {
          "direction": 1,
          "knowledge": 3,
          "kind": 0,
          "id": 7,
          "name": "TrendL7"
        }
      ],
      "groupTrends": [
        {
          "trends": [
            {
              "direction": 0,
              "knowledge": 3,
              "kind": 0,
              "id": 1,
              "name": "Mindfulness of employees"
            },
            {
              "direction": 0,
              "knowledge": 2,
              "kind": 0,
              "id": 2,
              "name": "Participatory processes"
            },
            {
              "direction": 0,
              "knowledge": 1,
              "kind": 0,
              "id": 3,
              "name": "Decentralized work structures"
            },
            {
              "direction": 1,
              "knowledge": 3,
              "kind": 0,
              "id": 5,
              "name": "Revival of the family business"
            },
            {
              "direction": 1,
              "knowledge": 3,
              "kind": 0,
              "id": 6,
              "name": "TrendL6"
            },
            {
              "direction": 1,
              "knowledge": 3,
              "kind": 0,
              "id": 7,
              "name": "TrendL7"
            }
          ],
          "id": -1,
          "name": "Ungrouped Trends"
        },
        {
          "trends": [
            {
              "direction": 1,
              "knowledge": 3,
              "kind": 0,
              "id": 4,
              "name": "Request for given tasks"
            }
          ],
          "id": 1,
          "name": "Hierarchy"
        }
      ],
      "initiatives": [
        {
          "direction": 1,
          "knowledge": 3,
          "impact": 4,
          "progress": 46,
          "risk": 2,
          "disabled": false,
          "kind": 1,
          "id": 1,
          "name": "Administration infrastructure"
        },
        {
          "direction": 1,
          "knowledge": 4,
          "impact": 4,
          "progress": 100,
          "risk": 2,
          "disabled": false,
          "kind": 1,
          "id": 2,
          "name": "Formalizing of Bluetools"
        },
        {
          "direction": 1,
          "knowledge": 3,
          "impact": 3,
          "progress": 51,
          "risk": 1,
          "disabled": false,
          "kind": 1,
          "id": 3,
          "name": "Florian Co-CEO"
        },
        {
          "direction": 1,
          "knowledge": 3,
          "impact": 4,
          "progress": 37,
          "risk": 0,
          "disabled": false,
          "kind": 1,
          "id": 4,
          "name": "Contracting of Programers"
        },
        {
          "direction": 0,
          "knowledge": 1,
          "impact": 3,
          "progress": 9,
          "risk": 1,
          "disabled": false,
          "kind": 1,
          "id": 5,
          "name": "Capacitation of new entrants"
        }
      ],
      "initiativeTrends": [
        {
          "idInitiative": 1,
          "idTrend": 2,
          "influence": 5
        },
        {
          "idInitiative": 1,
          "idTrend": 3,
          "influence": 5
        },
        {
          "idInitiative": 1,
          "idTrend": 4,
          "influence": 5
        },
        {
          "idInitiative": 3,
          "idTrend": 1,
          "influence": 3
        },
        {
          "idInitiative": 3,
          "idTrend": 2,
          "influence": 3
        },
        {
          "idInitiative": 3,
          "idTrend": 3,
          "influence": 4
        },
        {
          "idInitiative": 3,
          "idTrend": 4,
          "influence": 2
        },
        {
          "idInitiative": 4,
          "idTrend": 1,
          "influence": 4
        },
        {
          "idInitiative": 4,
          "idTrend": 2,
          "influence": 3
        },
        {
          "idInitiative": 4,
          "idTrend": 3,
          "influence": 3
        },
        {
          "idInitiative": 4,
          "idTrend": 4,
          "influence": 5
        },
        {
          "idInitiative": 5,
          "idTrend": 1,
          "influence": 5
        },
        {
          "idInitiative": 5,
          "idTrend": 2,
          "influence": 5
        },
        {
          "idInitiative": 5,
          "idTrend": 3,
          "influence": 3
        },
        {
          "idInitiative": 5,
          "idTrend": 4,
          "influence": 4
        }
      ],
      "yesterday": 53,
      "today": 44,
      "tomorrow": 67.5
    }
  ]
}


--
I am a Newbie in programming with WINDEV - thanks to all who support me with their answers.