SQL Server / Datadog API Collection / Get the list of all Synthetic tests
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, 'page_size', 'tempor Ut sed velit'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'page_number', 'tempor Ut sed velit'
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/synthetics/tests', @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)
-- {
-- "tests": [
-- {
-- "config": {
-- "configVariables": [
-- {
-- "description": "Example for the variable.",
-- "type": "string"
-- },
-- {
-- "description": "Example for the variable.",
-- "type": "string"
-- }
-- ],
-- "request": {
-- "allow_insecure": false,
-- "basicAuth": {
-- "password": "PaSSw0RD!",
-- "username": "my_username",
-- "type": "web"
-- },
-- "body": "nisi elit aute proident minim",
-- "bodyType": "text/plain",
-- "callType": "unary",
-- "certificate": {
-- "cert": {
-- "content": "Lorem irure",
-- "filename": "Excepteur occaecat",
-- "updatedAt": "quis exercitation"
-- },
-- "key": {
-- "content": "officia aliquip",
-- "filename": "Lorem in sed",
-- "updatedAt": "exercitation commodo"
-- }
-- },
-- "compressedJsonDescriptor": "dolore ea reprehenderit ad",
-- "dnsServer": "cupida",
-- "dnsServerPort": 54877,
-- "follow_redirects": true,
-- "headers": {
-- "site_": "adipisicing ea",
-- "sit1": "in incididunt exercitation eu"
-- },
-- "host": "ipsum",
-- "message": "in cupidatat",
-- "metadata": {
-- "pariaturd5f": "qui sed ullamco et",
-- "veniam2": "in ut adipisicing voluptate velit",
-- "consectetura": "laborum sed Lorem in"
-- },
-- "method": "commodo non",
-- "noSavingResponseBody": false,
-- "numberOfPackets": 6,
-- "persistCookies": false,
-- "port": 4381428,
-- "proxy": {
-- "url": "https://example.com",
-- "headers": {
-- "in081": "exercitation a"
-- }
-- },
-- "query": {},
-- "servername": "in",
-- "service": "Greeter",
-- "shouldTrackHops": false,
-- "timeout": -9075364.229425669,
-- "url": "https://example.com"
-- },
-- "variables": [
-- {
-- "description": "Example for the variable.",
-- "type": "string"
-- },
-- {
-- "description": "Example for the variable.",
-- "type": "string"
-- }
-- ]
-- },
-- "creator": {
-- "email": "eiusmod in",
-- "handle": "commodo enim",
-- "name": "magna do occaeca"
-- },
-- "locations": [
-- "aws:eu-west-3"
-- ],
-- "message": "velit Lorem amet non",
-- "monitor_id": -1212470,
-- "name": "esse incididunt consectetur labore",
-- "options": {
-- "accept_self_signed": false,
-- "allow_insecure": false,
-- "checkCertificateRevocation": false,
-- "ci": {
-- "executionRule": "blocking"
-- },
-- "device_ids": [
-- "laptop_large",
-- "laptop_large"
-- ],
-- "disableCors": false,
-- "disableCsp": false,
-- "follow_redirects": false,
-- "httpVersion": "http2",
-- "ignoreServerCertificateError": true,
-- "initialNavigationTimeout": -13991278,
-- "min_failure_duration": -25741137,
-- "min_location_failed": 16891533,
-- "monitor_name": "veniam occaecat Lorem do",
-- "monitor_options": {
-- "renotify_interval": 206
-- },
-- "monitor_priority": 1,
-- "noScreenshot": true,
-- "restricted_roles": [
-- "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
-- ],
-- "retry": {
-- "count": 75644948,
-- "interval": 62584402.461459786
-- },
-- "rumSettings": {
-- "applicationId": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
-- "clientTokenId": 12345,
-- "isEnabled": true
-- },
-- "scheduling": {
-- "timeframes": [
-- {
-- "day": 1,
-- "from": "07:00",
-- "to": "16:00"
-- },
-- {
-- "day": 3,
-- "from": "07:00",
-- "to": "16:00"
-- }
-- ],
-- "timezone": "America/New_York"
-- },
-- "tick_every": 276495
-- },
-- "public_id": "incididunt consequat officia nisi",
-- "status": "live",
-- "steps": [
-- {
-- "allowFailure": false,
-- "isCritical": false,
-- "name": "qui",
-- "noScreenshot": false,
-- "params": {},
-- "timeout": 50285708,
-- "type": "assertElementContent"
-- },
-- {
-- "allowFailure": true,
-- "isCritical": false,
-- "name": "esse minim ullamco occaecat",
-- "noScreenshot": true,
-- "params": {},
-- "timeout": -14507495,
-- "type": "assertElementContent"
-- }
-- ],
-- "subtype": "http",
-- "tags": [
-- "exercitation Ut",
-- "esse et sit"
-- ],
-- "type": "browser"
-- },
-- {
-- "config": {
-- "configVariables": [
-- {
-- "description": "Example for the variable.",
-- "type": "string"
-- },
-- {
-- "description": "Example for the variable.",
-- "type": "string"
-- }
-- ],
-- "request": {
-- "allow_insecure": false,
-- "basicAuth": {
-- "password": "PaSSw0RD!",
-- "username": "my_username",
-- "type": "web"
-- },
-- "body": "voluptate minim",
-- "bodyType": "text/plain",
-- "callType": "unary",
-- "certificate": {
-- "cert": {
-- "content": "qui Lorem non",
-- "filename": "nostrud laboris culpa adipisicing",
-- "updatedAt": "et esse cupidatat consectetur do"
-- },
-- "key": {
-- "content": "cupidatat sunt",
-- "filename": "pariatur nostru",
-- "updatedAt": "Lorem dolor"
-- }
-- },
-- "compressedJsonDescriptor": "aliquip laboris amet",
-- "dnsServer": "magna",
-- "dnsServerPort": 35750,
-- "follow_redirects": false,
-- "headers": {
-- "est_d9d": "anim",
-- "cupidatat98f": "esse"
-- },
-- "host": "ea esse",
-- "message": "consequat ipsum ut Lorem",
-- "metadata": {
-- "esse_ef4": "commodo",
-- "do_b06": "tempor adipisicing dolor",
-- "dolore_a5a": "nostrud"
-- },
-- "method": "laboris",
-- "noSavingResponseBody": true,
-- "numberOfPackets": 9,
-- "persistCookies": true,
-- "port": -288377,
-- "proxy": {
-- "url": "https://example.com",
-- "headers": {
-- "irure_15": "in",
-- "tempor40": "laboris veniam tempor qui nulla"
-- }
-- },
-- "query": {},
-- "servername": "ad laborum cupidatat",
-- "service": "Greeter",
-- "shouldTrackHops": true,
-- "timeout": -4889397.044413894,
-- "url": "https://example.com"
-- },
-- "variables": [
-- {
-- "description": "Example for the variable.",
-- "type": "string"
-- },
-- {
-- "description": "Example for the variable.",
-- "type": "string"
-- }
-- ]
-- },
-- "creator": {
-- "email": "in Duis nisi ex",
-- "handle": "fugiat sint sed consequa",
-- "name": "ipsum ut"
-- },
-- "locations": [
-- "aws:eu-west-3"
-- ],
-- "message": "Excepteur ipsum exercitat",
-- "monitor_id": 17707116,
-- "name": "deserunt elit proident Lorem",
-- "options": {
-- "accept_self_signed": false,
-- "allow_insecure": false,
-- "checkCertificateRevocation": false,
-- "ci": {
-- "executionRule": "skipped"
-- },
-- "device_ids": [
-- "laptop_large",
-- "laptop_large"
-- ],
-- "disableCors": false,
-- "disableCsp": false,
-- "follow_redirects": false,
-- "httpVersion": "http1",
-- "ignoreServerCertificateError": false,
-- "initialNavigationTimeout": 29100273,
-- "min_failure_duration": 5817749,
-- "min_location_failed": 84916784,
-- "monitor_name": "velit quis",
-- "monitor_options": {
-- "renotify_interval": 427
-- },
-- "monitor_priority": 1,
-- "noScreenshot": false,
-- "restricted_roles": [
-- "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
-- ],
-- "retry": {
-- "count": 37028687,
-- "interval": -23788886.712954804
-- },
-- "rumSettings": {
-- "applicationId": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
-- "clientTokenId": 12345,
-- "isEnabled": true
-- },
-- "scheduling": {
-- "timeframes": [
-- {
-- "day": 1,
-- "from": "07:00",
-- "to": "16:00"
-- },
-- {
-- "day": 3,
-- "from": "07:00",
-- "to": "16:00"
-- }
-- ],
-- "timezone": "America/New_York"
-- },
-- "tick_every": 256938
-- },
-- "public_id": "Exc",
-- "status": "live",
-- "steps": [
-- {
-- "allowFailure": true,
-- "isCritical": true,
-- "name": "ipsum conse",
-- "noScreenshot": false,
-- "params": {},
-- "timeout": -75416003,
-- "type": "assertElementContent"
-- },
-- {
-- "allowFailure": false,
-- "isCritical": false,
-- "name": "non do ex",
-- "noScreenshot": false,
-- "params": {},
-- "timeout": -91980592,
-- "type": "assertElementContent"
-- }
-- ],
-- "subtype": "http",
-- "tags": [
-- "fugiat ex amet minim",
-- "dolore occaecat ad dolor ex"
-- ],
-- "type": "api"
-- }
-- ]
-- }
-- Sample code for parsing the JSON response...
-- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
DECLARE @Allow_insecure int
DECLARE @Password nvarchar(4000)
DECLARE @Username nvarchar(4000)
DECLARE @v_Type nvarchar(4000)
DECLARE @Body nvarchar(4000)
DECLARE @BodyType nvarchar(4000)
DECLARE @CallType nvarchar(4000)
DECLARE @Content nvarchar(4000)
DECLARE @Filename nvarchar(4000)
DECLARE @UpdatedAt nvarchar(4000)
DECLARE @KeyContent nvarchar(4000)
DECLARE @KeyFilename nvarchar(4000)
DECLARE @KeyUpdatedAt nvarchar(4000)
DECLARE @CompressedJsonDescriptor nvarchar(4000)
DECLARE @DnsServer nvarchar(4000)
DECLARE @DnsServerPort int
DECLARE @Follow_redirects int
DECLARE @Site_ nvarchar(4000)
DECLARE @Sit1 nvarchar(4000)
DECLARE @Host nvarchar(4000)
DECLARE @Message nvarchar(4000)
DECLARE @Pariaturd5f nvarchar(4000)
DECLARE @Veniam2 nvarchar(4000)
DECLARE @Consectetura nvarchar(4000)
DECLARE @Method nvarchar(4000)
DECLARE @NoSavingResponseBody int
DECLARE @NumberOfPackets int
DECLARE @PersistCookies int
DECLARE @Port int
DECLARE @v_Url nvarchar(4000)
DECLARE @In081 nvarchar(4000)
DECLARE @Servername nvarchar(4000)
DECLARE @Service nvarchar(4000)
DECLARE @ShouldTrackHops int
DECLARE @Timeout nvarchar(4000)
DECLARE @RequestUrl nvarchar(4000)
DECLARE @v_Email nvarchar(4000)
DECLARE @Handle nvarchar(4000)
DECLARE @Name nvarchar(4000)
DECLARE @message nvarchar(4000)
DECLARE @monitor_id int
DECLARE @name nvarchar(4000)
DECLARE @Accept_self_signed int
DECLARE @optionsAllow_insecure int
DECLARE @CheckCertificateRevocation int
DECLARE @ExecutionRule nvarchar(4000)
DECLARE @DisableCors int
DECLARE @DisableCsp int
DECLARE @optionsFollow_redirects int
DECLARE @HttpVersion nvarchar(4000)
DECLARE @IgnoreServerCertificateError int
DECLARE @InitialNavigationTimeout int
DECLARE @Min_failure_duration int
DECLARE @Min_location_failed int
DECLARE @Monitor_name nvarchar(4000)
DECLARE @Renotify_interval int
DECLARE @Monitor_priority int
DECLARE @NoScreenshot int
DECLARE @Count int
DECLARE @Interval nvarchar(4000)
DECLARE @ApplicationId nvarchar(4000)
DECLARE @ClientTokenId int
DECLARE @IsEnabled int
DECLARE @Timezone nvarchar(4000)
DECLARE @Tick_every int
DECLARE @public_id nvarchar(4000)
DECLARE @status nvarchar(4000)
DECLARE @subtype nvarchar(4000)
DECLARE @v_type nvarchar(4000)
DECLARE @Est_d9d nvarchar(4000)
DECLARE @Cupidatat98f nvarchar(4000)
DECLARE @Esse_ef4 nvarchar(4000)
DECLARE @Do_b06 nvarchar(4000)
DECLARE @Dolore_a5a nvarchar(4000)
DECLARE @Irure_15 nvarchar(4000)
DECLARE @Tempor40 nvarchar(4000)
DECLARE @j int
DECLARE @count_j int
DECLARE @description nvarchar(4000)
DECLARE @strVal nvarchar(4000)
DECLARE @day int
DECLARE @from nvarchar(4000)
DECLARE @v_to nvarchar(4000)
DECLARE @allowFailure int
DECLARE @isCritical int
DECLARE @noScreenshot int
DECLARE @timeout int
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'tests'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'BoolOf', @Allow_insecure OUT, 'tests[i].config.request.allow_insecure'
EXEC sp_OAMethod @jResp, 'StringOf', @Password OUT, 'tests[i].config.request.basicAuth.password'
EXEC sp_OAMethod @jResp, 'StringOf', @Username OUT, 'tests[i].config.request.basicAuth.username'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'tests[i].config.request.basicAuth.type'
EXEC sp_OAMethod @jResp, 'StringOf', @Body OUT, 'tests[i].config.request.body'
EXEC sp_OAMethod @jResp, 'StringOf', @BodyType OUT, 'tests[i].config.request.bodyType'
EXEC sp_OAMethod @jResp, 'StringOf', @CallType OUT, 'tests[i].config.request.callType'
EXEC sp_OAMethod @jResp, 'StringOf', @Content OUT, 'tests[i].config.request.certificate.cert.content'
EXEC sp_OAMethod @jResp, 'StringOf', @Filename OUT, 'tests[i].config.request.certificate.cert.filename'
EXEC sp_OAMethod @jResp, 'StringOf', @UpdatedAt OUT, 'tests[i].config.request.certificate.cert.updatedAt'
EXEC sp_OAMethod @jResp, 'StringOf', @KeyContent OUT, 'tests[i].config.request.certificate.key.content'
EXEC sp_OAMethod @jResp, 'StringOf', @KeyFilename OUT, 'tests[i].config.request.certificate.key.filename'
EXEC sp_OAMethod @jResp, 'StringOf', @KeyUpdatedAt OUT, 'tests[i].config.request.certificate.key.updatedAt'
EXEC sp_OAMethod @jResp, 'StringOf', @CompressedJsonDescriptor OUT, 'tests[i].config.request.compressedJsonDescriptor'
EXEC sp_OAMethod @jResp, 'StringOf', @DnsServer OUT, 'tests[i].config.request.dnsServer'
EXEC sp_OAMethod @jResp, 'IntOf', @DnsServerPort OUT, 'tests[i].config.request.dnsServerPort'
EXEC sp_OAMethod @jResp, 'BoolOf', @Follow_redirects OUT, 'tests[i].config.request.follow_redirects'
EXEC sp_OAMethod @jResp, 'StringOf', @Site_ OUT, 'tests[i].config.request.headers.site_'
EXEC sp_OAMethod @jResp, 'StringOf', @Sit1 OUT, 'tests[i].config.request.headers.sit1'
EXEC sp_OAMethod @jResp, 'StringOf', @Host OUT, 'tests[i].config.request.host'
EXEC sp_OAMethod @jResp, 'StringOf', @Message OUT, 'tests[i].config.request.message'
EXEC sp_OAMethod @jResp, 'StringOf', @Pariaturd5f OUT, 'tests[i].config.request.metadata.pariaturd5f'
EXEC sp_OAMethod @jResp, 'StringOf', @Veniam2 OUT, 'tests[i].config.request.metadata.veniam2'
EXEC sp_OAMethod @jResp, 'StringOf', @Consectetura OUT, 'tests[i].config.request.metadata.consectetura'
EXEC sp_OAMethod @jResp, 'StringOf', @Method OUT, 'tests[i].config.request.method'
EXEC sp_OAMethod @jResp, 'BoolOf', @NoSavingResponseBody OUT, 'tests[i].config.request.noSavingResponseBody'
EXEC sp_OAMethod @jResp, 'IntOf', @NumberOfPackets OUT, 'tests[i].config.request.numberOfPackets'
EXEC sp_OAMethod @jResp, 'BoolOf', @PersistCookies OUT, 'tests[i].config.request.persistCookies'
EXEC sp_OAMethod @jResp, 'IntOf', @Port OUT, 'tests[i].config.request.port'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Url OUT, 'tests[i].config.request.proxy.url'
EXEC sp_OAMethod @jResp, 'StringOf', @In081 OUT, 'tests[i].config.request.proxy.headers.in081'
EXEC sp_OAMethod @jResp, 'StringOf', @Servername OUT, 'tests[i].config.request.servername'
EXEC sp_OAMethod @jResp, 'StringOf', @Service OUT, 'tests[i].config.request.service'
EXEC sp_OAMethod @jResp, 'BoolOf', @ShouldTrackHops OUT, 'tests[i].config.request.shouldTrackHops'
EXEC sp_OAMethod @jResp, 'StringOf', @Timeout OUT, 'tests[i].config.request.timeout'
EXEC sp_OAMethod @jResp, 'StringOf', @RequestUrl OUT, 'tests[i].config.request.url'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Email OUT, 'tests[i].creator.email'
EXEC sp_OAMethod @jResp, 'StringOf', @Handle OUT, 'tests[i].creator.handle'
EXEC sp_OAMethod @jResp, 'StringOf', @Name OUT, 'tests[i].creator.name'
EXEC sp_OAMethod @jResp, 'StringOf', @message OUT, 'tests[i].message'
EXEC sp_OAMethod @jResp, 'IntOf', @monitor_id OUT, 'tests[i].monitor_id'
EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'tests[i].name'
EXEC sp_OAMethod @jResp, 'BoolOf', @Accept_self_signed OUT, 'tests[i].options.accept_self_signed'
EXEC sp_OAMethod @jResp, 'BoolOf', @optionsAllow_insecure OUT, 'tests[i].options.allow_insecure'
EXEC sp_OAMethod @jResp, 'BoolOf', @CheckCertificateRevocation OUT, 'tests[i].options.checkCertificateRevocation'
EXEC sp_OAMethod @jResp, 'StringOf', @ExecutionRule OUT, 'tests[i].options.ci.executionRule'
EXEC sp_OAMethod @jResp, 'BoolOf', @DisableCors OUT, 'tests[i].options.disableCors'
EXEC sp_OAMethod @jResp, 'BoolOf', @DisableCsp OUT, 'tests[i].options.disableCsp'
EXEC sp_OAMethod @jResp, 'BoolOf', @optionsFollow_redirects OUT, 'tests[i].options.follow_redirects'
EXEC sp_OAMethod @jResp, 'StringOf', @HttpVersion OUT, 'tests[i].options.httpVersion'
EXEC sp_OAMethod @jResp, 'BoolOf', @IgnoreServerCertificateError OUT, 'tests[i].options.ignoreServerCertificateError'
EXEC sp_OAMethod @jResp, 'IntOf', @InitialNavigationTimeout OUT, 'tests[i].options.initialNavigationTimeout'
EXEC sp_OAMethod @jResp, 'IntOf', @Min_failure_duration OUT, 'tests[i].options.min_failure_duration'
EXEC sp_OAMethod @jResp, 'IntOf', @Min_location_failed OUT, 'tests[i].options.min_location_failed'
EXEC sp_OAMethod @jResp, 'StringOf', @Monitor_name OUT, 'tests[i].options.monitor_name'
EXEC sp_OAMethod @jResp, 'IntOf', @Renotify_interval OUT, 'tests[i].options.monitor_options.renotify_interval'
EXEC sp_OAMethod @jResp, 'IntOf', @Monitor_priority OUT, 'tests[i].options.monitor_priority'
EXEC sp_OAMethod @jResp, 'BoolOf', @NoScreenshot OUT, 'tests[i].options.noScreenshot'
EXEC sp_OAMethod @jResp, 'IntOf', @Count OUT, 'tests[i].options.retry.count'
EXEC sp_OAMethod @jResp, 'StringOf', @Interval OUT, 'tests[i].options.retry.interval'
EXEC sp_OAMethod @jResp, 'StringOf', @ApplicationId OUT, 'tests[i].options.rumSettings.applicationId'
EXEC sp_OAMethod @jResp, 'IntOf', @ClientTokenId OUT, 'tests[i].options.rumSettings.clientTokenId'
EXEC sp_OAMethod @jResp, 'BoolOf', @IsEnabled OUT, 'tests[i].options.rumSettings.isEnabled'
EXEC sp_OAMethod @jResp, 'StringOf', @Timezone OUT, 'tests[i].options.scheduling.timezone'
EXEC sp_OAMethod @jResp, 'IntOf', @Tick_every OUT, 'tests[i].options.tick_every'
EXEC sp_OAMethod @jResp, 'StringOf', @public_id OUT, 'tests[i].public_id'
EXEC sp_OAMethod @jResp, 'StringOf', @status OUT, 'tests[i].status'
EXEC sp_OAMethod @jResp, 'StringOf', @subtype OUT, 'tests[i].subtype'
EXEC sp_OAMethod @jResp, 'StringOf', @v_type OUT, 'tests[i].type'
EXEC sp_OAMethod @jResp, 'StringOf', @Est_d9d OUT, 'tests[i].config.request.headers.est_d9d'
EXEC sp_OAMethod @jResp, 'StringOf', @Cupidatat98f OUT, 'tests[i].config.request.headers.cupidatat98f'
EXEC sp_OAMethod @jResp, 'StringOf', @Esse_ef4 OUT, 'tests[i].config.request.metadata.esse_ef4'
EXEC sp_OAMethod @jResp, 'StringOf', @Do_b06 OUT, 'tests[i].config.request.metadata.do_b06'
EXEC sp_OAMethod @jResp, 'StringOf', @Dolore_a5a OUT, 'tests[i].config.request.metadata.dolore_a5a'
EXEC sp_OAMethod @jResp, 'StringOf', @Irure_15 OUT, 'tests[i].config.request.proxy.headers.irure_15'
EXEC sp_OAMethod @jResp, 'StringOf', @Tempor40 OUT, 'tests[i].config.request.proxy.headers.tempor40'
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'tests[i].config.configVariables'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @description OUT, 'tests[i].config.configVariables[j].description'
EXEC sp_OAMethod @jResp, 'StringOf', @v_type OUT, 'tests[i].config.configVariables[j].type'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'tests[i].config.variables'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @description OUT, 'tests[i].config.variables[j].description'
EXEC sp_OAMethod @jResp, 'StringOf', @v_type OUT, 'tests[i].config.variables[j].type'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'tests[i].locations'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'tests[i].locations[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'tests[i].options.device_ids'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'tests[i].options.device_ids[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'tests[i].options.restricted_roles'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'tests[i].options.restricted_roles[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'tests[i].options.scheduling.timeframes'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'IntOf', @day OUT, 'tests[i].options.scheduling.timeframes[j].day'
EXEC sp_OAMethod @jResp, 'StringOf', @from OUT, 'tests[i].options.scheduling.timeframes[j].from'
EXEC sp_OAMethod @jResp, 'StringOf', @v_to OUT, 'tests[i].options.scheduling.timeframes[j].to'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'tests[i].steps'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'BoolOf', @allowFailure OUT, 'tests[i].steps[j].allowFailure'
EXEC sp_OAMethod @jResp, 'BoolOf', @isCritical OUT, 'tests[i].steps[j].isCritical'
EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'tests[i].steps[j].name'
EXEC sp_OAMethod @jResp, 'BoolOf', @noScreenshot OUT, 'tests[i].steps[j].noScreenshot'
EXEC sp_OAMethod @jResp, 'IntOf', @timeout OUT, 'tests[i].steps[j].timeout'
EXEC sp_OAMethod @jResp, 'StringOf', @v_type OUT, 'tests[i].steps[j].type'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'tests[i].tags'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'tests[i].tags[j]'
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 "page_size=tempor%20Ut%20sed%20velit"
-d "page_number=tempor%20Ut%20sed%20velit"
-H "Accept: application/json"
https://api.app.ddog-gov.com/api/v1/synthetics/tests
Postman Collection Item JSON
{
"name": "Get the list of all Synthetic tests",
"request": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
}
],
"url": {
"raw": "{{baseUrl}}/api/v1/synthetics/tests?page_size=tempor Ut sed velit&page_number=tempor Ut sed velit",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"synthetics",
"tests"
],
"query": [
{
"key": "page_size",
"value": "tempor Ut sed velit",
"description": "Used for pagination. The number of tests returned in the page."
},
{
"key": "page_number",
"value": "tempor Ut sed velit",
"description": "Used for pagination. Which page you want to retrieve. Starts at zero."
}
]
},
"description": "Get the list of all Synthetic tests."
},
"response": [
{
"name": "OK - Returns the list of all Synthetic tests.",
"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/synthetics/tests?page_size=tempor Ut sed velit&page_number=tempor Ut sed velit",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"synthetics",
"tests"
],
"query": [
{
"key": "page_size",
"value": "tempor Ut sed velit",
"description": "Used for pagination. The number of tests returned in the page."
},
{
"key": "page_number",
"value": "tempor Ut sed velit",
"description": "Used for pagination. Which page you want to retrieve. Starts at zero."
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"tests\": [\n {\n \"config\": {\n \"configVariables\": [\n {\n \"description\": \"Example for the variable.\",\n \"type\": \"string\"\n },\n {\n \"description\": \"Example for the variable.\",\n \"type\": \"string\"\n }\n ],\n \"request\": {\n \"allow_insecure\": false,\n \"basicAuth\": {\n \"password\": \"PaSSw0RD!\",\n \"username\": \"my_username\",\n \"type\": \"web\"\n },\n \"body\": \"nisi elit aute proident minim\",\n \"bodyType\": \"text/plain\",\n \"callType\": \"unary\",\n \"certificate\": {\n \"cert\": {\n \"content\": \"Lorem irure\",\n \"filename\": \"Excepteur occaecat\",\n \"updatedAt\": \"quis exercitation\"\n },\n \"key\": {\n \"content\": \"officia aliquip\",\n \"filename\": \"Lorem in sed\",\n \"updatedAt\": \"exercitation commodo\"\n }\n },\n \"compressedJsonDescriptor\": \"dolore ea reprehenderit ad\",\n \"dnsServer\": \"cupida\",\n \"dnsServerPort\": 54877,\n \"follow_redirects\": true,\n \"headers\": {\n \"site_\": \"adipisicing ea\",\n \"sit1\": \"in incididunt exercitation eu\"\n },\n \"host\": \"ipsum\",\n \"message\": \"in cupidatat\",\n \"metadata\": {\n \"pariaturd5f\": \"qui sed ullamco et\",\n \"veniam2\": \"in ut adipisicing voluptate velit\",\n \"consectetura\": \"laborum sed Lorem in\"\n },\n \"method\": \"commodo non\",\n \"noSavingResponseBody\": false,\n \"numberOfPackets\": 6,\n \"persistCookies\": false,\n \"port\": 4381428,\n \"proxy\": {\n \"url\": \"https://example.com\",\n \"headers\": {\n \"in081\": \"exercitation a\"\n }\n },\n \"query\": {},\n \"servername\": \"in\",\n \"service\": \"Greeter\",\n \"shouldTrackHops\": false,\n \"timeout\": -9075364.229425669,\n \"url\": \"https://example.com\"\n },\n \"variables\": [\n {\n \"description\": \"Example for the variable.\",\n \"type\": \"string\"\n },\n {\n \"description\": \"Example for the variable.\",\n \"type\": \"string\"\n }\n ]\n },\n \"creator\": {\n \"email\": \"eiusmod in\",\n \"handle\": \"commodo enim\",\n \"name\": \"magna do occaeca\"\n },\n \"locations\": [\n \"aws:eu-west-3\"\n ],\n \"message\": \"velit Lorem amet non\",\n \"monitor_id\": -1212470,\n \"name\": \"esse incididunt consectetur labore\",\n \"options\": {\n \"accept_self_signed\": false,\n \"allow_insecure\": false,\n \"checkCertificateRevocation\": false,\n \"ci\": {\n \"executionRule\": \"blocking\"\n },\n \"device_ids\": [\n \"laptop_large\",\n \"laptop_large\"\n ],\n \"disableCors\": false,\n \"disableCsp\": false,\n \"follow_redirects\": false,\n \"httpVersion\": \"http2\",\n \"ignoreServerCertificateError\": true,\n \"initialNavigationTimeout\": -13991278,\n \"min_failure_duration\": -25741137,\n \"min_location_failed\": 16891533,\n \"monitor_name\": \"veniam occaecat Lorem do\",\n \"monitor_options\": {\n \"renotify_interval\": 206\n },\n \"monitor_priority\": 1,\n \"noScreenshot\": true,\n \"restricted_roles\": [\n \"xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx\"\n ],\n \"retry\": {\n \"count\": 75644948,\n \"interval\": 62584402.461459786\n },\n \"rumSettings\": {\n \"applicationId\": \"xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\n \"clientTokenId\": 12345,\n \"isEnabled\": true\n },\n \"scheduling\": {\n \"timeframes\": [\n {\n \"day\": 1,\n \"from\": \"07:00\",\n \"to\": \"16:00\"\n },\n {\n \"day\": 3,\n \"from\": \"07:00\",\n \"to\": \"16:00\"\n }\n ],\n \"timezone\": \"America/New_York\"\n },\n \"tick_every\": 276495\n },\n \"public_id\": \"incididunt consequat officia nisi\",\n \"status\": \"live\",\n \"steps\": [\n {\n \"allowFailure\": false,\n \"isCritical\": false,\n \"name\": \"qui\",\n \"noScreenshot\": false,\n \"params\": {},\n \"timeout\": 50285708,\n \"type\": \"assertElementContent\"\n },\n {\n \"allowFailure\": true,\n \"isCritical\": false,\n \"name\": \"esse minim ullamco occaecat\",\n \"noScreenshot\": true,\n \"params\": {},\n \"timeout\": -14507495,\n \"type\": \"assertElementContent\"\n }\n ],\n \"subtype\": \"http\",\n \"tags\": [\n \"exercitation Ut\",\n \"esse et sit\"\n ],\n \"type\": \"browser\"\n },\n {\n \"config\": {\n \"configVariables\": [\n {\n \"description\": \"Example for the variable.\",\n \"type\": \"string\"\n },\n {\n \"description\": \"Example for the variable.\",\n \"type\": \"string\"\n }\n ],\n \"request\": {\n \"allow_insecure\": false,\n \"basicAuth\": {\n \"password\": \"PaSSw0RD!\",\n \"username\": \"my_username\",\n \"type\": \"web\"\n },\n \"body\": \"voluptate minim\",\n \"bodyType\": \"text/plain\",\n \"callType\": \"unary\",\n \"certificate\": {\n \"cert\": {\n \"content\": \"qui Lorem non\",\n \"filename\": \"nostrud laboris culpa adipisicing\",\n \"updatedAt\": \"et esse cupidatat consectetur do\"\n },\n \"key\": {\n \"content\": \"cupidatat sunt\",\n \"filename\": \"pariatur nostru\",\n \"updatedAt\": \"Lorem dolor\"\n }\n },\n \"compressedJsonDescriptor\": \"aliquip laboris amet\",\n \"dnsServer\": \"magna\",\n \"dnsServerPort\": 35750,\n \"follow_redirects\": false,\n \"headers\": {\n \"est_d9d\": \"anim\",\n \"cupidatat98f\": \"esse\"\n },\n \"host\": \"ea esse\",\n \"message\": \"consequat ipsum ut Lorem\",\n \"metadata\": {\n \"esse_ef4\": \"commodo\",\n \"do_b06\": \"tempor adipisicing dolor\",\n \"dolore_a5a\": \"nostrud\"\n },\n \"method\": \"laboris\",\n \"noSavingResponseBody\": true,\n \"numberOfPackets\": 9,\n \"persistCookies\": true,\n \"port\": -288377,\n \"proxy\": {\n \"url\": \"https://example.com\",\n \"headers\": {\n \"irure_15\": \"in\",\n \"tempor40\": \"laboris veniam tempor qui nulla\"\n }\n },\n \"query\": {},\n \"servername\": \"ad laborum cupidatat\",\n \"service\": \"Greeter\",\n \"shouldTrackHops\": true,\n \"timeout\": -4889397.044413894,\n \"url\": \"https://example.com\"\n },\n \"variables\": [\n {\n \"description\": \"Example for the variable.\",\n \"type\": \"string\"\n },\n {\n \"description\": \"Example for the variable.\",\n \"type\": \"string\"\n }\n ]\n },\n \"creator\": {\n \"email\": \"in Duis nisi ex\",\n \"handle\": \"fugiat sint sed consequa\",\n \"name\": \"ipsum ut\"\n },\n \"locations\": [\n \"aws:eu-west-3\"\n ],\n \"message\": \"Excepteur ipsum exercitat\",\n \"monitor_id\": 17707116,\n \"name\": \"deserunt elit proident Lorem\",\n \"options\": {\n \"accept_self_signed\": false,\n \"allow_insecure\": false,\n \"checkCertificateRevocation\": false,\n \"ci\": {\n \"executionRule\": \"skipped\"\n },\n \"device_ids\": [\n \"laptop_large\",\n \"laptop_large\"\n ],\n \"disableCors\": false,\n \"disableCsp\": false,\n \"follow_redirects\": false,\n \"httpVersion\": \"http1\",\n \"ignoreServerCertificateError\": false,\n \"initialNavigationTimeout\": 29100273,\n \"min_failure_duration\": 5817749,\n \"min_location_failed\": 84916784,\n \"monitor_name\": \"velit quis\",\n \"monitor_options\": {\n \"renotify_interval\": 427\n },\n \"monitor_priority\": 1,\n \"noScreenshot\": false,\n \"restricted_roles\": [\n \"xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx\"\n ],\n \"retry\": {\n \"count\": 37028687,\n \"interval\": -23788886.712954804\n },\n \"rumSettings\": {\n \"applicationId\": \"xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\n \"clientTokenId\": 12345,\n \"isEnabled\": true\n },\n \"scheduling\": {\n \"timeframes\": [\n {\n \"day\": 1,\n \"from\": \"07:00\",\n \"to\": \"16:00\"\n },\n {\n \"day\": 3,\n \"from\": \"07:00\",\n \"to\": \"16:00\"\n }\n ],\n \"timezone\": \"America/New_York\"\n },\n \"tick_every\": 256938\n },\n \"public_id\": \"Exc\",\n \"status\": \"live\",\n \"steps\": [\n {\n \"allowFailure\": true,\n \"isCritical\": true,\n \"name\": \"ipsum conse\",\n \"noScreenshot\": false,\n \"params\": {},\n \"timeout\": -75416003,\n \"type\": \"assertElementContent\"\n },\n {\n \"allowFailure\": false,\n \"isCritical\": false,\n \"name\": \"non do ex\",\n \"noScreenshot\": false,\n \"params\": {},\n \"timeout\": -91980592,\n \"type\": \"assertElementContent\"\n }\n ],\n \"subtype\": \"http\",\n \"tags\": [\n \"fugiat ex amet minim\",\n \"dolore occaecat ad dolor ex\"\n ],\n \"type\": \"api\"\n }\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/synthetics/tests?page_size=tempor Ut sed velit&page_number=tempor Ut sed velit",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"synthetics",
"tests"
],
"query": [
{
"key": "page_size",
"value": "tempor Ut sed velit",
"description": "Used for pagination. The number of tests returned in the page."
},
{
"key": "page_number",
"value": "tempor Ut sed velit",
"description": "Used for pagination. Which page you want to retrieve. Starts at zero."
}
]
}
},
"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": "Synthetic Monitoring is not activated for the user.",
"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/synthetics/tests?page_size=tempor Ut sed velit&page_number=tempor Ut sed velit",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"synthetics",
"tests"
],
"query": [
{
"key": "page_size",
"value": "tempor Ut sed velit",
"description": "Used for pagination. The number of tests returned in the page."
},
{
"key": "page_number",
"value": "tempor Ut sed velit",
"description": "Used for pagination. Which page you want to retrieve. Starts at zero."
}
]
}
},
"status": "Not Found",
"code": 404,
"_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/synthetics/tests?page_size=tempor Ut sed velit&page_number=tempor Ut sed velit",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v1",
"synthetics",
"tests"
],
"query": [
{
"key": "page_size",
"value": "tempor Ut sed velit",
"description": "Used for pagination. The number of tests returned in the page."
},
{
"key": "page_number",
"value": "tempor Ut sed velit",
"description": "Used for pagination. Which page you want to retrieve. Starts at zero."
}
]
}
},
"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}"
}
]
}
