I’m using the Data Preparation API in Qlik Sense 2021 to automate data wrangling tasks across multiple CSV sources. The API script throws parsing errors when loading files with inconsistent date formats from different regional offices.
Error from the API response:
DateParseException: Unable to parse date value
Expected format: yyyy-MM-dd, received: dd/MM/yyyy
Row 1247, Column: transaction_date
Our European office sends dates as DD/MM/YYYY while US office uses MM/DD/YYYY, and our Asia office uses YYYY-MM-DD. The data prep API seems to expect a single standardized format, but I need to handle all three in the same automated workflow.
I’ve looked at API script validation options but can’t find a way to specify multiple date formats or apply conditional parsing logic. The data wrangling transformations work fine once the dates are loaded correctly, but we can’t get past this initial parsing stage. Any suggestions on date format standardization through the API?