SQL Server / Orchestrator / Gets Jobs. Copy
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, 'mandatoryPermissions', 'enim officia ut oc'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'mandatoryPermissions', 'quis ex ullamco sit'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'atLeastOnePermissions', 'enim officia ut oc'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'atLeastOnePermissions', 'quis ex ullamco sit'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, '$expand', 'esse sit qui'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, '$filter', 'esse sit qui'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, '$select', 'esse sit qui'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, '$orderby', 'esse sit qui'
EXEC sp_OAMethod @queryParams, 'UpdateInt', @success OUT, '$top', 12575632
EXEC sp_OAMethod @queryParams, 'UpdateInt', @success OUT, '$skip', 12575632
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, '$count', 'true'
-- Adds the "Authorization: Bearer <access_token>" header.
EXEC sp_OASetProperty @http, 'AuthToken', '<access_token>'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'X-UIPATH-OrganizationUnitId', '12575632'
DECLARE @resp int
EXEC sp_OAMethod @http, 'QuickRequestParams', @resp OUT, 'GET', 'https://domain.com/odata/Jobs', @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 @jResp int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.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)
-- {
-- "value": [
-- {
-- "Key": "urn:uuid:be08766e-ac51-bb45-5501-0a3dc5154af2",
-- "StartTime": "1968-12-05T22:17:50.256Z",
-- "EndTime": "1987-05-29T17:04:27.173Z",
-- "State": "Running",
-- "JobPriority": "Normal",
-- "Robot": {
-- "HostingType": "Standard",
-- "Name": "ve",
-- "Type": "RpaDeveloper",
-- "Username": "exercitation et ea",
-- "LicenseKey": "elit in",
-- "MachineName": "irure Ut mollit dolore",
-- "MachineId": -25291783,
-- "ExternalName": "laboris commodo dolor do",
-- "Description": "culpa eu consequat",
-- "ProvisionType": "Automatic",
-- "Password": "officia eu ut cupidatat",
-- "CredentialStoreId": 68306960,
-- "UserId": 31877342,
-- "Enabled": true,
-- "CredentialType": "Default",
-- "Environments": [
-- {
-- "value": "<Circular reference to #/components/schemas/EnvironmentDto detected>"
-- },
-- {
-- "value": "<Circular reference to #/components/schemas/EnvironmentDto detected>"
-- }
-- ],
-- "RobotEnvironments": "non exercitation ut dolor",
-- "ExecutionSettings": {},
-- "IsExternalLicensed": false,
-- "LimitConcurrentExecution": false,
-- "Id": -59332040
-- },
-- "Release": {
-- "Name": "sed in aliquip consequat",
-- "ProcessKey": "exercitation",
-- "ProcessVersion": "amet",
-- "Key": "velit ipsum ut",
-- "IsLatestVersion": false,
-- "IsProcessDeleted": true,
-- "Description": "dolore",
-- "EnvironmentId": -41748387,
-- "EnvironmentName": "esse culpa",
-- "Environment": {
-- "Name": "ea dolor",
-- "Description": "cillum Duis enim",
-- "Robots": [
-- {
-- "HostingType": "Standard",
-- "Name": "magna adip",
-- "Type": "Development",
-- "Username": "dolore ex",
-- "LicenseKey": "nulla veniam dolor proident ipsum",
-- "MachineName": "deserunt sed aute reprehenderit",
-- "MachineId": 99549561,
-- "ExternalName": "ad laboris veniam sint incididunt",
-- "Description": "Ut commodo",
-- "ProvisionType": "Automatic",
-- "Password": "reprehenderit",
-- "CredentialStoreId": -86457645,
-- "UserId": -62740279,
-- "Enabled": false,
-- "CredentialType": "Default",
-- "Environments": [
-- {
-- "value": "<Circular reference to #/components/schemas/EnvironmentDto detected>"
-- },
-- {
-- "value": "<Circular reference to #/components/schemas/EnvironmentDto detected>"
-- }
-- ],
-- "RobotEnvironments": "fugiat labore sunt non",
-- "ExecutionSettings": {},
-- "IsExternalLicensed": false,
-- "LimitConcurrentExecution": false,
-- "Id": -57032659
-- },
-- {
-- "HostingType": "Standard",
-- "Name": "ut",
-- "Type": "Studio",
-- "Username": "ipsum fugiat",
-- "LicenseKey": "laboris",
-- "MachineName": "nisi consequat nostrud adipisicing",
-- "MachineId": -86957591,
-- "ExternalName": "consequat nulla culpa",
-- "Description": "quis proident",
-- "ProvisionType": "Automatic",
-- "Password": "dolor laborum dolore exercitation",
-- "CredentialStoreId": -50712714,
-- "UserId": -77316487,
-- "Enabled": true,
-- "CredentialType": "NCipher",
-- "Environments": [
-- {
-- "value": "<Circular reference to #/components/schemas/EnvironmentDto detected>"
-- },
-- {
-- "value": "<Circular reference to #/components/schemas/EnvironmentDto detected>"
-- }
-- ],
-- "RobotEnvironments": "consectetur proident",
-- "ExecutionSettings": {},
-- "IsExternalLicensed": false,
-- "LimitConcurrentExecution": false,
-- "Id": 61973728
-- }
-- ],
-- "Type": "Dev",
-- "Id": -81564071
-- },
-- "EntryPointId": 65883382,
-- "EntryPoint": {
-- "UniqueId": "33d009ac-efb0-a268-39d6-f418e596355f",
-- "Path": "ipsum enim est sunt",
-- "InputArguments": "quis incididunt sed aliquip laboris",
-- "OutputArguments": "labore in a",
-- "DataVariation": {
-- "Content": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "ContentType": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "Id": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "Id": -88661283
-- },
-- "InputArguments": "aliqua laborum id reprehenderit irure",
-- "ProcessType": "Process",
-- "SupportsMultipleEntryPoints": false,
-- "RequiresUserInteraction": true,
-- "CurrentVersion": {
-- "ReleaseId": 74749251,
-- "VersionNumber": "et sed in",
-- "CreationTime": "2004-08-18T18:18:03.338Z",
-- "ReleaseName": "culpa irure eiusmod cillum",
-- "Id": -2823220
-- },
-- "ReleaseVersions": [
-- {
-- "ReleaseId": 98978237,
-- "VersionNumber": "dolor",
-- "CreationTime": "1946-05-25T08:32:13.398Z",
-- "ReleaseName": "cillum amet do sit",
-- "Id": 20089819
-- },
-- {
-- "ReleaseId": -81798741,
-- "VersionNumber": "commodo",
-- "CreationTime": "1948-07-19T18:02:36.929Z",
-- "ReleaseName": "commodo ut",
-- "Id": -50835643
-- }
-- ],
-- "Arguments": {
-- "Input": "cupidatat nulla dolore laboris",
-- "Output": "irure enim"
-- },
-- "ProcessSettings": {
-- "ErrorRecordingEnabled": false,
-- "Duration": 21017457,
-- "Frequency": -78467124,
-- "Quality": -81865886,
-- "AutoStartProcess": false,
-- "AlwaysRunning": false
-- },
-- "AutoUpdate": true,
-- "FeedId": "b75e256e-424d-3bf4-0039-f805bddcfa1c",
-- "JobPriority": "Normal",
-- "CreationTime": "1968-10-01T15:48:41.828Z",
-- "OrganizationUnitId": 83258498,
-- "OrganizationUnitFullyQualifiedName": "deserunt Excepteur velit fugiat ipsum",
-- "Id": 97579630
-- },
-- "Source": "in sed eiusmod officia",
-- "SourceType": "Manual",
-- "BatchExecutionKey": "0af7775b-abfd-b5da-a616-c1368d064956",
-- "Info": "elit qui cupidatat Excepteur irure",
-- "CreationTime": "2011-03-20T05:47:21.122Z",
-- "StartingScheduleId": -96622782,
-- "ReleaseName": "aliqua cillum do",
-- "Type": "Attended",
-- "InputArguments": "mollit et anim Duis la",
-- "OutputArguments": "nisi eu",
-- "HostMachineName": "ex nisi est",
-- "HasMediaRecorded": true,
-- "PersistenceId": "7d168d12-cdee-3fc1-6573-e51cf722927c",
-- "ResumeVersion": 80821028,
-- "StopStrategy": "Kill",
-- "RuntimeType": "Studio",
-- "RequiresUserInteraction": true,
-- "ReleaseVersionId": -14684718,
-- "EntryPointPath": "irure ex",
-- "OrganizationUnitId": -47866254,
-- "OrganizationUnitFullyQualifiedName": "in dolor adipisicing irure fugiat",
-- "Reference": "veniam quis",
-- "ProcessType": "TestAutomationProcess",
-- "Id": 74454915
-- },
-- {
-- "Key": "urn:uuid:ebc451f5-37de-ca57-6a04-841f283e3db3",
-- "StartTime": "2015-06-26T01:29:47.772Z",
-- "EndTime": "1975-12-07T06:11:09.831Z",
-- "State": "Terminating",
-- "JobPriority": "Normal",
-- "Robot": {
-- "HostingType": "Floating",
-- "Name": "reprehenderit mag",
-- "Type": "NonProduction",
-- "Username": "amet",
-- "LicenseKey": "in",
-- "MachineName": "veniam sint Duis in",
-- "MachineId": -69775421,
-- "ExternalName": "sit esse in in",
-- "Description": "mollit laboris et adipisicing",
-- "ProvisionType": "Manual",
-- "Password": "mollit exercitation",
-- "CredentialStoreId": -60643044,
-- "UserId": 69734890,
-- "Enabled": false,
-- "CredentialType": "NCipher",
-- "Environments": [
-- {
-- "value": "<Circular reference to #/components/schemas/EnvironmentDto detected>"
-- },
-- {
-- "value": "<Circular reference to #/components/schemas/EnvironmentDto detected>"
-- }
-- ],
-- "RobotEnvironments": "fugiat velit",
-- "ExecutionSettings": {},
-- "IsExternalLicensed": true,
-- "LimitConcurrentExecution": true,
-- "Id": -10649011
-- },
-- "Release": {
-- "Name": "exer",
-- "ProcessKey": "esse irure sunt",
-- "ProcessVersion": "commodo esse",
-- "Key": "et",
-- "IsLatestVersion": false,
-- "IsProcessDeleted": false,
-- "Description": "cillum elit sint proident laboris",
-- "EnvironmentId": -28668699,
-- "EnvironmentName": "fugiat dolor",
-- "Environment": {
-- "Name": "aliquip in ",
-- "Description": "ullamco Ut ipsum",
-- "Robots": [
-- {
-- "HostingType": "Standard",
-- "Name": "veniam irure",
-- "Type": "Unattended",
-- "Username": "exercitation eu",
-- "LicenseKey": "eu",
-- "MachineName": "laborum non ut",
-- "MachineId": -97603824,
-- "ExternalName": "do",
-- "Description": "commodo",
-- "ProvisionType": "Manual",
-- "Password": "amet",
-- "CredentialStoreId": -46683638,
-- "UserId": -79507069,
-- "Enabled": false,
-- "CredentialType": "SafeNet",
-- "Environments": [
-- {
-- "value": "<Circular reference to #/components/schemas/EnvironmentDto detected>"
-- },
-- {
-- "value": "<Circular reference to #/components/schemas/EnvironmentDto detected>"
-- }
-- ],
-- "RobotEnvironments": "ut nisi cupidatat",
-- "ExecutionSettings": {},
-- "IsExternalLicensed": true,
-- "LimitConcurrentExecution": false,
-- "Id": 54910452
-- },
-- {
-- "HostingType": "Standard",
-- "Name": "ipsum labor",
-- "Type": "TestAutomation",
-- "Username": "sed enim anim",
-- "LicenseKey": "laboris ut officia id",
-- "MachineName": "quis in",
-- "MachineId": -90219792,
-- "ExternalName": "in pariatur laborum sit",
-- "Description": "minim fugiat nisi dolore consectetur",
-- "ProvisionType": "Manual",
-- "Password": "officia cupidatat",
-- "CredentialStoreId": 43407097,
-- "UserId": -57075544,
-- "Enabled": false,
-- "CredentialType": "SafeNet",
-- "Environments": [
-- {
-- "value": "<Circular reference to #/components/schemas/EnvironmentDto detected>"
-- },
-- {
-- "value": "<Circular reference to #/components/schemas/EnvironmentDto detected>"
-- }
-- ],
-- "RobotEnvironments": "Duis proident irure",
-- "ExecutionSettings": {},
-- "IsExternalLicensed": true,
-- "LimitConcurrentExecution": true,
-- "Id": -9267781
-- }
-- ],
-- "Type": "Prod",
-- "Id": -62000928
-- },
-- "EntryPointId": -90692421,
-- "EntryPoint": {
-- "UniqueId": "urn:uuid:d301be4a-2392-bf86-7e46-bb8be011fbf7",
-- "Path": "velit minim a",
-- "InputArguments": "aliquip eu reprehenderit sit",
-- "OutputArguments": "in Lorem sint",
-- "DataVariation": {
-- "Content": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "ContentType": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "Id": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "Id": -7344118
-- },
-- "InputArguments": "commodo aute",
-- "ProcessType": "TestAutomationProcess",
-- "SupportsMultipleEntryPoints": true,
-- "RequiresUserInteraction": true,
-- "CurrentVersion": {
-- "ReleaseId": 81406107,
-- "VersionNumber": "id dolor fugiat est",
-- "CreationTime": "1985-09-08T00:08:37.146Z",
-- "ReleaseName": "amet nisi in et",
-- "Id": 18866201
-- },
-- "ReleaseVersions": [
-- {
-- "ReleaseId": -18017135,
-- "VersionNumber": "laboris",
-- "CreationTime": "2010-11-11T00:55:45.791Z",
-- "ReleaseName": "s",
-- "Id": -24543215
-- },
-- {
-- "ReleaseId": 55664279,
-- "VersionNumber": "sint",
-- "CreationTime": "2017-11-30T09:41:33.627Z",
-- "ReleaseName": "laboris dolore",
-- "Id": 98955952
-- }
-- ],
-- "Arguments": {
-- "Input": "laboris Ut eiusmod ad occaecat",
-- "Output": "dolor ut aliquip Lorem"
-- },
-- "ProcessSettings": {
-- "ErrorRecordingEnabled": true,
-- "Duration": -46266930,
-- "Frequency": 79484330,
-- "Quality": 57996402,
-- "AutoStartProcess": false,
-- "AlwaysRunning": false
-- },
-- "AutoUpdate": true,
-- "FeedId": "ba07e4b6-b53b-9353-118a-b30abad1721a",
-- "JobPriority": "Low",
-- "CreationTime": "2018-12-13T23:39:20.742Z",
-- "OrganizationUnitId": -70783962,
-- "OrganizationUnitFullyQualifiedName": "ullamco dolor",
-- "Id": -27097135
-- },
-- "Source": "elit exercitation",
-- "SourceType": "Schedule",
-- "BatchExecutionKey": "8ab4e543-f97f-69ee-ff36-3957c3150367",
-- "Info": "deserunt ullamco non ",
-- "CreationTime": "2017-03-10T11:50:24.671Z",
-- "StartingScheduleId": 95117699,
-- "ReleaseName": "sunt commodo ex in ut",
-- "Type": "Attended",
-- "InputArguments": "cupid",
-- "OutputArguments": "enim ad",
-- "HostMachineName": "elit Lorem",
-- "HasMediaRecorded": false,
-- "PersistenceId": "urn:uuid:cdafed65-066d-922a-b8e4-414a65fc1ee1",
-- "ResumeVersion": 96117442,
-- "StopStrategy": "SoftStop",
-- "RuntimeType": "CitizenDeveloper",
-- "RequiresUserInteraction": true,
-- "ReleaseVersionId": 49481835,
-- "EntryPointPath": "culpa enim",
-- "OrganizationUnitId": 73582213,
-- "OrganizationUnitFullyQualifiedName": "in Lorem ex",
-- "Reference": "sunt cupidatat id",
-- "ProcessType": "TestAutomationProcess",
-- "Id": 15658384
-- }
-- ]
-- }
-- Sample code for parsing the JSON response...
-- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
DECLARE @Key nvarchar(4000)
DECLARE @StartTime nvarchar(4000)
DECLARE @EndTime nvarchar(4000)
DECLARE @State nvarchar(4000)
DECLARE @JobPriority nvarchar(4000)
DECLARE @HostingType nvarchar(4000)
DECLARE @Name nvarchar(4000)
DECLARE @v_Type nvarchar(4000)
DECLARE @Username nvarchar(4000)
DECLARE @LicenseKey nvarchar(4000)
DECLARE @MachineName nvarchar(4000)
DECLARE @MachineId int
DECLARE @ExternalName nvarchar(4000)
DECLARE @Description nvarchar(4000)
DECLARE @ProvisionType nvarchar(4000)
DECLARE @Password nvarchar(4000)
DECLARE @CredentialStoreId int
DECLARE @UserId int
DECLARE @Enabled int
DECLARE @CredentialType nvarchar(4000)
DECLARE @RobotEnvironments nvarchar(4000)
DECLARE @IsExternalLicensed int
DECLARE @LimitConcurrentExecution int
DECLARE @Id int
DECLARE @ReleaseName nvarchar(4000)
DECLARE @ProcessKey nvarchar(4000)
DECLARE @ProcessVersion nvarchar(4000)
DECLARE @ReleaseKey nvarchar(4000)
DECLARE @IsLatestVersion int
DECLARE @IsProcessDeleted int
DECLARE @ReleaseDescription nvarchar(4000)
DECLARE @EnvironmentId int
DECLARE @EnvironmentName nvarchar(4000)
DECLARE @EnvironmentDescription nvarchar(4000)
DECLARE @EnvironmentType nvarchar(4000)
DECLARE @EntryPointId int
DECLARE @UniqueId nvarchar(4000)
DECLARE @Path nvarchar(4000)
DECLARE @InputArguments nvarchar(4000)
DECLARE @OutputArguments nvarchar(4000)
DECLARE @Value nvarchar(4000)
DECLARE @ContentTypeValue nvarchar(4000)
DECLARE @IdValue nvarchar(4000)
DECLARE @ReleaseInputArguments nvarchar(4000)
DECLARE @ProcessType nvarchar(4000)
DECLARE @SupportsMultipleEntryPoints int
DECLARE @RequiresUserInteraction int
DECLARE @ReleaseId int
DECLARE @VersionNumber nvarchar(4000)
DECLARE @CreationTime nvarchar(4000)
DECLARE @CurrentVersionReleaseName nvarchar(4000)
DECLARE @CurrentVersionId int
DECLARE @Input nvarchar(4000)
DECLARE @Output nvarchar(4000)
DECLARE @ErrorRecordingEnabled int
DECLARE @Duration int
DECLARE @Frequency int
DECLARE @Quality int
DECLARE @AutoStartProcess int
DECLARE @AlwaysRunning int
DECLARE @AutoUpdate int
DECLARE @FeedId nvarchar(4000)
DECLARE @ReleaseJobPriority nvarchar(4000)
DECLARE @ReleaseCreationTime nvarchar(4000)
DECLARE @OrganizationUnitId int
DECLARE @OrganizationUnitFullyQualifiedName nvarchar(4000)
DECLARE @Source nvarchar(4000)
DECLARE @SourceType nvarchar(4000)
DECLARE @BatchExecutionKey nvarchar(4000)
DECLARE @Info nvarchar(4000)
DECLARE @StartingScheduleId int
DECLARE @HostMachineName nvarchar(4000)
DECLARE @HasMediaRecorded int
DECLARE @PersistenceId nvarchar(4000)
DECLARE @ResumeVersion int
DECLARE @StopStrategy nvarchar(4000)
DECLARE @RuntimeType nvarchar(4000)
DECLARE @ReleaseVersionId int
DECLARE @EntryPointPath nvarchar(4000)
DECLARE @Reference nvarchar(4000)
DECLARE @j int
DECLARE @count_j int
DECLARE @value nvarchar(4000)
DECLARE @k int
DECLARE @count_k int
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'value'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @Key OUT, 'value[i].Key'
EXEC sp_OAMethod @jResp, 'StringOf', @StartTime OUT, 'value[i].StartTime'
EXEC sp_OAMethod @jResp, 'StringOf', @EndTime OUT, 'value[i].EndTime'
EXEC sp_OAMethod @jResp, 'StringOf', @State OUT, 'value[i].State'
EXEC sp_OAMethod @jResp, 'StringOf', @JobPriority OUT, 'value[i].JobPriority'
EXEC sp_OAMethod @jResp, 'StringOf', @HostingType OUT, 'value[i].Robot.HostingType'
EXEC sp_OAMethod @jResp, 'StringOf', @Name OUT, 'value[i].Robot.Name'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'value[i].Robot.Type'
EXEC sp_OAMethod @jResp, 'StringOf', @Username OUT, 'value[i].Robot.Username'
EXEC sp_OAMethod @jResp, 'StringOf', @LicenseKey OUT, 'value[i].Robot.LicenseKey'
EXEC sp_OAMethod @jResp, 'StringOf', @MachineName OUT, 'value[i].Robot.MachineName'
EXEC sp_OAMethod @jResp, 'IntOf', @MachineId OUT, 'value[i].Robot.MachineId'
EXEC sp_OAMethod @jResp, 'StringOf', @ExternalName OUT, 'value[i].Robot.ExternalName'
EXEC sp_OAMethod @jResp, 'StringOf', @Description OUT, 'value[i].Robot.Description'
EXEC sp_OAMethod @jResp, 'StringOf', @ProvisionType OUT, 'value[i].Robot.ProvisionType'
EXEC sp_OAMethod @jResp, 'StringOf', @Password OUT, 'value[i].Robot.Password'
EXEC sp_OAMethod @jResp, 'IntOf', @CredentialStoreId OUT, 'value[i].Robot.CredentialStoreId'
EXEC sp_OAMethod @jResp, 'IntOf', @UserId OUT, 'value[i].Robot.UserId'
EXEC sp_OAMethod @jResp, 'BoolOf', @Enabled OUT, 'value[i].Robot.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CredentialType OUT, 'value[i].Robot.CredentialType'
EXEC sp_OAMethod @jResp, 'StringOf', @RobotEnvironments OUT, 'value[i].Robot.RobotEnvironments'
EXEC sp_OAMethod @jResp, 'BoolOf', @IsExternalLicensed OUT, 'value[i].Robot.IsExternalLicensed'
EXEC sp_OAMethod @jResp, 'BoolOf', @LimitConcurrentExecution OUT, 'value[i].Robot.LimitConcurrentExecution'
EXEC sp_OAMethod @jResp, 'IntOf', @Id OUT, 'value[i].Robot.Id'
EXEC sp_OAMethod @jResp, 'StringOf', @ReleaseName OUT, 'value[i].Release.Name'
EXEC sp_OAMethod @jResp, 'StringOf', @ProcessKey OUT, 'value[i].Release.ProcessKey'
EXEC sp_OAMethod @jResp, 'StringOf', @ProcessVersion OUT, 'value[i].Release.ProcessVersion'
EXEC sp_OAMethod @jResp, 'StringOf', @ReleaseKey OUT, 'value[i].Release.Key'
EXEC sp_OAMethod @jResp, 'BoolOf', @IsLatestVersion OUT, 'value[i].Release.IsLatestVersion'
EXEC sp_OAMethod @jResp, 'BoolOf', @IsProcessDeleted OUT, 'value[i].Release.IsProcessDeleted'
EXEC sp_OAMethod @jResp, 'StringOf', @ReleaseDescription OUT, 'value[i].Release.Description'
EXEC sp_OAMethod @jResp, 'IntOf', @EnvironmentId OUT, 'value[i].Release.EnvironmentId'
EXEC sp_OAMethod @jResp, 'StringOf', @EnvironmentName OUT, 'value[i].Release.EnvironmentName'
EXEC sp_OAMethod @jResp, 'StringOf', @EnvironmentName OUT, 'value[i].Release.Environment.Name'
EXEC sp_OAMethod @jResp, 'StringOf', @EnvironmentDescription OUT, 'value[i].Release.Environment.Description'
EXEC sp_OAMethod @jResp, 'StringOf', @EnvironmentType OUT, 'value[i].Release.Environment.Type'
EXEC sp_OAMethod @jResp, 'IntOf', @EnvironmentId OUT, 'value[i].Release.Environment.Id'
EXEC sp_OAMethod @jResp, 'IntOf', @EntryPointId OUT, 'value[i].Release.EntryPointId'
EXEC sp_OAMethod @jResp, 'StringOf', @UniqueId OUT, 'value[i].Release.EntryPoint.UniqueId'
EXEC sp_OAMethod @jResp, 'StringOf', @Path OUT, 'value[i].Release.EntryPoint.Path'
EXEC sp_OAMethod @jResp, 'StringOf', @InputArguments OUT, 'value[i].Release.EntryPoint.InputArguments'
EXEC sp_OAMethod @jResp, 'StringOf', @OutputArguments OUT, 'value[i].Release.EntryPoint.OutputArguments'
EXEC sp_OAMethod @jResp, 'StringOf', @Value OUT, 'value[i].Release.EntryPoint.DataVariation.Content.value'
EXEC sp_OAMethod @jResp, 'StringOf', @ContentTypeValue OUT, 'value[i].Release.EntryPoint.DataVariation.ContentType.value'
EXEC sp_OAMethod @jResp, 'StringOf', @IdValue OUT, 'value[i].Release.EntryPoint.DataVariation.Id.value'
EXEC sp_OAMethod @jResp, 'IntOf', @EntryPointId OUT, 'value[i].Release.EntryPoint.Id'
EXEC sp_OAMethod @jResp, 'StringOf', @ReleaseInputArguments OUT, 'value[i].Release.InputArguments'
EXEC sp_OAMethod @jResp, 'StringOf', @ProcessType OUT, 'value[i].Release.ProcessType'
EXEC sp_OAMethod @jResp, 'BoolOf', @SupportsMultipleEntryPoints OUT, 'value[i].Release.SupportsMultipleEntryPoints'
EXEC sp_OAMethod @jResp, 'BoolOf', @RequiresUserInteraction OUT, 'value[i].Release.RequiresUserInteraction'
EXEC sp_OAMethod @jResp, 'IntOf', @ReleaseId OUT, 'value[i].Release.CurrentVersion.ReleaseId'
EXEC sp_OAMethod @jResp, 'StringOf', @VersionNumber OUT, 'value[i].Release.CurrentVersion.VersionNumber'
EXEC sp_OAMethod @jResp, 'StringOf', @CreationTime OUT, 'value[i].Release.CurrentVersion.CreationTime'
EXEC sp_OAMethod @jResp, 'StringOf', @CurrentVersionReleaseName OUT, 'value[i].Release.CurrentVersion.ReleaseName'
EXEC sp_OAMethod @jResp, 'IntOf', @CurrentVersionId OUT, 'value[i].Release.CurrentVersion.Id'
EXEC sp_OAMethod @jResp, 'StringOf', @Input OUT, 'value[i].Release.Arguments.Input'
EXEC sp_OAMethod @jResp, 'StringOf', @Output OUT, 'value[i].Release.Arguments.Output'
EXEC sp_OAMethod @jResp, 'BoolOf', @ErrorRecordingEnabled OUT, 'value[i].Release.ProcessSettings.ErrorRecordingEnabled'
EXEC sp_OAMethod @jResp, 'IntOf', @Duration OUT, 'value[i].Release.ProcessSettings.Duration'
EXEC sp_OAMethod @jResp, 'IntOf', @Frequency OUT, 'value[i].Release.ProcessSettings.Frequency'
EXEC sp_OAMethod @jResp, 'IntOf', @Quality OUT, 'value[i].Release.ProcessSettings.Quality'
EXEC sp_OAMethod @jResp, 'BoolOf', @AutoStartProcess OUT, 'value[i].Release.ProcessSettings.AutoStartProcess'
EXEC sp_OAMethod @jResp, 'BoolOf', @AlwaysRunning OUT, 'value[i].Release.ProcessSettings.AlwaysRunning'
EXEC sp_OAMethod @jResp, 'BoolOf', @AutoUpdate OUT, 'value[i].Release.AutoUpdate'
EXEC sp_OAMethod @jResp, 'StringOf', @FeedId OUT, 'value[i].Release.FeedId'
EXEC sp_OAMethod @jResp, 'StringOf', @ReleaseJobPriority OUT, 'value[i].Release.JobPriority'
EXEC sp_OAMethod @jResp, 'StringOf', @ReleaseCreationTime OUT, 'value[i].Release.CreationTime'
EXEC sp_OAMethod @jResp, 'IntOf', @OrganizationUnitId OUT, 'value[i].Release.OrganizationUnitId'
EXEC sp_OAMethod @jResp, 'StringOf', @OrganizationUnitFullyQualifiedName OUT, 'value[i].Release.OrganizationUnitFullyQualifiedName'
EXEC sp_OAMethod @jResp, 'IntOf', @ReleaseId OUT, 'value[i].Release.Id'
EXEC sp_OAMethod @jResp, 'StringOf', @Source OUT, 'value[i].Source'
EXEC sp_OAMethod @jResp, 'StringOf', @SourceType OUT, 'value[i].SourceType'
EXEC sp_OAMethod @jResp, 'StringOf', @BatchExecutionKey OUT, 'value[i].BatchExecutionKey'
EXEC sp_OAMethod @jResp, 'StringOf', @Info OUT, 'value[i].Info'
EXEC sp_OAMethod @jResp, 'StringOf', @CreationTime OUT, 'value[i].CreationTime'
EXEC sp_OAMethod @jResp, 'IntOf', @StartingScheduleId OUT, 'value[i].StartingScheduleId'
EXEC sp_OAMethod @jResp, 'StringOf', @ReleaseName OUT, 'value[i].ReleaseName'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'value[i].Type'
EXEC sp_OAMethod @jResp, 'StringOf', @InputArguments OUT, 'value[i].InputArguments'
EXEC sp_OAMethod @jResp, 'StringOf', @OutputArguments OUT, 'value[i].OutputArguments'
EXEC sp_OAMethod @jResp, 'StringOf', @HostMachineName OUT, 'value[i].HostMachineName'
EXEC sp_OAMethod @jResp, 'BoolOf', @HasMediaRecorded OUT, 'value[i].HasMediaRecorded'
EXEC sp_OAMethod @jResp, 'StringOf', @PersistenceId OUT, 'value[i].PersistenceId'
EXEC sp_OAMethod @jResp, 'IntOf', @ResumeVersion OUT, 'value[i].ResumeVersion'
EXEC sp_OAMethod @jResp, 'StringOf', @StopStrategy OUT, 'value[i].StopStrategy'
EXEC sp_OAMethod @jResp, 'StringOf', @RuntimeType OUT, 'value[i].RuntimeType'
EXEC sp_OAMethod @jResp, 'BoolOf', @RequiresUserInteraction OUT, 'value[i].RequiresUserInteraction'
EXEC sp_OAMethod @jResp, 'IntOf', @ReleaseVersionId OUT, 'value[i].ReleaseVersionId'
EXEC sp_OAMethod @jResp, 'StringOf', @EntryPointPath OUT, 'value[i].EntryPointPath'
EXEC sp_OAMethod @jResp, 'IntOf', @OrganizationUnitId OUT, 'value[i].OrganizationUnitId'
EXEC sp_OAMethod @jResp, 'StringOf', @OrganizationUnitFullyQualifiedName OUT, 'value[i].OrganizationUnitFullyQualifiedName'
EXEC sp_OAMethod @jResp, 'StringOf', @Reference OUT, 'value[i].Reference'
EXEC sp_OAMethod @jResp, 'StringOf', @ProcessType OUT, 'value[i].ProcessType'
EXEC sp_OAMethod @jResp, 'IntOf', @Id OUT, 'value[i].Id'
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'value[i].Robot.Environments'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'value[i].Robot.Environments[j].value'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'value[i].Release.Environment.Robots'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @HostingType OUT, 'value[i].Release.Environment.Robots[j].HostingType'
EXEC sp_OAMethod @jResp, 'StringOf', @Name OUT, 'value[i].Release.Environment.Robots[j].Name'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'value[i].Release.Environment.Robots[j].Type'
EXEC sp_OAMethod @jResp, 'StringOf', @Username OUT, 'value[i].Release.Environment.Robots[j].Username'
EXEC sp_OAMethod @jResp, 'StringOf', @LicenseKey OUT, 'value[i].Release.Environment.Robots[j].LicenseKey'
EXEC sp_OAMethod @jResp, 'StringOf', @MachineName OUT, 'value[i].Release.Environment.Robots[j].MachineName'
EXEC sp_OAMethod @jResp, 'IntOf', @MachineId OUT, 'value[i].Release.Environment.Robots[j].MachineId'
EXEC sp_OAMethod @jResp, 'StringOf', @ExternalName OUT, 'value[i].Release.Environment.Robots[j].ExternalName'
EXEC sp_OAMethod @jResp, 'StringOf', @Description OUT, 'value[i].Release.Environment.Robots[j].Description'
EXEC sp_OAMethod @jResp, 'StringOf', @ProvisionType OUT, 'value[i].Release.Environment.Robots[j].ProvisionType'
EXEC sp_OAMethod @jResp, 'StringOf', @Password OUT, 'value[i].Release.Environment.Robots[j].Password'
EXEC sp_OAMethod @jResp, 'IntOf', @CredentialStoreId OUT, 'value[i].Release.Environment.Robots[j].CredentialStoreId'
EXEC sp_OAMethod @jResp, 'IntOf', @UserId OUT, 'value[i].Release.Environment.Robots[j].UserId'
EXEC sp_OAMethod @jResp, 'BoolOf', @Enabled OUT, 'value[i].Release.Environment.Robots[j].Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CredentialType OUT, 'value[i].Release.Environment.Robots[j].CredentialType'
EXEC sp_OAMethod @jResp, 'StringOf', @RobotEnvironments OUT, 'value[i].Release.Environment.Robots[j].RobotEnvironments'
EXEC sp_OAMethod @jResp, 'BoolOf', @IsExternalLicensed OUT, 'value[i].Release.Environment.Robots[j].IsExternalLicensed'
EXEC sp_OAMethod @jResp, 'BoolOf', @LimitConcurrentExecution OUT, 'value[i].Release.Environment.Robots[j].LimitConcurrentExecution'
EXEC sp_OAMethod @jResp, 'IntOf', @Id OUT, 'value[i].Release.Environment.Robots[j].Id'
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'value[i].Release.Environment.Robots[j].Environments'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'value[i].Release.Environment.Robots[j].Environments[k].value'
SELECT @k = @k + 1
END
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'value[i].Release.ReleaseVersions'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'IntOf', @ReleaseId OUT, 'value[i].Release.ReleaseVersions[j].ReleaseId'
EXEC sp_OAMethod @jResp, 'StringOf', @VersionNumber OUT, 'value[i].Release.ReleaseVersions[j].VersionNumber'
EXEC sp_OAMethod @jResp, 'StringOf', @CreationTime OUT, 'value[i].Release.ReleaseVersions[j].CreationTime'
EXEC sp_OAMethod @jResp, 'StringOf', @ReleaseName OUT, 'value[i].Release.ReleaseVersions[j].ReleaseName'
EXEC sp_OAMethod @jResp, 'IntOf', @Id OUT, 'value[i].Release.ReleaseVersions[j].Id'
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 "mandatoryPermissions=enim%20officia%20ut%20oc"
-d "mandatoryPermissions=quis%20ex%20ullamco%20sit"
-d "atLeastOnePermissions=enim%20officia%20ut%20oc"
-d "atLeastOnePermissions=quis%20ex%20ullamco%20sit"
-d "$expand=esse%20sit%20qui"
-d "$filter=esse%20sit%20qui"
-d "$select=esse%20sit%20qui"
-d "$orderby=esse%20sit%20qui"
-d "$top=12575632"
-d "$skip=12575632"
-d "$count=true"
-H "Authorization: Bearer <access_token>"
-H "X-UIPATH-OrganizationUnitId: 12575632"
https://domain.com/odata/Jobs
Postman Collection Item JSON
{
"name": "Gets Jobs. Copy",
"request": {
"method": "GET",
"header": [
{
"description": "Folder/OrganizationUnit Id",
"key": "X-UIPATH-OrganizationUnitId",
"value": "12575632"
}
],
"url": {
"raw": "{{baseUrl}}/odata/Jobs?mandatoryPermissions=enim officia ut oc&mandatoryPermissions=quis ex ullamco sit&atLeastOnePermissions=enim officia ut oc&atLeastOnePermissions=quis ex ullamco sit&$expand=esse sit qui&$filter=esse sit qui&$select=esse sit qui&$orderby=esse sit qui&$top=12575632&$skip=12575632&$count=true",
"host": [
"{{baseUrl}}"
],
"path": [
"odata",
"Jobs"
],
"query": [
{
"key": "mandatoryPermissions",
"value": "enim officia ut oc",
"description": "If in a cross-folder scenario, these represent the additional permissions\r\n required in the folders the data is retrieved from; all permissions in this set must be met"
},
{
"key": "mandatoryPermissions",
"value": "quis ex ullamco sit",
"description": "If in a cross-folder scenario, these represent the additional permissions\r\n required in the folders the data is retrieved from; all permissions in this set must be met"
},
{
"key": "atLeastOnePermissions",
"value": "enim officia ut oc",
"description": "If in a cross-folder scenario, these represent the additional permissions\r\n required in the folders the data is retrieved from; at least one permission in this set must be met"
},
{
"key": "atLeastOnePermissions",
"value": "quis ex ullamco sit",
"description": "If in a cross-folder scenario, these represent the additional permissions\r\n required in the folders the data is retrieved from; at least one permission in this set must be met"
},
{
"key": "$expand",
"value": "esse sit qui",
"description": "Indicates the related entities to be represented inline. The maximum depth is 2."
},
{
"key": "$filter",
"value": "esse sit qui",
"description": "Restricts the set of items returned. The maximum number of expressions is 100."
},
{
"key": "$select",
"value": "esse sit qui",
"description": "Limits the properties returned in the result."
},
{
"key": "$orderby",
"value": "esse sit qui",
"description": "Specifies the order in which items are returned. The maximum number of expressions is 5."
},
{
"key": "$top",
"value": "12575632",
"description": "Limits the number of items returned from a collection. The maximum value is 1000."
},
{
"key": "$skip",
"value": "12575632",
"description": "Excludes the specified number of items of the queried collection from the result."
},
{
"key": "$count",
"value": "true",
"description": "Indicates whether the total count of items within a collection are returned in the result."
}
]
},
"description": "OAuth required scopes: OR.Jobs or OR.Jobs.Read.\r\n\r\nRequired permissions: Jobs.View."
},
"response": [
{
"name": "Success",
"originalRequest": {
"method": "GET",
"header": [
{
"description": "Folder/OrganizationUnit Id",
"key": "X-UIPATH-OrganizationUnitId",
"value": "12575632"
}
],
"url": {
"raw": "{{baseUrl}}/odata/Jobs?mandatoryPermissions=eiusmod officia pariatur&mandatoryPermissions=amet eiusmod nulla dolore&atLeastOnePermissions=eiusmod officia pariatur&atLeastOnePermissions=amet eiusmod nulla dolore&$expand=esse sit qui&$filter=esse sit qui&$select=esse sit qui&$orderby=esse sit qui&$top=12575632&$skip=12575632&$count=true",
"host": [
"{{baseUrl}}"
],
"path": [
"odata",
"Jobs"
],
"query": [
{
"key": "mandatoryPermissions",
"value": "eiusmod officia pariatur"
},
{
"key": "mandatoryPermissions",
"value": "amet eiusmod nulla dolore"
},
{
"key": "atLeastOnePermissions",
"value": "eiusmod officia pariatur"
},
{
"key": "atLeastOnePermissions",
"value": "amet eiusmod nulla dolore"
},
{
"key": "$expand",
"value": "esse sit qui"
},
{
"key": "$filter",
"value": "esse sit qui"
},
{
"key": "$select",
"value": "esse sit qui"
},
{
"key": "$orderby",
"value": "esse sit qui"
},
{
"key": "$top",
"value": "12575632"
},
{
"key": "$skip",
"value": "12575632"
},
{
"key": "$count",
"value": "true"
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"value\": [\n {\n \"Key\": \"urn:uuid:be08766e-ac51-bb45-5501-0a3dc5154af2\",\n \"StartTime\": \"1968-12-05T22:17:50.256Z\",\n \"EndTime\": \"1987-05-29T17:04:27.173Z\",\n \"State\": \"Running\",\n \"JobPriority\": \"Normal\",\n \"Robot\": {\n \"HostingType\": \"Standard\",\n \"Name\": \"ve\",\n \"Type\": \"RpaDeveloper\",\n \"Username\": \"exercitation et ea\",\n \"LicenseKey\": \"elit in\",\n \"MachineName\": \"irure Ut mollit dolore\",\n \"MachineId\": -25291783,\n \"ExternalName\": \"laboris commodo dolor do\",\n \"Description\": \"culpa eu consequat\",\n \"ProvisionType\": \"Automatic\",\n \"Password\": \"officia eu ut cupidatat\",\n \"CredentialStoreId\": 68306960,\n \"UserId\": 31877342,\n \"Enabled\": true,\n \"CredentialType\": \"Default\",\n \"Environments\": [\n {\n \"value\": \"<Circular reference to #/components/schemas/EnvironmentDto detected>\"\n },\n {\n \"value\": \"<Circular reference to #/components/schemas/EnvironmentDto detected>\"\n }\n ],\n \"RobotEnvironments\": \"non exercitation ut dolor\",\n \"ExecutionSettings\": {},\n \"IsExternalLicensed\": false,\n \"LimitConcurrentExecution\": false,\n \"Id\": -59332040\n },\n \"Release\": {\n \"Name\": \"sed in aliquip consequat\",\n \"ProcessKey\": \"exercitation\",\n \"ProcessVersion\": \"amet\",\n \"Key\": \"velit ipsum ut\",\n \"IsLatestVersion\": false,\n \"IsProcessDeleted\": true,\n \"Description\": \"dolore\",\n \"EnvironmentId\": -41748387,\n \"EnvironmentName\": \"esse culpa\",\n \"Environment\": {\n \"Name\": \"ea dolor\",\n \"Description\": \"cillum Duis enim\",\n \"Robots\": [\n {\n \"HostingType\": \"Standard\",\n \"Name\": \"magna adip\",\n \"Type\": \"Development\",\n \"Username\": \"dolore ex\",\n \"LicenseKey\": \"nulla veniam dolor proident ipsum\",\n \"MachineName\": \"deserunt sed aute reprehenderit\",\n \"MachineId\": 99549561,\n \"ExternalName\": \"ad laboris veniam sint incididunt\",\n \"Description\": \"Ut commodo\",\n \"ProvisionType\": \"Automatic\",\n \"Password\": \"reprehenderit\",\n \"CredentialStoreId\": -86457645,\n \"UserId\": -62740279,\n \"Enabled\": false,\n \"CredentialType\": \"Default\",\n \"Environments\": [\n {\n \"value\": \"<Circular reference to #/components/schemas/EnvironmentDto detected>\"\n },\n {\n \"value\": \"<Circular reference to #/components/schemas/EnvironmentDto detected>\"\n }\n ],\n \"RobotEnvironments\": \"fugiat labore sunt non\",\n \"ExecutionSettings\": {},\n \"IsExternalLicensed\": false,\n \"LimitConcurrentExecution\": false,\n \"Id\": -57032659\n },\n {\n \"HostingType\": \"Standard\",\n \"Name\": \"ut\",\n \"Type\": \"Studio\",\n \"Username\": \"ipsum fugiat\",\n \"LicenseKey\": \"laboris\",\n \"MachineName\": \"nisi consequat nostrud adipisicing\",\n \"MachineId\": -86957591,\n \"ExternalName\": \"consequat nulla culpa\",\n \"Description\": \"quis proident\",\n \"ProvisionType\": \"Automatic\",\n \"Password\": \"dolor laborum dolore exercitation\",\n \"CredentialStoreId\": -50712714,\n \"UserId\": -77316487,\n \"Enabled\": true,\n \"CredentialType\": \"NCipher\",\n \"Environments\": [\n {\n \"value\": \"<Circular reference to #/components/schemas/EnvironmentDto detected>\"\n },\n {\n \"value\": \"<Circular reference to #/components/schemas/EnvironmentDto detected>\"\n }\n ],\n \"RobotEnvironments\": \"consectetur proident\",\n \"ExecutionSettings\": {},\n \"IsExternalLicensed\": false,\n \"LimitConcurrentExecution\": false,\n \"Id\": 61973728\n }\n ],\n \"Type\": \"Dev\",\n \"Id\": -81564071\n },\n \"EntryPointId\": 65883382,\n \"EntryPoint\": {\n \"UniqueId\": \"33d009ac-efb0-a268-39d6-f418e596355f\",\n \"Path\": \"ipsum enim est sunt\",\n \"InputArguments\": \"quis incididunt sed aliquip laboris\",\n \"OutputArguments\": \"labore in a\",\n \"DataVariation\": {\n \"Content\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"ContentType\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"Id\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"Id\": -88661283\n },\n \"InputArguments\": \"aliqua laborum id reprehenderit irure\",\n \"ProcessType\": \"Process\",\n \"SupportsMultipleEntryPoints\": false,\n \"RequiresUserInteraction\": true,\n \"CurrentVersion\": {\n \"ReleaseId\": 74749251,\n \"VersionNumber\": \"et sed in\",\n \"CreationTime\": \"2004-08-18T18:18:03.338Z\",\n \"ReleaseName\": \"culpa irure eiusmod cillum\",\n \"Id\": -2823220\n },\n \"ReleaseVersions\": [\n {\n \"ReleaseId\": 98978237,\n \"VersionNumber\": \"dolor\",\n \"CreationTime\": \"1946-05-25T08:32:13.398Z\",\n \"ReleaseName\": \"cillum amet do sit\",\n \"Id\": 20089819\n },\n {\n \"ReleaseId\": -81798741,\n \"VersionNumber\": \"commodo\",\n \"CreationTime\": \"1948-07-19T18:02:36.929Z\",\n \"ReleaseName\": \"commodo ut\",\n \"Id\": -50835643\n }\n ],\n \"Arguments\": {\n \"Input\": \"cupidatat nulla dolore laboris\",\n \"Output\": \"irure enim\"\n },\n \"ProcessSettings\": {\n \"ErrorRecordingEnabled\": false,\n \"Duration\": 21017457,\n \"Frequency\": -78467124,\n \"Quality\": -81865886,\n \"AutoStartProcess\": false,\n \"AlwaysRunning\": false\n },\n \"AutoUpdate\": true,\n \"FeedId\": \"b75e256e-424d-3bf4-0039-f805bddcfa1c\",\n \"JobPriority\": \"Normal\",\n \"CreationTime\": \"1968-10-01T15:48:41.828Z\",\n \"OrganizationUnitId\": 83258498,\n \"OrganizationUnitFullyQualifiedName\": \"deserunt Excepteur velit fugiat ipsum\",\n \"Id\": 97579630\n },\n \"Source\": \"in sed eiusmod officia\",\n \"SourceType\": \"Manual\",\n \"BatchExecutionKey\": \"0af7775b-abfd-b5da-a616-c1368d064956\",\n \"Info\": \"elit qui cupidatat Excepteur irure\",\n \"CreationTime\": \"2011-03-20T05:47:21.122Z\",\n \"StartingScheduleId\": -96622782,\n \"ReleaseName\": \"aliqua cillum do\",\n \"Type\": \"Attended\",\n \"InputArguments\": \"mollit et anim Duis la\",\n \"OutputArguments\": \"nisi eu\",\n \"HostMachineName\": \"ex nisi est\",\n \"HasMediaRecorded\": true,\n \"PersistenceId\": \"7d168d12-cdee-3fc1-6573-e51cf722927c\",\n \"ResumeVersion\": 80821028,\n \"StopStrategy\": \"Kill\",\n \"RuntimeType\": \"Studio\",\n \"RequiresUserInteraction\": true,\n \"ReleaseVersionId\": -14684718,\n \"EntryPointPath\": \"irure ex\",\n \"OrganizationUnitId\": -47866254,\n \"OrganizationUnitFullyQualifiedName\": \"in dolor adipisicing irure fugiat\",\n \"Reference\": \"veniam quis\",\n \"ProcessType\": \"TestAutomationProcess\",\n \"Id\": 74454915\n },\n {\n \"Key\": \"urn:uuid:ebc451f5-37de-ca57-6a04-841f283e3db3\",\n \"StartTime\": \"2015-06-26T01:29:47.772Z\",\n \"EndTime\": \"1975-12-07T06:11:09.831Z\",\n \"State\": \"Terminating\",\n \"JobPriority\": \"Normal\",\n \"Robot\": {\n \"HostingType\": \"Floating\",\n \"Name\": \"reprehenderit mag\",\n \"Type\": \"NonProduction\",\n \"Username\": \"amet\",\n \"LicenseKey\": \"in\",\n \"MachineName\": \"veniam sint Duis in\",\n \"MachineId\": -69775421,\n \"ExternalName\": \"sit esse in in\",\n \"Description\": \"mollit laboris et adipisicing\",\n \"ProvisionType\": \"Manual\",\n \"Password\": \"mollit exercitation\",\n \"CredentialStoreId\": -60643044,\n \"UserId\": 69734890,\n \"Enabled\": false,\n \"CredentialType\": \"NCipher\",\n \"Environments\": [\n {\n \"value\": \"<Circular reference to #/components/schemas/EnvironmentDto detected>\"\n },\n {\n \"value\": \"<Circular reference to #/components/schemas/EnvironmentDto detected>\"\n }\n ],\n \"RobotEnvironments\": \"fugiat velit\",\n \"ExecutionSettings\": {},\n \"IsExternalLicensed\": true,\n \"LimitConcurrentExecution\": true,\n \"Id\": -10649011\n },\n \"Release\": {\n \"Name\": \"exer\",\n \"ProcessKey\": \"esse irure sunt\",\n \"ProcessVersion\": \"commodo esse\",\n \"Key\": \"et\",\n \"IsLatestVersion\": false,\n \"IsProcessDeleted\": false,\n \"Description\": \"cillum elit sint proident laboris\",\n \"EnvironmentId\": -28668699,\n \"EnvironmentName\": \"fugiat dolor\",\n \"Environment\": {\n \"Name\": \"aliquip in \",\n \"Description\": \"ullamco Ut ipsum\",\n \"Robots\": [\n {\n \"HostingType\": \"Standard\",\n \"Name\": \"veniam irure\",\n \"Type\": \"Unattended\",\n \"Username\": \"exercitation eu\",\n \"LicenseKey\": \"eu\",\n \"MachineName\": \"laborum non ut\",\n \"MachineId\": -97603824,\n \"ExternalName\": \"do\",\n \"Description\": \"commodo\",\n \"ProvisionType\": \"Manual\",\n \"Password\": \"amet\",\n \"CredentialStoreId\": -46683638,\n \"UserId\": -79507069,\n \"Enabled\": false,\n \"CredentialType\": \"SafeNet\",\n \"Environments\": [\n {\n \"value\": \"<Circular reference to #/components/schemas/EnvironmentDto detected>\"\n },\n {\n \"value\": \"<Circular reference to #/components/schemas/EnvironmentDto detected>\"\n }\n ],\n \"RobotEnvironments\": \"ut nisi cupidatat\",\n \"ExecutionSettings\": {},\n \"IsExternalLicensed\": true,\n \"LimitConcurrentExecution\": false,\n \"Id\": 54910452\n },\n {\n \"HostingType\": \"Standard\",\n \"Name\": \"ipsum labor\",\n \"Type\": \"TestAutomation\",\n \"Username\": \"sed enim anim\",\n \"LicenseKey\": \"laboris ut officia id\",\n \"MachineName\": \"quis in\",\n \"MachineId\": -90219792,\n \"ExternalName\": \"in pariatur laborum sit\",\n \"Description\": \"minim fugiat nisi dolore consectetur\",\n \"ProvisionType\": \"Manual\",\n \"Password\": \"officia cupidatat\",\n \"CredentialStoreId\": 43407097,\n \"UserId\": -57075544,\n \"Enabled\": false,\n \"CredentialType\": \"SafeNet\",\n \"Environments\": [\n {\n \"value\": \"<Circular reference to #/components/schemas/EnvironmentDto detected>\"\n },\n {\n \"value\": \"<Circular reference to #/components/schemas/EnvironmentDto detected>\"\n }\n ],\n \"RobotEnvironments\": \"Duis proident irure\",\n \"ExecutionSettings\": {},\n \"IsExternalLicensed\": true,\n \"LimitConcurrentExecution\": true,\n \"Id\": -9267781\n }\n ],\n \"Type\": \"Prod\",\n \"Id\": -62000928\n },\n \"EntryPointId\": -90692421,\n \"EntryPoint\": {\n \"UniqueId\": \"urn:uuid:d301be4a-2392-bf86-7e46-bb8be011fbf7\",\n \"Path\": \"velit minim a\",\n \"InputArguments\": \"aliquip eu reprehenderit sit\",\n \"OutputArguments\": \"in Lorem sint\",\n \"DataVariation\": {\n \"Content\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"ContentType\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"Id\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"Id\": -7344118\n },\n \"InputArguments\": \"commodo aute\",\n \"ProcessType\": \"TestAutomationProcess\",\n \"SupportsMultipleEntryPoints\": true,\n \"RequiresUserInteraction\": true,\n \"CurrentVersion\": {\n \"ReleaseId\": 81406107,\n \"VersionNumber\": \"id dolor fugiat est\",\n \"CreationTime\": \"1985-09-08T00:08:37.146Z\",\n \"ReleaseName\": \"amet nisi in et\",\n \"Id\": 18866201\n },\n \"ReleaseVersions\": [\n {\n \"ReleaseId\": -18017135,\n \"VersionNumber\": \"laboris\",\n \"CreationTime\": \"2010-11-11T00:55:45.791Z\",\n \"ReleaseName\": \"s\",\n \"Id\": -24543215\n },\n {\n \"ReleaseId\": 55664279,\n \"VersionNumber\": \"sint\",\n \"CreationTime\": \"2017-11-30T09:41:33.627Z\",\n \"ReleaseName\": \"laboris dolore\",\n \"Id\": 98955952\n }\n ],\n \"Arguments\": {\n \"Input\": \"laboris Ut eiusmod ad occaecat\",\n \"Output\": \"dolor ut aliquip Lorem\"\n },\n \"ProcessSettings\": {\n \"ErrorRecordingEnabled\": true,\n \"Duration\": -46266930,\n \"Frequency\": 79484330,\n \"Quality\": 57996402,\n \"AutoStartProcess\": false,\n \"AlwaysRunning\": false\n },\n \"AutoUpdate\": true,\n \"FeedId\": \"ba07e4b6-b53b-9353-118a-b30abad1721a\",\n \"JobPriority\": \"Low\",\n \"CreationTime\": \"2018-12-13T23:39:20.742Z\",\n \"OrganizationUnitId\": -70783962,\n \"OrganizationUnitFullyQualifiedName\": \"ullamco dolor\",\n \"Id\": -27097135\n },\n \"Source\": \"elit exercitation\",\n \"SourceType\": \"Schedule\",\n \"BatchExecutionKey\": \"8ab4e543-f97f-69ee-ff36-3957c3150367\",\n \"Info\": \"deserunt ullamco non \",\n \"CreationTime\": \"2017-03-10T11:50:24.671Z\",\n \"StartingScheduleId\": 95117699,\n \"ReleaseName\": \"sunt commodo ex in ut\",\n \"Type\": \"Attended\",\n \"InputArguments\": \"cupid\",\n \"OutputArguments\": \"enim ad\",\n \"HostMachineName\": \"elit Lorem\",\n \"HasMediaRecorded\": false,\n \"PersistenceId\": \"urn:uuid:cdafed65-066d-922a-b8e4-414a65fc1ee1\",\n \"ResumeVersion\": 96117442,\n \"StopStrategy\": \"SoftStop\",\n \"RuntimeType\": \"CitizenDeveloper\",\n \"RequiresUserInteraction\": true,\n \"ReleaseVersionId\": 49481835,\n \"EntryPointPath\": \"culpa enim\",\n \"OrganizationUnitId\": 73582213,\n \"OrganizationUnitFullyQualifiedName\": \"in Lorem ex\",\n \"Reference\": \"sunt cupidatat id\",\n \"ProcessType\": \"TestAutomationProcess\",\n \"Id\": 15658384\n }\n ]\n}"
}
]
}
