Null values

Keith Myers

Hi,

I'm doing a GET on /v1/lists/advanced and when the results are returned, the value key is missing for fields that have null values. When I process the results, the missing value is causing issues. I figured this must have come up before, but I couldn't find anything in the search. In the example below, I need a value under “Middle Name” that is either blank, or null. I'd appreciate any advice. Thanks!

"columns": [{
"name": "First Name",
"value": "Ian"
}, {
"name": "Last Name",
"value": "Smith"
}, {
"name": "Middle Name"
}]

Alex Wong

@Keith Myers
Generally in SKY API (RE and FE), when a field doesn't have value, the field wouldn't be returned at all. (so you woundn't even get “name”:"middle name")

But given this isn't RE SKY API, the way the data is returned is also not the same JSON constructoin, I think only Blackbaud can help you answer.

However, I would suggest you can try updating your JSON Schema to allow “name” property to be string OR null.

"name": { "type": ["string", "null"] }