CODEWITHSUNDEEP
jsonpower-automatejsonparserpower-platform
John John
John John

Reputation: 1

How I can go deep into a JSON data and loop thorugh an array

I have an external api which return the following JSON:-

{
  "resultSetMetaData": {
    "page": 0,
    "numPages": 2,
    "numRows": 3,
    "format": "json",
    "rowType": [
      {
        "name": "FIRST_NAME",
        "database": "PROD",
        "schema": "RIC",
        "table": "OWNER_VW",
        "type": "text",
        "scale": null,
        "precision": null,
        "nullable": true,
        "byteLength": 16777216,
        "collation": null,
        "length": 16777216
      },
      {
        "name": "LAST_NAME",
        "database": "PROD",
        "schema": "RIC",
        "table": "OWNER_VW",
        "type": "text",
        "scale": null,
        "precision": null,
        "nullable": true,
        "byteLength": 16777216,
        "collation": null,
        "length": 16777216
      },
      {
        "name": "EMAIL",
        "database": "PROD",
        "schema": "RIC",
        "table": "OWNER_VW",
        "type": "text",
        "scale": null,
        "precision": null,
        "nullable": true,
        "byteLength": 16777216,
        "collation": null,
        "length": 16777216
      },
      {
        "name": "CITY",
        "database": "PROD",
        "schema": "RIC",
        "table": "OWNER_VW",
        "type": "text",
        "scale": null,
        "precision": null,
        "nullable": true,
        "byteLength": 16777216,
        "collation": null,
        "length": 16777216
      },
      {
        "name": "ZIP",
        "database": "PROD",
        "schema": "RIC",
        "table": "OWNER_VW",
        "type": "text",
        "scale": null,
        "precision": null,
        "nullable": true,
        "byteLength": 16777216,
        "collation": null,
        "length": 16777216
      },
      {
        "name": "STATE",
        "database": "PROD",
        "schema": "RIC",
        "table": "OWNER_VW",
        "type": "text",
        "scale": null,
        "precision": null,
        "nullable": true,
        "byteLength": 16777216,
        "collation": null,
        "length": 16777216
      },
      {
        "name": "ADDRESS",
        "database": "PROD",
        "schema": "RIC",
        "table": "OWNER_VW",
        "type": "text",
        "scale": null,
        "precision": null,
        "nullable": true,
        "byteLength": 16777216,
        "collation": null,
        "length": 16777216
      },
      {
        "name": "PHONE",
        "database": "PROD",
        "schema": "RIC",
        "table": "OWNER_VW",
        "type": "text",
        "scale": null,
        "precision": null,
        "nullable": true,
        "byteLength": 16777216,
        "collation": null,
        "length": 16777216
      },
      {
        "name": "UID",
        "database": "PROD",
        "schema": "RIC",
        "table": "OWNER_VW",
        "type": "text",
        "scale": null,
        "precision": null,
        "nullable": true,
        "byteLength": 16777216,
        "collation": null,
        "length": 16777216
      }
    ]
  },
  "data": [
    [
      "0",
      "HoT",
      "Hot",
      "No_Email@no-email.com",
      "Miami",
      "33",
      "Florida",
      "",
      "",
      ""
    ],
    [
      "1",
      "Richie",
      "Hot",
      "No_Email@no-email.com",
      "Miami",
      "331",
      "Florida",
      "",
      "",
      ""
    ],
    [
      "2",
      "Jeff",
      "Hot",
      "No_Email@no-email.com",
      "Miami",
      "33",
      "Florida",
      "",
      "(0",
      "4"
    ]
  ],
  "code": "090001",
  "statementStatusUrl": "/api/statements/01a4d180-0b03-2ad4-0000-f67903a02826?requestId=4d32040e-ba17-4936-a013-7dd7ab1797aa",
  "requestId": "4d32040e-ba17-4936-a013-7dd7ab1797aa",
  "sqlState": "00000",
  "statementHandle": "01a4d180-0b03-2ad4-0000-f67903a02826",
  "message": "Statement executed successfully.",
  "createdOn": 1654725152956
}

now i want to loop through the items inside the data[] array, so how i can do so?

Now i wrote a test Flow and i create a Parse JSON action with the above JSON as the input and as the template, then i will get these.. so i only get rowType.. so how i can loop through the data[] array inside the rowType?

johnjohn123_0-1655159045919.png

Thanks

Upvotes: 1

Views: 3295

Answers (1)

Skin
Skin

Reputation: 11277

I loaded your data into an object variable called Data and then constructed a For each action beneath that ...

Flow

The expression in the screenshot is simply ...

variables('Data')['data']

That will loop through your array of data elements.

To get each item (which in this case is an array) then follow this pattern.

Firstly, initialise a variable (top arrow, variable is called Initialize Item) that is of type Array ...

Flow

Then within the For each loop, set that variable (as shown) by using the Current item dynamic object.

You will get your result from there.

Result ...

Result

Upvotes: 0

Related Questions