Hello, I have a big problem with the current address book example on df 2.7.0.1. The app is running fine, but I can’t retrieve the relations from a contact to contact info etc.
When I do the GET /api/v2/db/_table/contact/1?related=contact_infos_by_contact_id,contact_groups_by_contact_group_relationship described in https://wiki.dreamfactory.com/DreamFactory/Features/Database/Related_Data via the API DOCs page I never get any of the relations.
This should be the answer:
{
“record”: [
{
“id”: 1,
“first_name”: “Jon”,
“last_name”: “Yang”,
“display_name”: “Jon Yang”,
…
“reports_to”: null,
“contact_infos_by_contact_id”: [
{
“id”: 1,
“contact_id”: 1,
“info_type”: “home”,
“phone”: “500 555-0162”,
“email”: "jon24@Home.com",
“address”: “3761 N. 14th St”,
“city”: “MEDINA”,
“state”: “ND”,
“zip”: “58467”,
“country”: “USA”
},
{
“id”: 2,
“contact_id”: 1,
“info_type”: “work”,
“phone”: “500 555-0110”,
“email”: "jon24@Work.com",
“address”: “2243 W St.”,
“city”: “MEDINA”,
“state”: “ND”,
“zip”: “58467”,
“country”: “USA”
}
],
“contact_group_relationships_by_contact_id”: [
{
“id”: 1,
“contact_id”: 1,
“contact_group_id”: 7
}
],
“contact_groups_by_contact_group_relationship”: [
{
“id”: 7,
“name”: “Mid West”
}
]
}
]
}
This is what I get:
{
“id”: 1,
“first_name”: “Jon”,
“last_name”: “Yang”,
“image_url”: “”,
“twitter”: “@jon24”,
“skype”: “jon24”,
“notes”: “”
}
When I take a look into the sql tables, all looking fine. There are 3 entries in the contact_info table related to entry #1.
What is wrong with the address book example app?
Kind regards, Chris