Getting more data from hook_civicrm_contactListQuery

[DerekL]

I have a custom query set up in my module using the contactListQuery hook, it works just fine (sql query matching and returning all fields I'm interested in, but I am having a bit of trouble figuring out how to actually get more than just the two "contact id and sort_name" fields returned via the request. Is this possible?

I am creating a mod to the event participant add page. It has a contact field with autocomplete. Once a contact of type individual is selected, I am trying to get the contact's id, then its employee of id, the employer's membership id, membership type id, and membership type name.

If not, is there any other way to fetch this data via ajax so that I can populate the fields?

Any help would be apprecaited, thank you.

[xavier]

Hi,

I would use the api.contact.get (set the return=sort_name,organization_name...) Not sure if you can get directly the membership, use the api explorer and check out what the membership api returns. You might need a second call

http://en.flossmanuals.net/civicrm-developer-guide/api/ and the blog post if you want to learn more about it.

X+

[DerekL]

Ok, that looks like it might work:

I'm looking at my /civicrm/api/explorer#/drupal7/civicrm/ajax/rest?json=1&debug=1&version=3&entity=Membership&action=get

which returns:

{
   "is_error":0,
   "version":3,
   "count":15,
   "values":{
      "1":{
         "id":"1",
         "contact_id":"49734",
         "membership_type_id":"2",
         "join_date":"2011-10-03",
         "start_date":"2011-10-03",
         "end_date":"2012-11-02",
         "status_id":"1",
         "is_test":"0",
         "is_pay_later":"0",
         "membership_name":"Corporate",
         "relationship_name":"Employee of",
         "custom_6":"2",
         "custom_6_1":"2",
         "custom_8":"5",
         "custom_8_-1":"5"
      },...all the way to value 15.


Is there a way to modify the ajax call with parameters in order to only limit the return to only those memberships with a matching contact_id? I'm only looking to for values on a specific membership at a time.

[DerekL]

Ok, I've gone a step further. I now have a button trying to pass the API call.

My problem is that the URL its going after is not correct.

My install is localhost/drupal7/civicrm.

http://localhost/civicrm/ajax/rest?version=3&contact_id=36049&entity=Membership&action=get&json=1

Where does the source path come from?

[xavier]

Are you using cj.crmAPI()? the 4th param allows you to set the base url.
eg.
{'ajaxURL': '/drupal7/civicrm/ajax/rest'} should work

as for the contact_id, should work if you simply put it in the second param {'contact_id':42}
X+

[DerekL]

Beautiful! Thanks Xavier. I was trying to pass ajaxURL via var options, as per the comments on rest.js, but that was leading me nowhere fast.

This is what the comments say on rest.js :

Code: [Select]

If you do not use clean urls on drupal, you have to define a variable to set the url of the server to be used for the rest
<script type="text/javascript">
var options {ajaxURL:"{$config->userFrameworkResourceURL}";
</script>

Here is my current, working test code, set to trigger on a button click, contact_id hardcoded for now. Its ugly as sin, and hard to work with... I'm wondering if there is a more elegant way to parse the result.

Code: [Select]

cj( function( ) {

cj('#getmembership').click(function() {
//ready for function to call on click event


  cj().crmAPI ('Membership','get',{'version' :'3', 'contact_id' : '36049'}
  ,{ 'ajaxURL': '/drupal7/civicrm/ajax/rest',
  success:function (data){
 
      cj.each(data, function(key, value) {
      if (key == 'values' ) {
      cj.each(value, function(key1,value1) {
       
      cj.each(value1, function(key2,value2) {
       
      alert(key2 + ': ' + value2);   
      });
      });
       
      }
      });
      }
//end function called on click event  
});
});
});