Sort with JSON schema help

[Emil2]

Dear community i am stuck again. 

I am reading out data from SQL, its a view that i have created that gives e some values. 

Here is my Json input 

[
  {
    "ResultSets": {
      "Table1": [
        {
          "Name": " prototype",
          "TidPunkt": "2020-11-29T00:00:00",
          "Conductivity": "0.4322977066040039",
          "Volume": "38900",
          "Alarm": ""
        },

I want to sort this in a create html table like this

Name TidPunkt Conductivity Volume

0657	2020-11-25T23:48:03Z	1	0.526404857635498
0679	2020-11-25T11:11:54Z	2	0.47801780700683594
0670	2020-11-20T23:22:16Z	1	1.4046096801757812

But i get this 

{"Table1":[{"Name":"0657","TidPunkt":"2020-11-29T00:00:00","Conductivity":"1","Volume":"38900","Alarm":""}

My schema looks like this 

{
  "type": "array",
  "items": {
    "type": "object",
    "properties": {
      "ResultSets": {
        "type": "object",
        "properties": {
          "Table1": {
            "type": "array",
            "items": {
              "type": "object",
              "properties": {
                "Name": {
                  "type": [
                    "string",
                    "null"
                  ]
                },
                "TidPunkt": {
                  "type": [
                    "string",
                    "null"
                  ]
                },
                "Conductivity": {
                  "type": [
                    "string",
                    "null"
                  ]
                },
                "Volume": {
                  "type": [
                    "string",
                    "null"
                  ]
                },
                "Alarm": {
                  "type": [
                    "string",
                    "null"
                  ]
                }
              },
              "required": [
                "Name",
                "TidPunkt",
                "Conductivity",
                "Volume",
                "Alarm"
              ]
            }
          }
        }
      }
    }
  }
}

What do i do wrong? 

All the best

[v-litu-msft · Accepted solution]

Hi @Emil2,

After you get the output, you could put it into a Compose action:

{"Table1":[{"Name":"0657","TidPunkt":"2020-11-29T00:00:00","Conductivity":"1","Volume":"38900","Alarm":""}

Then use expression to get table 1, then put it into the Create HTML table action:

Run result:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.