Thanks for the update @Swegmann !
I know there was some discussion to allow null but I didn’t realize it had ever been implemented. I’m glad you were able to find a workaround for this. My thought regarding SQL vs. Transform is that it SHOULD work (as I believe it ultimately calls the same API) but I could be wrong.