Loopback - EmbedsOne relation producing error

Question

I have following two models

Nurse

Room

A room has belongsTo relation with the nurse model as defined below:

"relations": {
        "nurse": {
            "model": "Nurse",
            "type": "belongsTo",
            "foreignKey": "nid"
        }
    }

which works fine and produces the data on following urls

http://localhost:3000/api/Rooms/1

http://localhost:3000/api/Rooms/1/nurse

but when I try the embedsOne relation as defined below:

"relations": {
        "nurse": {
            "model": "Nurse",
            "type": "embedsOne",
            "foreignKey": "nid"
        }
    }

and try accessing url at

http://localhost:3000/api/Rooms/1

I get the following error:

message: "ER_BAD_FIELD_ERROR: Unknown column '_nurse' in 'field list'",

thoughts?

user_7018499 · Answer

"relations": {
  "address": {
    "type": "embedsOne",
    "model": "Address",
    "property": "billingAddress"
  }
}

then your object will look like

 {
  id: 1,
  name: 'John Smith',
  billingAddress: {
    street: '123 Main St',
    city: 'San Jose',
    state: 'CA',
    zipCode: '95124'
  }
}