API JSON Output format to table format

[harinder1301]

Hi 

I am trying to convert API JSON Output format to table format.

From:

JSON Name JSON ValueString
data.0.Name A1
data.0.Age B1
data.0.Skills C1
data.1.Name A2
data.1.Age B2
data.1.Skills C2
data.2.Name A3
data.2.Age B3
data.2.Skills C3

Required columns:

RowNo Name Age Skills
0 A1 B1 C1
1 A2 B2 C2
2 A3 B3 C3

Appreciate your advise.

Thanks

Harinder

[mceleavey · Accepted solution]

Hi @harinder1301 ,

Hello Regex my old friend....

Hope this helps.

M.

[Luke_C · Accepted solution]

@harinder1301 

You can parse the json field then crosstab the data:

[harinder1301]

Thank you 🙂

[messi007]

@harinder1301,

Please see below:

If this solve the need please make it as solved it will help others,

Attached the workflow,

Regards,