JSON Validation

(0) Share

Report

Posted on by DDM

Dear Community,

I have a flow that takes a CSV and parses the contents. What I need to be able to do is validate that values in the CSV meet a certain set of requirements.

I have used Compose to validate that the first value in the column is -eq to 6 or is empty (null) and if not then send an email. This works well.

I need to be able to add additional validation for example I need to be able to validate that there is a header row in the CSV and I need to be able to ensure that there are 6 columns.

I thought I would be able to use multiple compose and then add the validation in the condition using OR but when I add a compose the only Dynamic Content available to me is the current item or the Get SAPAgent Value Length from the previous compose (see below).

Can anyone offer any help in achieving this.

Thanks in advance

DDM

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

wskinnermctc 6,519 Moderator on at

Like (1)

Report

Re: JSON Validation

You'll have to manually type in the column name with the expression.

Outputs('Get_SAPAgent_Value_Length')?['ColumnName']
or
items('Parse_JSON')?['ColumnName']

Was this reply helpful? Yes No
DDM 79 on at

Like (1)

Report

Re: JSON Validation

Thanks @wskinnermctc Wasn't the exact solution but put me on the right track.

outputs('FieldNames')[0]

Was this reply helpful? Yes No