Byte Array data from API to Excel file that can be imported
Is it possible for Mendix to do the following: 1. Read a string from a REST API and convert it to a byte array? The original byte array is from an excel file that is stored in a SQL database that is converted to JSON via the API. 2. Take that byte array and convert it to an Excel file that can then be imported into the database
I think, you might have to write a java code for converting the string into a byte array.
or you can use non persistent objects and you can use it in REST post.
For converting it into the excel file you can make a use of Mx Model Reflection or excel importer