Bulk Add Queue Items shouldn't set values to null

If you Read Range a sheet into a DT and then Bulk Add Queue Items, any blank values from the spreadsheet show as null in the queue item. This is a huge annoyance because any reference to that key throws the “object reference not set to an instance of an object” error.

If the values in the source sheet are empty, they should be empty (ie “”) in the queue item.

For anyone looking for a workaround, this results in “Empty” instead of “null” in the queue item:


Here are the properties of the For Each Column:


Thanks for the feedback. I will investigate if empty string instead of null is possible.

This should be fixed now in the latest versions.

1 Like

Does this mean later versions of Studio, or later versions of a particular package?

Oh, and what was changed? Bulk Add Queue Items won’t add them as null, or a reference to transactionItem.SpecificContent(“somekey”) won’t throw an object reference error when the value is null?

I believe of the System activity package which hosts that activity.

It will add an empty string rather than null.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.