AnsweredAssumed Answered

Relationship List as JSON

Question asked by user28311 on Feb 6, 2019
Latest reply on Feb 6, 2019 by PeterDoern

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 ?


Thanks !