Export to csv
I’m pretty new to Collibra workflows. I am trying to list all of the assets in our Collibra system. I have all the APIs to retrieve the data. Where I am stuck is how to write the data to a csv file so I can load it into Excel. I checked the marketplace and did not find anything doing that.
Any direction would be appreciated.
Thanks!
michaelwalter
Posted 4 years ago · Edited 1 year ago·Last reply 4 years ago
5 comments
jennifertemple
·4 years ago · EditedCheck out the MetaModel Usage report in marketplace - this workflow has a create excel file component to it that I have re-used to create other excel files from metadata I have pulled from Collibra.
Former User
·4 years ago · EditedNice recommendation @jennifer_bauer_temple.baxter.com ! My response is not about the mechanics of doing it, but making sure you should do it. As a metadata hub the platform surpasses any collection of spreadsheets. Perhaps think of ways to bring your audience to the platform, so they can get more interested / excited about what it can do. In my experience, it’s a chance to fire their imaginations and my audience often comes up with high-value applications for the platform that I hadn’t considered. If your metadata isn’t as complete or broad as you need it, think of creating some examples to illustrate the power of what you can do.
jennifertemple
·4 years ago · EditedIt is not as difficult as it looks (I too am new to workflows and have not written java type script in a very long time). Much of the code remains the same, only changing file names and the column headings and contents. I also just stumbled across this in the knowledge base area. I have not looked at it in detail and it is a bit old, but might also help. https://productresources.collibra.com/kb_article/export-dgc-terms-created-given-time-period-excel/ Good luck!
jennifertemple
·4 years ago · EditedCheck out the MetaModel Usage report in marketplace - this workflow has a create excel file component to it that I have re-used to create other excel files from metadata I have pulled from Collibra.
michaelwalter
OP4 years ago · EditedI think I did look at that and got completely lost
I will visit it again. Thanks for your response.