Share
ReportHi everyone,
I’m new to Power Automate and I’m trying to extract the message_id from my JSON, but it’s returning a null value in the Compose action.
My JSON schema looks like this:
{
"type": "object",
"properties": {
"type": {
"type": "string"
},
"properties": {
"type": "object",
"properties": {
"ticket": {
"type": "object",
"properties": {
"type": {
"type": "string"
},
"properties": {
"type": "object",
"properties": {
"id": {
"type": "object",
"properties": {
"type": {
"type": "string"
}
}
},
"brand": {
"type": "object",
"properties": {
"type": {
"type": "string"
},
"properties": {
"type": "object",
"properties": {
"name": {
"type": "object",
"properties": {
"type": {
"type": "string"
}
}
}
}
}
}
},
"subject": {
"type": "object",
"properties": {
"type": {
"type": "string"
}
}
},
"comments": {
"type": "object",
"properties": {
"type": {
"type": "string"
},
"items": {
"type": "object",
"properties": {
"type": {
"type": "string"
},
"properties": {
"type": "object",
"properties": {
"id": {
"type": "object",
"properties": {
"type": {
"type": "string"
}
}
},
"message_id": {
"type": "object",
"properties": {
"type": {
"type": "string"
}
}
},
"body": {
"type": "object",
"properties": {
"type": {
"type": "string"
}
}
},
"public": {
"type": "object",
"properties": {
"type": {
"type": "string"
}
}
},
"author_id": {
"type": "object",
"properties": {
"type": {
"type": "string"
}
}
}
}
},
"required": {
"type": "array",
"items": {
"type": "string"
}
}
}
}
}
},
"email_id": {
"type": "object",
"properties": {
"type": {
"type": "string"
}
}
}
}
},
"required": {
"type": "array",
"items": {
"type": "string"
}
}
}
}
}
}
}
}
The result:
Can you please help me?
Thanks!
Categories:
All responses (
Answers (
424
