Answered

trouble parsing JSON data when a field is blank

(0) Share

Report

Posted on by LS-05052252-0

I need help fixing an error in my parse JSON step:

I am parsing JSON data from the body of an email (I have my reasons!), and I had it working at one point. Now, when an email with JSON data arrives in the inbox inbox my flow fails in the "parse JSON" step. The errors I've been getting are pretty consistent. Here's one example:

Here's the schema:

"Unique Entity ID UEI_1": {
      "type": "integer"
    },

Here's the data input:

"Unique Entity ID UEI_1": "",

And here's the error I get:

{
    "message": "Invalid type. Expected Integer but got String.",
    "lineNumber": 0,
    "linePosition": 0,
    "path": "['Unique Entity ID UEI_1']",
    "value": "",
    "schemaId": "#/properties/Unique Entity ID UEI_1",
    "errorType": "type",
    "childErrors": []
  }
 
It appears to me that it somehow has difficulty when an integer field is blank. If I could do away with the "type" altogether I would - it's of no value to me. Thanks in advance for any ideas on a fix.
 

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hey @LS-05052252-0,

I know this prolem all too well. Add this and it should work ;)

"Unique Entity ID UEI_1": { "type": ["integer", "string", "null"] }

String and null since the error says that it's of type string and not null and null so that the field can also be blank. let me know if it worked.

If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!

Was this reply helpful? Yes No
LS-05052252-0 13 on at

Like (1)

Report
Copy link

Link copied!

Thank you so much! This fixed it! I did add "numbers" as an option in there too. I *knew* there must be a way to make it more indiscriminate! Thanks again!

Was this reply helpful? Yes No