Empty or no value, JSON Service always returns empty array

you can try a custom module...

function mymodule_services_views_execute_view_alter(&$output, $view) {
  if ($view->name == 'my_view' && $view->current_display == 'myview') {
    // Make sure we have results.
    if (empty($output) && !is_array($output)) {
      return;
    }

    // Loop trough all rows.
    foreach ($output as &$row) {
      foreach ($row as $field_name => $field_value) {
        // Replace all empty values with an empty string.
        if (empty($field_value) && strpos($field_name, 'field') === FALSE) {
          $row->$field_name = '';
        }
      }
    }
  }
}

thx! it's work for me

It should actually be:

function mymodule_services_views_execute_view_alter(&$output, $view) {
  if ($view->name == 'my_view' && $view->current_display == 'my_display') {
    // Make sure we have results.
    if (empty($output) || !is_array($output)) {
      return;
    }
    // Loop trough all rows.
    foreach ($output as &$row) {
      foreach ($row as $field_name => $field_value) {
        // Replace all empty arrays with an empty string.
        if (empty($field_value)) {
          $row->$field_name = '';
        }
      }
    }
  }
}

The part with strpos($field_name, 'field_name') === FALSE) was only making sure that 'field_name' is not being altered and most probably is not needed. But in some cases a field should always return an object, for example a double field.

@ajlow is this hook not being called at all, or the results are not altered?

Mihai

@ajlow,

I downloaded/installed:
Drupal 7.19
Services (services) 7.x-3.5
Services Views (services_views) 7.x-1.0+4-dev

Implemented custom module:

function MYMODULE_services_views_execute_view_alter(&$output, $view) {
  print_r($output);
}

On my views endpoint I also get the printed output.
So I assume you are doing something wrong ... :)

Mihai

Excellent work Mihai :)

@mihai_brb Should'nt it be excluding the empty fields (or arrays) completely? Even fields that are specifically 'Excluded from display' show up..

In instead of setting them to an empty string -

        if (empty($field_value)) {
          unset($row->$field_name);
        }

This works with the views preview but in the json output the empty fields are still there.

@mesh I didn't wanted to unset empty values, because the system accessing this endpoint assumes those keys are always sent, even empty. isset() is not that easy to implement in some programming languages.

Mihai

Simple patch to the module fix that issue by setting the to $target_key = '' instead of array if cardinality = 1

The patch provided in #11 solves the issue!!! ( tested on 7.x-1.1). Thanks for the good work.

#11 solved my problem too!
Thanks ;)

+1 for #11 patch.

Is this issue specific to Service_views module?
Because I face this problem when I login a user using Services module. (I have custom fields in User Profile).
Can someone please confirm?
If this needs to be fixed with Services module, I'll create a bug for Services module.

The patch does not work if the module is installed in other folder than sites/all/modules. I have changed the paths on the patch file so now is working with another installation folders as in a profile.

#16 worked for me. Thanks @earelin