Answered

Best Way to Handle Variable JSON Formatting When Parsing

(0) Share

Report

Posted on by emauerbach

124

I've been working on a flow that will retrieve FedEx API data. The flow is pretty straightforward, taking a tracking number from a canvas app, calling the API, and then returning the formatted JSON to the app for display. I'm having issues as the FedEx return is not constant: some of the nodes vary between an array or an object. I've tried setting up failover by configuring Run After with different JSON samples that I've received, but the API continues to come up with new structures (current iteration allows for 3 different JSON results).

What's the best way to handle an API result that can provide different structures for the same call?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @eauerbach

This is not a flow issue. The schema validation for that JSON you have used can only validate based on you have provided. I would recommend to look the API documentation and see the full sample dataset and generate the schema. Also remove the mandatory schema validations once the object is generated so that it could handle all the scenarios.

Thanks

Was this reply helpful? Yes No
emauerbach 124 on at

Like (1)

Report

Thanks @abm . How do I disable mandatory validation?

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @eauerbach

Look at the schema and manually delete those nodes where it says mandatory from the JSON or set to accept null for those properties which are complaining about.

"Age": {
"type": ["number","null"]
},
"Name": {
"type": ["string","null"]
},

Was this reply helpful? Yes No
emauerbach 124 on at

Like (1)

Report

Thank you @abm ! Works great now.

Was this reply helpful? Yes No