Skip to main content

Getting the node body with the index method call - services module drupal 7

The api call to the index method i.e. http://domain/?q=endpoint/node returns an index of nodes (this call can be paged too. e.g. http://domain/?q=endpoint/node.json&page=2&pagesize=10 ).
It does not return the node body with it.
node body is in a separate table (field_data_body) table
I needed the index to contain the body too, which I can parse and display as a feed on my application.
I was looking at "services views" module but could not it to work.
So I hacked around and played around with the node_resource's index method to respond back with the join of the two tables and thus containing the node body for a given node id.

Code snippet:

function _node_resource_index($page, $fields, $parameters, $page_size) {
  module_load_include('inc', 'services', 'services.module');
  $start = (($page)-1)*$page_size;
  $query = db_select('node', 'n');
  $query->join('field_data_body', 'u', 'n.nid = u.entity_id'); //JOIN node with field_data_body to get node body
  $query->fields('n',array('title','created'))//SELECT the fields from node
    ->fields('u',array('body_value'))//SELECT the fields from field_data_body
    ->orderBy('created', 'DESC')//ORDER BY created
    ->range($start,$page_size);//LIMIT records if (!user_access('administer nodes')) {
}
  $result = services_resource_execute_index_query($query);
  return services_resource_build_index_list($result, 'node', 'nid');
  }

Comments

Popular posts from this blog

On working remote

The last company I worked for, did have an office space, but the code was all on Github, infra on AWS, we tracked issues over Asana and more or less each person had at least one project they could call "their own" (I had a bunch of them ;-)). This worked pretty well. And it gave me a feeling that working remote would not be very different from this. So when we started working on our own startup, we started with working from our homes. It looked great at first. I could now spend more time with Mom and could work at leisure. However, it is not as good as it looks like. At times it just feels you are busy without business, that you had been working, yet didn't achieve much. If you are evaluating working from home and are not sure of how to start, or you already do (then please review and add your views in comments) and feel like you were better off in the office, do read on. Remote work is great. But a physical office is better. So if you can, find yourself a co-working s

Capture and compare stdout in python unit tests

A recent fan of TDD, I set out to write tests for whatever comes my way. And there was one feature where the code would print messages to the console. Now - I had tests written for the API but I could not get my head around ways to capture these messages in my unittests. After some searching and some stroke of genius, here's how I accomplished capturing stdout.

AIT a.k.a Army institute of Technology

Been quite a while that I wrote anything. But I am glad, that I am back. Now that I am done with my submissions for my third year second semester (and that too right on time. Bang!), and 10 days right before the practicals start banging my head off, I am feeling a certain urge of writing about this place. AIT. Army Institute of Technology, Pune. But how could I end up writing a post on AIT . I should instead be doing something else . Anything …sleeping , rope-skipping, play gilli danda , dancing or doing anything more worthwhile. But NO! My idiotic , uncontrollable , insensible , psychotic and involuntary mind could think of doing nothing else when I was getting the urge to write this senseless post. But as I am a man of my words [huh ? What words ? Half the time I don’t even know what I speak] . MAN AM GOING CRAZY THESE DAYS . I blame this summer heat for turning me crazy with the utter joy of timely submissions, So I am going to write something on AIT. Mighty mighty AIT they s