Execute SMQL Query With Eager Loading
|
Method
|
GET
|
|
URL
|
/v2/query?q=select *,io_owner.* from io_showcase order by io_created_on desc
|
|
Parameters
|
q
|
|
Response Content Type
|
application/json
|
Example Response
The response is a JSON representation of the record and the related io_owner field eager-loaded as a record. Following is an example Status Code 200 response for a Showcase record.
{
"__object_identifier": "io_showcase",
"io_showcase_phone_number": "+1 (925) 965-7859",
"io_search_filter_file_object": null,
"io_owner": {
"__object_identifier": "io_user",
"io_updated_by": "764f0869-8b2a-4e43-8f23-88f593863eff",
"io_active": true,
"io_tags": null,
"io_description": null,
"io_last_name": "Techmann",
"io_username": "scott",
"io_overrides": null,
"io_first_name": "Scott",
"io_deleted": false,
"io_private": false,
"io_full_name": "Scott Techmann",
"io_last_login_on": "2016-11-28T17:46:55.532-03:00",
"io_platform_changes_permitted": null
.
.
.
}
"io_showcase_document": null,
"io_private": false,
"io_platform_changes_permitted": null.
.
.
}
"__object_identifier": "io_showcase",
"io_showcase_phone_number": "+1 (925) 965-7859",
"io_search_filter_file_object": null,
"io_owner": {
"__object_identifier": "io_user",
"io_updated_by": "764f0869-8b2a-4e43-8f23-88f593863eff",
"io_active": true,
"io_tags": null,
"io_description": null,
"io_last_name": "Techmann",
"io_username": "scott",
"io_overrides": null,
"io_first_name": "Scott",
"io_deleted": false,
"io_private": false,
"io_full_name": "Scott Techmann",
"io_last_login_on": "2016-11-28T17:46:55.532-03:00",
"io_platform_changes_permitted": null
.
.
.
}
"io_showcase_document": null,
"io_private": false,
"io_platform_changes_permitted": null.
.
.
}
 |
Each returned record includes the __object_identifier pseudo-field, which contains the full identifier of the object to which the record belongs. In this case, the related field io_owner is also expanded as an inner record, and also includes the __object_identifier pseudo-field that points to an instance of the User object.
|
For more information: