Answered

JSON parse - automating the 'generate from sample data' for a schema

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

So I currently have a flow which fetches an excel file from one drive, filters some data. The filtered data is parsed to JSON and then exported as a csv file back to one drive.

Now while parsing for JSON, I manually paste the output from 'List rows present in a table' after filtering into the 'generate from sample data to get the schema

Is it possible to automate this function? if so, how? and if not, are there any other suggestions?

Thanks for your replies in advance!!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

In order to parse an output, parse json action would need to know the schema at design time. Why are you looking forward to automate this step?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @PrasadAthalye,
For the schema required in parse json, I copy-paste the output from the previous step into the 'generate by sample' window manually, so my assumption is, if that step is automated wouldn't the flow be able to parse files with different schemas

Was this reply helpful? Yes No
Verified answer

PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

What you get from other actions is actual data and not schema. Schema is always a design time object against which you parse your data and convert it. What you are asking is to generate schema based on data runtime. It wont work because data may or may not be consistent. So providing design time schema informs parser what to expect for parsing function and to check if data is compliant and if not, it would throw error.

Was this reply helpful? Yes No