autoColumnMapping function in Workflow api

Options
Alexis G.
Alexis G.
edited December 2023 in General

Hi,

Have you consider having a flag in your api to execute Workflows to use the auto Mapping columns we can have in Studio ?

This will be great to avoid case sensitive headers in DataSet for instance.

Regards,

Tagged:

Answers

  • Josh Boxer
    Josh Boxer Administrator
    Options

    Hi Alexis

    If columns in the new dataset have been re-ordered, but have the same name, then I believe they are auto mapped to original workflow schema so will execute successfully. If the column names do not match then it currently will fail. I guess we could be less strict on smaller changes like case sensitivity, but wonder how far this should be taken what about a double space character or trailing space character in a column header etc.? Something we can look into.

    I believe loading data into an existing Dataset might handle this today, so worth testing. If you leave the Dataset to overwrite data you could also set the workflow to delete the data once it completes successfully.

Categories