Unanswered

How to pass the JSON Payload Schema dynamically

(0) Share

Report

Posted on by madmvx

Im getting a Json like this:

[
 [
 {
 "TimeGenerated": "2021-05-18T20:36:11.916Z"
 },
 {
 "DestinationIP": "9.9.9.9"
 },
 {
 "DestinationUserName": "abc"
 },
 {
 "country_name": "Panama"
 },
 {
 "country_iso_code": "PA"
 },
 {
 "AccountCustomEntity": "xyz"
 }
 ],
 [
 {
 "TimeGenerated": "2021-05-18T20:36:11.916Z"
 },
 {
 "DestinationIP": "9.9.9.9"
 },
 {
 "DestinationUserName": "abc"
 },
 {
 "country_name": "Panama"
 },
 {
 "country_iso_code": "PA"
 },
 {
 "AccountCustomEntity": "xyz"
 }
 ]
]

But not ever im gonna get that style of json,

somethimes im gonna get a json like this:

[
 [
 {
 "ABC": "2021-05-18T20:36:11.916Z"
 },
 {
 "BCD": "9.9.9.9"
 },
 {
 "ZXC": "abc"
 }
 ],
[
 {
 "ABC": "2021-05-18T20:36:11.916Z"
 },
 {
 "BCD": "9.9.9.9"
 },
 {
 "ZXC": "abc"
 }
 ]
]

With different Key and Value

So, i need to pass this Json to PowerApps to make a collection but to do this, first i need to pass with a RESPONSE

But the RESPONSE needs a sample schema, the problem is, the schema NEVER gonna be the same

and i can not pass the sample stored in a variable to the option "generate from sample"

like:

Exist a way to parse a json to pass a powerapps that never gonna be the same?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @madmvx

You can't dynamically generate a JSON Schema. The whole idea for Parse JSON schema is validate the data in a specified manner so that in next step you can access the expected data attributes.

Can't you pass the JSON output under the Body. My understanding is Response Body JSON Schema is optional where if you want to validate before it returns.

Thanks

Was this reply helpful? Yes No
madmvx 30 on at

Like (0)

Report

If i dont pass the schema, in power apps, i can't use the data as collection
How can i solve that?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @madmvx

Unfortunately this is not possible. Like I mentioned earlier the whole idea of schema validation is make sure the data is coming in right format. If you know all the format of your JSON format why not generate one schema which might work for you.

Thanks

Was this reply helpful? Yes No
ravisonawane4 4 on at

Like (1)

Report
Hi @madmvx
try this schema

{ "type": "object", "properties": { "[index]": { "type": "string" } } }

Was this reply helpful? Yes No
CU20011233-0 54 on at

Like (0)

Report

I'm having the same issue. Did you find a resolution to that?

Was this reply helpful? Yes No