Answered

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

Like (0) Share

Report

Posted on 6 Aug 2021 08:39:05 by Community Power Pla...

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!!

All responses (3)

Answers (1)

Verified answer

PrasadAthalye on 09 Aug 2021 at 20:04:00

Like (0)

Report

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

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.
Community Power Pla... on 09 Aug 2021 at 04:15:12

Like (0)

Report

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

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
PrasadAthalye on 06 Aug 2021 at 18:40:02

Like (0)

Report

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

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?