jsonjsonschemapower-automate
Object with dynamic keys not able to generate Parse JSON schema in power automate
I am making one API call in Power Automate and the response I am receiving the below JSON
{
"paging": {
"start": 0,
"count": 10,
"links": [],
"total": 3
},
"elements": [
{
"isReshareDisabledByAuthor": false,
"createdAt": 1704446818959,
"lifecycleState": "PUBLISHED",
"lastModifiedAt": 1704446818959,
"visibility": "PUBLIC",
"publishedAt": 1704446818959,
"author": "urn:li:organization:101414444",
"id": "urn:li:share:7148968102884841984",
"distribution": {
"feedDistribution": "MAIN_FEED",
"thirdPartyDistributionChannels": []
},
"content": {
"media": {
"altText": "",
"id": "urn:li:image:D4D22AQHbdiWdPzeHtg"
}
},
"commentary": "Hi Test",
"lifecycleStateInfo": {
"isEditedByAuthor": false
}
},
{
"isReshareDisabledByAuthor": false,
"createdAt": 1704285674051,
"lifecycleState": "PUBLISHED",
"lastModifiedAt": 1704285674096,
"visibility": "PUBLIC",
"publishedAt": 1704285674051,
"author": "urn:li:organization:101414444",
"id": "urn:li:ugcPost:7148292213186180096",
"distribution": {
"feedDistribution": "MAIN_FEED",
"thirdPartyDistributionChannels": []
},
"content": {
"multiImage": {
"images": [
{
"altText": "",
"id": "urn:li:image:D4D22AQFnjGKot4DBIg"
},
{
"altText": "",
"id": "urn:li:image:D4D22AQEzSmXKu93lmw"
},
{
"altText": "",
"id": "urn:li:image:D4D22AQGMb7DQf3s7zA"
}
]
}
},
"commentary": "Hi There",
"lifecycleStateInfo": {
"isEditedByAuthor": false
}
},
{
"isReshareDisabledByAuthor": false,
"lifecycleState": "PUBLISHED",
"createdAt": 1703744862033,
"lastModifiedAt": 1703744862095,
"visibility": "PUBLIC",
"publishedAt": 1703744862033,
"author": "urn:li:organization:101414444",
"id": "urn:li:share:7146023559452666882",
"distribution": {
"feedDistribution": "MAIN_FEED",
"thirdPartyDistributionChannels": []
},
"commentary": "Hi Community!",
"lifecycleStateInfo": {
"isEditedByAuthor": false
}
}
]
}
In my next step, I am using Parse JSON to read the above JSON like
In the Schema input of the above image, I tried to generate from the sample and it asked sample payload, where I put the above JSON and it generated the below Schema.
{
"type": "object",
"properties": {
"paging": {
"type": "object",
"properties": {
"start": {
"type": "integer"
},
"count": {
"type": "integer"
},
"links": {
"type": "array"
},
"total": {
"type": "integer"
}
}
},
"elements": {
"type": "array",
"items": {
"type": "object",
"properties": {
"isReshareDisabledByAuthor": {
"type": "boolean"
},
"createdAt": {
"type": "integer"
},
"lifecycleState": {
"type": "string"
},
"lastModifiedAt": {
"type": "integer"
},
"visibility": {
"type": "string"
},
"publishedAt": {
"type": "integer"
},
"author": {
"type": "string"
},
"id": {
"type": "string"
},
"distribution": {
"type": "object",
"properties": {
"feedDistribution": {
"type": "string"
},
"thirdPartyDistributionChannels": {
"type": "array"
}
}
},
"content": {
"type": "object",
"properties": {
"media": {
"type": "object",
"properties": {
"altText": {
"type": "string"
},
"id": {
"type": "string"
}
}
}
}
},
"commentary": {
"type": "string"
},
"lifecycleStateInfo": {
"type": "object",
"properties": {
"isEditedByAuthor": {
"type": "boolean"
}
}
}
},
"required": [
"isReshareDisabledByAuthor",
"createdAt",
"lifecycleState",
"lastModifiedAt",
"visibility",
"publishedAt",
"author",
"id",
"distribution",
"commentary",
"lifecycleStateInfo"
]
}
}
}
}
It is successfully running when content object has media value like
but it is failing when content object has multiImage value like
so, I am not sure if we can generate a Schema for the above JSON or not? or any other way to solve the above problem.
Solution
I think this should work...
{
"type": "object",
"properties": {
"paging": {
"type": "object",
"properties": {
"start": {
"type": "integer"
},
"count": {
"type": "integer"
},
"links": {
"type": "array"
},
"total": {
"type": "integer"
}
}
},
"elements": {
"type": "array",
"items": {
"type": "object",
"properties": {
"isReshareDisabledByAuthor": {
"type": "boolean"
},
"createdAt": {
"type": "integer"
},
"lifecycleState": {
"type": "string"
},
"lastModifiedAt": {
"type": "integer"
},
"visibility": {
"type": "string"
},
"publishedAt": {
"type": "integer"
},
"author": {
"type": "string"
},
"id": {
"type": "string"
},
"distribution": {
"type": "object",
"properties": {
"feedDistribution": {
"type": "string"
},
"thirdPartyDistributionChannels": {
"type": "array"
}
}
},
"content": {
"type": "object",
"properties": {
"media": {
"type": "object",
"properties": {
"altText": {
"type": "string"
},
"id": {
"type": "string"
}
}
},
"multiImage": {
"type": "object",
"properties": {
"images": {
"type": "array",
"items": [
{
"type": "object",
"properties": {
"altText": {
"type": "string"
},
"id": {
"type": "string"
}
}
}
]
}
}
}
}
},
"commentary": {
"type": "string"
},
"lifecycleStateInfo": {
"type": "object",
"properties": {
"isEditedByAuthor": {
"type": "boolean"
}
}
}
},
"required": [
"isReshareDisabledByAuthor",
"createdAt",
"lifecycleState",
"lastModifiedAt",
"visibility",
"publishedAt",
"author",
"id",
"distribution",
"commentary",
"lifecycleStateInfo"
]
}
}
}
}
- Keep numbers which appear in both columns, in J lang
- Differentiation in J
- How to reshape an array with an arbitrary size in one dimension?
- Why is Insert (fold) right associative
- Write 4 : 'x&{.&.;: y' tacitly
- Alignment issue when printing formatted prime numbers in J language
- How can I define a verb in J that applies a different verb alternately to each atom in a list?
- How to get user input in the J programming language
- How to unbox a list of boxed lists of differing lengths in J?
- How can I fix 'noun result was required' error in J?
- In j, how can I define a verb locally in one scope and pass it to a defined adverb?
- Convert boxed array to normal array?
- Read column of CSV file as array
- Replace atom in array of strings
- What does the dyad `=` do to boxed strings?
- Index of minimum element using J
- How can I take the outer product of string vectors in J?
- Building an array of verbs in J
- Reading in multidigit command line parameter
- Amend with bond to new data shows unexpected behaviour
- How to turn a table or matrix into a (flat) list in J
- How to run dissect in J?
- How to define selection using index function in J
- How to exit the J console?
- Find 4-neighbors using J
- Writing custom verbs in J
- How do I negate a selector in J lang?
- How to use arbitrary selector in interchange in J lang?
- different result once square root is added inside tacit
- Sum of arrays with repeated indices