What does this add-on do?
Sage X3 Automations, to make the most of your system and optimize your time.
This add on was created with the purpose of facilitating the generation of a predefined structure in json, xml, csv, etc... with information available in SQL tables or views to be used in specific developments such as web service communications or file creation on the server.
This development consists of a parameterization function where various options are available to generate the content in the desired format and the call of the subprogram to execute the utility.
Function Export development
Sage X3 Automations, to make the most of your system and optimize your time.
The Export development function allows the user to define the structure of the generated content without the need for direct intervention in the code.
The function allows the user to define:
- SQL table/view with the information;
- Record filter;
- Record sorting;
- Server folder to save the generated file (if necessary);
- Generated file name (if necessary);
- Record separator in the template;
- Record update after exporting them
NOTE
Currently, the development is able to generate templates with up to 5 consecutive levels, with the possibility of increasing this number if necessary.
