POST
/
api
/
v2
/
secret-rotations
/
mssql-credentials
curl --request POST \
  --url https://us.infisical.com/api/v2/secret-rotations/mssql-credentials \
  --header 'Content-Type: application/json' \
  --data '{
  "name": "<string>",
  "projectId": "<string>",
  "description": "<string>",
  "connectionId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "environment": "<string>",
  "secretPath": "<string>",
  "isAutoRotationEnabled": true,
  "rotationInterval": 2,
  "rotateAtUtc": {
    "hours": 11.5,
    "minutes": 29.5
  },
  "parameters": {
    "username1": "<string>",
    "username2": "<string>"
  },
  "secretsMapping": {
    "username": "<string>",
    "password": "<string>"
  }
}'
{
  "secretRotation": {
    "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "name": "<string>",
    "description": "<string>",
    "secretsMapping": {
      "username": "<string>",
      "password": "<string>"
    },
    "isAutoRotationEnabled": true,
    "activeIndex": 0,
    "folderId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "connectionId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "createdAt": "2023-11-07T05:31:56Z",
    "updatedAt": "2023-11-07T05:31:56Z",
    "rotationInterval": 123,
    "rotationStatus": "<string>",
    "lastRotationAttemptedAt": "2023-11-07T05:31:56Z",
    "lastRotatedAt": "2023-11-07T05:31:56Z",
    "lastRotationJobId": "<string>",
    "nextRotationAt": "2023-11-07T05:31:56Z",
    "isLastRotationManual": true,
    "connection": {
      "app": "mssql",
      "name": "<string>",
      "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
    },
    "environment": {
      "slug": "<string>",
      "name": "<string>",
      "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
    },
    "projectId": "<string>",
    "folder": {
      "id": "<string>",
      "path": "<string>"
    },
    "rotateAtUtc": {
      "hours": 11.5,
      "minutes": 29.5
    },
    "lastRotationMessage": "<string>",
    "type": "mssql-credentials",
    "parameters": {
      "username1": "<string>",
      "username2": "<string>"
    }
  }
}

Check out the configuration docs for Microsoft SQL Server Credentials Rotations to learn how to obtain the required parameters.

Body

application/json
​
name
string
required

The name of the Microsoft SQL Sever Credentials Rotation to create. Must be slug-friendly.

Required string length: 1 - 32
​
projectId
string
required

The ID of the project to create the rotation in.

Minimum length: 1
​
connectionId
string
required

The ID of the Microsoft SQL Server Connection to use for rotation.

​
environment
string
required

The slug of the project environment to create the rotation in.

Required string length: 1 - 64
​
secretPath
string
required

The secret path of the project to create the rotation in.

Minimum length: 1
​
rotationInterval
number
required

The interval, in days, to automatically rotate secrets.

Required range: x >= 1
​
parameters
object
required
​
secretsMapping
object
required
​
description
string | null

An optional description for the Microsoft SQL Sever Credentials Rotation.

Maximum length: 256
​
isAutoRotationEnabled
boolean
default:true

Whether secrets should be automatically rotated when the specified rotation interval has elapsed.

​
rotateAtUtc
object

The hours and minutes rotation should occur at in UTC. Defaults to Midnight (00:00) UTC.

Response

200
application/json
Default Response
​
secretRotation
object
required

Was this page helpful?

Suggest editsRaise issue