As a Integrator builder, I want to be efficient with my usage of extracts from cloud based systems.
Right now, I need to define a specific json or xml schema for each rest connection.
What would be great is if Integrator could automatically assign columns to the jason/xml extract, and that these columns were dynamic. So if the REST connection changes, the json automatically adjusts to show the correct columns.
It is currently time consuming to define every column in the json schema every time. What would be more efficient is for Integrator to dynamically define the json into a table format. It would be ok if there were limitations as to the levels and file definition that it could accept to transform the data.
Some links that explain more about transforming json to tables:
A chrome extension that converts a json to a table dynamically
https://chrome.google.com/webstore/detail/json-as-table-viewer/khclkgjdjddedohnomokbhinlmpclick
https://huongdanjava.com/convert-json-to-csv-using-jackson-library.html
https://www.baeldung.com/java-json
