4.7 lists the ability to use joins for API queries, but I can't find anything in the docs or in the API Explorer. Can someone point me to documentation or examples?


The JIRA Issue for this feature https://issues.civicrm.org/jira/browse/CRM-17795 reads

This adds support for joins in api.get operations to fetch information from more than one table.

It also adds ACL enforcement to the Contact and related (email, address, phone, etc) apis for get, create & delete actions.

The JIRA issue links to a couple of pull requests; pull request 7565 includes a comment that has screen shots and descriptions (and one join example).

  • Admittedly not a ton to go off of, but a start. Feb 13 '16 at 1:04

4.7.1 explorer includes the Join options and is reasonably intuitive. (4.7.0 did not.)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.