Empty data in the response

[pods13]

Hi!
I'm facing a problem that request are returning empty data.
For example:
my mongodb collection:
{ "_id" : "1", "name" : "Moscow" }, { "_id" : "2", "name" : "London" }
cities resource:

'use strict';

const jsonApi = require('jsonapi-server'),
    Joi = jsonApi.Joi;

const MongoHandler = require('jsonapi-store-mongodb');

module.exports = {
    resource: 'cities',
    handlers: new MongoHandler({
        url: "mongodb://localhost:27017/data",
    }),
    attributes: {
        name: Joi.string(),
    }
};

After this request:
http://localhost:4000/cities
I am getting this:
{"jsonapi":{"version":"1.0"},"meta":{"page":{"offset":0,"limit":50,"total":2}},"links":{"self":"/cities"},"data":[],"included":[]}
For some reason total==2 but api isn't providing any data.
Maybe something is wrong with the structure of my collection?

Many thanks in advance.

[pmcnr-hx]

Hi @alta0815. The first issue I am noticing with the code sample provided above is that you're not using jsonApi.define to define your resource (documentation here) for reference. I also recommend you have a look at the example server in the jsonapi-server project. Let us know if you still can't make any progress after this.

[pods13]

I'm adding my full code sample to this rep https://github.com/pod-proteinom/rb-api/ . I have no idea why it's not working.

[pmcnr-hx]

Hi @alta0815, I have had a look at your code above. You are not calling jsonApi.define to defined your resources. Please read the resources documentation and have a look at the example server in the jsonapi-server project which should make clear how to use this module.

[pods13]

And what is this https://github.com/pod-proteinom/rb-api/blob/master/src/index.js#L12 ?

[pmcnr-hx]

I am afraid I didn't notice that, since it wasn't where I expect it to be. I'll try to have another look at your code later. It's probably something fairly straightforward. Meanwhile if you run your server with the DEBUG='jsonApi:* environment variable set (see full documentation for details), you'll get detailed debug information printed to the console which will probably point you in the right direction.

[pods13]

Hi) I'm trying to run my code sample with the DEBUG=jsonApi:handler:*
I am getting next in the console output:

jsonApi:handler:search {"type":"cities","page":{"offset":0,"limit":50}} +0ms [
null,[{"name":"Moscow"},{"name":"London"}],2]

As far as I can see results.resultSet([{"name":"Moscow"},{"name":"London"}]) and results.totalRows(2) contain correct data.
So, maybe a problem is in the jsonapi-server?

[footniko]

@alta0815, I've faced with the same issue. Try to insert the data into your DB using POST request:

{"data":{"type":"cities","attributes":{"name":"Kiev"}}}

It will be inserted correctly in such case and then you'll be able to GET expected results.

[ju-Skinner]

Since there is no id in the returned data, it is being omitted. Add a key to your data named id: with any value and you will see your data being returned.

[rhettl]

Hello, I was having this issue until a moment ago. The key was DEBUG=jsonApi:*

I needed to add id : Joi.string() and, since my data was populated via mongoose, __v: Joi.number() (for object version)

Thank you, Have a wonderful day.