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:
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?