Q: I did a export to file and now how can I get the result zip file?
A: You should use the API GetExecutionOutputs, with the parameter IncludeFile set to true and the file will be sent as a zip base64 encoded in the field ZipFile.
Q: The header X-DMM-Token-OTP is just needed in the StartExecution request?
A: Yes, this is a second authentication factor that is only needed to start a new execution. This value can be found in the Authentication Token page, this works as a double security validation and also to avoid starting a new execution by mistake.
Q: I did an export and in the entity data the text fields have a N' appended. Why this is happening and how can I removed it?
A: That N' char is being added to text fields because the export is being made so it could be later imported into OutSystems using DMM API. To avoid having those changes to the data, if for example the export is to be loaded in a non-OutSystems analytics database, you have to run the Export with the configuration parameter ExportPlain with true.
Q: How can I get a import zip file to fill with some data and import later?
A: You can use the StartExecution request with the type Export. In the configuration, you need to select all the entities that you want to insert later and in the field OnlyExportStructure set the value true, this way DMM will just export the metadata, without any entity record. After the export execute, you can use the GetExecutionOutputs to download the result zip file and fill with the data that you need.