{"id":2631,"date":"2017-03-11T06:41:50","date_gmt":"2017-03-10T22:41:50","guid":{"rendered":"https:\/\/www.microdium.net\/public\/device42-obejct-query-language-doql-howto\/"},"modified":"2017-03-11T06:41:50","modified_gmt":"2017-03-10T22:41:50","slug":"device42-obejct-query-language-doql-howto","status":"publish","type":"post","link":"https:\/\/www.microdium.com\/public\/2017\/03\/11\/device42-obejct-query-language-doql-howto\/","title":{"rendered":"Device42 Obejct Query Language (DOQL) HowTo"},"content":{"rendered":"<p>Today we&#8217;ll use Postman to send GET calls to the new DOQL endpoint in Device42, demonstrating queries that return:<br \/>\n1) All Asset Numbers in Device42<br \/>\n2) All Asset Numbers in Device42, removing empty sets, and<br \/>\n3) All Assets with a Custom Field of &#8220;IPMI_Firmware&#8221; Where the Asset Number is not blank.<\/p>\n<p>If you know SQL, you already know DOQL! Send standard PostgreSql syntax to the Device42 database via the API!<\/p>\n<p>Download the Device42 appliance today @ <a target=\"_blank\" href=\"http:\/\/www.device42.com\/download\/\" rel=\"noopener\">http:\/\/www.device42.com\/download\/<\/a> and find about 90% of your infrastructure in about 90 minutes!<\/p>\n<p>Please leave any questions, comments, or requests for new HowTo&#8217;s below!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today we&#8217;ll use Postman to send GET calls to the new DOQL endpoint in Device42, demonstrating queries that return: 1) All Asset Numbers in Device42 2) All Asset Numbers in Device42, removing empty sets, and 3) All Assets with a&hellip;<\/p>\n","protected":false},"author":1,"featured_media":2632,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[276,277,278,279,280,281,282,146,283,284,285,286,287,288,289,290,291,292,75,293,294],"class_list":["post-2631","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-videos","tag-against","tag-all","tag-api","tag-asset","tag-asset_no","tag-call","tag-database","tag-device42","tag-doql","tag-get","tag-language","tag-numbers","tag-object","tag-postgres","tag-postgresql","tag-postgressql","tag-postman","tag-query","tag-sql","tag-standard","tag-syntax"],"_links":{"self":[{"href":"https:\/\/www.microdium.com\/public\/wp-json\/wp\/v2\/posts\/2631","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=2631"}],"version-history":[{"count":0,"href":"https:\/\/www.microdium.com\/public\/wp-json\/wp\/v2\/posts\/2631\/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=2631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.microdium.com\/public\/wp-json\/wp\/v2\/categories?post=2631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microdium.com\/public\/wp-json\/wp\/v2\/tags?post=2631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}