SQL Server / DocuSign REST API / Update the password rules
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
-- Use this online tool to generate code from sample JSON: Generate Code to Create JSON
-- The following JSON is sent in the request body.
-- {
-- "passwordStrengthType": "sample string 1",
-- "passwordStrengthTypeMetadata": {
-- "options": [
-- {
-- "name": "sample string 1",
-- "minimumLength": "sample string 2",
-- "passwordIncludeUpperCase": "sample string 3",
-- "passwordIncludeLowerCase": "sample string 4",
-- "passwordIncludeDigit": "sample string 5",
-- "passwordIncludeSpecialCharacter": "sample string 6",
-- "passwordIncludeDigitOrSpecialCharacter": "sample string 7"
-- }
-- ]
-- },
-- "expirePassword": "sample string 2",
-- "expirePasswordDays": "sample string 3",
-- "expirePasswordDaysMetadata": {
-- "minimumDays": "sample string 1",
-- "maximumDays": "sample string 2"
-- },
-- "minimumPasswordLength": "sample string 4",
-- "minimumPasswordLengthMetadata": {
-- "minimumLength": "sample string 1",
-- "maximumLength": "sample string 2"
-- },
-- "minimumPasswordAgeDays": "sample string 5",
-- "minimumPasswordAgeDaysMetadata": {
-- "minimumAge": "sample string 1",
-- "maximumAge": "sample string 2"
-- },
-- "lockoutDurationType": "sample string 6",
-- "lockoutDurationTypeMetadata": {
-- "options": [
-- "sample string 1"
-- ]
-- },
-- "lockoutDurationMinutes": "sample string 7",
-- "lockoutDurationMinutesMetadata": {
-- "minimumMinutes": "sample string 1",
-- "maximumMinutes": "sample string 2"
-- },
-- "passwordIncludeUpperCase": "sample string 8",
-- "passwordIncludeLowerCase": "sample string 9",
-- "passwordIncludeDigit": "sample string 10",
-- "passwordIncludeSpecialCharacter": "sample string 11",
-- "passwordIncludeDigitOrSpecialCharacter": "sample string 12",
-- "questionsRequired": "sample string 13",
-- "questionsRequiredMetadata": {
-- "minimumQuestions": "sample string 1",
-- "maximumQuestions": "sample string 2"
-- }
-- }
DECLARE @json int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'passwordStrengthType', 'sample string 1'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'passwordStrengthTypeMetadata.options[0].name', 'sample string 1'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'passwordStrengthTypeMetadata.options[0].minimumLength', 'sample string 2'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'passwordStrengthTypeMetadata.options[0].passwordIncludeUpperCase', 'sample string 3'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'passwordStrengthTypeMetadata.options[0].passwordIncludeLowerCase', 'sample string 4'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'passwordStrengthTypeMetadata.options[0].passwordIncludeDigit', 'sample string 5'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'passwordStrengthTypeMetadata.options[0].passwordIncludeSpecialCharacter', 'sample string 6'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'passwordStrengthTypeMetadata.options[0].passwordIncludeDigitOrSpecialCharacter', 'sample string 7'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'expirePassword', 'sample string 2'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'expirePasswordDays', 'sample string 3'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'expirePasswordDaysMetadata.minimumDays', 'sample string 1'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'expirePasswordDaysMetadata.maximumDays', 'sample string 2'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'minimumPasswordLength', 'sample string 4'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'minimumPasswordLengthMetadata.minimumLength', 'sample string 1'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'minimumPasswordLengthMetadata.maximumLength', 'sample string 2'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'minimumPasswordAgeDays', 'sample string 5'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'minimumPasswordAgeDaysMetadata.minimumAge', 'sample string 1'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'minimumPasswordAgeDaysMetadata.maximumAge', 'sample string 2'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'lockoutDurationType', 'sample string 6'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'lockoutDurationTypeMetadata.options[0]', 'sample string 1'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'lockoutDurationMinutes', 'sample string 7'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'lockoutDurationMinutesMetadata.minimumMinutes', 'sample string 1'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'lockoutDurationMinutesMetadata.maximumMinutes', 'sample string 2'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'passwordIncludeUpperCase', 'sample string 8'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'passwordIncludeLowerCase', 'sample string 9'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'passwordIncludeDigit', 'sample string 10'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'passwordIncludeSpecialCharacter', 'sample string 11'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'passwordIncludeDigitOrSpecialCharacter', 'sample string 12'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'questionsRequired', 'sample string 13'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'questionsRequiredMetadata.minimumQuestions', 'sample string 1'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'questionsRequiredMetadata.maximumQuestions', 'sample string 2'
-- Adds the "Authorization: Bearer {{accessToken}}" header.
EXEC sp_OASetProperty @http, 'AuthToken', '{{accessToken}}'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Accept', 'application/json'
DECLARE @sbRequestBody int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbRequestBody OUT
EXEC sp_OAMethod @json, 'EmitSb', @success OUT, @sbRequestBody
DECLARE @resp int
EXEC sp_OAMethod @http, 'PTextSb', @resp OUT, 'PUT', 'https://domain.com/v2.1/accounts/{{accountId}}/settings/password_rules', @sbRequestBody, 'utf-8', 'application/json', 0, 0
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 @json
EXEC @hr = sp_OADestroy @sbRequestBody
RETURN
END
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
PRINT @iTmp0
EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @sbRequestBody
END
GO
Curl Command
curl -X PUT
-H "Accept: application/json"
-H "Authorization: Bearer {{accessToken}}"
-d '{
"passwordStrengthType": "sample string 1",
"passwordStrengthTypeMetadata": {
"options": [
{
"name": "sample string 1",
"minimumLength": "sample string 2",
"passwordIncludeUpperCase": "sample string 3",
"passwordIncludeLowerCase": "sample string 4",
"passwordIncludeDigit": "sample string 5",
"passwordIncludeSpecialCharacter": "sample string 6",
"passwordIncludeDigitOrSpecialCharacter": "sample string 7"
}
]
},
"expirePassword": "sample string 2",
"expirePasswordDays": "sample string 3",
"expirePasswordDaysMetadata": {
"minimumDays": "sample string 1",
"maximumDays": "sample string 2"
},
"minimumPasswordLength": "sample string 4",
"minimumPasswordLengthMetadata": {
"minimumLength": "sample string 1",
"maximumLength": "sample string 2"
},
"minimumPasswordAgeDays": "sample string 5",
"minimumPasswordAgeDaysMetadata": {
"minimumAge": "sample string 1",
"maximumAge": "sample string 2"
},
"lockoutDurationType": "sample string 6",
"lockoutDurationTypeMetadata": {
"options": [
"sample string 1"
]
},
"lockoutDurationMinutes": "sample string 7",
"lockoutDurationMinutesMetadata": {
"minimumMinutes": "sample string 1",
"maximumMinutes": "sample string 2"
},
"passwordIncludeUpperCase": "sample string 8",
"passwordIncludeLowerCase": "sample string 9",
"passwordIncludeDigit": "sample string 10",
"passwordIncludeSpecialCharacter": "sample string 11",
"passwordIncludeDigitOrSpecialCharacter": "sample string 12",
"questionsRequired": "sample string 13",
"questionsRequiredMetadata": {
"minimumQuestions": "sample string 1",
"maximumQuestions": "sample string 2"
}
}'
https://domain.com/v2.1/accounts/{{accountId}}/settings/password_rules
Postman Collection Item JSON
{
"name": "Update the password rules",
"request": {
"method": "PUT",
"header": [
{
"key": "Accept",
"value": "application/json"
},
{
"key": "Authorization",
"value": "Bearer {{accessToken}}"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"passwordStrengthType\": \"sample string 1\",\n \"passwordStrengthTypeMetadata\": {\n \"options\": [\n {\n \"name\": \"sample string 1\",\n \"minimumLength\": \"sample string 2\",\n \"passwordIncludeUpperCase\": \"sample string 3\",\n \"passwordIncludeLowerCase\": \"sample string 4\",\n \"passwordIncludeDigit\": \"sample string 5\",\n \"passwordIncludeSpecialCharacter\": \"sample string 6\",\n \"passwordIncludeDigitOrSpecialCharacter\": \"sample string 7\"\n }\n ]\n },\n \"expirePassword\": \"sample string 2\",\n \"expirePasswordDays\": \"sample string 3\",\n \"expirePasswordDaysMetadata\": {\n \"minimumDays\": \"sample string 1\",\n \"maximumDays\": \"sample string 2\"\n },\n \"minimumPasswordLength\": \"sample string 4\",\n \"minimumPasswordLengthMetadata\": {\n \"minimumLength\": \"sample string 1\",\n \"maximumLength\": \"sample string 2\"\n },\n \"minimumPasswordAgeDays\": \"sample string 5\",\n \"minimumPasswordAgeDaysMetadata\": {\n \"minimumAge\": \"sample string 1\",\n \"maximumAge\": \"sample string 2\"\n },\n \"lockoutDurationType\": \"sample string 6\",\n \"lockoutDurationTypeMetadata\": {\n \"options\": [\n \"sample string 1\"\n ]\n },\n \"lockoutDurationMinutes\": \"sample string 7\",\n \"lockoutDurationMinutesMetadata\": {\n \"minimumMinutes\": \"sample string 1\",\n \"maximumMinutes\": \"sample string 2\"\n },\n \"passwordIncludeUpperCase\": \"sample string 8\",\n \"passwordIncludeLowerCase\": \"sample string 9\",\n \"passwordIncludeDigit\": \"sample string 10\",\n \"passwordIncludeSpecialCharacter\": \"sample string 11\",\n \"passwordIncludeDigitOrSpecialCharacter\": \"sample string 12\",\n \"questionsRequired\": \"sample string 13\",\n \"questionsRequiredMetadata\": {\n \"minimumQuestions\": \"sample string 1\",\n \"maximumQuestions\": \"sample string 2\"\n }\n}"
},
"url": {
"raw": "{{baseUrl}}/v2.1/accounts/{{accountId}}/settings/password_rules",
"host": [
"{{baseUrl}}"
],
"path": [
"v2.1",
"accounts",
"{{accountId}}",
"settings",
"password_rules"
],
"variable": [
{
"key": "accountId",
"value": "{{accountId}}"
}
]
}
},
"response": [
]
}
