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.

15 minutes of courage

"I Quit" , said she and walked out as briskly as she could, her face as stern as a stone. She didn't look back. I wanted her to. I felt helpless, somewhat creepy, and a sudden chill went down my spine. I didn't know what to do. I wanted to just run away. Run away from her. Run away from this world. Run away to some distant place where I could be myself. Some place where I could cry to my heart's content. But I was not one of those who would leave the ground, wounded! I had always been the one who took life head on. So was it the time to lean back and contemplate what actually went wrong? No. That won't be the man, the world knew! So.. was it the time to build a castle around my feelings and play cold? ~ Prince Mishra