Unanswered

JSON Validation

(0) Share

Report

Posted on by philjn77

156

I'm parsing some JSON data and I'm hitting a problem where a value is defined as being an integer in the schema, but when there is no data for an individual record, it's being returned as an empty string so it should be:

value: 12345

but when 'value' has no value, it's given as:

value: ""

Because it's expecting an integer, it gives me a validation error. I'm quite new to JSON so maybe i'm missing something obvious, but what is the best way around it? Can I make it be more flexible with the data its expecting in the schema, or can i make it ignore this error, or do i need to modify the JSON content with string replacement before I use the JSON parser?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

Do you really need the parse action?
Then you probably should change the schema.

Was this reply helpful? Yes No
philjn77 156 on at

Like (0)

Report

Do you mean change the schema i'm providing in power automate or change the schema of the source json, because thats not something i can do as its a 3rd party API.

By taking out the type i've managed to get around it as I dont need this data in any circumstance - though it leaves me wondering what i'd do if I did need it when it was present.

I guess I'd have to do string replacement?

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

Yes, you'd have to replace it.
That's exactly what the scheme is good for, at least you know where the service is messing up for you.

Was this reply helpful? Yes No