Flow Parse JSON use a sample payload to generate schema

Like (0) Share

Report

Posted on 28 Jul 2019 09:48:49 by CABIRD

234

Hello

I've looked for training module to generate 'Flow' JSON scheme. While I have successfully built Flows with JSON it's more a hit and miss implementation. The principal reason my understanding at this moment in time is inadequate as to how to generate a schema correctly.

Is there any step by step training available?

Regards

Christopher

All responses (16)

Answers (1)

Madiko 37 on 01 Oct 2021 at 02:02:43

Like (0)

Report

Re: Flow Parse JSON use a sample payload to generate schema

did you find a solution? I have the same issue and posted here: https://powerusers.microsoft.com/t5/General-Power-Automate/Issue-with-JSON-PARSE/td-p/1291942

Can anyone help me?
CABIRD 234 on 30 Jul 2019 at 07:06:47

Like (0)

Report

Re: Flow Parse JSON use a sample payload to generate schema

Hello @faustocapellanj

Thank you.

Clear documentation with examples.

Best wishes
Christopher
faustocapellanj 1,662 on 29 Jul 2019 at 20:46:43

Like (1)

Report

Re: Flow Parse JSON use a sample payload to generate schema

@CABIRD I totally hear you. When you have a chance, take a look at the PowerApps JSON function. It's actually so much easier to build your JSON in PowerApps and just send that as a single parameter to Flow.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-json
CABIRD 234 on 29 Jul 2019 at 16:17:13

Like (0)

Report

Re: Flow Parse JSON use a sample payload to generate schema

Hello @faustocapellanj

Thank you.

I have a working Flow. My issue was I didn't want to spend days at some point in the future having to manually create a new schema for a new Flow because I couldn't Parse JSON correctly.

The dataUriToBinary() expression isn't a problem provided the Parse JSON schema is correct.

I really appreciate your help resolving this. Thank you.

Regards
Christopher
faustocapellanj 1,662 on 29 Jul 2019 at 15:48:45

Like (0)

Report

Re: Flow Parse JSON use a sample payload to generate schema

Hi @CABIRD

The JSON schema doesn't have a File type. If the goal is to send info from PowerApps to Flow to create a file, at the 3:50 marker of Paul's video, you can see that File is of String type. Also at that point, you can see that he wraps in the File property from the Parse JSON action inside a dataUriToBinary() expression so that can be the file content. Please check out the screenshot I attached.
CABIRD 234 on 29 Jul 2019 at 15:35:28

Like (0)

Report
Re: Flow Parse JSON use a sample payload to generate schema

Hello @LauraGB

Thank you.

I assume the generated schema is correct although the "type" would need to change to "File" etc. to have relevance to further Flow development.

{ "type": "object", "properties": { "type": { "type": "string" }, "properties": { "type": "object", "properties": { "FileName": { "type": "object", "properties": { "type": { "type": "string" } } }, "File": { "type": "object", "properties": { "type": { "type": "string" } } } } } } }
Thank you.

Regards
Christopher
Verified answer

LauraGB 71 on 29 Jul 2019 at 14:52:30

Like (4)

Report

Re: Flow Parse JSON use a sample payload to generate schema

Hi

If you are following Paul's video at about 4:15 he shows what he is sending to the Flow from PowerApp.

So using this as an example a sample payload for this would be

{"FileName":"aaa","File":"aaa"}

I put the names within quotes and I put example data in, eg the "aaa" is just to show the data will be a string.

So in the Parse JSON Action I click on Use Sample Payload to Generate schema and paste the above string in and then click Done. That should generate the schema for you.

Hope that helps.

Laura GB
CABIRD 234 on 29 Jul 2019 at 13:55:52

Like (0)

Report

Re: Flow Parse JSON use a sample payload to generate schema

Hello @faustocapellanj

Thank you for forwarding the video.

Let me repeat I have a Flow that works for all the features Paul's video illustrates. I just don't want to have to tediously build a schema each time if there is an approved methodogly.

The issue is how do I generate the JSON scheme. The how is not explicitly shown in the video. Paul mentions running the Flow to generate the Scheme. However, you cannot generate output from PowerApp trigger and Initialise Variable alone to create JSON scheme.

So, the question remains. How do I generate the output that enables me to paste schema into the generate JSON scheme?

Clearly, I’m missing something in my understanding.
faustocapellanj 1,662 on 29 Jul 2019 at 13:15:50

Like (0)

Report

Re: Flow Parse JSON use a sample payload to generate schema

Here's a video that Paul Culmsee did on that:

https://www.youtube.com/watch?v=kQVYid1p_vA&t=254s
CABIRD 234 on 29 Jul 2019 at 12:56:03

Like (0)

Report

Re: Flow Parse JSON use a sample payload to generate schema

I have a button. The button initiates Flow. Flow opens, I added an action. Save the Flow. From Flow I clicked Run and the above opens. I typed in hello.jpg.

I have built an app that works but that was tortious process to state the least as I had to build the schema myself. I have the Flow upload audio, files, photos, pdf metadata to SharePoint. I begin with a PowerApp trigger then my action initialise variable, then Parse JSON, SharePoint Create File, Update file Properties.

Obiviously I cannot add Parse JSON and save an run.

So how do I get the generate JSON schema function to create the schema?

Thank you.