Back to Collection Items
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
DECLARE @queryParams int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @queryParams OUT
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'group_states', 'alert'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'name', 'tempor Ut sed velit'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'tags', 'host:host0'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'monitor_tags', 'service:my-app'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'with_downtimes', 'true'
EXEC sp_OAMethod @queryParams, 'UpdateInt', @success OUT, 'id_offset', -62147425
EXEC sp_OAMethod @queryParams, 'UpdateInt', @success OUT, 'page', 0
EXEC sp_OAMethod @queryParams, 'UpdateInt', @success OUT, 'page_size', 20
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Accept', 'application/json'
DECLARE @resp int
EXEC sp_OAMethod @http, 'QuickRequestParams', @resp OUT, 'GET', 'https://api.app.ddog-gov.com/api/v1/monitor', @queryParams
EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
RETURN
END
DECLARE @sbResponseBody int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @resp, 'GetBodySb', @success OUT, @sbResponseBody
DECLARE @jarrResp int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonArray', @jarrResp OUT
EXEC sp_OAMethod @jarrResp, 'LoadSb', @success OUT, @sbResponseBody
EXEC sp_OASetProperty @jarrResp, 'EmitCompact', 0
PRINT 'Response Body:'
EXEC sp_OAMethod @jarrResp, 'Emit', @sTmp0 OUT
PRINT @sTmp0
DECLARE @respStatusCode int
EXEC sp_OAGetProperty @resp, 'StatusCode', @respStatusCode OUT
PRINT 'Response Status Code = ' + @respStatusCode
IF @respStatusCode >= 400
BEGIN
PRINT 'Response Header:'
EXEC sp_OAGetProperty @resp, 'Header', @sTmp0 OUT
PRINT @sTmp0
PRINT 'Failed.'
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jarrResp
RETURN
END
EXEC @hr = sp_OADestroy @resp
-- Sample JSON response:
-- (Sample code for parsing the JSON response is shown below)
-- [
-- {
-- "type": "query alert",
-- "query": "avg(last_5m):sum:system.net.bytes_rcvd{host:host0} > 100",
-- "created": "1977-10-10T13:08:01.527Z",
-- "creator": {
-- "email": "eiusmod aliquip pariatur dolore",
-- "handle": "fugiat id sint",
-- "name": "elit in"
-- },
-- "deleted": "2015-07-16T18:46:50.390Z",
-- "id": 83649643,
-- "matching_downtimes": [
-- {
-- "id": 1625,
-- "end": 1412792983,
-- "scope": [
-- "env:staging"
-- ],
-- "start": 1412792983
-- },
-- {
-- "id": 1625,
-- "end": 1412792983,
-- "scope": [
-- "env:staging"
-- ],
-- "start": 1412792983
-- }
-- ],
-- "message": "adi",
-- "modified": "1973-08-05T09:10:13.718Z",
-- "multi": false,
-- "name": "My monitor",
-- "options": {
-- "aggregation": {
-- "group_by": "host",
-- "metric": "metrics.name",
-- "type": "count"
-- },
-- "device_ids": [
-- "firefox.tablet",
-- "mobile_small"
-- ],
-- "enable_logs_sample": true,
-- "enable_samples": true,
-- "escalation_message": "none",
-- "evaluation_delay": 27121357,
-- "group_retention_duration": "esse aliquip ullamco irure",
-- "groupby_simple_monitor": true,
-- "include_tags": true,
-- "locked": false,
-- "min_failure_duration": 0,
-- "min_location_failed": 1,
-- "new_group_delay": -9275927,
-- "new_host_delay": 300,
-- "no_data_timeframe": 58492166,
-- "notification_preset_name": "show_all",
-- "notify_audit": false,
-- "notify_by": [
-- "ut quis e",
-- "dolore elit"
-- ],
-- "notify_no_data": false,
-- "on_missing_data": "show_no_data",
-- "renotify_interval": null,
-- "renotify_occurrences": -27638100,
-- "renotify_statuses": [
-- "alert",
-- "warn"
-- ],
-- "require_full_window": true,
-- "scheduling_options": {
-- "evaluation_window": {
-- "day_starts": "04:00",
-- "hour_starts": 0,
-- "month_starts": 1
-- }
-- },
-- "silenced": {
-- "Ut_d_e": 94650378
-- },
-- "synthetics_check_id": "enim et tempor",
-- "threshold_windows": {
-- "recovery_window": "ipsum eiusmod",
-- "trigger_window": "ullamco"
-- },
-- "thresholds": {
-- "critical": -74585739.55469063,
-- "critical_recovery": -14449679.792215124,
-- "ok": 69468073.65422091,
-- "unknown": -35840527.53565459,
-- "warning": -78191860.79094723,
-- "warning_recovery": 30967604.742167816
-- },
-- "timeout_h": null,
-- "variables": [
-- {
-- "data_source": "rum",
-- "compute": {
-- "aggregation": "avg",
-- "interval": 60000,
-- "metric": "@duration"
-- },
-- "name": "query_errors",
-- "group_by": [
-- {
-- "facet": "status",
-- "limit": 10,
-- "sort": {
-- "aggregation": "avg",
-- "metric": "qui Ut cupidatat proid",
-- "order": "desc"
-- }
-- },
-- {
-- "facet": "status",
-- "limit": 10,
-- "sort": {
-- "aggregation": "avg",
-- "metric": "nostrud mollit",
-- "order": "desc"
-- }
-- }
-- ],
-- "indexes": [
-- "days-3",
-- "days-7"
-- ],
-- "search": {
-- "query": "service:query"
-- }
-- },
-- {
-- "data_source": "rum",
-- "compute": {
-- "aggregation": "avg",
-- "interval": 60000,
-- "metric": "@duration"
-- },
-- "name": "query_errors",
-- "group_by": [
-- {
-- "facet": "status",
-- "limit": 10,
-- "sort": {
-- "aggregation": "avg",
-- "metric": "ut non",
-- "order": "desc"
-- }
-- },
-- {
-- "facet": "status",
-- "limit": 10,
-- "sort": {
-- "aggregation": "avg",
-- "metric": "reprehenderit sint eu proident",
-- "order": "desc"
-- }
-- }
-- ],
-- "indexes": [
-- "days-3",
-- "days-7"
-- ],
-- "search": {
-- "query": "service:query"
-- }
-- }
-- ]
-- },
-- "overall_state": "Unknown",
-- "priority": 4,
-- "restricted_roles": [
-- "Ut",
-- "dolor ad Duis proident"
-- ],
-- "state": {
-- "groups": {
-- "ullamco2": {
-- "last_nodata_ts": -30657062,
-- "last_notified_ts": -69789968,
-- "last_resolved_ts": -40935564,
-- "last_triggered_ts": 63742261,
-- "name": "id",
-- "status": "Alert"
-- },
-- "voluptate_0c": {
-- "last_nodata_ts": 13097104,
-- "last_notified_ts": 53104444,
-- "last_resolved_ts": -69320667,
-- "last_triggered_ts": 27152807,
-- "name": "quis amet",
-- "status": "Alert"
-- }
-- }
-- },
-- "tags": [
-- "fugiat culpa aliqua consectetur",
-- "minim in"
-- ]
-- },
-- {
-- "type": "query alert",
-- "query": "avg(last_5m):sum:system.net.bytes_rcvd{host:host0} > 100",
-- "created": "1952-04-01T14:02:58.093Z",
-- "creator": {
-- "email": "esse ad veniam qui",
-- "handle": "nulla enim non",
-- "name": "ut reprehend"
-- },
-- "deleted": "2005-07-24T20:18:36.078Z",
-- "id": 14961847,
-- "matching_downtimes": [
-- {
-- "id": 1625,
-- "end": 1412792983,
-- "scope": [
-- "env:staging"
-- ],
-- "start": 1412792983
-- },
-- {
-- "id": 1625,
-- "end": 1412792983,
-- "scope": [
-- "env:staging"
-- ],
-- "start": 1412792983
-- }
-- ],
-- "message": "labore nulla",
-- "modified": "2013-05-28T22:30:26.014Z",
-- "multi": true,
-- "name": "My monitor",
-- "options": {
-- "aggregation": {
-- "group_by": "host",
-- "metric": "metrics.name",
-- "type": "count"
-- },
-- "device_ids": [
-- "chrome.tablet",
-- "firefox.laptop_large"
-- ],
-- "enable_logs_sample": false,
-- "enable_samples": true,
-- "escalation_message": "none",
-- "evaluation_delay": 48023490,
-- "group_retention_duration": "veniam eiusmod anim",
-- "groupby_simple_monitor": true,
-- "include_tags": true,
-- "locked": false,
-- "min_failure_duration": 0,
-- "min_location_failed": 1,
-- "new_group_delay": -78698406,
-- "new_host_delay": 300,
-- "no_data_timeframe": -29298203,
-- "notification_preset_name": "show_all",
-- "notify_audit": false,
-- "notify_by": [
-- "in labore irure reprehenderit",
-- "Ut ea"
-- ],
-- "notify_no_data": false,
-- "on_missing_data": "default",
-- "renotify_interval": null,
-- "renotify_occurrences": 88843653,
-- "renotify_statuses": [
-- "warn",
-- "no data"
-- ],
-- "require_full_window": false,
-- "scheduling_options": {
-- "evaluation_window": {
-- "day_starts": "04:00",
-- "hour_starts": 0,
-- "month_starts": 1
-- }
-- },
-- "silenced": {
-- "ut_8": -75892703
-- },
-- "synthetics_check_id": "ut et aute cupidatat",
-- "threshold_windows": {
-- "recovery_window": "dolor do",
-- "trigger_window": "pariatur"
-- },
-- "thresholds": {
-- "critical": -5336230.352944598,
-- "critical_recovery": 7945004.71738635,
-- "ok": -68115416.21610427,
-- "unknown": 89541673.34797806,
-- "warning": 66901483.96194494,
-- "warning_recovery": -39599171.26178945
-- },
-- "timeout_h": null,
-- "variables": [
-- {
-- "data_source": "rum",
-- "compute": {
-- "aggregation": "avg",
-- "interval": 60000,
-- "metric": "@duration"
-- },
-- "name": "query_errors",
-- "group_by": [
-- {
-- "facet": "status",
-- "limit": 10,
-- "sort": {
-- "aggregation": "avg",
-- "metric": "deserunt nisi mollit",
-- "order": "desc"
-- }
-- },
-- {
-- "facet": "status",
-- "limit": 10,
-- "sort": {
-- "aggregation": "avg",
-- "metric": "dolor pariatur",
-- "order": "desc"
-- }
-- }
-- ],
-- "indexes": [
-- "days-3",
-- "days-7"
-- ],
-- "search": {
-- "query": "service:query"
-- }
-- },
-- {
-- "data_source": "rum",
-- "compute": {
-- "aggregation": "avg",
-- "interval": 60000,
-- "metric": "@duration"
-- },
-- "name": "query_errors",
-- "group_by": [
-- {
-- "facet": "status",
-- "limit": 10,
-- "sort": {
-- "aggregation": "avg",
-- "metric": "l",
-- "order": "desc"
-- }
-- },
-- {
-- "facet": "status",
-- "limit": 10,
-- "sort": {
-- "aggregation": "avg",
-- "metric": "ut non",
-- "order": "desc"
-- }
-- }
-- ],
-- "indexes": [
-- "days-3",
-- "days-7"
-- ],
-- "search": {
-- "query": "service:query"
-- }
-- }
-- ]
-- },
-- "overall_state": "Unknown",
-- "priority": 3,
-- "restricted_roles": [
-- "ipsum laboris laborum incididunt",
-- "fugiat non est"
-- ],
-- "state": {
-- "groups": {
-- "Ut7": {
-- "last_nodata_ts": 21127128,
-- "last_notified_ts": 19208840,
-- "last_resolved_ts": 29022384,
-- "last_triggered_ts": -96682791,
-- "name": "ex tempor",
-- "status": "OK"
-- }
-- }
-- },
-- "tags": [
-- "dolor nulla dolore elit",
-- "consequat sunt in"
-- ]
-- }
-- ]
-- Sample code for parsing the JSON response...
-- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
DECLARE @json int
DECLARE @v_type nvarchar(4000)
DECLARE @query nvarchar(4000)
DECLARE @created nvarchar(4000)
DECLARE @v_Email nvarchar(4000)
DECLARE @Handle nvarchar(4000)
DECLARE @Name nvarchar(4000)
DECLARE @deleted nvarchar(4000)
DECLARE @id int
DECLARE @message nvarchar(4000)
DECLARE @modified nvarchar(4000)
DECLARE @multi int
DECLARE @name nvarchar(4000)
DECLARE @Group_by nvarchar(4000)
DECLARE @Metric nvarchar(4000)
DECLARE @v_Type nvarchar(4000)
DECLARE @Enable_logs_sample int
DECLARE @Enable_samples int
DECLARE @Escalation_message nvarchar(4000)
DECLARE @Evaluation_delay int
DECLARE @Group_retention_duration nvarchar(4000)
DECLARE @Groupby_simple_monitor int
DECLARE @Include_tags int
DECLARE @Locked int
DECLARE @Min_failure_duration int
DECLARE @Min_location_failed int
DECLARE @New_group_delay int
DECLARE @New_host_delay int
DECLARE @No_data_timeframe int
DECLARE @Notification_preset_name nvarchar(4000)
DECLARE @Notify_audit int
DECLARE @Notify_no_data int
DECLARE @On_missing_data nvarchar(4000)
DECLARE @Renotify_interval nvarchar(4000)
DECLARE @Renotify_occurrences int
DECLARE @Require_full_window int
DECLARE @Day_starts nvarchar(4000)
DECLARE @Hour_starts int
DECLARE @Month_starts int
DECLARE @Ut_d_e int
DECLARE @Synthetics_check_id nvarchar(4000)
DECLARE @Recovery_window nvarchar(4000)
DECLARE @Trigger_window nvarchar(4000)
DECLARE @Critical nvarchar(4000)
DECLARE @Critical_recovery nvarchar(4000)
DECLARE @Ok nvarchar(4000)
DECLARE @Unknown nvarchar(4000)
DECLARE @Warning nvarchar(4000)
DECLARE @Warning_recovery nvarchar(4000)
DECLARE @Timeout_h nvarchar(4000)
DECLARE @overall_state nvarchar(4000)
DECLARE @priority int
DECLARE @Last_nodata_ts int
DECLARE @Last_notified_ts int
DECLARE @Last_resolved_ts int
DECLARE @Last_triggered_ts int
DECLARE @Ullamco2Name nvarchar(4000)
DECLARE @Status nvarchar(4000)
DECLARE @Voluptate_0cLast_nodata_ts int
DECLARE @Voluptate_0cLast_notified_ts int
DECLARE @Voluptate_0cLast_resolved_ts int
DECLARE @Voluptate_0cLast_triggered_ts int
DECLARE @Voluptate_0cName nvarchar(4000)
DECLARE @Voluptate_0cStatus nvarchar(4000)
DECLARE @Ut_8 int
DECLARE @Ut7Last_nodata_ts int
DECLARE @Ut7Last_notified_ts int
DECLARE @Ut7Last_resolved_ts int
DECLARE @Ut7Last_triggered_ts int
DECLARE @Ut7Name nvarchar(4000)
DECLARE @Ut7Status nvarchar(4000)
DECLARE @j int
DECLARE @count_j int
DECLARE @v_end int
DECLARE @start int
DECLARE @k int
DECLARE @count_k int
DECLARE @strVal nvarchar(4000)
DECLARE @data_source nvarchar(4000)
DECLARE @Aggregation nvarchar(4000)
DECLARE @Interval int
DECLARE @computeMetric nvarchar(4000)
DECLARE @Query nvarchar(4000)
DECLARE @facet nvarchar(4000)
DECLARE @limit int
DECLARE @sortAggregation nvarchar(4000)
DECLARE @sortMetric nvarchar(4000)
DECLARE @Order nvarchar(4000)
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAGetProperty @jarrResp, 'Size', @count_i OUT
WHILE @i < @count_i
BEGIN
EXEC sp_OAMethod @jarrResp, 'ObjectAt', @json OUT, @i
EXEC sp_OAMethod @json, 'StringOf', @v_type OUT, 'type'
EXEC sp_OAMethod @json, 'StringOf', @query OUT, 'query'
EXEC sp_OAMethod @json, 'StringOf', @created OUT, 'created'
EXEC sp_OAMethod @json, 'StringOf', @v_Email OUT, 'creator.email'
EXEC sp_OAMethod @json, 'StringOf', @Handle OUT, 'creator.handle'
EXEC sp_OAMethod @json, 'StringOf', @Name OUT, 'creator.name'
EXEC sp_OAMethod @json, 'StringOf', @deleted OUT, 'deleted'
EXEC sp_OAMethod @json, 'IntOf', @id OUT, 'id'
EXEC sp_OAMethod @json, 'StringOf', @message OUT, 'message'
EXEC sp_OAMethod @json, 'StringOf', @modified OUT, 'modified'
EXEC sp_OAMethod @json, 'BoolOf', @multi OUT, 'multi'
EXEC sp_OAMethod @json, 'StringOf', @name OUT, 'name'
EXEC sp_OAMethod @json, 'StringOf', @Group_by OUT, 'options.aggregation.group_by'
EXEC sp_OAMethod @json, 'StringOf', @Metric OUT, 'options.aggregation.metric'
EXEC sp_OAMethod @json, 'StringOf', @v_Type OUT, 'options.aggregation.type'
EXEC sp_OAMethod @json, 'BoolOf', @Enable_logs_sample OUT, 'options.enable_logs_sample'
EXEC sp_OAMethod @json, 'BoolOf', @Enable_samples OUT, 'options.enable_samples'
EXEC sp_OAMethod @json, 'StringOf', @Escalation_message OUT, 'options.escalation_message'
EXEC sp_OAMethod @json, 'IntOf', @Evaluation_delay OUT, 'options.evaluation_delay'
EXEC sp_OAMethod @json, 'StringOf', @Group_retention_duration OUT, 'options.group_retention_duration'
EXEC sp_OAMethod @json, 'BoolOf', @Groupby_simple_monitor OUT, 'options.groupby_simple_monitor'
EXEC sp_OAMethod @json, 'BoolOf', @Include_tags OUT, 'options.include_tags'
EXEC sp_OAMethod @json, 'BoolOf', @Locked OUT, 'options.locked'
EXEC sp_OAMethod @json, 'IntOf', @Min_failure_duration OUT, 'options.min_failure_duration'
EXEC sp_OAMethod @json, 'IntOf', @Min_location_failed OUT, 'options.min_location_failed'
EXEC sp_OAMethod @json, 'IntOf', @New_group_delay OUT, 'options.new_group_delay'
EXEC sp_OAMethod @json, 'IntOf', @New_host_delay OUT, 'options.new_host_delay'
EXEC sp_OAMethod @json, 'IntOf', @No_data_timeframe OUT, 'options.no_data_timeframe'
EXEC sp_OAMethod @json, 'StringOf', @Notification_preset_name OUT, 'options.notification_preset_name'
EXEC sp_OAMethod @json, 'BoolOf', @Notify_audit OUT, 'options.notify_audit'
EXEC sp_OAMethod @json, 'BoolOf', @Notify_no_data OUT, 'options.notify_no_data'
EXEC sp_OAMethod @json, 'StringOf', @On_missing_data OUT, 'options.on_missing_data'
EXEC sp_OAMethod @json, 'StringOf', @Renotify_interval OUT, 'options.renotify_interval'
EXEC sp_OAMethod @json, 'IntOf', @Renotify_occurrences OUT, 'options.renotify_occurrences'
EXEC sp_OAMethod @json, 'BoolOf', @Require_full_window OUT, 'options.require_full_window'
EXEC sp_OAMethod @json, 'StringOf', @Day_starts OUT, 'options.scheduling_options.evaluation_window.day_starts'
EXEC sp_OAMethod @json, 'IntOf', @Hour_starts OUT, 'options.scheduling_options.evaluation_window.hour_starts'
EXEC sp_OAMethod @json, 'IntOf', @Month_starts OUT, 'options.scheduling_options.evaluation_window.month_starts'
EXEC sp_OAMethod @json, 'IntOf', @Ut_d_e OUT, 'options.silenced.Ut_d_e'
EXEC sp_OAMethod @json, 'StringOf', @Synthetics_check_id OUT, 'options.synthetics_check_id'
EXEC sp_OAMethod @json, 'StringOf', @Recovery_window OUT, 'options.threshold_windows.recovery_window'
EXEC sp_OAMethod @json, 'StringOf', @Trigger_window OUT, 'options.threshold_windows.trigger_window'
EXEC sp_OAMethod @json, 'StringOf', @Critical OUT, 'options.thresholds.critical'
EXEC sp_OAMethod @json, 'StringOf', @Critical_recovery OUT, 'options.thresholds.critical_recovery'
EXEC sp_OAMethod @json, 'StringOf', @Ok OUT, 'options.thresholds.ok'
EXEC sp_OAMethod @json, 'StringOf', @Unknown OUT, 'options.thresholds.unknown'
EXEC sp_OAMethod @json, 'StringOf', @Warning OUT, 'options.thresholds.warning'
EXEC sp_OAMethod @json, 'StringOf', @Warning_recovery OUT, 'options.thresholds.warning_recovery'
EXEC sp_OAMethod @json, 'StringOf', @Timeout_h OUT, 'options.timeout_h'
EXEC sp_OAMethod @json, 'StringOf', @overall_state OUT, 'overall_state'
EXEC sp_OAMethod @json, 'IntOf', @priority OUT, 'priority'
EXEC sp_OAMethod @json, 'IntOf', @Last_nodata_ts OUT, 'state.groups.ullamco2.last_nodata_ts'
EXEC sp_OAMethod @json, 'IntOf', @Last_notified_ts OUT, 'state.groups.ullamco2.last_notified_ts'
EXEC sp_OAMethod @json, 'IntOf', @Last_resolved_ts OUT, 'state.groups.ullamco2.last_resolved_ts'
EXEC sp_OAMethod @json, 'IntOf', @Last_triggered_ts OUT, 'state.groups.ullamco2.last_triggered_ts'
EXEC sp_OAMethod @json, 'StringOf', @Ullamco2Name OUT, 'state.groups.ullamco2.name'
EXEC sp_OAMethod @json, 'StringOf', @Status OUT, 'state.groups.ullamco2.status'
EXEC sp_OAMethod @json, 'IntOf', @Voluptate_0cLast_nodata_ts OUT, 'state.groups.voluptate_0c.last_nodata_ts'
EXEC sp_OAMethod @json, 'IntOf', @Voluptate_0cLast_notified_ts OUT, 'state.groups.voluptate_0c.last_notified_ts'
EXEC sp_OAMethod @json, 'IntOf', @Voluptate_0cLast_resolved_ts OUT, 'state.groups.voluptate_0c.last_resolved_ts'
EXEC sp_OAMethod @json, 'IntOf', @Voluptate_0cLast_triggered_ts OUT, 'state.groups.voluptate_0c.last_triggered_ts'
EXEC sp_OAMethod @json, 'StringOf', @Voluptate_0cName OUT, 'state.groups.voluptate_0c.name'
EXEC sp_OAMethod @json, 'StringOf', @Voluptate_0cStatus OUT, 'state.groups.voluptate_0c.status'
EXEC sp_OAMethod @json, 'IntOf', @Ut_8 OUT, 'options.silenced.ut_8'
EXEC sp_OAMethod @json, 'IntOf', @Ut7Last_nodata_ts OUT, 'state.groups.Ut7.last_nodata_ts'
EXEC sp_OAMethod @json, 'IntOf', @Ut7Last_notified_ts OUT, 'state.groups.Ut7.last_notified_ts'
EXEC sp_OAMethod @json, 'IntOf', @Ut7Last_resolved_ts OUT, 'state.groups.Ut7.last_resolved_ts'
EXEC sp_OAMethod @json, 'IntOf', @Ut7Last_triggered_ts OUT, 'state.groups.Ut7.last_triggered_ts'
EXEC sp_OAMethod @json, 'StringOf', @Ut7Name OUT, 'state.groups.Ut7.name'
EXEC sp_OAMethod @json, 'StringOf', @Ut7Status OUT, 'state.groups.Ut7.status'
SELECT @j = 0
EXEC sp_OAMethod @json, 'SizeOfArray', @count_j OUT, 'matching_downtimes'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @json, 'J', @j
EXEC sp_OAMethod @json, 'IntOf', @id OUT, 'matching_downtimes[j].id'
EXEC sp_OAMethod @json, 'IntOf', @v_end OUT, 'matching_downtimes[j].end'
EXEC sp_OAMethod @json, 'IntOf', @start OUT, 'matching_downtimes[j].start'
SELECT @k = 0
EXEC sp_OAMethod @json, 'SizeOfArray', @count_k OUT, 'matching_downtimes[j].scope'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @json, 'K', @k
EXEC sp_OAMethod @json, 'StringOf', @strVal OUT, 'matching_downtimes[j].scope[k]'
SELECT @k = @k + 1
END
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @json, 'SizeOfArray', @count_j OUT, 'options.device_ids'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @json, 'J', @j
EXEC sp_OAMethod @json, 'StringOf', @strVal OUT, 'options.device_ids[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @json, 'SizeOfArray', @count_j OUT, 'options.notify_by'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @json, 'J', @j
EXEC sp_OAMethod @json, 'StringOf', @strVal OUT, 'options.notify_by[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @json, 'SizeOfArray', @count_j OUT, 'options.renotify_statuses'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @json, 'J', @j
EXEC sp_OAMethod @json, 'StringOf', @strVal OUT, 'options.renotify_statuses[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @json, 'SizeOfArray', @count_j OUT, 'options.variables'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @json, 'J', @j
EXEC sp_OAMethod @json, 'StringOf', @data_source OUT, 'options.variables[j].data_source'
EXEC sp_OAMethod @json, 'StringOf', @Aggregation OUT, 'options.variables[j].compute.aggregation'
EXEC sp_OAMethod @json, 'IntOf', @Interval OUT, 'options.variables[j].compute.interval'
EXEC sp_OAMethod @json, 'StringOf', @computeMetric OUT, 'options.variables[j].compute.metric'
EXEC sp_OAMethod @json, 'StringOf', @name OUT, 'options.variables[j].name'
EXEC sp_OAMethod @json, 'StringOf', @Query OUT, 'options.variables[j].search.query'
SELECT @k = 0
EXEC sp_OAMethod @json, 'SizeOfArray', @count_k OUT, 'options.variables[j].group_by'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @json, 'K', @k
EXEC sp_OAMethod @json, 'StringOf', @facet OUT, 'options.variables[j].group_by[k].facet'
EXEC sp_OAMethod @json, 'IntOf', @limit OUT, 'options.variables[j].group_by[k].limit'
EXEC sp_OAMethod @json, 'StringOf', @sortAggregation OUT, 'options.variables[j].group_by[k].sort.aggregation'
EXEC sp_OAMethod @json, 'StringOf', @sortMetric OUT, 'options.variables[j].group_by[k].sort.metric'
EXEC sp_OAMethod @json, 'StringOf', @Order OUT, 'options.variables[j].group_by[k].sort.order'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @json, 'SizeOfArray', @count_k OUT, 'options.variables[j].indexes'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @json, 'K', @k
EXEC sp_OAMethod @json, 'StringOf', @strVal OUT, 'options.variables[j].indexes[k]'
SELECT @k = @k + 1
END
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @json, 'SizeOfArray', @count_j OUT, 'restricted_roles'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @json, 'J', @j
EXEC sp_OAMethod @json, 'StringOf', @strVal OUT, 'restricted_roles[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @json, 'SizeOfArray', @count_j OUT, 'tags'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @json, 'J', @j
EXEC sp_OAMethod @json, 'StringOf', @strVal OUT, 'tags[j]'
SELECT @j = @j + 1
END
EXEC @hr = sp_OADestroy @json
SELECT @i = @i + 1
END
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jarrResp
END
GO
Curl Command
curl -G -d "group_states=alert"
-d "name=tempor%20Ut%20sed%20velit"
-d "tags=host%3Ahost0"
-d "monitor_tags=service%3Amy-app"
-d "with_downtimes=true"
-d "id_offset=-62147425"
-d "page=0"
-d "page_size=20"
-H "Accept: application/json"
https://api.app.ddog-gov.com/api/v1/monitor
Postman Collection Item JSON
{
"name": "Get all monitor details",
"request": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
}
],
"url": {
"raw": "{{baseUrl}}/api/v1/monitor?group_states=alert&name=tempor Ut sed velit&tags=host:host0&monitor_tags=service:my-app&with_downtimes=true&id_offset=-62147425&page=0&page_size=20",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"monitor"
],
"query": [
{
"key": "group_states",
"value": "alert",
"description": "When specified, shows additional information about the group states.\nChoose one or more from `all`, `alert`, `warn`, and `no data`."
},
{
"key": "name",
"value": "tempor Ut sed velit",
"description": "A string to filter monitors by name."
},
{
"key": "tags",
"value": "host:host0",
"description": "A comma separated list indicating what tags, if any, should be used to filter the list of monitors by scope.\nFor example, `host:host0`."
},
{
"key": "monitor_tags",
"value": "service:my-app",
"description": "A comma separated list indicating what service and/or custom tags, if any, should be used to filter the list of monitors.\nTags created in the Datadog UI automatically have the service key prepended. For example, `service:my-app`."
},
{
"key": "with_downtimes",
"value": "true",
"description": "If this argument is set to true, then the returned data includes all current active downtimes for each monitor."
},
{
"key": "id_offset",
"value": "-62147425",
"description": "Use this parameter for paginating through large sets of monitors. Start with a value of zero, make a request, set the value to the last ID of result set, and then repeat until the response is empty."
},
{
"key": "page",
"value": "0",
"description": "The page to start paginating from. If this argument is not specified, the request returns all monitors without pagination."
},
{
"key": "page_size",
"value": "20",
"description": "The number of monitors to return per page. If the page argument is not specified, the default behavior returns all monitors without a `page_size` limit. However, if page is specified and `page_size` is not, the argument defaults to 100."
}
]
},
"description": "Get details about the specified monitor from your organization."
},
"response": [
{
"name": "OK",
"originalRequest": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
},
{
"description": "Added as a part of security scheme: apikey",
"key": "DD-API-KEY",
"value": "<API Key>"
}
],
"url": {
"raw": "{{baseUrl}}/api/v1/monitor?group_states=alert&name=tempor Ut sed velit&tags=host:host0&monitor_tags=service:my-app&with_downtimes=true&id_offset=-62147425&page=0&page_size=20",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"monitor"
],
"query": [
{
"key": "group_states",
"value": "alert",
"description": "When specified, shows additional information about the group states.\nChoose one or more from `all`, `alert`, `warn`, and `no data`."
},
{
"key": "name",
"value": "tempor Ut sed velit",
"description": "A string to filter monitors by name."
},
{
"key": "tags",
"value": "host:host0",
"description": "A comma separated list indicating what tags, if any, should be used to filter the list of monitors by scope.\nFor example, `host:host0`."
},
{
"key": "monitor_tags",
"value": "service:my-app",
"description": "A comma separated list indicating what service and/or custom tags, if any, should be used to filter the list of monitors.\nTags created in the Datadog UI automatically have the service key prepended. For example, `service:my-app`."
},
{
"key": "with_downtimes",
"value": "true",
"description": "If this argument is set to true, then the returned data includes all current active downtimes for each monitor."
},
{
"key": "id_offset",
"value": "-62147425",
"description": "Use this parameter for paginating through large sets of monitors. Start with a value of zero, make a request, set the value to the last ID of result set, and then repeat until the response is empty."
},
{
"key": "page",
"value": "0",
"description": "The page to start paginating from. If this argument is not specified, the request returns all monitors without pagination."
},
{
"key": "page_size",
"value": "20",
"description": "The number of monitors to return per page. If the page argument is not specified, the default behavior returns all monitors without a `page_size` limit. However, if page is specified and `page_size` is not, the argument defaults to 100."
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "[\n {\n \"type\": \"query alert\",\n \"query\": \"avg(last_5m):sum:system.net.bytes_rcvd{host:host0} > 100\",\n \"created\": \"1977-10-10T13:08:01.527Z\",\n \"creator\": {\n \"email\": \"eiusmod aliquip pariatur dolore\",\n \"handle\": \"fugiat id sint\",\n \"name\": \"elit in\"\n },\n \"deleted\": \"2015-07-16T18:46:50.390Z\",\n \"id\": 83649643,\n \"matching_downtimes\": [\n {\n \"id\": 1625,\n \"end\": 1412792983,\n \"scope\": [\n \"env:staging\"\n ],\n \"start\": 1412792983\n },\n {\n \"id\": 1625,\n \"end\": 1412792983,\n \"scope\": [\n \"env:staging\"\n ],\n \"start\": 1412792983\n }\n ],\n \"message\": \"adi\",\n \"modified\": \"1973-08-05T09:10:13.718Z\",\n \"multi\": false,\n \"name\": \"My monitor\",\n \"options\": {\n \"aggregation\": {\n \"group_by\": \"host\",\n \"metric\": \"metrics.name\",\n \"type\": \"count\"\n },\n \"device_ids\": [\n \"firefox.tablet\",\n \"mobile_small\"\n ],\n \"enable_logs_sample\": true,\n \"enable_samples\": true,\n \"escalation_message\": \"none\",\n \"evaluation_delay\": 27121357,\n \"group_retention_duration\": \"esse aliquip ullamco irure\",\n \"groupby_simple_monitor\": true,\n \"include_tags\": true,\n \"locked\": false,\n \"min_failure_duration\": 0,\n \"min_location_failed\": 1,\n \"new_group_delay\": -9275927,\n \"new_host_delay\": 300,\n \"no_data_timeframe\": 58492166,\n \"notification_preset_name\": \"show_all\",\n \"notify_audit\": false,\n \"notify_by\": [\n \"ut quis e\",\n \"dolore elit\"\n ],\n \"notify_no_data\": false,\n \"on_missing_data\": \"show_no_data\",\n \"renotify_interval\": null,\n \"renotify_occurrences\": -27638100,\n \"renotify_statuses\": [\n \"alert\",\n \"warn\"\n ],\n \"require_full_window\": true,\n \"scheduling_options\": {\n \"evaluation_window\": {\n \"day_starts\": \"04:00\",\n \"hour_starts\": 0,\n \"month_starts\": 1\n }\n },\n \"silenced\": {\n \"Ut_d_e\": 94650378\n },\n \"synthetics_check_id\": \"enim et tempor\",\n \"threshold_windows\": {\n \"recovery_window\": \"ipsum eiusmod\",\n \"trigger_window\": \"ullamco\"\n },\n \"thresholds\": {\n \"critical\": -74585739.55469063,\n \"critical_recovery\": -14449679.792215124,\n \"ok\": 69468073.65422091,\n \"unknown\": -35840527.53565459,\n \"warning\": -78191860.79094723,\n \"warning_recovery\": 30967604.742167816\n },\n \"timeout_h\": null,\n \"variables\": [\n {\n \"data_source\": \"rum\",\n \"compute\": {\n \"aggregation\": \"avg\",\n \"interval\": 60000,\n \"metric\": \"@duration\"\n },\n \"name\": \"query_errors\",\n \"group_by\": [\n {\n \"facet\": \"status\",\n \"limit\": 10,\n \"sort\": {\n \"aggregation\": \"avg\",\n \"metric\": \"qui Ut cupidatat proid\",\n \"order\": \"desc\"\n }\n },\n {\n \"facet\": \"status\",\n \"limit\": 10,\n \"sort\": {\n \"aggregation\": \"avg\",\n \"metric\": \"nostrud mollit\",\n \"order\": \"desc\"\n }\n }\n ],\n \"indexes\": [\n \"days-3\",\n \"days-7\"\n ],\n \"search\": {\n \"query\": \"service:query\"\n }\n },\n {\n \"data_source\": \"rum\",\n \"compute\": {\n \"aggregation\": \"avg\",\n \"interval\": 60000,\n \"metric\": \"@duration\"\n },\n \"name\": \"query_errors\",\n \"group_by\": [\n {\n \"facet\": \"status\",\n \"limit\": 10,\n \"sort\": {\n \"aggregation\": \"avg\",\n \"metric\": \"ut non\",\n \"order\": \"desc\"\n }\n },\n {\n \"facet\": \"status\",\n \"limit\": 10,\n \"sort\": {\n \"aggregation\": \"avg\",\n \"metric\": \"reprehenderit sint eu proident\",\n \"order\": \"desc\"\n }\n }\n ],\n \"indexes\": [\n \"days-3\",\n \"days-7\"\n ],\n \"search\": {\n \"query\": \"service:query\"\n }\n }\n ]\n },\n \"overall_state\": \"Unknown\",\n \"priority\": 4,\n \"restricted_roles\": [\n \"Ut\",\n \"dolor ad Duis proident\"\n ],\n \"state\": {\n \"groups\": {\n \"ullamco2\": {\n \"last_nodata_ts\": -30657062,\n \"last_notified_ts\": -69789968,\n \"last_resolved_ts\": -40935564,\n \"last_triggered_ts\": 63742261,\n \"name\": \"id\",\n \"status\": \"Alert\"\n },\n \"voluptate_0c\": {\n \"last_nodata_ts\": 13097104,\n \"last_notified_ts\": 53104444,\n \"last_resolved_ts\": -69320667,\n \"last_triggered_ts\": 27152807,\n \"name\": \"quis amet\",\n \"status\": \"Alert\"\n }\n }\n },\n \"tags\": [\n \"fugiat culpa aliqua consectetur\",\n \"minim in\"\n ]\n },\n {\n \"type\": \"query alert\",\n \"query\": \"avg(last_5m):sum:system.net.bytes_rcvd{host:host0} > 100\",\n \"created\": \"1952-04-01T14:02:58.093Z\",\n \"creator\": {\n \"email\": \"esse ad veniam qui\",\n \"handle\": \"nulla enim non\",\n \"name\": \"ut reprehend\"\n },\n \"deleted\": \"2005-07-24T20:18:36.078Z\",\n \"id\": 14961847,\n \"matching_downtimes\": [\n {\n \"id\": 1625,\n \"end\": 1412792983,\n \"scope\": [\n \"env:staging\"\n ],\n \"start\": 1412792983\n },\n {\n \"id\": 1625,\n \"end\": 1412792983,\n \"scope\": [\n \"env:staging\"\n ],\n \"start\": 1412792983\n }\n ],\n \"message\": \"labore nulla\",\n \"modified\": \"2013-05-28T22:30:26.014Z\",\n \"multi\": true,\n \"name\": \"My monitor\",\n \"options\": {\n \"aggregation\": {\n \"group_by\": \"host\",\n \"metric\": \"metrics.name\",\n \"type\": \"count\"\n },\n \"device_ids\": [\n \"chrome.tablet\",\n \"firefox.laptop_large\"\n ],\n \"enable_logs_sample\": false,\n \"enable_samples\": true,\n \"escalation_message\": \"none\",\n \"evaluation_delay\": 48023490,\n \"group_retention_duration\": \"veniam eiusmod anim\",\n \"groupby_simple_monitor\": true,\n \"include_tags\": true,\n \"locked\": false,\n \"min_failure_duration\": 0,\n \"min_location_failed\": 1,\n \"new_group_delay\": -78698406,\n \"new_host_delay\": 300,\n \"no_data_timeframe\": -29298203,\n \"notification_preset_name\": \"show_all\",\n \"notify_audit\": false,\n \"notify_by\": [\n \"in labore irure reprehenderit\",\n \"Ut ea\"\n ],\n \"notify_no_data\": false,\n \"on_missing_data\": \"default\",\n \"renotify_interval\": null,\n \"renotify_occurrences\": 88843653,\n \"renotify_statuses\": [\n \"warn\",\n \"no data\"\n ],\n \"require_full_window\": false,\n \"scheduling_options\": {\n \"evaluation_window\": {\n \"day_starts\": \"04:00\",\n \"hour_starts\": 0,\n \"month_starts\": 1\n }\n },\n \"silenced\": {\n \"ut_8\": -75892703\n },\n \"synthetics_check_id\": \"ut et aute cupidatat\",\n \"threshold_windows\": {\n \"recovery_window\": \"dolor do\",\n \"trigger_window\": \"pariatur\"\n },\n \"thresholds\": {\n \"critical\": -5336230.352944598,\n \"critical_recovery\": 7945004.71738635,\n \"ok\": -68115416.21610427,\n \"unknown\": 89541673.34797806,\n \"warning\": 66901483.96194494,\n \"warning_recovery\": -39599171.26178945\n },\n \"timeout_h\": null,\n \"variables\": [\n {\n \"data_source\": \"rum\",\n \"compute\": {\n \"aggregation\": \"avg\",\n \"interval\": 60000,\n \"metric\": \"@duration\"\n },\n \"name\": \"query_errors\",\n \"group_by\": [\n {\n \"facet\": \"status\",\n \"limit\": 10,\n \"sort\": {\n \"aggregation\": \"avg\",\n \"metric\": \"deserunt nisi mollit\",\n \"order\": \"desc\"\n }\n },\n {\n \"facet\": \"status\",\n \"limit\": 10,\n \"sort\": {\n \"aggregation\": \"avg\",\n \"metric\": \"dolor pariatur\",\n \"order\": \"desc\"\n }\n }\n ],\n \"indexes\": [\n \"days-3\",\n \"days-7\"\n ],\n \"search\": {\n \"query\": \"service:query\"\n }\n },\n {\n \"data_source\": \"rum\",\n \"compute\": {\n \"aggregation\": \"avg\",\n \"interval\": 60000,\n \"metric\": \"@duration\"\n },\n \"name\": \"query_errors\",\n \"group_by\": [\n {\n \"facet\": \"status\",\n \"limit\": 10,\n \"sort\": {\n \"aggregation\": \"avg\",\n \"metric\": \"l\",\n \"order\": \"desc\"\n }\n },\n {\n \"facet\": \"status\",\n \"limit\": 10,\n \"sort\": {\n \"aggregation\": \"avg\",\n \"metric\": \"ut non\",\n \"order\": \"desc\"\n }\n }\n ],\n \"indexes\": [\n \"days-3\",\n \"days-7\"\n ],\n \"search\": {\n \"query\": \"service:query\"\n }\n }\n ]\n },\n \"overall_state\": \"Unknown\",\n \"priority\": 3,\n \"restricted_roles\": [\n \"ipsum laboris laborum incididunt\",\n \"fugiat non est\"\n ],\n \"state\": {\n \"groups\": {\n \"Ut7\": {\n \"last_nodata_ts\": 21127128,\n \"last_notified_ts\": 19208840,\n \"last_resolved_ts\": 29022384,\n \"last_triggered_ts\": -96682791,\n \"name\": \"ex tempor\",\n \"status\": \"OK\"\n }\n }\n },\n \"tags\": [\n \"dolor nulla dolore elit\",\n \"consequat sunt in\"\n ]\n }\n]"
},
{
"name": "Bad Request",
"originalRequest": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
},
{
"description": "Added as a part of security scheme: apikey",
"key": "DD-API-KEY",
"value": "<API Key>"
}
],
"url": {
"raw": "{{baseUrl}}/api/v1/monitor?group_states=alert&name=tempor Ut sed velit&tags=host:host0&monitor_tags=service:my-app&with_downtimes=true&id_offset=-62147425&page=0&page_size=20",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"monitor"
],
"query": [
{
"key": "group_states",
"value": "alert",
"description": "When specified, shows additional information about the group states.\nChoose one or more from `all`, `alert`, `warn`, and `no data`."
},
{
"key": "name",
"value": "tempor Ut sed velit",
"description": "A string to filter monitors by name."
},
{
"key": "tags",
"value": "host:host0",
"description": "A comma separated list indicating what tags, if any, should be used to filter the list of monitors by scope.\nFor example, `host:host0`."
},
{
"key": "monitor_tags",
"value": "service:my-app",
"description": "A comma separated list indicating what service and/or custom tags, if any, should be used to filter the list of monitors.\nTags created in the Datadog UI automatically have the service key prepended. For example, `service:my-app`."
},
{
"key": "with_downtimes",
"value": "true",
"description": "If this argument is set to true, then the returned data includes all current active downtimes for each monitor."
},
{
"key": "id_offset",
"value": "-62147425",
"description": "Use this parameter for paginating through large sets of monitors. Start with a value of zero, make a request, set the value to the last ID of result set, and then repeat until the response is empty."
},
{
"key": "page",
"value": "0",
"description": "The page to start paginating from. If this argument is not specified, the request returns all monitors without pagination."
},
{
"key": "page_size",
"value": "20",
"description": "The number of monitors to return per page. If the page argument is not specified, the default behavior returns all monitors without a `page_size` limit. However, if page is specified and `page_size` is not, the argument defaults to 100."
}
]
}
},
"status": "Bad Request",
"code": 400,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"errors\": [\n \"Bad Request\",\n \"Bad Request\"\n ]\n}"
},
{
"name": "Forbidden",
"originalRequest": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
},
{
"description": "Added as a part of security scheme: apikey",
"key": "DD-API-KEY",
"value": "<API Key>"
}
],
"url": {
"raw": "{{baseUrl}}/api/v1/monitor?group_states=alert&name=tempor Ut sed velit&tags=host:host0&monitor_tags=service:my-app&with_downtimes=true&id_offset=-62147425&page=0&page_size=20",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"monitor"
],
"query": [
{
"key": "group_states",
"value": "alert",
"description": "When specified, shows additional information about the group states.\nChoose one or more from `all`, `alert`, `warn`, and `no data`."
},
{
"key": "name",
"value": "tempor Ut sed velit",
"description": "A string to filter monitors by name."
},
{
"key": "tags",
"value": "host:host0",
"description": "A comma separated list indicating what tags, if any, should be used to filter the list of monitors by scope.\nFor example, `host:host0`."
},
{
"key": "monitor_tags",
"value": "service:my-app",
"description": "A comma separated list indicating what service and/or custom tags, if any, should be used to filter the list of monitors.\nTags created in the Datadog UI automatically have the service key prepended. For example, `service:my-app`."
},
{
"key": "with_downtimes",
"value": "true",
"description": "If this argument is set to true, then the returned data includes all current active downtimes for each monitor."
},
{
"key": "id_offset",
"value": "-62147425",
"description": "Use this parameter for paginating through large sets of monitors. Start with a value of zero, make a request, set the value to the last ID of result set, and then repeat until the response is empty."
},
{
"key": "page",
"value": "0",
"description": "The page to start paginating from. If this argument is not specified, the request returns all monitors without pagination."
},
{
"key": "page_size",
"value": "20",
"description": "The number of monitors to return per page. If the page argument is not specified, the default behavior returns all monitors without a `page_size` limit. However, if page is specified and `page_size` is not, the argument defaults to 100."
}
]
}
},
"status": "Forbidden",
"code": 403,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"errors\": [\n \"Bad Request\",\n \"Bad Request\"\n ]\n}"
},
{
"name": "Too many requests",
"originalRequest": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
},
{
"description": "Added as a part of security scheme: apikey",
"key": "DD-API-KEY",
"value": "<API Key>"
}
],
"url": {
"raw": "{{baseUrl}}/api/v1/monitor?group_states=alert&name=tempor Ut sed velit&tags=host:host0&monitor_tags=service:my-app&with_downtimes=true&id_offset=-62147425&page=0&page_size=20",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"monitor"
],
"query": [
{
"key": "group_states",
"value": "alert",
"description": "When specified, shows additional information about the group states.\nChoose one or more from `all`, `alert`, `warn`, and `no data`."
},
{
"key": "name",
"value": "tempor Ut sed velit",
"description": "A string to filter monitors by name."
},
{
"key": "tags",
"value": "host:host0",
"description": "A comma separated list indicating what tags, if any, should be used to filter the list of monitors by scope.\nFor example, `host:host0`."
},
{
"key": "monitor_tags",
"value": "service:my-app",
"description": "A comma separated list indicating what service and/or custom tags, if any, should be used to filter the list of monitors.\nTags created in the Datadog UI automatically have the service key prepended. For example, `service:my-app`."
},
{
"key": "with_downtimes",
"value": "true",
"description": "If this argument is set to true, then the returned data includes all current active downtimes for each monitor."
},
{
"key": "id_offset",
"value": "-62147425",
"description": "Use this parameter for paginating through large sets of monitors. Start with a value of zero, make a request, set the value to the last ID of result set, and then repeat until the response is empty."
},
{
"key": "page",
"value": "0",
"description": "The page to start paginating from. If this argument is not specified, the request returns all monitors without pagination."
},
{
"key": "page_size",
"value": "20",
"description": "The number of monitors to return per page. If the page argument is not specified, the default behavior returns all monitors without a `page_size` limit. However, if page is specified and `page_size` is not, the argument defaults to 100."
}
]
}
},
"status": "Too Many Requests",
"code": 429,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"errors\": [\n \"Bad Request\",\n \"Bad Request\"\n ]\n}"
}
]
}
