Using the API to return the PQL or MDX of a Formulate
I have a need to retrieve a list of formulas from our instance that includes the name, description and the actual logic for documentation purposes. I have figured out how to get the first two items from the repository tables but the logic is embedded in a JSON column that looks a bit too tricky to extract. What we are looking for is the information typically shown in the Syntax Preview tab in Formulate. I stumbled across this API in the documentation and I am wondering if it returns what I am looking for:
It claims to return the PQL or MDX representation of the formulate object. There is no sample of what the output looks like so I am wanting some confirmation that this is what I want before figuring out how to implement the code.
For example, let's say I have a custom formula/measure that is defined as a ratio and was built in Formulate using the Growth template in the Marketplace (A-B)/A. Would this API call return the actual column names seen in the Syntax Preview?
