I realize that the DDR can output a RelationshipList containing all the TO in a file with
LeftTable , Predicate, and RightTable values.
Right now I have to transform the DDR XML to JSON in order to generate a data model chart using d3js.
I am looking for an in-FileMaker automated alternative method for getting the relationships as JSON without a plugin or any other external tools.
Is there a SQL query that can be executed to produce this data ?