Unanswered

JSON Missing Property

(1) Share

Report

Posted on by ScotSunnergren

I have an HTTP request that pulls JSON from an API. I sometimes get records that are missing fields. Not empty but simply missing.

When I run a Select against the HTTP results, I get...

The template language expression 'item()['PlacedOn']' cannot be evaluated because property 'PlacedOn' doesn't exist

And a review of the incoming JSON shows some records with that property and some without. How can I get around that error and either fill the property as blank or ignore records that do not have it?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (2)

Report

Hi @ScotSunnergren

Use the below

item()?['PlacedOn']

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (1)

Report
Try putting a question mark after item and before the column. It worked for me in a test, but I didn't do comprehensive testing.

item()?['PlacedOn']

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (1)

Report

You beat me to it. I didn't see your reply bc my browser wasn't refreshed.

Was this reply helpful? Yes No
ScotSunnergren 15 on at

Like (1)

Report

PERFECT! Thank you! that gave me a null field but at least it doesn't kill the flow.

Was this reply helpful? Yes No