Specifies whether empty values should be interpreted as empty strings or as NULL.

Data Type

bool

Default Value

false

Remarks

This property applies to SELECT operations.

Zuora returns all column values as strings. Unless you enable this property, an empty string returned for any column is passed through as an empty string.

When PushEmptyValuesAsNull is set to false (the default), empty values are pushed as an empty string for VARCHAR columns, 0 for numeric fields, and NULL for date fields.

When set to true, the connector pushes empty values returned from the query operation as NULL.

This property applies to both the DataQuery and AQuADataExport schemas that you select with the ZuoraService property.