Expand all | Collapse all

Getting any data about forms (or reports) from the API

  • 1.  Getting any data about forms (or reports) from the API

    Posted 04-30-2019 06:35
    I've seen this issue discussed a little bit before, but wanted to know if anyone has found a way to get information about forms (especially dynamic form rules) or reports through the API or other automate-able means.

    My ideal would be something like the API capabilities for fields, where you can get a list of fields and their properties and add, edit, or remove them all through the API. Something where you could actually back up and restore your forms/reports or programmatically edit them

    I would be happy enough though with just being able to get a list of form and report names and any properties would be a bonus. It would be nice to be able to periodically get a count of forms and reports to get insight into which apps are growing in complexity.

  • 2.  RE: Getting any data about forms (or reports) from the API

    Posted 04-30-2019 23:56
    So part of your question is possible in the API, others are 'possible' through much more complicated, non-api means.

    You can use API_GetSchema against individual tables - and the response will kick back a list of reports, and you can parse out what reports exist in each table. 

    As for forms and dynamic form rules, nothing in the API to date has provided that option. That being said - depending on how fancy you are with true development - you could theoretically set up an automated process that scrapes that page for you on a schedule. Basically set up a process in Node JS for example, and using a headless browser, navigate to the form elements and parse out the fields on the page. Its not as clear cut as the API - but theoretically possible.

    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base