0
Completed

CSV Connector does not support binary values

Tony Sheehy 7 years ago in CSV connector • updated by anonymous 4 years ago 4

A CSV connector configured to import a binary value fails with:

Change detection engine import all items for connector CSV Connector Example failed with reason Line 1 column 1 value of 010011010110000101101110 is not valid. Duration: 00:00:00.1406250

This was tried with a byte value, byte array value, binary value and base64 encoded string; all resulting with a message similar to the one provided above.

  • Either the validator should be updated to handle string values
  • Or an intermediate step is included where the CSV connector tries to parse the values retrieved based on the field ValueType, before creating with the Validator
  • Otherwise, a more descriptive exception should be provided denoting that this connector doesn't support that value type.
Affected Versions:
Fixed by Version:

Matthew, do you think that adding Base64 encoded string support in the binary CreateValue method would make sense?

Thanks.

I have added support in the validator for base64 encoded strings.

Please confirm that this has worked for your scenario.

Thanks.

After some fixes this has been confirmed.