Get Worksheet Used Range

Retrieves a worksheet's used range from Microsoft 365.

GET

Query

Arguments

stringrequired

Microsoft Graph drive item ID for the Excel workbook.

stringrequired

Name of the worksheet to read.

Field selectionChoose which fields should be included in the response. Learn more

string

Comma-separated response fields to include.

Try this request

Request

curl --request GET \
  --url "https://connect.mindcloud.co/v1/universal/microsoft365/0.0.36/actions/get-worksheet-used-range" \
  --header "Authorization: Bearer $MINDCLOUD_API_TOKEN" \
  --get \
  --data-urlencode 'connectionId=$CONNECTION_ID' \
  --data-urlencode 'driveItemId=' \
  --data-urlencode 'worksheetName='

{
  "success": true,
  "data": [
    {
      "address": "string",
      "cellCount": 1,
      "columnCount": 1,
      "columnIndex": 1,
      "rowCount": 1,
      "rowIndex": 1,
      "text": [
        [
          "string"
        ]
      ],
      "values": [
        [
          "string"
        ]
      ],
      "valueTypes": [
        [
          "string"
        ]
      ]
    }
  ],
  "meta": {}
}

Every app you connect,one REST pattern

Call any app with one REST pattern. MindCloud handles each provider's auth, request shape, and responses for you.

Learn what the Universal API is

One REST patternUse the same request structure across apps like Slack, HubSpot, Salesforce, and thousands more.

Managed connectionsSend a MindCloud connection ID instead of handling provider tokens, refresh logic, and credential storage yourself.

Action-level docsEach action page shows the exact endpoint, required arguments, optional controls, and response behavior for that app version.