Answered

Json Parse Schema

(0) Share

Report

Posted on by jhenry

I am trying to parse data from my API into Flow, however i cannot figure out how to parse a list of objects. I want the end result be that for each item in the list, i can send an email about it.

Data given by API:

{
 "item1" : {
 "category" : "1",
 "name" : "my name",
 "data" : "my data"
 },
 "item2" : {
 "category" : "2",
 "name" : "my name",
 "data" : "my data"
 }.........
}

payload given by JSON parser:

{
 "type": "object",
 "properties": {
 "item1": {
 "type": "object",
 "properties": {
 "category": {
 "type": "string"
 },
 "name": {
 "type": "string"
 },
 "data": {
 "type": "string"
 }
 }
 },
 "item2": {
 "type": "object",
 "properties": {
 "category": {
 "type": "string"
 },
 "name": {
 "type": "string"
 },
 "data": {
 "type": "string"
 }
 }
 }
 }
}

how to i set the parser to understand there may be diffrent items in the list?

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

gamoraes 1,040 on at

Like (0)

Report

Hi @jhenry

What you need to do after parse? i really recommend you to use the expression json() to parse your text in this case.

If you can explain a little more for us your case will be great.

Hope have helped,

Gustavo Moraes

Was this reply helpful? Yes No
jhenry 5 on at

Like (0)

Report

hi @gamoraes,

For each Item (item1,item2,item3.....) i want to get its name and email it someone. I will use the json() to parse the body to json, but i still need to parse the data correctly since it is not a finite amount of information.

Was this reply helpful? Yes No
Verified answer

v-micsh-msft on at

Like (1)

Report

Hi @jhenry,

Take a look at the parse JSON Action:

Parse JSON messages

Then you should be able to manage the items returned by the Parse JSON Action.

Regards,

Michael

Was this reply helpful? Yes No