318
Views
12
Comments
is there any way to download all the entities and their attribute names to json/excel

Is there any way to download all the entities and their attributes (not the table data) from an outsystems application in a convienent format like json/excel , i have more than 50 entities in my application and would like to see at a glance which entity has which attributes?

2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP

Hi,

You can use the metadata entities available in the system module or use the OutSystems Forge component Outdoc.

Regards,

Daniel

UserImage.jpg
SS27

how do i access the metadata entities in system module and how do i download them? i can only view the entities and attributes in the system module


2023-10-21 19-42-11
Tousif Khan
Champion

Hello,
You need to add the dependencies from the Systems Module

And to download you can just get the data and download the data using Record to excel by creating a logic.

I am attaching an OML for the reference hope it might help

https://personal-ejuytnht.outsystemscloud.com/SamplePOC_s/SampleDownload?_ts=638101666767605267

I hope this helps
Thanks

SamplePOC_EntityToExcel.oml
UserImage.jpg
SS27

I can't add the server action because i can't publish it in the current environment i am in without affecting others working on it. Is there any other work around ?

2023-10-21 19-42-11
Tousif Khan
Champion

If you want to export the data, this the only way you can do that.

If you want to just view the data then add the entity and apply your desired filters to preview data into aggregate, But here if you want to Export the data you need to add your logic and export.

Thanks

UserImage.jpg
SS27

the format of the data is not desirable at all. i don't want the physical table names and everything. Just simply the entity name and the attributes which are present in it

2023-10-21 19-42-11
Tousif Khan
Champion

Hi ,

you can just modify the oml and on the record list to excel just select the Entity name, not all the attributes it will only return you names, I have showed you just an example, so that you may have an idea to get the details of the entity names, you can further modify it according to your desired output .

2021-10-09 07-57-44
Stefan Weber
 
MVP

In addition to the above mentions you may find OutDoc helpful which generates a report (not that beautiful *sigh*) for your applications. Available on the Forge https://www.outsystems.com/forge/component-overview/159/outdoc

UserImage.jpg
SS27

thanks for outdoc though, it is not opening in my dev environment 

2023-01-23 00-22-07
Elizer

Hi,

I suggest taking a look at this forge component, Hubway connect. This application has many features including viewing and managing API's and generating reports and dashboards . Hope this helps.

https://www.outsystems.com/forge/component-overview/13087/hubway-connect

Youtube demo:

https://www.youtube.com/watch?v=fNgd1D6eX9c

Thank you and Regards,

Elizer

EDIT by moderator: the above is a paid component with a 30-day free trial.

UserImage.jpg
SS27

Elizer please don't advertise products here. Some of us are learners and can't afford such things. Thanks

2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi Satvik,

I don't think there's something wrong with advertising something that's part of the OutSystems ecosystem. Even learners may be part of a company that can afford to buy a licence, and the component has a 30-days free trial. The only thing I would've liked to be seen is an indication that it is a paid component.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.