2023 Apr 19 7:48 AM
How to combine different document type in a custom view creation in Operational reporting view management?
2023 Apr 19 10:06 PM
Depending on the documentType, the join must be done on your own (after data is extracted, stored on your own DB).
Using parameter includePrimaryKeys = true and includeForeignKeys = true during metadata call should indicate whether the field is a PK or FK.
As of now, the list is incomplete though, only Analytical Reporting API has a complete PK/FK.
Usually UniqueName field of object is the PK.
2023 Apr 19 10:06 PM
Depending on the documentType, the join must be done on your own (after data is extracted, stored on your own DB).
Using parameter includePrimaryKeys = true and includeForeignKeys = true during metadata call should indicate whether the field is a PK or FK.
As of now, the list is incomplete though, only Analytical Reporting API has a complete PK/FK.
Usually UniqueName field of object is the PK.
2023 Apr 20 9:58 AM