Possible bug in handling Boolean values in ADFv2 Copy Activity from a JSON source. RRS feed

  • Question

  •  I have recently been working with json files in ADFv2 and I believe there is a bug around the way it is handling tristate boolean values in json.

    Consider the following json:

    "data": [
     "bool2bitFails": false
     "bool2bitfails": true
     "bool2bitfails": ""

    when I try to map a boolean json value to a bit in SQL Server all is well as long as the value is true or false However I believe json allows a empty string to represent null (3rd case above)
    in a normal js environment, this should map to false.

     I suspect that the correct behavior for sql should be to map it to null if the column is nullable and perhaps false if the column is non-nullable. 

    to work around, I tried loading the boolean field into a nvarchar but that returned the same error

    Thursday, August 30, 2018 9:59 PM

All replies

  • Hi Jason,

    Could repost this one?  Something happened with the formatting and its hard to read.

    Monday, September 3, 2018 10:13 PM
  • ok i fixed this not sure why it got garbled
    Monday, September 3, 2018 11:10 PM