topic Re: Get app data model using API in Integration, Extension & APIs

Get app data model using API

Mauritz_SA — Tue, 05 Nov 2019 12:25:27 GMT

Hi everyone

Is there any way to get the data model of an app using the REST APIs? I am currently working with PostMan. I would like to pass it the app id and get a response with the tables, their fields and the key's between different tables if possible.

Please let me know if anything is unclear and I'll gladly elaborate.

Regards,

Mauritz

Re: Get app data model using API

hrigner — Wed, 06 Nov 2019 09:17:31 GMT

Hi Mauritz,

If you just want to explore/validate the data model you can use catwalk , a tool very useful when you want to explore your data model for whatever reason. It's open source, and the source code can be found on GitHub .

It might however not be the answer to your question, depending on what you want the data model for. 🙂

Best Regards,

Helene

Re: Get app data model using API

Mauritz_SA — Wed, 06 Nov 2019 10:23:14 GMT

Hi Helene

Thanks so much for the feedback. We have an OEM solution where we have a stream per client and a standard app which is published to all clients. We have many fields available in the QVDs (data layer) that can get loaded, but what is important to one is not necessarily to another. My idea is to have the full possible data model in a main app (template/standard app) and then having the clients select which fields they want in their version of the published app. We are already doing this using Excel files, but this is obviously not scalable as we need to update all of the Excel files when adding a field. We are now moving this to an external application (rather than Excel files). I would ideally like to extract the QS template app's data model using the external application. I can then use this to populate the choices that we expose to the client dynamically, rather than having to update the choices manually.

I'll have a look at Catwalk to see what they do :).

Maybe someone else has an easy example that I can piggy back off.

Regards,

Mauritz