Manipulate data from integration source

Martin Grønbekk Moen

Posted on 01/06/2021 19:42:51

We have an integration source which give boolean data in a wrong format, and it cant be changed.
Is it possible to manipulate this in the integration job, ex. with @Code() ?

Ex. the data source return "0" or "1" as a string, representing "0" = false and "1" = true.
How can we manipulate that data so that the integration job understand that "0" = false and "1" = true?

I tried something like this in the scripting section of the integration job column @Code({{ColumnName}} == "1" ? true : false) but that was clearly wrong...

Replies

Dmitriy Benyuk

Posted on 01/06/2021 23:57:47

Hi Martin,
if you are importing from source column of type System.String to the destination column of type System.Boolean then it should work and auto convert 1 to true and other value to false.
Try to check if your schema is of type System.String for the source column where you have 0/1 values and System.Boolean is the destination column type.
Also if that still does not help, let me know what are your source and destination providers that are not working?
BR, Dmitrij

Martin Grønbekk Moen

Posted on 02/06/2021 09:07:36

Hi Dmitrij,

When we try to import it directly we get this error: Import job failed: cannot parse '1' to a System.Boolean.
The source is SQL provider with views and the destination is Dynamicweb provider maybe thats the issue?

You must be logged in to post in the forum

Developer forum

Manipulate data from integration source

Replies