ETL-Tool: transforming table data to json objects and calling Rest Api possible? #14884
Unanswered
magoralczyk
asked this question in
Help
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I want to build an app, where my input data are some 2-dimensional tables (like csv or google spreadsheet). Every table represents an entity and every row one object. I want to transform all rows of all tables into more complex json documents and use an existing rest api to store all of them via post http calls.
So, after the trigger event fires, all tables would have to be loaded into budibase, then iterating through all tables, iterating through all rows of every table, transforming the current row to json and calling the rest api to export/save the transformed object externally.
This would be kind of an ETL Tool (extract-transform-load) for a specifc use case.
Could budibase be the right tool for my use case?
How would I organize the project? Where would my loops over tables and rows be?
How would I map my input data into building mor compex json objects (some values maybe fixed, others from my input row, mapped into deeper structures with subobjects containing arrays and so on.)
Beta Was this translation helpful? Give feedback.
All reactions