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
-- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
DECLARE @queryParams int
-- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @queryParams OUT
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'query', 'tempor Ut sed velit'
EXEC sp_OAMethod @queryParams, 'UpdateInt', @success OUT, 'page[size]', -62147425
EXEC sp_OAMethod @queryParams, 'UpdateInt', @success OUT, 'page[number]', -62147425
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'include_facets', 'true'
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/slo/search', @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
-- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @resp, 'GetBodySb', @success OUT, @sbResponseBody
DECLARE @jResp int
-- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jResp OUT
EXEC sp_OAMethod @jResp, 'LoadSb', @success OUT, @sbResponseBody
EXEC sp_OASetProperty @jResp, 'EmitCompact', 0
PRINT 'Response Body:'
EXEC sp_OAMethod @jResp, '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 @jResp
RETURN
END
EXEC @hr = sp_OADestroy @resp
-- Sample JSON response:
-- (Sample code for parsing the JSON response is shown below)
-- {
-- "data": {
-- "attributes": {
-- "facets": {
-- "all_tags": [
-- {
-- "count": -8530751,
-- "name": "est cillum id ex"
-- },
-- {
-- "count": 20390494,
-- "name": "adipisicing minim quis velit dolore"
-- }
-- ],
-- "creator_name": [
-- {
-- "count": 77247452,
-- "name": "cupidatat elit eu id aute"
-- },
-- {
-- "count": -77371710,
-- "name": "dolore"
-- }
-- ],
-- "env_tags": [
-- {
-- "count": -42199690,
-- "name": "dolor eiusmod"
-- },
-- {
-- "count": -60615528,
-- "name": "commodo mollit"
-- }
-- ],
-- "service_tags": [
-- {
-- "count": 49217615,
-- "name": "aute cupidatat"
-- },
-- {
-- "count": 77659232,
-- "name": "est Ut aute"
-- }
-- ],
-- "slo_type": [
-- {
-- "count": 55153641,
-- "name": 41482978.922150195
-- },
-- {
-- "count": 11427450,
-- "name": 85748817.01266047
-- }
-- ],
-- "target": [
-- {
-- "count": 96778717,
-- "name": -37511597.68983867
-- },
-- {
-- "count": 15549994,
-- "name": 30406993.57594505
-- }
-- ],
-- "team_tags": [
-- {
-- "count": -61109884,
-- "name": "laborum ex esse proident"
-- },
-- {
-- "count": 68412080,
-- "name": "nisi qui cillum exercitation"
-- }
-- ],
-- "timeframe": [
-- {
-- "count": -21958451,
-- "name": "fugiat"
-- },
-- {
-- "count": 12824105,
-- "name": "tempor adipisi"
-- }
-- ]
-- },
-- "slos": [
-- {
-- "data": {
-- "attributes": {
-- "all_tags": [
-- "env:prod",
-- "app:core"
-- ],
-- "created_at": 2857983,
-- "creator": {
-- "email": "non Lorem",
-- "id": 39288042,
-- "name": "voluptate"
-- },
-- "description": "fugiat sit in quis",
-- "env_tags": [
-- "irure tempor",
-- "laborum reprehenderi"
-- ],
-- "groups": [
-- "env:prod",
-- "role:mysql"
-- ],
-- "modified_at": -85796945,
-- "monitor_ids": [
-- 99205206,
-- 23793820
-- ],
-- "name": "Custom Metric SLO",
-- "overall_status": [
-- {
-- "error": "occaecat dolore",
-- "error_budget_remaining": 100,
-- "indexed_at": 1662496260,
-- "raw_error_budget_remaining": {
-- "unit": "requests",
-- "value": 60
-- },
-- "span_precision": 2,
-- "state": "ok",
-- "status": 100,
-- "target": 99,
-- "timeframe": "30d"
-- },
-- {
-- "error": "in officia",
-- "error_budget_remaining": 100,
-- "indexed_at": 1662496260,
-- "raw_error_budget_remaining": {
-- "unit": "requests",
-- "value": 60
-- },
-- "span_precision": 2,
-- "state": "ok",
-- "status": 100,
-- "target": 99,
-- "timeframe": "30d"
-- }
-- ],
-- "query": {
-- "denominator": "sum:my.custom.metric{*}.as_count()",
-- "metrics": [
-- "my.custom.metric",
-- "my.other.custom.metric"
-- ],
-- "numerator": "sum:my.custom.metric{type:good}.as_count()"
-- },
-- "service_tags": [
-- "aute amet dolor pariatur mollit",
-- "officia"
-- ],
-- "slo_type": "metric",
-- "status": {
-- "calculation_error": "qui",
-- "error_budget_remaining": 100,
-- "indexed_at": 1662496260,
-- "raw_error_budget_remaining": {
-- "unit": "requests",
-- "value": 60
-- },
-- "sli": 100,
-- "span_precision": 2,
-- "state": "ok"
-- },
-- "team_tags": [
-- "quis veniam magna",
-- "ad"
-- ],
-- "thresholds": [
-- {
-- "target": 95,
-- "target_display": "95",
-- "timeframe": "7d"
-- },
-- {
-- "target": 95,
-- "target_display": "95",
-- "timeframe": "30d",
-- "warning": 97,
-- "warning_display": "97"
-- }
-- ]
-- },
-- "id": "sed fugiat est cillum",
-- "type": "mollit dolore"
-- }
-- },
-- {
-- "data": {
-- "attributes": {
-- "all_tags": [
-- "env:prod",
-- "app:core"
-- ],
-- "created_at": -97407922,
-- "creator": {
-- "email": "in nulla",
-- "id": -4202515,
-- "name": "elit et consequat"
-- },
-- "description": "dolor sed cupidatat pariatur sint",
-- "env_tags": [
-- "magna ex pariatur dolore sed",
-- "velit dolor aute in nostrud"
-- ],
-- "groups": [
-- "env:prod",
-- "role:mysql"
-- ],
-- "modified_at": -32142227,
-- "monitor_ids": [
-- 83809238,
-- -63596037
-- ],
-- "name": "Custom Metric SLO",
-- "overall_status": [
-- {
-- "error": "reprehenderit cupidat",
-- "error_budget_remaining": 100,
-- "indexed_at": 1662496260,
-- "raw_error_budget_remaining": {
-- "unit": "requests",
-- "value": 60
-- },
-- "span_precision": 2,
-- "state": "ok",
-- "status": 100,
-- "target": 99,
-- "timeframe": "30d"
-- },
-- {
-- "error": "consequat",
-- "error_budget_remaining": 100,
-- "indexed_at": 1662496260,
-- "raw_error_budget_remaining": {
-- "unit": "requests",
-- "value": 60
-- },
-- "span_precision": 2,
-- "state": "ok",
-- "status": 100,
-- "target": 99,
-- "timeframe": "30d"
-- }
-- ],
-- "query": {
-- "denominator": "sum:my.custom.metric{*}.as_count()",
-- "metrics": [
-- "my.custom.metric",
-- "my.other.custom.metric"
-- ],
-- "numerator": "sum:my.custom.metric{type:good}.as_count()"
-- },
-- "service_tags": [
-- "magna velit",
-- "occaecat tempor proident ex ea"
-- ],
-- "slo_type": "metric",
-- "status": {
-- "calculation_error": "in occaecat e",
-- "error_budget_remaining": 100,
-- "indexed_at": 1662496260,
-- "raw_error_budget_remaining": {
-- "unit": "requests",
-- "value": 60
-- },
-- "sli": 100,
-- "span_precision": 2,
-- "state": "ok"
-- },
-- "team_tags": [
-- "Ut nisi ipsum fugiat",
-- "exercitation proident consequat aute"
-- ],
-- "thresholds": [
-- {
-- "target": 95,
-- "target_display": "95",
-- "timeframe": "7d"
-- },
-- {
-- "target": 95,
-- "target_display": "95",
-- "timeframe": "30d",
-- "warning": 97,
-- "warning_display": "97"
-- }
-- ]
-- },
-- "id": "et sit commodo",
-- "type": "Lorem ut quis"
-- }
-- }
-- ]
-- },
-- "type": ""
-- },
-- "links": {
-- "first": "voluptate veniam aliqua ea enim",
-- "last": "non cupidatat amet dolore et",
-- "next": "reprehenderit ex anim Lorem",
-- "prev": "aute ex",
-- "self": "deserunt"
-- },
-- "meta": {
-- "pagination": {
-- "first_number": 71439942,
-- "last_number": -13516974,
-- "next_number": -42474877,
-- "number": 60934593,
-- "prev_number": -25990176,
-- "size": -54076764,
-- "total": 58951452,
-- "type": "deserunt et voluptate"
-- }
-- }
-- }
-- Sample code for parsing the JSON response...
-- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
DECLARE @count int
DECLARE @name nvarchar(4000)
DECLARE @Created_at int
DECLARE @v_Email nvarchar(4000)
DECLARE @Id int
DECLARE @Name nvarchar(4000)
DECLARE @Description nvarchar(4000)
DECLARE @Modified_at int
DECLARE @AttributesName nvarchar(4000)
DECLARE @Denominator nvarchar(4000)
DECLARE @Numerator nvarchar(4000)
DECLARE @Slo_type nvarchar(4000)
DECLARE @Calculation_error nvarchar(4000)
DECLARE @Error_budget_remaining int
DECLARE @Indexed_at int
DECLARE @Unit nvarchar(4000)
DECLARE @Value int
DECLARE @Sli int
DECLARE @Span_precision int
DECLARE @State nvarchar(4000)
DECLARE @dataId nvarchar(4000)
DECLARE @dataType nvarchar(4000)
DECLARE @j int
DECLARE @count_j int
DECLARE @strVal nvarchar(4000)
DECLARE @intVal int
DECLARE @error nvarchar(4000)
DECLARE @error_budget_remaining int
DECLARE @indexed_at int
DECLARE @raw_error_budget_remainingUnit nvarchar(4000)
DECLARE @raw_error_budget_remainingValue int
DECLARE @span_precision int
DECLARE @state nvarchar(4000)
DECLARE @status int
DECLARE @target int
DECLARE @timeframe nvarchar(4000)
DECLARE @target_display nvarchar(4000)
DECLARE @warning int
DECLARE @warning_display nvarchar(4000)
DECLARE @v_Type nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'data.type'
DECLARE @First nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @First OUT, 'links.first'
DECLARE @Last nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Last OUT, 'links.last'
DECLARE @v_Next nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @v_Next OUT, 'links.next'
DECLARE @Prev nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Prev OUT, 'links.prev'
DECLARE @v_Self nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @v_Self OUT, 'links.self'
DECLARE @First_number int
EXEC sp_OAMethod @jResp, 'IntOf', @First_number OUT, 'meta.pagination.first_number'
DECLARE @Last_number int
EXEC sp_OAMethod @jResp, 'IntOf', @Last_number OUT, 'meta.pagination.last_number'
DECLARE @Next_number int
EXEC sp_OAMethod @jResp, 'IntOf', @Next_number OUT, 'meta.pagination.next_number'
DECLARE @v_Number int
EXEC sp_OAMethod @jResp, 'IntOf', @v_Number OUT, 'meta.pagination.number'
DECLARE @Prev_number int
EXEC sp_OAMethod @jResp, 'IntOf', @Prev_number OUT, 'meta.pagination.prev_number'
DECLARE @Size int
EXEC sp_OAMethod @jResp, 'IntOf', @Size OUT, 'meta.pagination.size'
DECLARE @Total int
EXEC sp_OAMethod @jResp, 'IntOf', @Total OUT, 'meta.pagination.total'
DECLARE @PaginationType nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @PaginationType OUT, 'meta.pagination.type'
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'data.attributes.facets.all_tags'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @count OUT, 'data.attributes.facets.all_tags[i].count'
EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'data.attributes.facets.all_tags[i].name'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'data.attributes.facets.creator_name'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @count OUT, 'data.attributes.facets.creator_name[i].count'
EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'data.attributes.facets.creator_name[i].name'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'data.attributes.facets.env_tags'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @count OUT, 'data.attributes.facets.env_tags[i].count'
EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'data.attributes.facets.env_tags[i].name'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'data.attributes.facets.service_tags'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @count OUT, 'data.attributes.facets.service_tags[i].count'
EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'data.attributes.facets.service_tags[i].name'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'data.attributes.facets.slo_type'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @count OUT, 'data.attributes.facets.slo_type[i].count'
EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'data.attributes.facets.slo_type[i].name'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'data.attributes.facets.target'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @count OUT, 'data.attributes.facets.target[i].count'
EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'data.attributes.facets.target[i].name'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'data.attributes.facets.team_tags'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @count OUT, 'data.attributes.facets.team_tags[i].count'
EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'data.attributes.facets.team_tags[i].name'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'data.attributes.facets.timeframe'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @count OUT, 'data.attributes.facets.timeframe[i].count'
EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'data.attributes.facets.timeframe[i].name'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'data.attributes.slos'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @Created_at OUT, 'data.attributes.slos[i].data.attributes.created_at'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Email OUT, 'data.attributes.slos[i].data.attributes.creator.email'
EXEC sp_OAMethod @jResp, 'IntOf', @Id OUT, 'data.attributes.slos[i].data.attributes.creator.id'
EXEC sp_OAMethod @jResp, 'StringOf', @Name OUT, 'data.attributes.slos[i].data.attributes.creator.name'
EXEC sp_OAMethod @jResp, 'StringOf', @Description OUT, 'data.attributes.slos[i].data.attributes.description'
EXEC sp_OAMethod @jResp, 'IntOf', @Modified_at OUT, 'data.attributes.slos[i].data.attributes.modified_at'
EXEC sp_OAMethod @jResp, 'StringOf', @AttributesName OUT, 'data.attributes.slos[i].data.attributes.name'
EXEC sp_OAMethod @jResp, 'StringOf', @Denominator OUT, 'data.attributes.slos[i].data.attributes.query.denominator'
EXEC sp_OAMethod @jResp, 'StringOf', @Numerator OUT, 'data.attributes.slos[i].data.attributes.query.numerator'
EXEC sp_OAMethod @jResp, 'StringOf', @Slo_type OUT, 'data.attributes.slos[i].data.attributes.slo_type'
EXEC sp_OAMethod @jResp, 'StringOf', @Calculation_error OUT, 'data.attributes.slos[i].data.attributes.status.calculation_error'
EXEC sp_OAMethod @jResp, 'IntOf', @Error_budget_remaining OUT, 'data.attributes.slos[i].data.attributes.status.error_budget_remaining'
EXEC sp_OAMethod @jResp, 'IntOf', @Indexed_at OUT, 'data.attributes.slos[i].data.attributes.status.indexed_at'
EXEC sp_OAMethod @jResp, 'StringOf', @Unit OUT, 'data.attributes.slos[i].data.attributes.status.raw_error_budget_remaining.unit'
EXEC sp_OAMethod @jResp, 'IntOf', @Value OUT, 'data.attributes.slos[i].data.attributes.status.raw_error_budget_remaining.value'
EXEC sp_OAMethod @jResp, 'IntOf', @Sli OUT, 'data.attributes.slos[i].data.attributes.status.sli'
EXEC sp_OAMethod @jResp, 'IntOf', @Span_precision OUT, 'data.attributes.slos[i].data.attributes.status.span_precision'
EXEC sp_OAMethod @jResp, 'StringOf', @State OUT, 'data.attributes.slos[i].data.attributes.status.state'
EXEC sp_OAMethod @jResp, 'StringOf', @dataId OUT, 'data.attributes.slos[i].data.id'
EXEC sp_OAMethod @jResp, 'StringOf', @dataType OUT, 'data.attributes.slos[i].data.type'
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'data.attributes.slos[i].data.attributes.all_tags'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'data.attributes.slos[i].data.attributes.all_tags[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'data.attributes.slos[i].data.attributes.env_tags'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'data.attributes.slos[i].data.attributes.env_tags[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'data.attributes.slos[i].data.attributes.groups'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'data.attributes.slos[i].data.attributes.groups[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'data.attributes.slos[i].data.attributes.monitor_ids'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'data.attributes.slos[i].data.attributes.monitor_ids[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'data.attributes.slos[i].data.attributes.overall_status'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @error OUT, 'data.attributes.slos[i].data.attributes.overall_status[j].error'
EXEC sp_OAMethod @jResp, 'IntOf', @error_budget_remaining OUT, 'data.attributes.slos[i].data.attributes.overall_status[j].error_budget_remaining'
EXEC sp_OAMethod @jResp, 'IntOf', @indexed_at OUT, 'data.attributes.slos[i].data.attributes.overall_status[j].indexed_at'
EXEC sp_OAMethod @jResp, 'StringOf', @raw_error_budget_remainingUnit OUT, 'data.attributes.slos[i].data.attributes.overall_status[j].raw_error_budget_remaining.unit'
EXEC sp_OAMethod @jResp, 'IntOf', @raw_error_budget_remainingValue OUT, 'data.attributes.slos[i].data.attributes.overall_status[j].raw_error_budget_remaining.value'
EXEC sp_OAMethod @jResp, 'IntOf', @span_precision OUT, 'data.attributes.slos[i].data.attributes.overall_status[j].span_precision'
EXEC sp_OAMethod @jResp, 'StringOf', @state OUT, 'data.attributes.slos[i].data.attributes.overall_status[j].state'
EXEC sp_OAMethod @jResp, 'IntOf', @status OUT, 'data.attributes.slos[i].data.attributes.overall_status[j].status'
EXEC sp_OAMethod @jResp, 'IntOf', @target OUT, 'data.attributes.slos[i].data.attributes.overall_status[j].target'
EXEC sp_OAMethod @jResp, 'StringOf', @timeframe OUT, 'data.attributes.slos[i].data.attributes.overall_status[j].timeframe'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'data.attributes.slos[i].data.attributes.query.metrics'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'data.attributes.slos[i].data.attributes.query.metrics[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'data.attributes.slos[i].data.attributes.service_tags'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'data.attributes.slos[i].data.attributes.service_tags[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'data.attributes.slos[i].data.attributes.team_tags'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'data.attributes.slos[i].data.attributes.team_tags[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'data.attributes.slos[i].data.attributes.thresholds'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'IntOf', @target OUT, 'data.attributes.slos[i].data.attributes.thresholds[j].target'
EXEC sp_OAMethod @jResp, 'StringOf', @target_display OUT, 'data.attributes.slos[i].data.attributes.thresholds[j].target_display'
EXEC sp_OAMethod @jResp, 'StringOf', @timeframe OUT, 'data.attributes.slos[i].data.attributes.thresholds[j].timeframe'
EXEC sp_OAMethod @jResp, 'IntOf', @warning OUT, 'data.attributes.slos[i].data.attributes.thresholds[j].warning'
EXEC sp_OAMethod @jResp, 'StringOf', @warning_display OUT, 'data.attributes.slos[i].data.attributes.thresholds[j].warning_display'
SELECT @j = @j + 1
END
SELECT @i = @i + 1
END
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
END
GO
Curl Command
curl -G -d "query=tempor%20Ut%20sed%20velit"
-d "page[size]=-62147425"
-d "page[number]=-62147425"
-d "include_facets=true"
-H "Accept: application/json"
https://api.app.ddog-gov.com/api/v1/slo/search
Postman Collection Item JSON
{
"name": "Search for SLOs",
"request": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
}
],
"url": {
"raw": "{{baseUrl}}/api/v1/slo/search?query=tempor Ut sed velit&page[size]=-62147425&page[number]=-62147425&include_facets=true",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"slo",
"search"
],
"query": [
{
"key": "query",
"value": "tempor Ut sed velit",
"description": "The query string to filter results based on SLO names.\nSome examples of queries include `service:<service-name>`\nand `<slo-name>`."
},
{
"key": "page[size]",
"value": "-62147425",
"description": "The number of files to return in the response `[default=10]`."
},
{
"key": "page[number]",
"value": "-62147425",
"description": "The identifier of the first page to return. This parameter is used for the pagination feature `[default=0]`."
},
{
"key": "include_facets",
"value": "true",
"description": "Whether or not to return facet information in the response `[default=false]`."
}
]
},
"description": "Get a list of service level objective objects for 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/slo/search?query=tempor Ut sed velit&page[size]=-62147425&page[number]=-62147425&include_facets=true",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"slo",
"search"
],
"query": [
{
"key": "query",
"value": "tempor Ut sed velit",
"description": "The query string to filter results based on SLO names.\nSome examples of queries include `service:<service-name>`\nand `<slo-name>`."
},
{
"key": "page[size]",
"value": "-62147425",
"description": "The number of files to return in the response `[default=10]`."
},
{
"key": "page[number]",
"value": "-62147425",
"description": "The identifier of the first page to return. This parameter is used for the pagination feature `[default=0]`."
},
{
"key": "include_facets",
"value": "true",
"description": "Whether or not to return facet information in the response `[default=false]`."
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"data\": {\n \"attributes\": {\n \"facets\": {\n \"all_tags\": [\n {\n \"count\": -8530751,\n \"name\": \"est cillum id ex\"\n },\n {\n \"count\": 20390494,\n \"name\": \"adipisicing minim quis velit dolore\"\n }\n ],\n \"creator_name\": [\n {\n \"count\": 77247452,\n \"name\": \"cupidatat elit eu id aute\"\n },\n {\n \"count\": -77371710,\n \"name\": \"dolore\"\n }\n ],\n \"env_tags\": [\n {\n \"count\": -42199690,\n \"name\": \"dolor eiusmod\"\n },\n {\n \"count\": -60615528,\n \"name\": \"commodo mollit\"\n }\n ],\n \"service_tags\": [\n {\n \"count\": 49217615,\n \"name\": \"aute cupidatat\"\n },\n {\n \"count\": 77659232,\n \"name\": \"est Ut aute\"\n }\n ],\n \"slo_type\": [\n {\n \"count\": 55153641,\n \"name\": 41482978.922150195\n },\n {\n \"count\": 11427450,\n \"name\": 85748817.01266047\n }\n ],\n \"target\": [\n {\n \"count\": 96778717,\n \"name\": -37511597.68983867\n },\n {\n \"count\": 15549994,\n \"name\": 30406993.57594505\n }\n ],\n \"team_tags\": [\n {\n \"count\": -61109884,\n \"name\": \"laborum ex esse proident\"\n },\n {\n \"count\": 68412080,\n \"name\": \"nisi qui cillum exercitation\"\n }\n ],\n \"timeframe\": [\n {\n \"count\": -21958451,\n \"name\": \"fugiat\"\n },\n {\n \"count\": 12824105,\n \"name\": \"tempor adipisi\"\n }\n ]\n },\n \"slos\": [\n {\n \"data\": {\n \"attributes\": {\n \"all_tags\": [\n \"env:prod\",\n \"app:core\"\n ],\n \"created_at\": 2857983,\n \"creator\": {\n \"email\": \"non Lorem\",\n \"id\": 39288042,\n \"name\": \"voluptate\"\n },\n \"description\": \"fugiat sit in quis\",\n \"env_tags\": [\n \"irure tempor\",\n \"laborum reprehenderi\"\n ],\n \"groups\": [\n \"env:prod\",\n \"role:mysql\"\n ],\n \"modified_at\": -85796945,\n \"monitor_ids\": [\n 99205206,\n 23793820\n ],\n \"name\": \"Custom Metric SLO\",\n \"overall_status\": [\n {\n \"error\": \"occaecat dolore\",\n \"error_budget_remaining\": 100,\n \"indexed_at\": 1662496260,\n \"raw_error_budget_remaining\": {\n \"unit\": \"requests\",\n \"value\": 60\n },\n \"span_precision\": 2,\n \"state\": \"ok\",\n \"status\": 100,\n \"target\": 99,\n \"timeframe\": \"30d\"\n },\n {\n \"error\": \"in officia\",\n \"error_budget_remaining\": 100,\n \"indexed_at\": 1662496260,\n \"raw_error_budget_remaining\": {\n \"unit\": \"requests\",\n \"value\": 60\n },\n \"span_precision\": 2,\n \"state\": \"ok\",\n \"status\": 100,\n \"target\": 99,\n \"timeframe\": \"30d\"\n }\n ],\n \"query\": {\n \"denominator\": \"sum:my.custom.metric{*}.as_count()\",\n \"metrics\": [\n \"my.custom.metric\",\n \"my.other.custom.metric\"\n ],\n \"numerator\": \"sum:my.custom.metric{type:good}.as_count()\"\n },\n \"service_tags\": [\n \"aute amet dolor pariatur mollit\",\n \"officia\"\n ],\n \"slo_type\": \"metric\",\n \"status\": {\n \"calculation_error\": \"qui\",\n \"error_budget_remaining\": 100,\n \"indexed_at\": 1662496260,\n \"raw_error_budget_remaining\": {\n \"unit\": \"requests\",\n \"value\": 60\n },\n \"sli\": 100,\n \"span_precision\": 2,\n \"state\": \"ok\"\n },\n \"team_tags\": [\n \"quis veniam magna\",\n \"ad\"\n ],\n \"thresholds\": [\n {\n \"target\": 95,\n \"target_display\": \"95\",\n \"timeframe\": \"7d\"\n },\n {\n \"target\": 95,\n \"target_display\": \"95\",\n \"timeframe\": \"30d\",\n \"warning\": 97,\n \"warning_display\": \"97\"\n }\n ]\n },\n \"id\": \"sed fugiat est cillum\",\n \"type\": \"mollit dolore\"\n }\n },\n {\n \"data\": {\n \"attributes\": {\n \"all_tags\": [\n \"env:prod\",\n \"app:core\"\n ],\n \"created_at\": -97407922,\n \"creator\": {\n \"email\": \"in nulla\",\n \"id\": -4202515,\n \"name\": \"elit et consequat\"\n },\n \"description\": \"dolor sed cupidatat pariatur sint\",\n \"env_tags\": [\n \"magna ex pariatur dolore sed\",\n \"velit dolor aute in nostrud\"\n ],\n \"groups\": [\n \"env:prod\",\n \"role:mysql\"\n ],\n \"modified_at\": -32142227,\n \"monitor_ids\": [\n 83809238,\n -63596037\n ],\n \"name\": \"Custom Metric SLO\",\n \"overall_status\": [\n {\n \"error\": \"reprehenderit cupidat\",\n \"error_budget_remaining\": 100,\n \"indexed_at\": 1662496260,\n \"raw_error_budget_remaining\": {\n \"unit\": \"requests\",\n \"value\": 60\n },\n \"span_precision\": 2,\n \"state\": \"ok\",\n \"status\": 100,\n \"target\": 99,\n \"timeframe\": \"30d\"\n },\n {\n \"error\": \"consequat\",\n \"error_budget_remaining\": 100,\n \"indexed_at\": 1662496260,\n \"raw_error_budget_remaining\": {\n \"unit\": \"requests\",\n \"value\": 60\n },\n \"span_precision\": 2,\n \"state\": \"ok\",\n \"status\": 100,\n \"target\": 99,\n \"timeframe\": \"30d\"\n }\n ],\n \"query\": {\n \"denominator\": \"sum:my.custom.metric{*}.as_count()\",\n \"metrics\": [\n \"my.custom.metric\",\n \"my.other.custom.metric\"\n ],\n \"numerator\": \"sum:my.custom.metric{type:good}.as_count()\"\n },\n \"service_tags\": [\n \"magna velit\",\n \"occaecat tempor proident ex ea\"\n ],\n \"slo_type\": \"metric\",\n \"status\": {\n \"calculation_error\": \"in occaecat e\",\n \"error_budget_remaining\": 100,\n \"indexed_at\": 1662496260,\n \"raw_error_budget_remaining\": {\n \"unit\": \"requests\",\n \"value\": 60\n },\n \"sli\": 100,\n \"span_precision\": 2,\n \"state\": \"ok\"\n },\n \"team_tags\": [\n \"Ut nisi ipsum fugiat\",\n \"exercitation proident consequat aute\"\n ],\n \"thresholds\": [\n {\n \"target\": 95,\n \"target_display\": \"95\",\n \"timeframe\": \"7d\"\n },\n {\n \"target\": 95,\n \"target_display\": \"95\",\n \"timeframe\": \"30d\",\n \"warning\": 97,\n \"warning_display\": \"97\"\n }\n ]\n },\n \"id\": \"et sit commodo\",\n \"type\": \"Lorem ut quis\"\n }\n }\n ]\n },\n \"type\": \"\"\n },\n \"links\": {\n \"first\": \"voluptate veniam aliqua ea enim\",\n \"last\": \"non cupidatat amet dolore et\",\n \"next\": \"reprehenderit ex anim Lorem\",\n \"prev\": \"aute ex\",\n \"self\": \"deserunt\"\n },\n \"meta\": {\n \"pagination\": {\n \"first_number\": 71439942,\n \"last_number\": -13516974,\n \"next_number\": -42474877,\n \"number\": 60934593,\n \"prev_number\": -25990176,\n \"size\": -54076764,\n \"total\": 58951452,\n \"type\": \"deserunt et voluptate\"\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/slo/search?query=tempor Ut sed velit&page[size]=-62147425&page[number]=-62147425&include_facets=true",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"slo",
"search"
],
"query": [
{
"key": "query",
"value": "tempor Ut sed velit",
"description": "The query string to filter results based on SLO names.\nSome examples of queries include `service:<service-name>`\nand `<slo-name>`."
},
{
"key": "page[size]",
"value": "-62147425",
"description": "The number of files to return in the response `[default=10]`."
},
{
"key": "page[number]",
"value": "-62147425",
"description": "The identifier of the first page to return. This parameter is used for the pagination feature `[default=0]`."
},
{
"key": "include_facets",
"value": "true",
"description": "Whether or not to return facet information in the response `[default=false]`."
}
]
}
},
"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/slo/search?query=tempor Ut sed velit&page[size]=-62147425&page[number]=-62147425&include_facets=true",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"slo",
"search"
],
"query": [
{
"key": "query",
"value": "tempor Ut sed velit",
"description": "The query string to filter results based on SLO names.\nSome examples of queries include `service:<service-name>`\nand `<slo-name>`."
},
{
"key": "page[size]",
"value": "-62147425",
"description": "The number of files to return in the response `[default=10]`."
},
{
"key": "page[number]",
"value": "-62147425",
"description": "The identifier of the first page to return. This parameter is used for the pagination feature `[default=0]`."
},
{
"key": "include_facets",
"value": "true",
"description": "Whether or not to return facet information in the response `[default=false]`."
}
]
}
},
"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/slo/search?query=tempor Ut sed velit&page[size]=-62147425&page[number]=-62147425&include_facets=true",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"slo",
"search"
],
"query": [
{
"key": "query",
"value": "tempor Ut sed velit",
"description": "The query string to filter results based on SLO names.\nSome examples of queries include `service:<service-name>`\nand `<slo-name>`."
},
{
"key": "page[size]",
"value": "-62147425",
"description": "The number of files to return in the response `[default=10]`."
},
{
"key": "page[number]",
"value": "-62147425",
"description": "The identifier of the first page to return. This parameter is used for the pagination feature `[default=0]`."
},
{
"key": "include_facets",
"value": "true",
"description": "Whether or not to return facet information in the response `[default=false]`."
}
]
}
},
"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}"
}
]
}
