{"id":6903,"date":"2018-12-22T02:17:20","date_gmt":"2018-12-21T18:17:20","guid":{"rendered":"https:\/\/www.microdium.net\/public\/doql-howto-w-data-dictionary-entity-relationship-diagram\/"},"modified":"2018-12-22T02:17:20","modified_gmt":"2018-12-21T18:17:20","slug":"doql-howto-w-data-dictionary-entity-relationship-diagram","status":"publish","type":"post","link":"https:\/\/www.microdium.com\/public\/2018\/12\/22\/doql-howto-w-data-dictionary-entity-relationship-diagram\/","title":{"rendered":"DOQL HowTo w\/ Data Dictionary &#038; Entity Relationship Diagram"},"content":{"rendered":"<p>Device42 DOQL is a powerful query language that uses familiar PostgreSQL-compatible syntax to provide access to the D42 database both via https &amp; the RESTful API. <\/p>\n<p>This Dec 2018 (2019) video update includes a quick API-based query demo using Postman &amp; shows users how to find the Viewer Schema which is comprised of the ERD (entity relationship diagram) and Data dictionary, both of which live in the help menu.<\/p>\n<p>For more info, see the Device42 DOQL docs @ <a target=\"_blank\" href=\"https:\/\/docs.device42.com\/device42-doql\/\" rel=\"noopener\">https:\/\/docs.device42.com\/device42-doql\/<\/a><\/p>\n<p>New to Device42? Learn more at <a target=\"_blank\" href=\"https:\/\/device42.com\" rel=\"noopener\">https:\/\/device42.com<\/a> and grab a free trial in the upper right-hand corner while you&#8217;re there!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Device42 DOQL is a powerful query language that uses familiar PostgreSQL-compatible syntax to provide access to the D42 database both via https &amp; the RESTful API. This Dec 2018 (2019) video update includes a quick API-based query demo using Postman&hellip;<\/p>\n","protected":false},"author":1,"featured_media":6904,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[278,606,282,607,146,283,608,609,371,292,610],"class_list":["post-6903","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-videos","tag-api","tag-data-dictionary","tag-database","tag-db","tag-device42","tag-doql","tag-entity-relationship-diagram","tag-erd","tag-how-to","tag-query","tag-viewer-schema"],"_links":{"self":[{"href":"https:\/\/www.microdium.com\/public\/wp-json\/wp\/v2\/posts\/6903","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microdium.com\/public\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microdium.com\/public\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microdium.com\/public\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microdium.com\/public\/wp-json\/wp\/v2\/comments?post=6903"}],"version-history":[{"count":0,"href":"https:\/\/www.microdium.com\/public\/wp-json\/wp\/v2\/posts\/6903\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microdium.com\/public\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.microdium.com\/public\/wp-json\/wp\/v2\/media?parent=6903"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.microdium.com\/public\/wp-json\/wp\/v2\/categories?post=6903"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microdium.com\/public\/wp-json\/wp\/v2\/tags?post=6903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}