Prepare the Pentaho ETL to extract the historical customer transactions. Applied modification to convert character encoding of columns to UTF-8 the format accepted by the API. Performed testing debugging and successful extraction.