CiviCRM Community Forums (archive)

Hi all,

If I want to retrieve an event and its loc block, I can do this like this:

    $result = civicrm_api3('Event', 'getsingle', array(
    'sequential' => 1,
    'return' => "title,loc_block_id",
    'id' => 1500,
    'api.LocBlock.get' => array('id' => "\$value.loc_block_id"),
    ));
If the event has a loc block, this works:
    {
    "id":"1500",
    "title":"Startdag regio Oost-Vlaanderen 2007",
    "event_title":"Startdag regio Oost-Vlaanderen 2007",
    "loc_block_id":"169",
    // I omitted a lot of custom field results I didn't request.
    "price_set_id":"69",
    "api.LocBlock.get":{
    "is_error":0,
    "version":3,
    "count":1,
    "id":169,
    "values":[{
    "id":"169",
    "address_id":"11018"
    }]
    }
    }
But if I do the same for an event that doesn't have a loc block:

    $result = civicrm_api3('Event', 'getsingle', array(
    'sequential' => 1,
    'return' => "title,loc_block_id",
    'id' => 1000,
    'api.LocBlock.get' => array('id' => "\$value.loc_block_id"),
    ));
The API returns an error:

    {
    "error_field":"id",
    "type":"integer",
    "error_code":2001,
    "entity":"Event",
    "action":"get",
    "is_error":1,
    "error_message":"Error in call to LocBlock_get : id is not a valid integer"
    }
I guess the fact that this event has no loc block id causes the chaining to fail. But is this error message expected? Or is this a bug, and should the API return
    {
    "id":"1000",
    "title":"IK ZENNEVALLEI 2011",
    "event_title":"IK ZENNEVALLEI 2011",
    "is_error":0,
    "api.LocBlock.get":{
    "is_error":0,
    "version":3,
    "count":0,
    "values":[]
    }
    }

I created an issue: https://issues.civicrm.org/jira/browse/CRM-16168