Send null in a string field (JSON)
I need to send the data from a view that returned NULL, but is going as empty. The fields are of type String.
I'm using:
SET tSC = ##Class(%ZEN.Auxiliary.jsonProvider).%WriteJSONStreamFromObject(.tSteamJson,pObj,,,,"e")
{ "altura": "", "atendimento_id": "3060382", "data_atualizacao": "2021-12-16 10:39:12.0", "data_coleta": "2021-12-16 10:37:00.0", "data_liberacao": "2021-12-16 10:39:12.0", "dor": "1", "dor_nr_seq_result": "", "escala_dor": "", "escala_temp": "C", "freq_cardiaca": "80", "freq_respiratoria": "22", "glicemia_capilar": "", "ds_ritmo_ecg": "", "ds_decubito": "", "ie_derivacao_seg_st": "N", "ds_derivacao_seg_st": "", "nivel_consciencia": "", "pa_aparelho": "", "pa_diastolica": 80, "pa_manguito": "", "pa_sistolica": "120", "paciente_id": "903283", "peso": "", "profissional_id": "260", "prontuario_id": "903283-7", "sat_o2": "", "sat_o2_membro": "", "setor": { "id": "38", "nome": "7 A CLIN/CIR PEDIATRIA" }, "temperatura": "36", "unidade_altura": "CM", "unidade_peso": "KG", "ie_o2_suplementar": "N" }
I need
{ "altura": null, "atendimento_id": "3060382", "data_atualizacao": "2021-12-16 10:39:12.0", "data_coleta": "2021-12-16 10:37:00.0", "data_liberacao": "2021-12-16 10:39:12.0", "dor": 1, "dor_nr_seq_result": null, "escala_dor": null, "escala_temp": "C", "freq_cardiaca": "80", "freq_respiratoria": "22", "glicemia_capilar": null, "ds_ritmo_ecg": null, "ds_decubito": null, "ie_derivacao_seg_st": "N", "ds_derivacao_seg_st": null, "nivel_consciencia": null, "pa_aparelho": null, "pa_diastolica": 80, "pa_manguito": null, "pa_media": null, "pa_membro": null, "pa_posicao": null, "pa_sistolica": "120", "paciente_id": "903283", "peso": null, "profissional_id": "260", "prontuario_id": "903283-7", "sat_o2": null, "sat_o2_membro": "", "setor": { "id": "38", "nome": "7 A CLIN/CIR PEDIATRIA" }, "temperatura": 36, "unidade_altura": "CM", "unidade_peso": "KG", "ie_o2_suplementar": "N" }
Product version: Ensemble 2012.1
$ZV: Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2017.1 (Build 792U) Mon Mar 20 2017 19:19:52 EDT